Advertisement
Guest User

Untitled

a guest
Oct 7th, 2018
146
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 0.79 KB | None | 0 0
  1.  
  2. import java.sql.DriverManager;
  3. import java.sql.ResultSet;
  4. import java.sql.SQLException;
  5.  
  6. public class Jdbc {
  7.  
  8.     static java.sql.Connection connection = null;
  9.     static java.sql.Statement statement = null;
  10.  
  11.     static boolean checkUser(String user, String password) {
  12.        
  13.  
  14.         try {
  15.             connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/login", "root", "");
  16.             statement = connection.createStatement();
  17.  
  18.             String select = "select * from login    where user" + user + "password" + password;
  19.             System.out.println("The SQL is :" + select);
  20.             ResultSet rset = statement.executeQuery(select);
  21.  
  22.             user = rset.getString("user");
  23.             password = rset.getString("password");
  24.             rset.next();
  25.         }
  26.  
  27.         catch (SQLException ex) {
  28.             ex.printStackTrace();
  29.         }
  30.         return true;
  31.     }
  32.  
  33. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement