这是插入的代码
PreparedStatement pstm=conn.prepareStatement("insert into order(customerID,bookID,bookName,bookPrice) values(?,?,?,?)");
pstm.setString(1, customerid);
pstm.setString(2, book.getBookID());
pstm.setString(3, book.getBookName());
pstm.setDouble(4, book.getBookPrice());
result=pstm.executeUpdate();
提示的错误是以下
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order(customerID,bookID,bookName,bookPrice) values('k','01','Social network',30.' at line 1
别的值都可以取到,其中bookPrice是double类型,请问各位是什么问题??
PreparedStatement pstm=conn.prepareStatement("insert into order(customerID,bookID,bookName,bookPrice) values(?,?,?,?)");
pstm.setString(1, customerid);
pstm.setString(2, book.getBookID());
pstm.setString(3, book.getBookName());
pstm.setDouble(4, book.getBookPrice());
result=pstm.executeUpdate();
提示的错误是以下
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order(customerID,bookID,bookName,bookPrice) values('k','01','Social network',30.' at line 1
别的值都可以取到,其中bookPrice是double类型,请问各位是什么问题??
解决方案 »
- S2SH 整合的问题~在线等
- 谁考了scwcd证书啊
- 请教如何开始学习 Struts 2
- 请高手作答:iBatis的Dynamic-mapped-statement之间的inline-parameter的传递问题
- hibernate中为什么要用组合映射?
- struts2里的action怎样获取表单里的大量数据?
- 急,解析xml,,实习第一个任务。
- 紧急求助!weblogic8启动的时候发生了问题!
- 如何运行*.Jar文件?
- 求:《java开发指南-应用xml和jsp开发电子商务》一书的原码,不胜感激
- jsp提交text,request后为空
- 想问一下哦~~希望有参加过JAVA培训班的人来说说你的经验~~!
pstm.setDouble(4, book.getBookPrice());
这里set是double啊,不是字符串呢
book.getBookPrice()
book对象的bookPrice属性是double类型么?
"insert into `order`(customerID,bookID,bookName,bookPrice) values(?,?,?,?)"
即在order两侧加上反引号(键盘上1的左边)
错误提示也说明是 order 附近的语法错误,因为order后边没找到by...