Advertisement
Guest User

Untitled

a guest
Apr 17th, 2017
76
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.69 KB | None | 0 0
  1. My servlet code:``
  2.  
  3. package servlet;
  4.  
  5. import java.io.*;
  6.  
  7. import javax.servlet.*;
  8.  
  9. import javax.servlet.annotation.WebServlet;
  10.  
  11. import javax.servlet.http.HttpServlet;
  12.  
  13. import javax.servlet.http.HttpServletRequest;
  14.  
  15. import javax.servlet.http.HttpServletResponse;
  16.  
  17. import java.sql.*;
  18.  
  19. public class MyServlet extends HttpServlet
  20. {
  21.  
  22. Connection con=null;
  23.  
  24. public void init(ServletConfig config)
  25. {
  26. try{
  27. Class.forName("oracle.jdbc.driver.OracleDriver");
  28. String url="jdbc:oracle:thin:@localhost:1521:xe";
  29. String username="system";
  30. String password="manager";
  31. con=DriverManager.getConnection(url,username,password);
  32. if(con!=null){
  33. System.out.println("connetion established");
  34. }
  35. }catch(Exception e){
  36. e.printStackTrace();
  37. }
  38. }
  39.  
  40. public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException
  41. {
  42.  
  43.  
  44. String username=request.getParameter("username");
  45.  
  46. String password=request.getParameter("password");
  47.  
  48. String email=request.getParameter("email");
  49. String x=request.getParameter("phone");
  50. long phone=0;
  51. if(x!=null){
  52. phone =Long.parseLong(x);
  53. }
  54. try {
  55. PreparedStatement ps=con.prepareStatement("insert into students values(?,?,?,?)");
  56. ps.setString(1, username);
  57. ps.setString(2,password);
  58. ps.setString(3,email);
  59. ps.setLong(4, phone);
  60. ps.executeUpdate();
  61.  
  62. }catch(Exception e){
  63. e.printStackTrace();
  64. }
  65.  
  66. PrintWriter pw=response.getWriter();
  67. pw.println("<html><body bgcolor='powderblue'><center>");
  68. pw.println(username+"registered succesfully");
  69. pw.println("</center></body></html>");
  70. }
  71. }
  72.  
  73. here my html codes starts
  74.  
  75. <!DOCTYPE html>
  76. <html>
  77. <head>
  78. <meta charset="ISO-8859-1">
  79. <title>Welcome</title>
  80. </head>
  81. <body>
  82. <form action="./register" name="ureg" style="position: relative;left: 110px;" method="post" onsubmit="return validation()">
  83. <!-- USERNAME:<br>-->
  84. ENTER USERNAME:<BR>
  85. <input type="text" name="username" placeholder="Enter username"><br></br>
  86. <!-- PASSWORD:<br>-->
  87. ENTER PASSWORD:<BR>
  88. <input type="password" name="password" placeholder="Enter password"><br></br>
  89. ENTER MAIL:<BR>
  90. <input type="email" name="email" placeholder="Enter your email"><br></br>
  91. ENTER PHONE NO:<BR>
  92. <input type="text" name="phone" placeholder="Enter your mobile no" maxlength="10"><br></br>
  93.  
  94. &nbsp;<input type="submit" id="but" value="Register"style="background-color: yellowgreen;color: #ffffff"/>
  95. &nbsp;&nbsp; <input type="reset"id="but" value="Reset" style="background-color: #AA3300;color: #ffffff"></input><br></br>
  96.  
  97. </form>
  98.  
  99.  
  100.  
  101.  
  102. </body>
  103. </html>
  104.  
  105.  
  106.  
  107.  
  108. My xml file:
  109. <?xml version="1.0" encoding="UTF-8"?>
  110. <web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://java.sun.com/xml/ns/javaee" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd" id="WebApp_ID" version="3.0">
  111. <display-name>Practice1</display-name>
  112. <welcome-file-list>
  113. <welcome-file>register.html</welcome-file>
  114. <welcome-file>index.htm</welcome-file>
  115. <welcome-file>index.jsp</welcome-file>
  116. <welcome-file>default.html</welcome-file>
  117. <welcome-file>default.htm</welcome-file>
  118. <welcome-file>default.jsp</welcome-file>
  119. </welcome-file-list>
  120. <servlet>
  121. <servlet-name>registerapp</servlet-name>
  122. <servlet-class>MyServlet</servlet-class>
  123.  
  124. </servlet>
  125. <servlet-mapping>
  126. <servlet-name>registerapp</servlet-name>
  127. <url-pattern>/register</url-pattern>
  128. </servlet-mapping>
  129. </web-app>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement