// 向数据库添加商品
public String addGood(String isbn,String username,String price,String imagesFile,String shu,String title) throws Exception{
System.out.print("进入Idao");
String sql="insert into cart(isbn,username,title,price,imagesFile,shu) values (?,?,?,?,?,?)";
//String sql = "insert into users values(?,?)";
pst.setString(1, isbn);
pst.setString(2, username);
pst.setString(3, title);
pst.setString(4, price);
pst.setString(5, imagesFile);
pst.setString(6, shu);
pst = con.prepareStatement(sql);
pst.executeUpdate(sql);
closePreparedStatement();
return "index.jsp";
}
}
----------
java.lang.NullPointerException
at dao.ICartActionDao.addGood(ICartActionDao.java:25)
at action.CookieCartAction.addGood(CookieCartAction.java:33)
at servlet.BanzhangServlet.dispatcher(BanzhangServlet.java:76)
at servlet.BanzhangServlet.doPost(BanzhangServlet.java:33)
at servlet.BanzhangServlet.doGet(BanzhangServlet.java:22)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
到底哪错了???
public String addGood(String isbn,String username,String price,String imagesFile,String shu,String title) throws Exception{
System.out.print("进入Idao");
String sql="insert into cart(isbn,username,title,price,imagesFile,shu) values (?,?,?,?,?,?)";
//String sql = "insert into users values(?,?)";
pst.setString(1, isbn);
pst.setString(2, username);
pst.setString(3, title);
pst.setString(4, price);
pst.setString(5, imagesFile);
pst.setString(6, shu);
pst = con.prepareStatement(sql);
pst.executeUpdate(sql);
closePreparedStatement();
return "index.jsp";
}
}
----------
java.lang.NullPointerException
at dao.ICartActionDao.addGood(ICartActionDao.java:25)
at action.CookieCartAction.addGood(CookieCartAction.java:33)
at servlet.BanzhangServlet.dispatcher(BanzhangServlet.java:76)
at servlet.BanzhangServlet.doPost(BanzhangServlet.java:33)
at servlet.BanzhangServlet.doGet(BanzhangServlet.java:22)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
到底哪错了???
解决方案 »
- springMVC3.0注解上传文件问题
- 大家是怎样分页的??????????
- 加载spring3.0.3的jar包后报 java.lang.NoSuchMethodException: javax.servlet.ServletConte
- struts2 的<s:iterator> 怎样访问Set下的对象属性?
- ssh项目不知道jar包原因还是代码错误,急求解答!!
- 咨询好书
- struts+hibernate开发人员看过来!
- 学习过程迷惑,望过来人指点
- 要开始学JSP了,请大家推荐几本书。
- 使用ant中遇到的问题!
- 小弟想问下 Java EE 与 Erp 二次开发哪个有前途些
- struts2框架配置问题
pst.setString(2, username);
pst.setString(3, title);
pst.setString(4, price);
pst.setString(5, imagesFile);
pst.setString(6, shu);
pst = con.prepareStatement(sql);
改成
pst = con.prepareStatement(sql);
pst.setString(1, isbn);
pst.setString(2, username);
pst.setString(3, title);
pst.setString(4, price);
pst.setString(5, imagesFile);
pst.setString(6, shu);
pst.setString(2, username);
pst.setString(3, title);
pst.setString(4, price);
pst.setString(5, imagesFile);
pst.setString(6, shu);很明显六个参数其中有空值,敢不敢输出来看看