How to pass values from SQL server to MPAndroidChart bar chart?

0

I have a sql database with data which I need to go to a bar chart graph.

import android.os.StrictMode;
import android.provider.ContactsContract;
import android.support.v7.app.AppCompatActivity;
import android.os.Bundle;
import android.widget.RelativeLayout;
import android.widget.Toast;

import com.github.mikephil.charting.charts.BarChart;
import com.github.mikephil.charting.charts.ScatterChart;
import com.github.mikephil.charting.data.BarData;
import com.github.mikephil.charting.data.BarDataSet;
import com.github.mikephil.charting.data.BarEntry;
import com.github.mikephil.charting.utils.ViewPortHandler;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.Random;

public class MainActivity extends AppCompatActivity {
    BarChart barChart;
    String rs;
    String ra;
    int i;
    int a;


    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);

        barChart = (BarChart) findViewById(R.id.bargraph);

        conexionBD();


        ArrayList<BarEntry> barEntries = new ArrayList<>();

        for (a = 1; a == i; a++) {

            barEntries.add(new BarEntry(Float.parseFloat(ra), i));

        }


        BarDataSet barDataSet = new BarDataSet(barEntries, "  EDADES");

        ArrayList<String> Day = new ArrayList<>();
        for (i = 0; i > 0; i++) {
            Day.add(rs);
        }


        BarData theData = new BarData(Day, barDataSet);
        barChart.setData(theData);

        barChart.setVisibleXRange(20); // allow 20 values to be displayed at once on the x-axis, not more
        barChart.moveViewToX(10);

        barChart.setTouchEnabled(true);
        barChart.setDragEnabled(true);
        barChart.setScaleEnabled(true);

        barChart.setDescription("INDICADOR DE EDADES OPDM");
    }
    public Connection conexionBD() {
        Connection conexionBD = null;
        try {
            StrictMode.ThreadPolicy policy = new StrictMode.ThreadPolicy.Builder().permitAll().build();
            StrictMode.setThreadPolicy(policy);
            Class.forName("net.sourceforge.jtds.jdbc.Driver").newInstance();
            conexionBD = DriverManager.getConnection("jdbc:jtds:sqlserver://192.168.1.67;databaseName=opdm;user=Jose;password=123;");

            Statement sentencia = conexionBD.createStatement();
            ResultSet rs = sentencia.executeQuery("select nombre from usuarios");
            Statement sentenia1 = conexionBD.createStatement();
            ResultSet ra = sentenia1.executeQuery("select codigo from ususarios");


            while (rs.next()&& ra.next()) {


            }
        } catch (Exception e) {
            Toast.makeText(getApplicationContext(), e.getMessage(), Toast.LENGTH_SHORT).show();
        }
        return conexionBD;
    }
}
    
asked by Mazgo Dos 19.09.2017 в 00:56
source

0 answers