Advertisement
Guest User

Untitled

a guest
Apr 29th, 2016
55
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.74 KB | None | 0 0
  1. public String authorize(String loginemail,String pass){
  2. Connection conn=null;
  3. boolean correctPassword=false;
  4. String pwd="default";
  5. PreparedStatement st=null;
  6. try{
  7. Class.forName("com.mysql.jdbc.Driver");
  8. conn=DriverManager.getConnection(DB_URI,DB_USERNAME,DB_USERNAME);
  9. st=conn.prepareStatement("SELECT Password FROM users WHERE Email = ?");
  10. st.setString(1,"'"+loginemail+"'");
  11.  
  12. ResultSet rs=st.executeQuery();
  13.  
  14.  
  15. if(rs.next())
  16. pwd=rs.getString("Password"); //(SQLException)error in this line
  17. }
  18.  
  19. catch(SQLException se){
  20. se.printStackTrace();
  21. }
  22. catch(Exception e){
  23. e.printStackTrace();
  24. }
  25. finally{
  26. return pwd;
  27. }
  28. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement