2009-02-13 13:31:00
下面是一个ResultSet和ArrayList应用的一个实例，是JSPStudio开发工具用于设备管理系统开发自动生成的一段代码。
public Collection findSQL(String sql) {
PreparedStatement ps = null;
ResultSet rs = null;
ArrayList list = new ArrayList();
try {
if (con.isClosed()) {
throw new IllegalStateException("error.unexpected");
}
ps = con.prepareStatement(sql);
rs = ps.executeQuery();
while(rs.next()) {
lyk m_lyk= new lyk();
//<find>
m_lyk.set领用单位号(rs.getString(1));
m_lyk.set实验室名称(rs.getString(2));
m_lyk.set仪器编号(rs.getString(3));
m_lyk.set分类号(rs.getString(4));
m_lyk.set仪器名称(rs.getString(5));
m_lyk.set型号(rs.getString(6));
m_lyk.set规格(rs.getString(7));
m_lyk.set存放地(rs.getString(8));
m_lyk.set单价(rs.getFloat(9));
m_lyk.set国别(rs.getString(10));
m_lyk.set国别码(rs.getString(11));
m_lyk.set厂家(rs.getString(12));
m_lyk.set出厂号(rs.getString(13));
m_lyk.set出厂日期(rs.getString(14));
m_lyk.set购置日期(rs.getString(15));
m_lyk.set附件数量(rs.getShort(16));
m_lyk.set附件总价(rs.getFloat(17));
m_lyk.set现状(rs.getString(18));
m_lyk.set管理级别(rs.getString(19));
m_lyk.set领用人(rs.getString(20));
m_lyk.set经费科目(rs.getString(21));
m_lyk.set科研号(rs.getString(22));
m_lyk.set设备号(rs.getString(23));
m_lyk.set使用方向(rs.getString(24));
m_lyk.set资产类别(rs.getString(25));
m_lyk.set单据号(rs.getString(26));
m_lyk.set经手人(rs.getString(27));
m_lyk.set调转入日期(rs.getString(28));
m_lyk.set使用单位号(rs.getString(29));
m_lyk.set设备照片(rs.getString(30));
m_lyk.set行政国资号(rs.getString(31));
m_lyk.set入库时间(rs.getString(32));
m_lyk.set审核(rs.getBoolean(33));
//</find>
list.add(m_lyk);
}
return list;
} catch (SQLException e) {
e.printStackTrace();
throw new RuntimeException("error.unexpected");
} finally {
try {
if (ps != null)
ps.close();
if (rs != null)
rs.close();
} catch (SQLException e) {
e.printStackTrace();
throw new RuntimeException("error.unexpected");
}
}
}
}