Advertisement
Guest User

client-server execute Login

a guest
Mar 11th, 2016
86
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 0.87 KB | None | 0 0
  1. //server
  2. PreparedStatement statement = null;
  3.     try {
  4.         statement = DatabaseUtilities.getConnection().prepareStatement(
  5.                 "SELECT * FROM user where id_user=? and password=MD5(?)");
  6.         statement.setString(1, ids);
  7.         statement.setString(2, password);
  8.         ResultSet result = statement.executeQuery();
  9.         User us = null;
  10.         if (result.next()) {
  11.             us = new User();
  12.             us.setUserID(result.getString("id_user"));
  13.             us.setUsername(result.getString("username"));
  14.             us.setPassword(result.getString("password"));
  15.         }
  16.  
  17. //client
  18. User us = salesmanService.getUser(ids, password);
  19.  
  20.         if (us != null) {
  21.             if (us.getUserID().equals(ids) && us.getPassword().equals(password)) {
  22.                 return true;
  23.             } else {
  24.                 return false;
  25.             }
  26.         }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement