com.mysql.jdbc.NotUpdatable: Result Set not updatable (references no primary keys).（解决方法）

【1】异常详细信息

com.mysql.jdbc.NotUpdatable: Result Set not updatable (references no primary keys).
This result set must come from a statement that was created with a result set type
of ResultSet.CONCUR_UPDATABLE, the query must select only one table, can not use functions and
must select all primary keys from that table. See the JDBC 2.1 API Specification, section 5.6 for more details.
at com.mysql.jdbc.UpdatableResultSet.generateStatements(UpdatableResultSet.java:628)
at com.mysql.jdbc.UpdatableResultSet.syncUpdate(UpdatableResultSet.java:1537)
at com.mysql.jdbc.UpdatableResultSet.updateString(UpdatableResultSet.java:2493)
at com.mysql.jdbc.UpdatableResultSet.updateString(UpdatableResultSet.java:2531)
at com.corejava.chapter4.UpdatableResultSet.main(UpdatableResultSet.java:50)

---

【2】解决方法

1）粗体第一行：提示sql 执行的对象（数据库表）没有主键，务必添加主键；

2）粗体第二行： sql 中的 select 语句必须要查询主键列名， 如

String sql = “select id, name from student”; //虽然我只想查询name，但由于id 是主键，select 语句中必须包含 id ；