出现错误

[linxuehong123]

<%@ page contentType="text/html; charset=gb18030" language="java" import="java.sql.*"%>



<%
String b=" ";
String name=request.getParameter("name");
String mima=request.getParameter("mima");
int nianling=Integer.parseInt(request.getParameter("nianling"));
String xingbie=request.getParameter("xingbie");
String ziwojieshao=request.getParameter("ziwojieshao");
String laizi=request.getParameter("laizi");
if(request.getParameterValues("hobby") != null)
{
String[] ch1 = request.getParameterValues("hobby");
for(int i=0;i<ch1.length;i++){

out.println(ch1[i]+"<br>");

}
}


if(xingbie!=null){

b=new String(xingbie.getBytes("ISO-8859-1"));
xingbie=b; }
if(laizi!=null){

b=new String(laizi.getBytes("ISO-8859-1"));

laizi=b; }
if(ziwojieshao!=null){

b=new String(ziwojieshao.getBytes("ISO-8859-1"));

ziwojieshao=b; }


Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); //载入驱动程序类别
String url="jdbc:odbc:MySiteDataBase"; //数据库路径
String user="";
String pwd="";
Connection con=DriverManager.getConnection(url,user,pwd);
PreparedStatement pstmt=con.prepareStatement("INSERT INTO userInfo () VALUES (?,?,?,?,?,?)",ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);

pstmt.setString(1,name);
pstmt.setString(2,mima);
pstmt.setString(3,xingbie);
pstmt.setString(4,ziwojieshao);
pstmt.setInt(5,nianling);
pstmt.setString(6,laizi);
pstmt.executeUpdate();%>



pstmt.close();
con.close();
out.println("注册成功");
%>

</CENTER>

<a href="/Mywork/login.jsp">返回登录页</a>

[qgqch2008]

what错误？

[linxuehong123]

javax.servlet.ServletException: java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] INSERT INTO 语句的语法错误。
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:915)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:844)
org.apache.jsp.Mywork.adduser_jsp._jspService(adduser_jsp.java:140)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:417)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:391)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)
javax.servlet.http.HttpServlet.service(HttpServlet.java:722)


root cause

[linxuehong123]

我自己解决了

[打一壶酱油]

恭喜恭喜