java. sql. SQLException: Before Start Of Result Set. how Can I Solve IT?

Question

How can I solve this error and what is the problem?

Here is my code:

     String sql = "select min(pressure),max(pressure),avg(pressure) from userinfo";
    pst = conn.prepareStatement(sql);
    rs = pst.executeQuery();
    String add1 = rs.getString("min(pressure)");
    min_pressure.setText(add1);
    String add2 = rs.getString("max(pressure)");
    max_pressure.setText(add2);
    String add3 = rs.getString("avg(pressure)");
    avg_pressure.setText(add3);
    }
    catch(Exception e){
        JOptionPane.showMessageDialog(null, e);
    }

This results in the exception:

java. sql. SQLException: Before Start Of ResultSet

You should also use the [try-with-resources statement](http://stackoverflow.com/questions/8066501/how-should-i-use-try-with-resources-with-jdbc) for managing JDBC resources efficiently and properly. — Mick Mnemonic, Mar 27 '16 at 18:30
you might want to go through the [JDBC tutorial](http://docs.oracle.com/javase/tutorial/jdbc/basics/processingsqlstatements.html) — , Mar 27 '16 at 18:39

score 3 · Accepted Answer · answered Mar 27 '16 at 18:18

3

The ResultSet javadoc says (in part) initially the cursor is positioned before the first row. Advance the resultset cursor to the first row by calling next() like

rs = pst.executeQuery();
rs.next(); // <-- or if (rs.next()) {
String add1 = rs.getString("min(pressure)");

answered Mar 27 '16 at 18:18

Elliott Frisch

198,278
20
158
249

Thanks @Elliot Frisch .Finally I solve it .... – Raihan Uddin Mar 27 '16 at 18:28

score 0 · Answer 2 · edited Mar 28 '16 at 17:06

0

rs = pst.executeQuery();
if (rs.next()) {
    String add1 = rs.getStr
}

edited Mar 28 '16 at 17:06

Floern

33,559
24
104
119

answered Mar 28 '16 at 16:46

Nazrul Islam

1

java. sql. SQLException: Before Start Of Result Set. how Can I Solve IT?

2 Answers2