过滤的关键字distinct 与动态游标冲突怎么解决

[Tom_ruanbb]

过滤的关键字distinct 与
Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);冲突

<%
String StrSql="select distinct sno,sname from TStudents";
ResultSet RS = workM.executeQuery(StrSql);
while (RS.next()){
%>//workM为一个bean
去掉distinct ,String StrSql="select sno,sname from TStudents";就正常了，怎么解决两者的冲突

[skyboy0720]

我不太清楚是否真的会冲突，如果真是，分组group by一样能达到效果！

[Tom_ruanbb]

我试了，用group by也一样不行

[Tom_ruanbb]

我用statement=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);就可以了

statement=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
与Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);有何区别