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 |