Create Array using result of a SELECT

Question

Create Array using result of a SELECT

Navigation

#1 by (2 votes)

0

public class TelaGrafico extends javax.swing.JFrame {

    Connection conexao = null;
    PreparedStatement pst = null;
    ResultSet rs = null;


    /**
     * Creates new form TelaGrafico
     */
    public TelaGrafico() {
        initComponents();
        conexao = ModuloConexao.conectar();
        jRadioButtonNatal.setSelected(true);
        jLabelGerarGrafico.setVisible(false);
        jProgressBarGerarGrafico.setVisible(false);

        Calendar calen = Calendar.getInstance();
        int anos = calen.get(Calendar.YEAR);
        jTextFieldAno.setText(Integer.toString(anos));
    }


    //MÉTODO PARA GERAR GRAFICO PELA LOCALIDADE:
    private void GraficoLocalidade() {
        String localidade = jComboBoxLocalidade.getSelectedItem().toString();
        String ano = jTextFieldAno.getText();
        String semIni = jTextFieldSemInicial.getText();
        String semFin = jTextFieldSemFinal.getText();
        switch (jComboBoxDistritos.getSelectedIndex()) {
            case 0:
                //NORTE:
                break;
            case 1:
                //SUL:
                break;
            case 2:
                //LESTE:

                String dadosGrafico = "select sem_epi,ipo,ido from tb_indices_leste where localidade='" + localidade + "' and ano='" + ano + "' and sem_epi between '" + semIni + "' and '"+semFin+"'";
                try {
                    pst = conexao.prepareStatement(dadosGrafico);
                    rs = pst.executeQuery();
                    if (rs.next()) {}

The code ends here and this SELECT above returns me the table:

+---------+-------+-------+
| sem_epi | ipo   | ido   |
+---------+-------+-------+
|       1 | 100.0 |  23.1 |
|       2 |  88.9 |  85.0 |
|       3 |  77.8 | 145.3 |
|       4 |  77.8 |   4.0 |
|       5 | 100.0 |   5.0 |
+---------+-------+-------+

How do I create an Array [] [] using the result of this table in JAVA?

mysql java array array-multidimensional

asked by anonymous 18.01.2018 / 14:41

1 answer

Servlet is responding but ajax does not reflect response Issue with eSocial digital signature - Invalid signature

score 2 · Answer 1

For comments, Array is of type float with 5 rows and 3 columns by SQL , an example:

try {
    pst = conexao.prepareStatement(dadosGrafico);
    rs = pst.executeQuery();
    float[][] items = new float[5][3];
    int line = 0;
    while (rs.next()) 
    {
        items[line][0] = rs.getInt("sem_ip");
        items[line][1] = rs.getFloat("ipo");
        items[line][2] = rs.getFloat("ido");
        line++;
    }
}