mysql-JSP页面无法进行发布操作

提示信息：
java.sql.sqlexception: column count doesn't match value count at row 1
at com.mysql.jdbc.sqlerror.createsqlexception(sqlerror.java:1055)
at com.mysql.jdbc.sqlerror.createsqlexception(sqlerror.java:956)
at com.mysql.jdbc.mysqlio.checkerrorpacket(mysqlio.java:3515)
at com.mysql.jdbc.mysqlio.checkerrorpacket(mysqlio.java:3447)
at com.mysql.jdbc.mysqlio.sendcommand(mysqlio.java:1951)
at com.mysql.jdbc.mysqlio.sqlquerydirect(mysqlio.java:2101)
at com.mysql.jdbc.connectionimpl.execsql(connectionimpl.java:2548)
at com.mysql.jdbc.statementimpl.executeupdate(statementimpl.java:1605)
at com.mysql.jdbc.statementimpl.executeupdate(statementimpl.java:1524)
at org.apache.tomcat.dbcp.dbcp.delegatingstatement.executeupdate(delegatingstatement.java:228)
at org.apache.tomcat.dbcp.dbcp.delegatingstatement.executeupdate(delegatingstatement.java:228)
at com.wy.jdbconnection.executeupdata(jdbconnection.java:39)
at org.apache.jsp.good_005fconfig_jsp._jspservice(good_005fconfig_jsp.java:120)
at org.apache.jasper.runtime.httpjspbase.service(httpjspbase.java:70)
at javax.servlet.http.httpservlet.service(httpservlet.java:722)
at org.apache.jasper.servlet.jspservletwrapper.service(jspservletwrapper.java:432)
at org.apache.jasper.servlet.jspservlet.servicejspfile(jspservlet.java:390)
at org.apache.jasper.servlet.jspservlet.service(jspservlet.java:334)
at javax.servlet.http.httpservlet.service(httpservlet.java:722)
at org.apache.catalina.core.applicationfilterchain.internaldofilter(applicationfilterchain.java:305)
at org.apache.catalina.core.applicationfilterchain.dofilter(applicationfilterchain.java:210)
at org.apache.catalina.core.standardwrappervalve.invoke(standardwrappervalve.java:222)
at org.apache.catalina.core.standardcontextvalve.invoke(standardcontextvalve.java:123)
at org.apache.catalina.authenticator.authenticatorbase.invoke(authenticatorbase.java:472)
at org.apache.catalina.core.standardhostvalve.invoke(standardhostvalve.java:168)
at org.apache.catalina.valves.errorreportvalve.invoke(errorreportvalve.java:99)
at org.apache.catalina.core.standardenginevalve.invoke(standardenginevalve.java:118)
at org.apache.catalina.connector.coyoteadapter.service(coyoteadapter.java:407)
at org.apache.coyote.http11.abstracthttp11processor.process(abstracthttp11processor.java:1002)
at org.apache.coyote.abstractprotocol$abstractconnectionhandler.process(abstractprotocol.java:585)
at org.apache.tomcat.util.net.jioendpoint$socketprocessor.run(jioendpoint.java:310)
at java.util.concurrent.threadpoolexecutor.runworker(threadpoolexecutor.java:1145)
at java.util.concurrent.threadpoolexecutor$worker.run(threadpoolexecutor.java:615)
at java.lang.thread.run(thread.java:745)

有关代码：

String gname=request.getParameter("gname");
String gclass=request.getParameter("gclass");
String gcount=request.getParameter("gcount");
String gunit=request.getParameter("gunit");
String startProvince=request.getParameter("startProvince");
String gstartcity=request.getParameter("gstartcity");
String endProvince=request.getParameter("endProvince");
String gendcity=request.getParameter("gendcity");
String gtransstyle=request.getParameter("gtransstyle");
String gtime=request.getParameter("gtime");
String glink=request.getParameter("glink");
String gphone=request.getParameter("gphone");
String gremark=request.getParameter("gremark");
String grequest=request.getParameter("grequest");
String username=(String)session.getAttribute("name");

java.sql.Date gshowdate=new java.sql.Date(date.getYear(),date.getMonth(),date.getDate());

sql="insert into tb_GoodsMeg values('"+gclass+"','"+
gname+"','"+gcount+"','"+gunit+"','"+startProvince+"','"+
gstartcity+"','"+endProvince+"','"+gendcity+"','"+
gtransstyle+"','"+gtime+"','"+gphone+"','"+
glink+"','"+gshowdate+"','"+gremark+"','"+grequest+"','"+username+"')";

MVM mall 网上购物系统

采用 php+mysql 数据库方式运行的强大网上商店系统，执行效率高速度快，支持多语言，模板和代码分离，轻松创建属于自己的个性化用户界面 v3.5更新： 1).进一步静态化了活动商品. 2).提供了一些重要UFT-8转换文件 3).修复了除了网银在线支付其它支付显示错误的问题. 4).修改了LOGO广告管理,增加LOGO链接后主页LOGO路径错误的问题 5).修改了公告无法发布的问题,可能是打压

0

查看详情

boolean sert=connection.executeUpdata(sql);

if(sert)
{%>

response.sendRedirect("goods_select.jsp");
}else
{
%>

response.sendRedirect("goods_add.jsp");
}
%>