Guest User

register servlet

a guest
Mar 19th, 2018
33
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.53 KB | None | 0 0
  1. protected void doPost(HttpServletRequest req, HttpServletResponse res) throws ServletException, IOException
  2. {
  3. PrintWriter out = res.getWriter();
  4. res.setContentType("text/html");
  5.  
  6. try
  7. {
  8. res.setContentType("text/html");
  9.  
  10. Class.forName("oracle.jdbc.driver.OracleDriver");
  11.  
  12. Connection con = DriverManager.getConnection( "jdbc:oracle:thin:@localhost:1521:XE" , "system" , "connect" );
  13.  
  14. String name = req.getParameter("name");
  15. String userName = req.getParameter("userName");
  16. String password = req.getParameter("password");
  17. String email = req.getParameter("email");
  18. String mobile = req.getParameter("mobile");
  19.  
  20. checkUserValid(con,userName);
  21.  
  22. PreparedStatement ps = con.prepareStatement("insert into table values( ?,?,?,?,? )");
  23. ps.setString(1, userName);
  24. ps.setString(2, name);
  25. ps.setString(3, password);
  26. ps.setString(4, email);
  27. ps.setString(5, mobile);
  28.  
  29. int x = ps.executeUpdate();
  30.  
  31. if(x>=1) {
  32. System.out.println("registration successful");
  33. } else {
  34. System.out.println("couldnot register");
  35. }
  36.  
  37. }
  38. catch(Exception e) {
  39. e.printStackTrace();
  40. }
  41. }
  42.  
  43. private boolean checkUserValid(Connection con,String userName) throws SQLException
  44. {
  45. Statement st = con.createStatement();
  46. ResultSet rs = st.executeQuery("select * from table where userName = "+userName);
  47.  
  48. try
  49. {
  50. if(rs.next())
  51. {
  52. return false;
  53. }
  54. }
  55. catch (SQLException e)
  56. {
  57. e.printStackTrace();
  58. }
  59. return true;
  60. }
Add Comment
Please, Sign In to add comment