hi,我执行下面这个SQL，在MYSQL的客户端工具与命令行都 可以执行，没有问题。INSERT INTO test (firstname,lastname,email,streetaddress,aptsuite,country,city,state,postalcode,phone,model1,quantityh1,quantityt1,dis1,weight1,spring1,creditcardnumber,creditcardvaliddate,cvv,comment) VALUES ('','','','','','','','','','','1',0.0,0.0,0,0.0,0.0,'','',0,'')但是用JDBC连MYSQL,然后执行，报错。
com.mysql.jdbc.JDBC4PreparedStatement@1a711a3: INSERT INTO order (firstname,lastname,email,streetaddress,aptsuite,country,city,state,postalcode,phone,model1,quantityh1,quantityt1,dis1,weight1,spring1,creditcardnumber,creditcardvaliddate,cvv,comment) VALUES ('','','','','','','','','','','1',0.0,0.0,0,0.0,0.0,'','',0,'')
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 '?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)' at line 1
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)这个是抛出的异常。哪位朋友知道为什么？
com.mysql.jdbc.JDBC4PreparedStatement@1a711a3: INSERT INTO order (firstname,lastname,email,streetaddress,aptsuite,country,city,state,postalcode,phone,model1,quantityh1,quantityt1,dis1,weight1,spring1,creditcardnumber,creditcardvaliddate,cvv,comment) VALUES ('','','','','','','','','','','1',0.0,0.0,0,0.0,0.0,'','',0,'')
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 '?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)' at line 1
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)这个是抛出的异常。哪位朋友知道为什么？
解决方案 »
免费领取超大流量手机卡，每月29元包185G流量+100分钟通话, 中国电信官方发货