Exception in thread "main" java.sql.BatchUpdateException: No value specified for parameter 5
at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1257)
at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:943)
at db.XmlParse.parseTables(XmlParse.java:510)
at db.XmlParse.main(XmlParse.java:47)
at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1257)
at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:943)
at db.XmlParse.parseTables(XmlParse.java:510)
at db.XmlParse.main(XmlParse.java:47)
建议你贴出你的语句。
sql语句中(?,?,?,?,?);
pt.set(1,p1);
pt.set(2,p2);
pt.set(3,p3);
pt.set(4,p4);
pt.set(5,p5)是不是没写;
检查P5有没有值
条件写错了特别谢谢大家,我这是第一次做项目(在公司实习)
遇到了好多好多的问题,来的这儿就解决了(流泪中……)还有:ACMAIN_CHM,WWWWA,你们帮助我不只一次了,我铭记于心!