Advertisement
Guest User

Untitled

a guest
Dec 11th, 2017
69
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 0.65 KB | None | 0 0
  1. //Valon Berisa
  2.     public boolean isLoginOK(String _user, String _pwd) throws Exception {
  3.         boolean isOK = false;
  4.         conn = createConnection(CONN_STRING); // let's assume there is already a Connection variable
  5.  
  6.         // Prepare statement
  7.         PreparedStatement myStmt = conn.prepareStatement("SELECT count(*) FROM member WHERE user=? AND passwort=?");
  8.  
  9.         // Set the parameters
  10.         myStmt.setString(1, _user);
  11.         myStmt.setString(2, _pwd);
  12.  
  13.         ResultSet rs = myStmt.executeQuery();
  14.  
  15.         if (rs.next() && rs.getInt(1) == 1) {
  16.             isOK = true;
  17.         }
  18.  
  19.         conn.close();
  20.         return isOK;
  21.     }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement