81,122
社区成员




CallableStatement cs = con.prepareCall("{call guest_getpage_one.sp_page(?,?,?,?,?,?,?)}");
cs.setInt(1,20);
cs.setInt(2, currpage);
cs.setString(3, ls_sql.toString());
cs.setString(4,ls_sql_count.toString());
cs.registerOutParameter(5, oracle.jdbc.OracleTypes.INTEGER);
cs.registerOutParameter(6,oracle.jdbc.OracleTypes.INTEGER);
cs.registerOutParameter(7, oracle.jdbc.OracleTypes.CURSOR);
cs.execute();
int rowcount=cs.getInt(5);
ResultSet rs=(ResultSet)cs.getObject(7);
cs.close();
cs=null;
System.out.println(rs.getRow()); //---用ojdbc14.jar有总数,用ojdbc6.jar为0
while (rs.next()){
LoginUser user=new LoginUser();
user.setUsercode(rs.getString("usercode"));
user.setUsername(rs.getString("username"));
user.setUserpwd(rs.getString("userpwd"));
user.setU_type(rs.getString("u_type"));
list.add(user);
}