Advertisement
Guest User

Untitled

a guest
Sep 18th, 2017
80
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.81 KB | None | 0 0
  1. @Override
  2. protected void onCreate(Bundle savedInstanceState) {
  3. super.onCreate(savedInstanceState);
  4. setContentView(R.layout.activity_main);
  5.  
  6. barChart = (BarChart) findViewById(R.id.bargraph);
  7.  
  8. conexionBD();
  9.  
  10.  
  11. ArrayList<BarEntry> barEntries = new ArrayList<>();
  12.  
  13. for (a = 1; a == i; a++) {
  14.  
  15. barEntries.add(new BarEntry(Float.parseFloat(ra), i));
  16.  
  17. }
  18.  
  19.  
  20. BarDataSet barDataSet = new BarDataSet(barEntries, " EDADES");
  21.  
  22. ArrayList<String> Day = new ArrayList<>();
  23. for (i = 0; i > 0; i++) {
  24. Day.add(rs);
  25. }
  26.  
  27.  
  28. BarData theData = new BarData(Day, barDataSet);
  29. barChart.setData(theData);
  30.  
  31. barChart.setVisibleXRange(20); // allow 20 values to be displayed at once on the x-axis, not more
  32. barChart.moveViewToX(10);
  33.  
  34. barChart.setTouchEnabled(true);
  35. barChart.setDragEnabled(true);
  36. barChart.setScaleEnabled(true);
  37.  
  38. barChart.setDescription("INDICADOR DE EDADES OPDM");
  39. }
  40. public Connection conexionBD() {
  41. Connection conexionBD = null;
  42. try {
  43. StrictMode.ThreadPolicy policy = new StrictMode.ThreadPolicy.Builder().permitAll().build();
  44. StrictMode.setThreadPolicy(policy);
  45. Class.forName("net.sourceforge.jtds.jdbc.Driver").newInstance();
  46. conexionBD = DriverManager.getConnection("jdbc:jtds:sqlserver://192.168.1.67;databaseName=opdm;user=Jose;password=123;");
  47.  
  48. Statement sentencia = conexionBD.createStatement();
  49. ResultSet rs = sentencia.executeQuery("select nombre from usuarios");
  50. Statement sentenia1 = conexionBD.createStatement();
  51. ResultSet ra = sentenia1.executeQuery("select codigo from ususarios");
  52.  
  53.  
  54. while (rs.next()&& ra.next()) {
  55.  
  56.  
  57. }
  58. } catch (Exception e) {
  59. Toast.makeText(getApplicationContext(), e.getMessage(), Toast.LENGTH_SHORT).show();
  60. }
  61. return conexionBD;
  62. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement