struts数据库连接

public class LogonDataPoolAction extends Action {
  public ActionForward perform(ActionMapping actionMapping, ActionForm actionForm,
                              HttpServletRequest request, HttpServletResponse response){
    try{request.setCharacterEncoding("GBK");}catch(Exception ex){ex.printStackTrace();}
    //定义数据库缓冲池的变量
    DataSource dataSource;
    Connection conn;
    PreparedStatement preparedStmt;
    ResultSet rs;
    try {
      //取得struts-config文件的数据缓冲池的联连
      dataSource = getDataSource(request, "logon");
      conn = dataSource.getConnection();
      //创建PreparedStatement接
      preparedStmt = conn.prepareStatement("select * from logonUser where userName=? " +
                                           "and userPassword=?");
      //取得用户输入的用户名和密码
      String name = request.getParameter("name").trim();
      String password = request.getParameter("password").trim();
      //如果用户名和密码正确，转向显示成功登陆信息页面，否则转向失败登陆信息页面
      preparedStmt.setString(1,name);
      preparedStmt.setString(2,password);
      rs = preparedStmt.executeQuery();
      String address = "";
      if(rs.next()){
        address = "success";
      }else{
        address = "failure";
      }
      //关闭数据库联接
      conn.close();
      return (actionMapping.findForward(address));
    }catch(Exception e){
       e.printStackTrace();
      return (actionMapping.findForward("failure"));
    }
  }
}

具体应用 http://www.cnpoint.com