请教:递归算法中的ResultSet如何重用。急!!!! 把一条记录的结果先存放在变量中。反复使用变量就可以了。你的错误信息时说:结果集中column 1的数据不能反复读取。 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 一次读出: public static Vector getRooms(String r_dep) throws SQLException { Vector vect = new Vector(); Connection conn = Conn.getConnection(); PreparedStatement pstmt = null; ResultSet rset = null; String sql = "select * from per_room where r_dep = ?"; try { pstmt = conn.prepareStatement(sql); pstmt.setString(1, r_dep); rset = pstmt.executeQuery(); while (rset.next()) { Room _room = new Room(); _room.setID(rset.getInt("ID")); _room.setR_num(rset.getString("r_num")); _room.setR_name(rset.getString("r_name")); _room.setR_addr(rset.getString("r_addr")); _room.setR_capacity(rset.getString("r_capacity")); _room.setR_equipment(rset.getString("r_equipment")); _room.setR_description(rset.getString("r_description")); _room.setR_note(rset.getString("r_note")); _room.setR_dep(rset.getString("r_dep")); vect.add(_room); } return vect; } catch (Exception e) { Debug.write(e); return null; } finally { Conn.close(rset, pstmt, conn); } }//Room为一bean 显示然后就显示返回的Vector 内容就的了 我已经解决了,原来sql的jdbc在取数据的时候只能按字段顺序取出。我晕~~~~~~~哈哈。感谢各位。马上给分 Date得到的日期不对 各位帮忙啊 ChartFactory.createBarChart3D生成柱状图颜色问题 PL/SQL,UltraEdit,Excel问题 求写个防cc攻击的js代码,有参考asp和php例子 关于修改servlet jsp服务器要重启的问题 怎么免费注册二级域名?在线等 写了一个Filter,报NullPointerException的错误,大家给看看 网页中“您有一条新留言”这种效果实现原理是什么? 我是一只要出水的鱼!!谁来给我设龙门!!! jsp中文问题 用poi读excel文件内容,单元格的类型问题 即将毕业的大四学生求助!!!!!!!!!!
Vector vect = new Vector();
Connection conn = Conn.getConnection();
PreparedStatement pstmt = null;
ResultSet rset = null;
String sql = "select * from per_room where r_dep = ?";
try {
pstmt = conn.prepareStatement(sql);
pstmt.setString(1, r_dep);
rset = pstmt.executeQuery();
while (rset.next()) {
Room _room = new Room();
_room.setID(rset.getInt("ID"));
_room.setR_num(rset.getString("r_num"));
_room.setR_name(rset.getString("r_name"));
_room.setR_addr(rset.getString("r_addr"));
_room.setR_capacity(rset.getString("r_capacity"));
_room.setR_equipment(rset.getString("r_equipment"));
_room.setR_description(rset.getString("r_description"));
_room.setR_note(rset.getString("r_note"));
_room.setR_dep(rset.getString("r_dep"));
vect.add(_room);
}
return vect;
}
catch (Exception e) {
Debug.write(e);
return null;
}
finally {
Conn.close(rset, pstmt, conn);
}
}//Room为一bean
哈哈。感谢各位。马上给分