SQL query shows only one result (the first one) but not all the result

Question

    private void search_fKeyReleased(java.awt.event.KeyEvent evt) {                                     
    try {

is ther something wrong here

        PreparedStatement pst =null;
        ResultSet rst=(ResultSet) pst;
        Connection con=(Connection)  
        DriverManager.getConnection("jdbc:mysql://localhost/iqari", 
        "root","");


        String sql="select * from first where  masaha_iqar=?";
        pst=(PreparedStatement) con.prepareStatement(sql);
        pst.setString(1,search_f.getText());
        rst=pst.executeQuery();

in the text area i get on result instead of two available in my database

        if (rst.next()){String add1=rst.getString("raqm_iqar");
        jTextArea2.append(add1 + "\n");

        System.out.format("%s",add1);
        }

    } catch (Exception e) {
    }
  TODO add your handling code here:
}

1

instead of if, use while loop. – SMA Sep 12 '16 at 10:22

score 0 · Answer 1 · answered Sep 12 '16 at 10:24

try {
    PreparedStatement pst =null;
    ResultSet rst=(ResultSet) pst;

    Connection con=(Connection)    DriverManager.getConnection("jdbc:mysql://localhost/iqari", "root","");
    String sql="select * from first where  masaha_iqar=?";
    pst=(PreparedStatement) con.prepareStatement(sql);
    pst.setString(1,search_f.getText());
    rst=pst.executeQuery();
   while (rst.next()){String add1=rst.getString("raqm_iqar");
    jTextArea2.append(add1 + "\n");
    System.out.format("%s",add1);
    }

} catch (Exception e) {
}

thanks a lot you saved my life Rakesh :) – ehab Sep 12 '16 at 10:39 — ehab, Sep 12 '16 at 10:39

SQL query shows only one result (the first one) but not all the result

1 Answers1