How to get a single value back from query vs resultset
I have used similar kind of thing to validate user login.
String sql = "SELECT * FROM login WHERE username=? AND password=?"; try { PreparedStatement statement; statement = connection.prepareStatement(sql); statement.setString(1, "hardik"); // set input parameter 1 statement.setString(2, "welcome"); // set input parameter 2 ResultSet rs = statement.executeQuery(); if(rs.next()){ // fetch data from resultset } }catch(SQLException sqle){ sqle.printStackTrace(); }