REGISTRATION FORM WITH JQUERY VALIDATION:
<html>
<head>
<title>TODO supply a title</title>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width">
</head>
<body>
<script type = "text/javascript" src = "https://ajax.googleapis.com/ajax/libs/jquery/2.1.3/jquery.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/jquery-validate/1.19.1/jquery.validate.min.js"></script>
<script>
jQuery.validator.addMethod("email", function(value, element) {
return /^(([^<>()[\]\\.,;:\s@\"]+(\.[^<>()[\]\\.,;:\s@\"]+)*)|(\".+\"))@((\[[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\])|(([a-zA-Z\-0-9]+\.)+[a-zA-Z]{2,}))$/.test(value) || /^[0-9]{10}$/.test(value);
});
jQuery(document).ready(function($) {
$("#signup").validate({
ignore: [],
rules: {
name: {
required: true
},
email: {
required: true,
email: true
},
phone: {
required: true,
minlength: 10,
maxlength: 10
},
pw: {
required: true,
minlength: 6
},
cp: {
required: true,
minlength: 6,
equalTo: "#pw"
}
},
messages: {
name: {
required: "Please enter the name."
},
email: {
required: "Please enter the email.",
email: "Please enter valid email id"
},
phone: {
required: "Please enter the number.",
minlength: "Please enter the number greater than 10.",
maxlength: "Please enter the number less than 10."
},
pw: {
required: "Please enter the password.",
minlength: "Please enter the password greater than 6.",
},
cp: {
required: "Please reenter the password.",
minlength: "Please enter the password greater than 6.",
equalTo: "mismatch password"
}
}
});
});
</script>
<style>
.error{
color:red;
}
</style>
<center>
<form method="POST" id ="signup" action="register">
<font color="green">
<h2> Sookshmas Registration Form</h2>
</font>
<table>
<tr>
<td> NAME </td>
<td> <input type="text" id="name" name="name"</td>
</tr>
<tr>
<td> PHONE NUMBER </td>
<td> <input type="number" name="phone" > </td>
</tr>
<tr>
<td> Email </td>
<td> <input type="email" name="email"></td>
</tr>
<tr>
<td> Password </td>
<td> <input type="password" id="pw" name="pw"></td>
</tr>
<tr>
<td> Confirm Password </td>
<td> <input type="password" name="cp"></td>
</tr>
<tr>
<td> </br> <input type="submit" name="submit" value="Register"</td>
</tr>
</table>
</form>
</center>
</body>
</html>
PACKAGE NAME: handler
Servlet name: register
import DAO.user;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.SQLException;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
@WebServlet(name = "register", urlPatterns = {"/register"})
public class register extends HttpServlet {
protected void processRequest(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException, SQLException {
response.setContentType("text/html;charset=UTF-8");
HttpSession session = request.getSession();
try (PrintWriter out = response.getWriter()) {
String name = request.getParameter("name");
String phone = request.getParameter("phone");
String email = request.getParameter("email");
String pw = request.getParameter("pw");
// System.out.println(name+"-"+phone+"-"+email+"---"+pw);
// String cpw =request.getParameter("cp");
user u = new user(session);
String status = u.register(name, phone, email, pw);
//System.out.println(status);
out.println("<html>");
out.println("<body bgcolor='lightblue'>");
out.println("<center><br><br>");
out.println("<font color='red' size='7'>");
if (status.equals("success"))
{
out.println("Registration Success");
}
if(status.equals("existed"))
{
out.println("User Existed Already");
}
if(status.equals("failure"))
{
out.println("Registration Failure");
}
out.println("</font></center></body></html>");
} catch (Exception e) {
e.printStackTrace();
}
}
@Override
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
try {
processRequest(request, response);
} catch (SQLException ex) {
ex.printStackTrace();
}
}
@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
try {
processRequest(request, response);
} catch (SQLException ex) {
ex.printStackTrace();
}
}
@Override
public String getServletInfo() {
return "Short description";
}
}
Package name: DAO
Java class: user.java
package DAO;
import java.sql.*;
import javax.servlet.http.HttpSession;
public class user
{
Connection con;
Statement st;
ResultSet rs = null;
String status = "";
HttpSession se;
student s;
public user(HttpSession session) {
try {
Class.forName("com.mysql.jdbc.Driver");
con = DriverManager.getConnection("jdbc:mysql://localhost:3306/sookshmas", "root", "root");
se = session;
} catch (Exception e) {
e.printStackTrace();
}
}
public String register(String name, String phone, String email, String pw) throws SQLException {
PreparedStatement ps;
try {
st = con.createStatement();
rs = st.executeQuery("select * from sookshmas where email='" + email + "'");
boolean b = rs.next();
if (b) {
status = "existed";
} else {
ps = (PreparedStatement) con.prepareStatement("insert into sookshmas values(0,?,?,?,?,now())");
// 0 – first column in sookshmas database ( slno-auto increment);
// now()- inserting current date and time
ps.setString(1, name);
ps.setString(2, phone);
ps.setString(3, email);
ps.setString(4, pw);
int a = ps.executeUpdate();
System.out.println(a);
if (a > 0) {
status = "success";
}
}
} catch (Exception e) {
status = "failure";
e.printStackTrace();
}
return status;
}
}
SQL :
CREATE TABLE sookshmas (
slno int(10) NOT NULL AUTO_INCREMENT,
name varchar(45) NOT NULL,
phone varchar(45) NOT NULL unique,
email varchar(45) NOT NULL unique,
password varchar(45) NOT NULL,
date datetime NOT NULL,
PRIMARY KEY (slno)
);
insert into sookshmas
values(0,'karthik','123456','[email protected]','pass',now());
