Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- try {
- Class.forName("com.mysql.jdbc.Driver");
- Connection con=DriverManager.getConnection("jdbc:mysql://192.168.100.75:3307/dac22", "dac22","welcome");
- Statement s=con.createStatement();
- String query="select uname,password from exam where uname=? and password=?";
- PreparedStatement ps=con.prepareStatement(query);
- ps.setString(1, u);
- ps.setString(2, p);
- ResultSet rs=ps.executeQuery();
- if(rs.next())
- {
- String u1=rs.getString(1);
- String p1=rs.getString(2);
- System.out.println(rs.getString(1)+" "+rs.getString(2));
- if(u.equals(u1)&& p.equals(p1))
- {
- rd=request.getRequestDispatcher("Hello_world.jsp");
- session=request.getSession();
- session.setAttribute("name", u);
- rd.forward(request, response);
- }
- else
- {
- rd=request.getRequestDispatcher("Login.jsp");
- pw.write("wrong");
- rd.include(request, response);
- }
- }
- } catch (ClassNotFoundException e) {
- e.printStackTrace();
- } catch (SQLException e) {
- e.printStackTrace();
- }
- }
Add Comment
Please, Sign In to add comment