Topic: 关于数据库连接的问题 |
Print this page |
1.关于数据库连接的问题 | Copy to clipboard |
Posted by: zhangyingwu Posted on: 2005-12-22 11:43 我想问一下高手,我在多个页面用到 <jsp:include flush="true" page="line_name_view.jsp" />,请求时在第一个页面还能看到请求数据,其它以后的就出现数据库关闭了的异常。 public Vector getTower_Num() { try { cst2 = conn.prepareCall("Exec getTower_num"); rst2=cst2.executeQuery(); while(rst2.next()) { String tower_num=rst2.getString("tower_num"); v2.add(tower_num); } } catch (SQLException ex) { ex.printStackTrace(); } finally { try { rst2.close(); cst2.close(); //conn.close(); } catch (SQLException ex1) { ex1.printStackTrace(); } 当我把conn.close()屏蔽了时就什么都不显示了。我想问结果机集和预编译要关吗?如果不关,我什么时候应该关闭呀?我是用连接池的,连接池该在什么时候归还呀 |
Powered by Jute Powerful Forum® Version Jute 1.5.6 Ent Copyright © 2002-2021 Cjsdn Team. All Righits Reserved. 闽ICP备05005120号-1 客服电话 18559299278 客服信箱 714923@qq.com 客服QQ 714923 |