问题描述

无法返回可滚动的ResultSet

public ResultSet select_file_role(String path){
    jdbc=new jdbcdriver();

    String s1="(select id,name,'1' as 状态 from role where id in (select a.id from role a,file_role b where a.id=b.roleid and b.filepath='"+path+"'))";

// String s2="(select id,name,'0' as 状态 from role where id not in (select a.id from role a,file_role b where a.id=b.roleid and b.filepath='"+path+"'))";
// s1=s1 +"union"+ s2;
try{
con=DriverManager.getConnection("jdbc:odbc:hello","sa","bineea");
sql=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
rs=sql.executeQuery(s1);
}
catch(SQLException e){
System.out.println(e);
}

    return rs;
}

返回的ResultSet是TYPE.FORWORD.ONLY，可是我明明设置为了TYPE_SCROLL_SENSITIVE
这是什么错误！！！求帮助

解决方案

求助！大家给帮帮忙吧！很着急