出现result set type is TYPE_FORWARD_ONLY的错误

Question

用createStatement可以这样
connect=dataSource.getConnection();
Statement stmt=connect.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,   
                     ResultSet.CONCUR_UPDATABLE);
ResultSet rs=stmt.executeQuery(strSql);
但我用的是stmt = conn.prepareStatement( SQL );
请问如何改变result set type

Answer 1

PreparedStatment pstmt = conn.prepareStatement(sql,ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);