try {
//取出一个数据库连接
ctx = new InitialContext();
if(ctx == null)
throw new Exception("context Look Up Error");
dsource = (DataSource)ctx.lookup("java:/comp/env/JDBC");
con = dsource.getConnection();
catch(Exception e) {
out.println(e);
}
finally {
try {
if(con != null) {
con.close();
}
}
catch(Exception e) {
out.println(e);
}
}现在问题就在finally里,请问用con != null判断行不行啊,应该怎么判断才万无一失啊!!!
//取出一个数据库连接
ctx = new InitialContext();
if(ctx == null)
throw new Exception("context Look Up Error");
dsource = (DataSource)ctx.lookup("java:/comp/env/JDBC");
con = dsource.getConnection();
catch(Exception e) {
out.println(e);
}
finally {
try {
if(con != null) {
con.close();
}
}
catch(Exception e) {
out.println(e);
}
}现在问题就在finally里,请问用con != null判断行不行啊,应该怎么判断才万无一失啊!!!
if(con != null) {
con.close();
怎么我的连接老是用完啊,有什么办法保险点的,一定能让连接关闭的
{
if(!conn.isClosed())
{
conn.close();
conn=null;
}
}