Advertisement
Guest User

Untitled

a guest
Mar 28th, 2017
73
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.74 KB | None | 0 0
  1. public static String connectDataBase(String login, String password) throws ClassNotFoundException, SQLException {
  2. Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
  3. String url = "jdbc:sqlserver://127.0.0.1:1433;databaseName=LoginPassword;user=sa;password=Apple99878";
  4. Connection con = DriverManager.getConnection(url);
  5. String sql = "Select*from UserTable where UserLogin=? and UserPassword=?";
  6. PreparedStatement pst = con.prepareStatement(sql);
  7. pst.setString(1, login);
  8. pst.setString(2, password);
  9. ResultSet rs = pst.executeQuery();
  10.  
  11. if(rs.next()){
  12. return "true";
  13. }
  14. else
  15. {
  16. return "false";
  17. }
  18. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement