java.sql.CallableStatement调用存储过程:

CallableStatement proc = null;

String loginid = "";

proc = conn.prepareCall("{call package.producure(?,?)}");

proc.setString(1, source);//设置参数

proc.registerOutParameter(2, Types.VARCHAR);//存储过程输出参数

logid = proc.getString(16);

Statement:

CachedRowSet crs;

Statement stmt1 = null;

ResultSet rs=null;

rs=stmt1.executeQuery(sql.toString());

while(rs.next()){

rs.getString("列");

}`

crs.populate(stmt1.executeQuery(strBuffer1.toString()));

CachedRowSet 转换为 Collection

ist> polices = null;

polices = (List>) CachedRowSetUtil.toCollection(rs);

ITPub博客

JDBC