Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public static User LoginU(String emailAddress)
- {
- try {
- Class.forName("com.mysql.jdbc.Driver");
- // get a connection
- String dbURL = "jdbc:mysql://localhost:3306/twitterdb";
- String username = "root";
- String password = "sesame";
- Connection connection = DriverManager.getConnection(dbURL, username, password);
- PreparedStatement ps = null;
- ResultSet rs = null;
- String query = "SELECT * FROM User "
- + "WHERE username = ?";
- ps = connection.prepareStatement(query);
- ps.setString(1, emailAddress);
- rs = ps.executeQuery();
- User user = null;
- if(rs.next())
- {
- user = new User();
- user.setFullName(rs.getString("fullname"));
- user.setUserName(rs.getString("username"));
- user.setEmail(rs.getString("emailAddress"));
- user.setPassword(rs.getString("password"));
- user.setBirthdate(rs.getString("bitrhdate"));
- user.setQuestionNo(rs.getString("questionNo"));
- user.setAnswer(rs.getString("answer"));
- }
- return user;
- } catch (SQLException e) {
- System.out.println(e);
- return null;
- } catch (ClassNotFoundException ex) {
- Logger.getLogger(UserDB.class.getName()).log(Level.SEVERE, null, ex);
- }
- return null;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement