public List list() throws SQLException,
javax.naming.NamingException {
String sql;
sql =
"select cy.cyno,cy.cname,cy.prvcode from city cy order by cy.cname";
Connection conn = null;
PreparedStatement pstmt = null;
ResultSet rs = null;
List list = new ArrayList();
City city = null;
try {
conn = getConnection();
pstmt = conn.prepareStatement(sql);
rs = pstmt.executeQuery();
while (rs.next()) {
city = new City();
populate(city, rs);//struts反射机制
list.add(city);
} close(rs);
close(pstmt); }
catch (SQLException sqle) {
System.out.println("SQLException" + sqle.getMessage());
close(rs);
close(pstmt); sqle.printStackTrace(); throw sqle; }
finally {
close(conn); }
return list;
}//--------------------------------------------------while (rs.next()) {
city = new City();
populate(city, rs);//struts反射机制
list.add(city);
}
//-------------------------------------------------
这段代码可能出现内存映射吗
javax.naming.NamingException {
String sql;
sql =
"select cy.cyno,cy.cname,cy.prvcode from city cy order by cy.cname";
Connection conn = null;
PreparedStatement pstmt = null;
ResultSet rs = null;
List list = new ArrayList();
City city = null;
try {
conn = getConnection();
pstmt = conn.prepareStatement(sql);
rs = pstmt.executeQuery();
while (rs.next()) {
city = new City();
populate(city, rs);//struts反射机制
list.add(city);
} close(rs);
close(pstmt); }
catch (SQLException sqle) {
System.out.println("SQLException" + sqle.getMessage());
close(rs);
close(pstmt); sqle.printStackTrace(); throw sqle; }
finally {
close(conn); }
return list;
}//--------------------------------------------------while (rs.next()) {
city = new City();
populate(city, rs);//struts反射机制
list.add(city);
}
//-------------------------------------------------
这段代码可能出现内存映射吗
解决方案 »
- java开发入门还有哪些个好的网站论坛 散分
- 这里讨论eclipse swt,欢迎加入群6674633
- 关于删除JComboBox中项的问题.
- "部署"的英文原文是什么?
- 有关垃圾回收?
- 老问题,新提法 (java字符串的截取,中英混合,并有其它各种字符,全角半角等.....) 在网上看了很多,都没有一个完善的解决办法
- ?数据库中的二进制的图片恢复成.GIF文件,并转化成.BMP文件?
- 高分在线等待
- 大家觉得拿什么工具写bean方便
- 关于用java来开发Web服务器,请教高手!
- 怎么删除JTable容器下属所有的组件,不知道到组件名,但知道组件类型,如,删除JTable下所有的TextField组件
- 高分求正则表达式的写法,如何将一个字符串中的中文和字母用split分开?
//--------------------------------------------------while (rs.next()) {
city = new City();
populate(city, rs);//struts反射机制
list.add(city);
}
//-------------------------------------------------
这段代码可能出现内存泄漏吗
rs = pstmt.executeQuery();
while (rs.next()) {
city = new City();
populate(city, rs);//struts反射机制
list.add(city);
}如果上面这段代码执行的过程中出错(如populate(city, rs)),产生了异常,那么后面的:
close(rs);
close(pstmt);就不会执行,这样就会造成数据库相关资源没有关闭,有可能会影响后面的数据库操作,会不会有内存泄漏我不能确定
catch (SQLException sqle) {
System.out.println("SQLException" + sqle.getMessage());
close(rs);
close(pstmt); sqle.printStackTrace(); throw sqle; }
函数:
close(rs);
close(pstmt);
是不是也有可能会产生异常呢,是不是也会影响程序的运行