数据库连接池~~hoho

struts-config.xml

<data-sources>
  <data-source key="oracleDB1" type="org.apache.commons.dbcp.BasicDataSource">
   <set-property property="driverClassName" 
    value="oracle.jdbc.driver.OracleDriver" />
   <set-property property="url"
    value="jdbc:oracle:thin:@127.0.0.1:1521:ZGYDB" />
   <set-property property="maxActive"
    value="5"/>
   <set-property property="username"
    value="jenny"/>
   <set-property property="password"
    value="888888"/>
   <set-property property="autoCommit"
    value="true"/>
  </data-source>
 </data-sources>

public class DBUser {

 DataSource dataSource;
 
 public DBUser(DataSource dataSource) {
  
   this.dataSource = dataSource;
 }
 
 
 public boolean checkUser(String name,String psw) throws Exception{
        Connection connect = null;
  String strSql;
  ResultSet rs;
  boolean result=false;
        strSql = "select * from classuser where username='"
     + name + "' and password='" + psw + "'";
  try {
   connect = dataSource.getConnection();
   Statement stmt = connect.createStatement();
   rs = stmt.executeQuery(strSql);
   if ( rs.next()) {
    result=true;
   }
  }
  catch(SQLException ex) {
   ex.printStackTrace();
  }
  finally{
   if(connect!=null)
    connect.close();
  }
  return result;
 
 }
 
}

 

public final class LoginAction extends Action{ 
 public ActionForward execute(
  ActionMapping mapping,
  ActionForm form,
  HttpServletRequest request, 
  HttpServletResponse response) throws Exception {
  
 
     UserForm userform = (UserForm) form;        
  String name = userform.getName();
  String psw = userform.getPsw();
  

     ServletContext context = servlet.getServletContext();
  DataSource dataSource = (DataSource)context.getAttribute("oracleDB1");
      
        DBUser dbuser = new DBUser(dataSource);
        HttpSession session = request.getSession();
       
        if (!dbuser.checkUser(name,psw)) {
   ActionMessages errors = new ActionMessages();
   errors.add(ActionMessages.GLOBAL_MESSAGE,
    new ActionMessage("label.deny"));
    
   if (!errors.isEmpty()) {
    saveErrors(request, errors);
   }
     return  mapping.findForward("failed");  //登陆失败
  }
  else{
       return (mapping.findForward("successed"));//登陆成功     
  } 
 }
}