Store form information in MySQL database using jsp

Question

<%@page import="javax.servlet.*"%>
<%@page import="java.sql.*"%>
<%@page import="java.util.*"%>
<%@page import="java.lang.Object.*"%>
<%@page import="java.text.*"%>
<% 
String empid=request.getParameter("Emp.Id");
String sname=request.getParameter("sname");
String designation=request.getParameter("designation");
String category=request.getParameter("category");
String  dept=request.getParameter("dept");
java.util.Date d=new SimpleDateFormat("yyyy-MM-   dd").parse(request.getParameter("dob"));
java.sql.Date dob=new java.sql.Date(d.getTime());
String age=request.getParameter("age");
java.util.Date dj=new SimpleDateFormat("yyyy-MM-dd").parse(request.getParameter("doj"));
java.sql.Date doj=new java.sql.Date(dj.getTime());
String gender=request.getParameter("gender");
String community=request.getParameter("community");
String education=request.getParameter("education");
String yoe=request.getParameter("yoe");
String pdoor=request.getParameter("pdoor");
String padd1=request.getParameter("padd1");
String padd2=request.getParameter("padd2");
String pcity=request.getParameter("pcity");
String ptaluk=request.getParameter("ptaluk");
String pdistrict=request.getParameter("pdistrict");
String ppcode=request.getParameter("ppcode");
String pstate=request.getParameter("pstate");
String cdoor=request.getParameter("cdoor");
String cadd1=request.getParameter("cadd1");
String cadd2=request.getParameter("cadd2");
String ccity=request.getParameter("ccity");
String ctaluk=request.getParameter("ctaluk");
String cdistrict=request.getParameter("cdistrict");
String cpcode=request.getParameter("cpcode");
String cstate=request.getParameter("cstate");
String email=request.getParameter("email");
String ms=request.getParameter("ms");
String noc=request.getParameter("noc");
String fsname=request.getParameter("fsname");
String fsocc=request.getParameter("fsocc");
String fsadd=request.getParameter("fsadd");
String fsmob=request.getParameter("fsmob");
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/mysql",
        "root", "mysql23");
Statement st = con.createStatement();
 int i=st.executeUpdate("insert into staffdetail(empid,sname,designation,category,dept,dob,age,doj,gender,community,education,yoe,pdoor,padd1,padd2,pcity,ptaluk,pdistrict,ppcode,pstate,cdoor,cadd1,cadd2,ccity,ctaluk,cdistrict,cpcode,cstate,emailid,mstatus,nchild,fsname,fsocc,fsaddress,fsmobile) values("+empid+",'"+sname+"','"+designation+"','"+category+"','"+dept+"','"+dob+"','"+age+"','"+doj+"','"+gender+"','"+community+"','"+education+"','"+yoe+"','"+pdoor+"','"+padd1+"','"+padd2+",'"+pcity+"','"+ptaluk+"','"+pdistrict+"','"+ppcode+"','"+pstate+"','"+cdoor+"','"+cadd1+"','"+cadd2+"','"+ccity+"','"+ctaluk+"','"+cdistrict+"','"+cpcode+"','"+cstate+"','"+email+"','"+ms+"','"+noc+"','"+fsname+"','"+fsocc+"','"+fsadd+"','"+fsmob+"')");
 if(i>0)
 {
response.sendRedirect("over.jsp");
  }
 else
{
 response.sendRedirect("over1.jsp");
  }

%>

The error is

javax.servlet.ServletException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version

The mysql class doesnt seem to be imported. Please provide your code. — Mad Dog Tannen, Feb 10 '16 at 09:00

score 0 · Answer 1 · answered Feb 10 '16 at 09:23

0

mysql-jdbc-connector.jar should be added into your project. so your jsp ll communicate to MySql database

answered Feb 10 '16 at 09:23

Prabakaran Mathi

11
1

but now i am getting like mysql syntex is wrong check proper mannual for your mysql version.javax.servlet.ServletException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version – VINU Feb 10 '16 at 16:43

score 0 · Accepted Answer · edited May 23 '17 at 12:07

0

The MySQL JDBC driver is not on your runtime classpath. You firstly need to download the JAR from here:

https://dev.mysql.com/downloads/connector/j/

You then need to copy it to a shared library folder on your server/container (rather than bundling it with your application - Why must the JDBC driver be put in TOMCAT_HOME/lib folder?).

Where exactly this is depends on your server:

For Tomcat 8 copy the JAR to TOMCAT_HOME/lib

For Jetty 9 copy the JAR to JETTY_HOME/lib/ext.

edited May 23 '17 at 12:07

Community

1
1

answered Feb 10 '16 at 10:08

Alan Hay

22,665
4
56
110

i have added connector jar file.few datas are stored when i make the mobile numbers are commends.but when i try to store the all values i am getting errors..the exception is javax.servlet.ServletException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's Street,kurichi(po),','Bhavani(tk),erode(dt)','kurichi','bhavani','erode','6383' at line 1....here these address are which i given in webpage – VINU Mar 07 '16 at 17:23

Store form information in MySQL database using jsp

2 Answers2