java - 将 Statement.RETURN_GENERATED_KEYS 与 MS-Access JDBC-ODBC 一起使用会引发异常

Question

import java.sql.* ;
import java.util.* ;
import java.io.* ;

class DataBaseFactory{
    public static Connection getConnection() {
        // ...
    }
}

class Demo{
    public static void main(String []args) throws SQLException {
        Connection con = DataBaseFactory.getConnection() ;

        // This is throwing exception
        // PreparedStatement ps = con.prepareStatement("insert into user values(?,?)", Statement.RETURN_GENERATED_KEYS) ;

        // But this is working fine
        PreparedStatement ps = con.prepareStatement("insert into user values(?,?)") ;
    }
}

Answer 1

我的猜测是您使用的数据库驱动程序不支持 RETURN_GENERATED_KEYS。您尝试连接的数据库是什么？