javaweb小白求大佬解决下 搞了我一天了都 在线等 急急急！！！！！！！！！！

java.sql.SQLException: No value specified for parameter 8 Query: update Chart set Gid=?,Gname=?,GCid=?,Gamount=?,Gunit=?,Gpin=?,Gpout=? where gid=? Parameters: [null, null, null, null, null, null, null]
at org.apache.commons.dbutils.AbstractQueryRunner.rethrow(AbstractQueryRunner.java:392)
at org.apache.commons.dbutils.QueryRunner.update(QueryRunner.java:491)
at org.apache.commons.dbutils.QueryRunner.update(QueryRunner.java:404)
at com.cqx.train67.DAO.update(DAO.java:75)
at com.cqx.train67.ChartDAOimpl.edit(ChartDAOimpl.java:18)
at com.cqx.train67.GoodsServlet.update(GoodsServlet.java:93)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.cqx.train67.GoodsServlet.doPost(GoodsServlet.java:37)
at com.cqx.train67.GoodsServlet.doGet(GoodsServlet.java:24)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:261)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:581)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Thread.java:619)
2018-5-1 15:01:22 org.apache.catalina.core.ApplicationDispatcher invoke
严重: Servlet.service() for servlet jsp threw exception
java.lang.ClassCastException: com.cqx.train67.Chart cannot be cast to java.util.List
at org.apache.jsp.update_jsp._jspService(update_jsp.java:87)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:393)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:654)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:445)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:379)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:292)
at com.cqx.train67.GoodsServlet.update(GoodsServlet.java:98)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.cqx.train67.GoodsServlet.doPost(GoodsServlet.java:37)
at com.cqx.train67.GoodsServlet.doGet(GoodsServlet.java:24)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:261)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:581)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Thread.java:619)
java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.cqx.train67.GoodsServlet.doPost(GoodsServlet.java:37)
at com.cqx.train67.GoodsServlet.doGet(GoodsServlet.java:24)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:261)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:581)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Thread.java:619)
Caused by: org.apache.jasper.JasperException: java.lang.ClassCastException: com.cqx.train67.Chart cannot be cast to java.util.List
at org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:541)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:435)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:654)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:445)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:379)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:292)
at com.cqx.train67.GoodsServlet.update(GoodsServlet.java:98)
... 20 more
Caused by: java.lang.ClassCastException: com.cqx.train67.Chart cannot be cast to java.util.List
at org.apache.jsp.update_jsp._jspService(update_jsp.java:87)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:393)

... 30 more

这是错误代码

package com.cqx.train67;


import java.lang.reflect.ParameterizedType;
import java.lang.reflect.Type;
import java.sql.Connection;
import java.util.List;


import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.BeanHandler;
import org.apache.commons.dbutils.handlers.BeanListHandler;
import org.apache.commons.dbutils.handlers.ScalarHandler;




/**
 * DAO 接口, 定义 DAO 的基本操作. 
 * @param <T>: DAO 实际操作的泛型类型
 */
public class DAO<T> {
private QueryRunner queryRunner=new QueryRunner();
private Class<T> clazz;
public DAO()
{
Type superClass=getClass().getGenericSuperclass();
if(superClass instanceof ParameterizedType)
{
ParameterizedType parameterizedType=(ParameterizedType) superClass;
Type[] typeArgs=parameterizedType.getActualTypeArguments();
if(typeArgs!=null&&typeArgs.length>0)
{
if(typeArgs[0] instanceof Class)
{
clazz=(Class<T>) typeArgs[0];
}
}
}
}
/**
* 执行单条记录的查询操作, 返回与记录对应的类的一个对象
* @param sql: 待执行的 SQL 语句
* @param args: 填充占位符的可变参数
* @return: 与记录对应的类的一个对象
*/
public T Get(String sql, Object ... args)
{
Connection connection=null;
try
{
connection=DBUtilsTools.getConnection();
return queryRunner.query(connection, sql, 
new BeanHandler<T>(clazz), args);
}
catch(Exception e)
{
e.printStackTrace();
}
finally{
DBUtilsTools.ReleaseConnection(connection);
}
return null;
}


/**
* 执行 UPDATE 操作, 包括 INSERT(但没有返回值), UPDATE, DELETE
* @param sql: 待执行的 SQL 语句
* @param args: 填充占位符的可变参数
* @throws Exception 
*/
public long update(String sql, Object ... args) 
{
Connection connection=null;
try
{
connection=DBUtilsTools.getConnection();
return queryRunner.update(connection, sql,args);
}
catch(Exception e)
{
e.printStackTrace();
}
finally{
DBUtilsTools.ReleaseConnection(connection);
}
return 0;
}

/**
* 执行多条记录的查询操作, 返回与记录对应的类的一个 List
* @param sql: 待执行的 SQL 语句
* @param args: 填充占位符的可变参数
* @return: 与记录对应的类的一个 List
*/
public List<T> queryForList(String sql, Object ... args)
{
Connection connection=null;
try
{
connection=DBUtilsTools.getConnection();
return queryRunner.query(connection, sql, 
new BeanListHandler<T>(clazz), args);
}
catch(Exception e)
{
e.printStackTrace();
}
finally{
DBUtilsTools.ReleaseConnection(connection);
}
return null;
}

/**
* 执行一个属性或值的查询操作, 例如查询某一条记录的一个字段, 
* 或查询某个统计信息, 返回要查询的值
* @param sql: 待执行的 SQL 语句
* @param args: 填充占位符的可变参数
* @return: 执行一个属性或值的查询操作, 例如查询某一条记录的一个字段, 
* 或查询某个统计信息, 返回要查询的值
*/
public <V> V getSingleVal(String sql, Object ... args)
{
Connection connection=null;
try
{
connection=DBUtilsTools.getConnection();
return queryRunner.query(connection, sql, 
new ScalarHandler<V>(), args);
}
catch(Exception e)
{
e.printStackTrace();
}
finally{
DBUtilsTools.ReleaseConnection(connection);
}
return null;
}

/**
* 执行批量更新操作
* @param sql: 待执行的 SQL 语句
* @param args: 填充占位符的可变参数
*/
public void batch(String sql, Object[]... params)
{
return ;
}
}

package com.cqx.train67;


import java.util.List;


public class ChartDAOimpl extends DAO<Chart> implements ChartDAO {


//删除
public void deleteById(String gid) {

String sql="delete from Goodsinfo where gid=?";
update(sql,gid);
}


public long edit(Chart c) {

String sql="update Chart set Gid=?,Gname=?,GCid=?,Gamount=?,Gunit=?,Gpin=?,Gpout=? ";

return update(sql,c.getGid(),c.getGname(),c.getgCid(),c.getGamount(),
c.getGunit(),c.getGpin(),c.getGpout());
}
//查找全部
public List<Chart> findAll() {
String sql="select * from Goodsinfo";
return queryForList(sql);
}
//ID查找
public Chart findById(String gid) {
String sql="select * from Goodsinfo where gid=?";
return Get(sql,gid);
}


public void save(Chart c) {

String sql="insert into Chart(Gid,Gname,GCid,Gamount,Gunit,Gpin,Gpout)"
+"values(?,?,?,?,?,?,?)";

update(sql,c.getGid(),c.getGname(),c.getgCid(),c.getGamount(),
c.getGunit(),c.getGpin(),c.getGpout());




}

}

package com.cqx.train67;


import java.io.IOException;
import java.io.PrintWriter;
import java.io.UnsupportedEncodingException;
import java.lang.reflect.Method;
import java.util.List;


import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;


public class GoodsServlet extends HttpServlet {


ChartDAO dao=new ChartDAOimpl();
public void destroy() {
super.destroy(); // Just puts "destroy" string in log
// Put your code here
}


public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
doPost(request,response);
}


public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {


String servletpath=request.getServletPath();

String methodName=servletpath.substring(1, servletpath.length()-3);

try {
Method method=getClass().getDeclaredMethod(methodName, 
HttpServletRequest.class,HttpServletResponse.class);
method.invoke(this, request,response);
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
} 
}


public void init() throws ServletException {
// Put your code here
}


public void list(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException{

List<Chart>  result =dao.findAll();
request.setAttribute("chart",result);

request.getRequestDispatcher("listAll.jsp").forward(request, response);
}


public void delete(HttpServletRequest request, HttpServletResponse response) throws IOException{

String gid=request.getParameter("gid");
dao.deleteById(gid);

response.sendRedirect("list.do");
}


public void edit(HttpServletRequest request, HttpServletResponse response) throws Exception{


String gid=request.getParameter("gid");

Chart c=dao.findById(gid);

request.setAttribute("chart", c);
request.getRequestDispatcher("update.jsp").forward(request, response);

}



public void update(HttpServletRequest request, HttpServletResponse response) throws IOException, ServletException{
request.setCharacterEncoding("utf-8");
String gid=request.getParameter("gid");
String gname=request.getParameter("gname");
String gCid=request.getParameter("gCid");
String gamount=request.getParameter("gamount");
String gunit=request.getParameter("gunit");
String gpin=request.getParameter("gpin");
String gpout=request.getParameter("gpout");


Chart c=new Chart(gid,gname,gCid,gamount,gunit,gpin,gpout);

request.setAttribute("chart", c);
long a=dao.edit(c);

if(a==0)
{
request.setAttribute("msg", "修改失败!");
request.getRequestDispatcher("update.jsp").forward(request, response);
}
else
response.sendRedirect("success.jsp");




}


}