MarcosInfo
asked on
MS Access Database, Tomcat Server, JSP Form and Insert jsp
I have been working for a while on this. And cannot get all to work. I have tomcat runnning well, it sees MS Access,
Upon Submit of Form I want to insert the data to Access on my local host pc, No luck so far CAN ANYONE SPOT inmy CODE where I may have issues..? AND can anyone simplify the insertion? I got help from a friend but really am lost on all the stuff....HELP!
<%@ page language="java" import="java.sql.*"%>
<%
String driver = "sun.jdbc.odbc.JdbcOdbcDri ver";
Class.forName(driver);
String url = "jdbc:odbc:Northwind";
String username = "";
String password = "";
Connection con=null;
ResultSet rst=null;
Statement stmt=null;
%>
<% //VERIFY SUBMIT IS PRESSED BEFORE INSERTING DATA
if("pressed".equals(reques t.getParam eter("id") )){
//MAKE CONX
//GET READY TO ENTER TO DATABASE
int i=1;
con = DriverManager.getConnectio n(url, username, password);
stmt=con.createStatement() ;
String x_Name = request.getParameter("Name ");
String x_Gender = request.getParameter("Gend er");
String x_DOB = request.getParameter("DOB" );
String x_Address1= request.getParameter("Addr ess1");
String x_Address2= request.getParameter("Addr ess2");
String x_City= request.getParameter("City ");
String x_State= request.getParameter("Stat e");
String x_Zip= request.getParameter("Zip" );
String x_Phone= request.getParameter("Phon e");
String x_Comments1= request.getParameter("Comm ents1");
String x_Comments2= request.getParameter("Comm ents2");
String x_Comments3= request.getParameter("Comm ents3");
String x_Comments4= request.getParameter("Comm ents4");
String x_Date = request.getParameter("Date ");
String x_Email = request.getParameter("Emai l");
String sql = "insert into jsp_table ";
sql +=
"(NAME,GENDER,DOB,ADDRESS1 ,ADDRESS1, CITY,STATE ,ZIP,PHONE ,COMMENTS1 ,COMMENTS2 ,COMMENTS3 ,COMMENTS4 ,DATE,EMAI L)
";
sql += " values ('";
sql += x_Name ;
sql += "','";
sql += x_Gender;
sql += "','";
sql += x_DOB;
sql += "','" ;
sql += x_Address1 ;
sql += "','" ;
sql += x_Address2;
sql += "','" ;
sql += x_City ;
sql += "','" ;
sql += x_State ;
sql += "'," ;
sql += x_Zip ;
sql += ",'" ;
sql += x_Phone;
sql += "','" ;
sql += x_Comments1;
sql += "','";
sql += x_Comments2 ;
sql += "','" ;
sql += x_Comments3 ;
sql += "','" ;
sql += x_Comments4 ;
sql += "','" ;
sql += x_Date ;
sql += "','" ;
sql += x_Email;
sql += "')";
//out.println(sql);
int val = stmt.executeUpdate(sql);
//if the insert was successfull, display all the values in the database
ordered decending by the insert date
if(val==1) {
out.println("<p>The following values have been entered in the
database<br>");
String sql2=("select * from JSP_TABLE");
rst=stmt.executeQuery(sql2 );
while(rst.next()){
out.println(rst.getString( 1));
out.println(" ");
out.println(rst.getString( 2));
out.println(" ");
out.println(rst.getString( 3));
out.println(" ");
out.println(rst.getString( 4));
out.println(" ");
out.println(rst.getString( 5));
out.println(" ");
out.println(rst.getString( 6));
out.println(" ");
out.println(rst.getString( 7));
out.println(" ");
out.println(rst.getString( 8));
out.println(" ");
out.println(rst.getString( 9));
out.println(" ");
out.println(rst.getString( 10));
out.println(" ");
out.println(rst.getString( 11));
out.println(" ");
out.println(rst.getString( 12));
out.println(" ");
out.println(rst.getString( 13));
out.println(" ");
out.println(rst.getString( 14));
out.println(" ");
out.println(rst.getString( 15));
out.println("<br>");
}//end while
out.println("<a href=\"InsertForm.jsp\">TH ANKS BACK TO ENTRY PAGE</a>");
out.println("</p>");
}else{
out.println("<p>There is a problem, your data was not saved</p>");
}
//Close all open connections when done.
rst.close();
stmt.close();
con.close();
//}else{
//do nothing
//}
%>
ERROR WHEN RUN:
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.apache.jasper.JasperEx ception: Unable to compile class for JSP
An error occurred at line: 19 in the jsp file: /insertdata.jsp
Generated servlet error:
String literal is not properly closed by a double-quote
An error occurred at line: 19 in the jsp file: /insertdata.jsp
Generated servlet error:
String literal is not properly closed by a double-quote
Generated servlet error:
Syntax error, insert "}" to complete ClassBody
org.apache.jasper.servlet. JspServlet Wrapper.ha ndleJspExc eption(Jsp ServletWra pper.java: 510)
org.apache.jasper.servlet. JspServlet Wrapper.se rvice(JspS ervletWrap per.java:3 75)
org.apache.jasper.servlet. JspServlet .serviceJs pFile(JspS ervlet.jav a:314)
org.apache.jasper.servlet. JspServlet .service(J spServlet. java:264)
javax.servlet.http.HttpSer vlet.servi ce(HttpSer vlet.java: 802)
root cause
org.apache.jasper.JasperEx ception: Unable to compile class for JSP
An error occurred at line: 19 in the jsp file: /insertdata.jsp
Generated servlet error:
String literal is not properly closed by a double-quote
An error occurred at line: 19 in the jsp file: /insertdata.jsp
Generated servlet error:
String literal is not properly closed by a double-quote
Generated servlet error:
Syntax error, insert "}" to complete ClassBody
org.apache.jasper.compiler .DefaultEr rorHandler .javacErro r(DefaultE rrorHandle r.java:84)
org.apache.jasper.compiler .ErrorDisp atcher.jav acError(Er rorDispatc her.java:3 28)
org.apache.jasper.compiler .JDTCompil er.generat eClass(JDT Compiler.j ava:414)
org.apache.jasper.compiler .Compiler. compile(Co mpiler.jav a:297)
org.apache.jasper.compiler .Compiler. compile(Co mpiler.jav a:276)
org.apache.jasper.compiler .Compiler. compile(Co mpiler.jav a:264)
org.apache.jasper.JspCompi lationCont ext.compil e(JspCompi lationCont ext.java:5 63)
org.apache.jasper.servlet. JspServlet Wrapper.se rvice(JspS ervletWrap per.java:3 03)
org.apache.jasper.servlet. JspServlet .serviceJs pFile(JspS ervlet.jav a:314)
org.apache.jasper.servlet. JspServlet .service(J spServlet. java:264)
javax.servlet.http.HttpSer vlet.servi ce(HttpSer vlet.java: 802)
Upon Submit of Form I want to insert the data to Access on my local host pc, No luck so far CAN ANYONE SPOT inmy CODE where I may have issues..? AND can anyone simplify the insertion? I got help from a friend but really am lost on all the stuff....HELP!
<%@ page language="java" import="java.sql.*"%>
<%
String driver = "sun.jdbc.odbc.JdbcOdbcDri
Class.forName(driver);
String url = "jdbc:odbc:Northwind";
String username = "";
String password = "";
Connection con=null;
ResultSet rst=null;
Statement stmt=null;
%>
<% //VERIFY SUBMIT IS PRESSED BEFORE INSERTING DATA
if("pressed".equals(reques
//MAKE CONX
//GET READY TO ENTER TO DATABASE
int i=1;
con = DriverManager.getConnectio
stmt=con.createStatement()
String x_Name = request.getParameter("Name
String x_Gender = request.getParameter("Gend
String x_DOB = request.getParameter("DOB"
String x_Address1= request.getParameter("Addr
String x_Address2= request.getParameter("Addr
String x_City= request.getParameter("City
String x_State= request.getParameter("Stat
String x_Zip= request.getParameter("Zip"
String x_Phone= request.getParameter("Phon
String x_Comments1= request.getParameter("Comm
String x_Comments2= request.getParameter("Comm
String x_Comments3= request.getParameter("Comm
String x_Comments4= request.getParameter("Comm
String x_Date = request.getParameter("Date
String x_Email = request.getParameter("Emai
String sql = "insert into jsp_table ";
sql +=
"(NAME,GENDER,DOB,ADDRESS1
";
sql += " values ('";
sql += x_Name ;
sql += "','";
sql += x_Gender;
sql += "','";
sql += x_DOB;
sql += "','" ;
sql += x_Address1 ;
sql += "','" ;
sql += x_Address2;
sql += "','" ;
sql += x_City ;
sql += "','" ;
sql += x_State ;
sql += "'," ;
sql += x_Zip ;
sql += ",'" ;
sql += x_Phone;
sql += "','" ;
sql += x_Comments1;
sql += "','";
sql += x_Comments2 ;
sql += "','" ;
sql += x_Comments3 ;
sql += "','" ;
sql += x_Comments4 ;
sql += "','" ;
sql += x_Date ;
sql += "','" ;
sql += x_Email;
sql += "')";
//out.println(sql);
int val = stmt.executeUpdate(sql);
//if the insert was successfull, display all the values in the database
ordered decending by the insert date
if(val==1) {
out.println("<p>The following values have been entered in the
database<br>");
String sql2=("select * from JSP_TABLE");
rst=stmt.executeQuery(sql2
while(rst.next()){
out.println(rst.getString(
out.println(" ");
out.println(rst.getString(
out.println(" ");
out.println(rst.getString(
out.println(" ");
out.println(rst.getString(
out.println(" ");
out.println(rst.getString(
out.println(" ");
out.println(rst.getString(
out.println(" ");
out.println(rst.getString(
out.println(" ");
out.println(rst.getString(
out.println(" ");
out.println(rst.getString(
out.println(" ");
out.println(rst.getString(
out.println(" ");
out.println(rst.getString(
out.println(" ");
out.println(rst.getString(
out.println(" ");
out.println(rst.getString(
out.println(" ");
out.println(rst.getString(
out.println(" ");
out.println(rst.getString(
out.println("<br>");
}//end while
out.println("<a href=\"InsertForm.jsp\">TH
out.println("</p>");
}else{
out.println("<p>There is a problem, your data was not saved</p>");
}
//Close all open connections when done.
rst.close();
stmt.close();
con.close();
//}else{
//do nothing
//}
%>
ERROR WHEN RUN:
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.apache.jasper.JasperEx
An error occurred at line: 19 in the jsp file: /insertdata.jsp
Generated servlet error:
String literal is not properly closed by a double-quote
An error occurred at line: 19 in the jsp file: /insertdata.jsp
Generated servlet error:
String literal is not properly closed by a double-quote
Generated servlet error:
Syntax error, insert "}" to complete ClassBody
org.apache.jasper.servlet.
org.apache.jasper.servlet.
org.apache.jasper.servlet.
org.apache.jasper.servlet.
javax.servlet.http.HttpSer
root cause
org.apache.jasper.JasperEx
An error occurred at line: 19 in the jsp file: /insertdata.jsp
Generated servlet error:
String literal is not properly closed by a double-quote
An error occurred at line: 19 in the jsp file: /insertdata.jsp
Generated servlet error:
String literal is not properly closed by a double-quote
Generated servlet error:
Syntax error, insert "}" to complete ClassBody
org.apache.jasper.compiler
org.apache.jasper.compiler
org.apache.jasper.compiler
org.apache.jasper.compiler
org.apache.jasper.compiler
org.apache.jasper.compiler
org.apache.jasper.JspCompi
org.apache.jasper.servlet.
org.apache.jasper.servlet.
org.apache.jasper.servlet.
javax.servlet.http.HttpSer
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.