mysql 传入list查询_将数据库中查询得到的信息集转化为List | 学步园

废话不说，直接上代码：

//传入sql语句查询数据信息

public ResultSet selectSetInfoSQL(String sql) throws MyException

{

CachedRowSetImpl crs = null;

PreparedStatement ps = null;

ResultSet rs = null;

try{

crs = new CachedRowSetImpl();

ps = c.prepareStatement(sql);

}catch(SQLException e){

dbError.throwMyException("ORACLE查询语句准备错误！", "DBManager.updateSQL");

}

try {

if(ps!=null){

rs = ps.executeQuery();

}

crs.populate(rs);

}catch(Exception e1) {

dbError.throwMyException("ORACLE执行错误！", "DBManager.updateSQL");

}finally{

try{

rs.close();

ps.close();

}catch(Exception e){

dbError.throwMyException("ORACLE