
the code is as follow
import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class InsertServlet extends HttpServlet{
public void doPost(HttpServletRequest req,HttpServletResponse res) throws ServletException,IOException {
res.setContentType("text/html");
int count=0;
PrintWriter out = res.getWriter();
String FirstName=req.getParameter("FirstName");
String LastName=req.getParameter("LastName");
String Email=req.getParameter("Email");
String Password=req.getParameter("Password");
String ConformPassword=req.getParameter("ConformPassword");
String Dateofbirth=req.getParameter("Dateofbirth");
int Age=Integer.parseInt(req.getParameter("Age"));
String Gender=req.getParameter("Gender");
String Address=req.getParameter("Address");
String Country=req.getParameter("Country");
String State=req.getParameter("State");
String City=req.getParameter("City");
int Telephone=Integer.parseInt(req.getParameter("Telephone"));
int Mobile=Integer.parseInt(req.getParameter("Mobile"));
String Howdidyouhear=req.getParameter("Howdidyouhear");
PreparedStatement pstm=null;
try{
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver ");
String connectionUrl = ("jdbc:sqlserver://localhost:1433;database=sree;integratedSecurity=true");
Connection con = DriverManager.getConnection(connectionUrl);
pstm=con.prepareStatement("insert into stureg(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)");
pstm.setString(1,FirstName);
pstm.setString(2,LastName);
pstm.setString(3,Email);
pstm.setString(4,Password);
pstm.setString(5,ConformPassword);
pstm.setString(6,Dateofbirth);
pstm.setInt(7,Age);
pstm.setString(8,Gender);
pstm.setString(9,Address);
pstm.setString(10,Country);
pstm.setString(11,State);
pstm.setString(12,City);
pstm.setInt(13,Telephone);
pstm.setInt(14,Mobile);
pstm.setString(15,Howdidyouhear);
int i=pstm.executeUpdate();
if(i==1){
System.out.print("insert");
}
else{
System.out.print("not insert");
}
}
catch(Exception e){
e.getMessage();
}
}
}

Here the given code works fine:
import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class InsertServlet extends HttpServlet{
public void doPost(HttpServletRequest req,HttpServletResponse res) throws ServletException,IOException {
res.setContentType("text/html");
int count=0;
PrintWriter out = res.getWriter();
String FirstName=req.getParameter("FirstName");
String LastName=req.getParameter("LastName");
String Email=req.getParameter("Email");
String Password=req.getParameter("Password");
String ConformPassword=req.getParameter("ConformPassword");
String Dateofbirth=req.getParameter("Dateofbirth");
int Age=Integer.parseInt(req.getParameter("Age"));
String Gender=req.getParameter("Gender");
String Address=req.getParameter("Address");
String Country=req.getParameter("Country");
String State=req.getParameter("State");
String City=req.getParameter("City");
int Telephone=Integer.parseInt(req.getParameter("Telephone"));
int Mobile=Integer.parseInt(req.getParameter("Mobile"));
String Howdidyouhear=req.getParameter("Howdidyouhear");
PreparedStatement pstm=null;
try{
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver ");
String connectionUrl = ("jdbc:sqlserver://localhost:1433;database=sree;integratedSecurity=true");
Connection con = DriverManager.getConnection(connectionUrl);
pstm=con.prepareStatement("insert into stureg(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)");
pstm.setString(1,FirstName);
pstm.setString(2,LastName);
pstm.setString(3,Email);
pstm.setString(4,Password);
pstm.setString(5,ConformPassword);
pstm.setString(6,Dateofbirth);
pstm.setInt(7,Age);
pstm.setString(8,Gender);
pstm.setString(9,Address);
pstm.setString(10,Country);
pstm.setString(11,State);
pstm.setString(12,City);
pstm.setInt(13,Telephone);
pstm.setInt(14,Mobile);
pstm.setString(15,Howdidyouhear);
int i=pstm.executeUpdate();
if(i==1){
System.out.print("insert");
}
else{
System.out.print("not insert");
}
}
catch(Exception e){
e.getMessage();
}
}
}
If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.
Ask your questions, our development team will try to give answers to your questions.