java - SQL查询仅显示一个结果(第一个)，但不显示所有结果

Question

这个问题已经有答案了:

JDBC ResultSet is giving only one row although there are many rows in table? (3 个回答)

已关闭 6 年前。

    private void search_fKeyReleased(java.awt.event.KeyEvent evt) {                                     
    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();

在文本区域中，我得到的是结果，而不是数据库中的两个可用结果

        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:
}

Answer 1

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) {
}