Advertisement
Guest User

Untitled

a guest
Sep 3rd, 2015
63
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.38 KB | None | 0 0
  1. <%--
  2. Document : register1
  3. Created on : Sep 3, 2015, 3:21:27 AM
  4. Author : kbp
  5. --%>
  6.  
  7. <%@page contentType="text/html" import="java.sql.*;" pageEncoding="UTF-8"%>
  8. <!DOCTYPE html>
  9. <html>
  10. <head>
  11. <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  12. <title>JSP Page</title>
  13. </head>
  14. <body>
  15. <%
  16. String username=request.getParameter("t1");
  17. String password=request.getParameter("t2");
  18. String firstname=request.getParameter("t3");
  19. String lastname=request.getParameter("t4");
  20. String email=request.getParameter("t5");
  21. try{
  22. Class.forName("oracle.jdbc.driver.OracleDriver");
  23. Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:XE","system","tiger");
  24. PreparedStatement ps=con.prepareStatement("insert into reg values(?,?,?,?,?)");
  25. ps.setString(1,username);
  26. ps.setString(2,password);
  27. ps.setString(3,firstname);
  28. ps.setString(4,lastname);
  29. ps.setString(5,email);
  30. ps.executeUpdate();
  31. out.println("Registration Done!!");
  32.  
  33.  
  34. }
  35. catch(Exception e)
  36. {
  37. out.println("Error"+e);
  38.  
  39. }
  40.  
  41. %>
  42. </body>
  43. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement