Question

用java向mysql中写入数据，报错，感觉我写的没问题，求大神帮忙！！

Connection conn = DriverManager.getConnection(url, user, password);
if(!conn.isClosed()){
System.out.println("Success in getconnection!");
}
Statement stmt = conn.createStatement();
String sql = "INSERT INTO dblp_data1(title,pubtype,author,key,journal,page) VALUES('k','j','l','s','o','5')";
stmt.executeUpdate(sql);
stmt.close();
conn.close();
报错：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 'key,journal,page) VALUES('k','j','l','s','o','5')' at line 1

Answer 1

sql语句有错误，把你这条sql拿到数据库上去执行一下，看是否表名，字段名等错误

Answer 2

重新检查一下你的mysql表中的字段名称是不是正确。区分大小写

追问

表名称什么的都没有错，检查很多遍了

追答

搜了下这个问题，应该是sql关键字冲突。。把表中的key字段换成别的试试