Question

java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver]COUNT 字段不正确

我用的是ACCESS数据库，jsp语言，连接数据库没有问题，但是只要往数据库里添加数据就不行。
代码是“String name=request.getParameter("name");
String sex=request.getParameter("sex");
String shouji=request.getParameter("shouji");
String youxiang=request.getParameter("youxiang");
String dizhi=request.getParameter("dizhi");
sql="update member set sex='"+sex+"',";
sql+="shouji='"+shouji+"',";
sql+="youxiang='"+youxiang+"',";
sql+="dizhi='"+dizhi+"' where membername="+name;
stmt.execute(sql);
out.print("<script>alert('保存成功!');window.location='12.jsp';</script>");
”
可是运行后的结果是
“java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver]COUNT 字段不正确
sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(Unknown Source)
sun.jdbc.odbc.JdbcOdbcStatement.execute(Unknown Source)
org.apache.jsp._12_jsp._jspService(_12_jsp.java:192)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:393)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
”
请各位高手帮帮忙吧……

Answer 1

你ACCESS数据库里,shouji字段如果是数字类型,这里也要数字的.并且不能用''号括起来.