看看如下servlet 代码,是否有未关闭的连接

[Sky_Wuhan]

看看如下servlet 代码,是否有未关闭的连接:
以下servlet用来接收编辑后的资料然后更新数据库存后返回显示页面,但是现在只要提交几次后就会报错,数据源连接池满.不知道是不是下面代码有没关闭的类

package dev;

import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.util.*;
import java.sql.*;
import javax.sql.DataSource;
import dev.DatabaseConn;
/**
* <p>Title: </p>
* <p>Description: </p>
* <p>Copyright: Copyright (c) 2007</p>
* <p>Company: </p>
* @author not attributable
* @version 1.0
*/

public class upinfo extends HttpServlet {
private static final String CONTENT_TYPE = "text/html; charset=GBK";
//Initialize global variables
private Connection conn;
private Statement stmt;
public void init() throws ServletException {
}
//Process the HTTP Get request
public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
response.setContentType(CONTENT_TYPE);
PrintWriter out = response.getWriter();
// out.print("tests");
String sid=request.getParameter("sid");
String tile=request.getParameter("zt");
String frm=request.getParameter("frm");
String content=request.getParameter("content");

try {
conn.close();
conn=dev.DatabaseConn.getConnection();
stmt=conn.createStatement();
// out.print("tes14ts");
stmt.executeUpdate("update nt01 set N001='"+tile+"',n002='"+frm+"',n003='"+content+"' where id="+sid+"");
stmt.close();
conn.close();
}
catch (Exception ex) {
ex.printStackTrace();
}

response.sendRedirect("admin/info/list.jsp");
//RequestDispatcher requestDispatcher=request.getRequestDispatcher("admin/info/list.jsp");
//requestDispatcher.forward(request,response);
}
//Clean up resources
public void destroy() {

}
}

[老紫竹]

        try   { 
            conn=dev.DatabaseConn.getConnection(); 
            stmt=conn.createStatement(); 
  //   out.print("tes14ts"); 
            stmt.executeUpdate("update   nt01   set   N001='"+tile+"',n002='"+frm+"',n003='"+content+"'   where   id="+sid+""); 
  } 
  catch   (Exception   ex)   { 
          ex.printStackTrace(); 
  }finally{
    if(smtp!=null) try{ stmt.close(); }catch(Exception ex){}
    if(conn!=null) try{ conn.close();  }catch(Exception ex){}
  }