Guest User

Untitled

a guest
Jun 28th, 2018
36
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.23 KB | None | 0 0
  1. try {
  2. Class.forName("com.mysql.jdbc.Driver");
  3. Connection con=DriverManager.getConnection("jdbc:mysql://192.168.100.75:3307/dac22", "dac22","welcome");
  4. Statement s=con.createStatement();
  5. String query="select uname,password from exam where uname=? and password=?";
  6. PreparedStatement ps=con.prepareStatement(query);
  7. ps.setString(1, u);
  8. ps.setString(2, p);
  9. ResultSet rs=ps.executeQuery();
  10. if(rs.next())
  11. {
  12. String u1=rs.getString(1);
  13. String p1=rs.getString(2);
  14.  
  15.  
  16. System.out.println(rs.getString(1)+" "+rs.getString(2));
  17. if(u.equals(u1)&& p.equals(p1))
  18. {
  19. rd=request.getRequestDispatcher("Hello_world.jsp");
  20.  
  21.  
  22. session=request.getSession();
  23. session.setAttribute("name", u);
  24. rd.forward(request, response);
  25. }
  26.  
  27. else
  28. {
  29. rd=request.getRequestDispatcher("Login.jsp");
  30. pw.write("wrong");
  31. rd.include(request, response);
  32.  
  33. }
  34. }
  35. } catch (ClassNotFoundException e) {
  36.  
  37. e.printStackTrace();
  38. } catch (SQLException e) {
  39.  
  40. e.printStackTrace();
  41. }
  42.  
  43. }
Add Comment
Please, Sign In to add comment