经典错误啊

[biaofengc]

Connection conn=DB.getConn();
String sql="select count(*) from products";
PreparedStatement pstmt=DB.prepareStmt(conn,sql);
ResultSet rsKey=pstmt.getGeneratedKeys();
rsKey.next();
int key=rsKey.getInt(1);
rsKey.close();
这里面那个pstmt方法有什么问题吗?
我这里老是报错
javax.servlet.ServletException: com.microsoft.jdbc.base.BasePreparedStatement.getGeneratedKeys()Ljava/sql/ResultSet;

[pt1314917]

C#?

[xiaoku]

不懂java.

[xiaoku]

String sql="select count(*) cnt from products";
这句最好付个别名.

[big_ear]

int key=rsKey.getInt(1); 把 1 改成 0 试试！！