Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- //Valon Berisa
- public boolean isLoginOK(String _user, String _pwd) throws Exception {
- boolean isOK = false;
- conn = createConnection(CONN_STRING); // let's assume there is already a Connection variable
- // Prepare statement
- PreparedStatement myStmt = conn.prepareStatement("SELECT count(*) FROM member WHERE user=? AND passwort=?");
- // Set the parameters
- myStmt.setString(1, _user);
- myStmt.setString(2, _pwd);
- ResultSet rs = myStmt.executeQuery();
- if (rs.next() && rs.getInt(1) == 1) {
- isOK = true;
- }
- conn.close();
- return isOK;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement