satish19

pg1

Jan 15th, 2018
47
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.82 KB | None | 0 0
  1. <%@page import="java.awt.print.Printable"%>
  2. <%@ page import="java.sql.*"%>
  3. <%@ page import="java.util.*"%>
  4. <%@ page import="java.sql.Connection"%>
  5. <%@ page import="java.sql.DriverManager"%>
  6. <%@ page import="java.sql.Date"%>
  7. <%
  8. int ph=Integer.parseInt(request.getParameter("ph"));
  9. String pwd,uid;
  10. try
  11. {
  12. Class.forName("com.mysql.jdbc.Driver");
  13. Connection conn=DriverManager.getConnection(
  14. "jdbc:mysql://localhost:3306/satish","root","root");
  15. Statement st=null;
  16. ResultSet rs=null;
  17. String s="SELECT * FROM details WHERE ph_no="+ph;
  18. st=conn.createStatement();
  19. rs=st.executeQuery(s);
  20. if(rs.next())
  21. {
  22. uid=rs.getString(1);
  23. pwd=rs.getString(2);
  24. session.setAttribute("usr", uid);
  25. session.setAttribute("pass", pwd);
  26. session.setAttribute("ph", ph);
  27. }
  28. conn.close();
  29. }
  30. catch(Exception e)
  31. {out.println(e);}
  32. %>
Add Comment
Please, Sign In to add comment