sql="INSERTINTOkc(number,name,sdate,fdate,courseName,courseType,student,amount,introduction)VALUES(?,?,?,?,?,?,?,?,?);";PreparedStatementps=dataBase.getCon().prepareState...
sql="INSERT INTO kc (number, name, sdate, fdate, courseName, courseType, student, amount, introduction) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?);";
PreparedStatement ps=dataBase.getCon().prepareStatement(sql);
int count=1;
ps.setString(count++, number);
ps.setString(count++, name);
ps.setDate(count++, teachingResults.getSdate());
ps.setDate(count++, teachingResults.getFdate());
ps.setString(count++, teachingResults.getCourseName());
ps.setString(count++, teachingResults.getCourseType());
ps.setString(count++, teachingResults.getStudent());
ps.setString(count++, teachingResults.getAmount());
ps.setString(count++, teachingResults.getIntroduction());
ps.execute(sql);
报错
Stacktraces
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
count确实是从1开始 之前查询语句也是这种写法没问题
也不是“;”的问题
ps.executeUpdate(sql)也没用
展开