my code is:
index.jsp
<%@ page language="java" import="java.util.*" pageEncoding="ISO-8859-1"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">
<title>Country State List</title>
<script src="countries.js"></script>
<title>My JSP 'index.jsp' starting page</title>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
<!--
<link rel="stylesheet" type="text/css" href="styles.css">
-->
</head>
<body>
<form action="RegisterServlet" method="post">
First Name:<input type="text" name="fname"></br>
Last Name:<input type="text" name="lname"></br>
SSN :<input type="text" name="ssn"></br>
Country:<select id="country" name ="country"></select>
<br />
State: <select name ="state" id ="state"></select>
<br/><br />
<script language="javascript">
populateCountries("country", "state");
</script>
Date of birth: <input type="date" name= "dob"/>
<input type="submit" value ="register">
</form>
</form>
</body>
</html>
RegisterServleet.java
/*
* To change this license header, choose License Headers in Project Properties.
* To change this template file, choose Tools | Templates
* and open the template in the editor.
*/
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
/**
*
* @author srini
*/
@WebServlet(urlPatterns = {"/RegisterServlet"})
public class RegisterServlet extends HttpServlet {
/**
* Processes requests for both HTTP <code>GET</code> and <code>POST</code>
* methods.
*
* @param request servlet request
* @param response servlet response
* @throws ServletException if a servlet-specific error occurs
* @throws IOException if an I/O error occurs
*/
public void doGet(HttpServletRequest request,HttpServletResponse response)
throws IOException,ServletException{
processRequset (request,response);
}
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
processRequset (request,response);
}
public void processRequset(HttpServletRequest request,HttpServletResponse response)
throws IOException,ServletException{
response.setContentType("text/html;charset=UTF-8");
PrintWriter out = response.getWriter();
String fname =request.getParameter("fname");
String lname =request.getParameter("lname");
String ssn =request.getParameter("ssn");
String country =request.getParameter("country");
String state =request.getParameter("state");
String date =request.getParameter("dob");
try{
Class.forName("com.mysql.jdbc.Driver");
Connection con=DriverManager.getConnection(
"jdbc:mysql://localhost:3306/headway","root","toor");
PreparedStatement pstmt=con.prepareStatement("select fname,lname from employee where fname=? " );
pstmt.setString(1,fname);
ResultSet rs = pstmt.executeQuery();
if(rs.next())
{
out.println("<script type=\"text/javascript\">");
out.println("alert('User details are already exist ');");
out.print |  0 |
