Advertisement
Guest User

Untitled

a guest
Oct 24th, 2016
88
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.27 KB | None | 0 0
  1. package com.jwt.servlet;
  2.  
  3. import java.io.IOException;
  4. import java.io.PrintWriter;
  5. import java.sql.Connection;
  6. import java.sql.DriverManager;
  7. import java.sql.PreparedStatement;
  8.  
  9. import javax.servlet.ServletException;
  10. import javax.servlet.http.HttpServlet;
  11. import javax.servlet.http.HttpServletRequest;
  12. import javax.servlet.http.HttpServletResponse;
  13.  
  14.  
  15.  
  16. public class RegisterServlet extends HttpServlet {
  17.  
  18.  
  19. public void doPost(HttpServletRequest request, HttpServletResponse response)
  20. throws ServletException, IOException {
  21.  
  22. response.setContentType("text/html");
  23. PrintWriter out = response.getWriter();
  24.  
  25. String n = request.getParameter("userName");
  26. String p = request.getParameter("password");
  27. String e = request.getParameter("email");
  28. String c = request.getParameter("language");
  29. try{
  30. System.out.println("connecting...");
  31.  
  32. Class.forName("com.mysql.jdbc.Driver");
  33. System.out.println("connecting to physical database...");
  34. Connection con = DriverManager.getConnection(
  35. "jdbc:mysql://localhost:3306/User1", "root", "root");
  36.  
  37. PreparedStatement ps = con.prepareStatement("insert into USERDETAILS values(?,?,?,?)");
  38. System.out.println("Connection has been made");
  39.  
  40. ps.setString(1, n);
  41. ps.setString(2, p);
  42. ps.setString(3, e);
  43. ps.setString(4, c);
  44.  
  45. int i = ps.executeUpdate();
  46. if (i > 0)
  47. out.print("You are successfully registered...");
  48.  
  49. } catch (Exception e2) {
  50. System.out.println(e2);
  51. }
  52.  
  53.  
  54. out.close();
  55. }
  56.  
  57. }
  58.  
  59. <%@ page language="java" contentType="text/html; charset=ISO-8859-1"
  60. pageEncoding="ISO-8859-1"%>
  61. <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
  62. <html>
  63. <head>
  64. <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
  65. <title>Insert title here</title>
  66. <script>
  67. function validateForm() {
  68. var x = document.forms["myForm"]["userName"].value;
  69. var y = document.forms["myForm"]["password"].value;
  70. var z = document.forms["myForm"]["email"].value;
  71. var checkString = document.myForm.userName.value;
  72.  
  73.  
  74. if ((x == null || x == "") || (y==null || y=="") || (z==null || z=="" ) )
  75. {
  76. alert("Enter the mandatory fields");
  77. return false;
  78. }
  79. }
  80. </script>
  81. </head>
  82. <body>
  83. <div style="background-color:grey;color:white;padding:25px 75px 25px 50px; text-align:center; border: 1px solid red; display:inline-block; text- style:bold">
  84. <form name="myForm" action="register" onsubmit="return validateForm()" method="post">
  85. <p id="tt" style="margin-left"></p>
  86. <script>
  87. document.getElementById("tt").innerHTML = Date();
  88. </script>
  89. Name*:<input type="text" name="userName" placeholder="Enter Name" style="margin-left:35px; " onkeypress="return alpha(event)" /><br/>
  90. Password*:<input type="password" name="password" style="margin- left:12px; margin-top:10px" placeholder="Enter Password" /><br/>
  91. Email Id*:<input type="text" name="email" placeholder="Enter Email Id" style="margin-left:18px; margin-top:10px" /><br/>
  92. Language: <select name="language" style="margin-left:80px; margin-top:10px">
  93. <option>--Select--</option>
  94. <option>Hindi</option>
  95. <option>English</option>
  96. <option>French</option>
  97. </select> <br/>
  98. <p id="demo" style="display:none">Saved...</p>
  99. <input type="submit" onclick="document.getElementById('demo').style.display='block'" value="Submit" style="margin-left:150px; margin-top:10px"/>
  100. <footer style="margin-bottom"> By </footer>
  101. </form>
  102. </div>
  103. </body>
  104. </html>
  105.  
  106. <?xml version="1.0" encoding="UTF-8"?>
  107. <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" version="3.0">
  108. <display-name>ServletDBExample</display-name>
  109. <servlet>
  110. <servlet-name>Register</servlet-name>
  111. <servlet-class>com.jwt.servlet.RegisterServlet</servlet-class>
  112. </servlet>
  113.  
  114.  
  115.  
  116. <servlet-mapping>
  117. <servlet-name>Register</servlet-name>
  118. <url-pattern>/register</url-pattern>
  119. </servlet-mapping>
  120.  
  121. <welcome-file-list>
  122. <welcome-file>register.jsp</welcome-file>
  123. </welcome-file-list>
  124. </web-app>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement