mysql数据库添加不执行输入语句_java中 数据库插入语句无法执行

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)也没用

展开