Struts配置数据源

原文地址：Struts配置数据源 作者：哈哈宝

今天用struts datasouce成功连接mysql数据库，在此记录一下心得。

 

需要注意的是要将mysql-connector-java-5.0.5-bin.jar，commons-dbcp-1.2.2.jar，commons-pool-1.3.jar放到WEB-INFlib中。如果没有这些包，运行时会出现servlet action is not available的错误。

 

这些jar包分别到一下网站去下载：

http://dev.mysql.com/downloads/connector/j/5.0.html

http://www.uniontransit.com/apache/jakarta/commons/dbcp/binaries/

http://www.uniontransit.com/apache/jakarta/commons/pool/binaries/

 

1）struts-config.xml中data-sources的配置

<data-sources>
        <data-source key="org.apache.struts.action.DATA_SOURCE" type="org.apache.commons.dbcp.BasicDataSource">
            <set-property property="url" value="jdbc:mysql://localhost:3306/hhbtest" />
            <set-property property="username" value="root" />
            <set-property property="password" value="19850608" />
            <set-property property="minCount" value="1" />
            <set-property property="maxCount" value="10" />
            <set-property property="driverClassName" value="com.mysql.jdbc.Driver" /> 
        </data-source>
    </data-sources>

 

2)Action类中获得数据源

 DataSource ds = getDataSource(request,"org.apache.struts.action.DATA_SOURCE");
SqlBean sql = new SqlBean();
sql.setDataSource(ds);
boolean success = sql.checkUser(username,password1);

 

3) 对数据库操作的SqlBean类

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import javax.sql.DataSource;

/**
 *
 * @author Hahabao
 */
public class SqlBean {
    DataSource dataSource;
    public void setDataSource(DataSource dataSource) {
        this.dataSource = dataSource;
    }
       
    public boolean checkUser(String username,String password) throws Exception{
        Connection connect = null;
        String strSql;
        ResultSet rs;
        boolean check=false;
        strSql = "select * from user where username='"
                + username + "' and password='" + password + "'";
        try {
            connect = dataSource.getConnection();
            Statement stmt = connect.createStatement();
            rs = stmt.executeQuery(strSql);
            if (rs.next()) {
                check=true;
            }
        } catch(SQLException ex) {
            ex.printStackTrace();
        } finally{
            if(connect!=null)
                connect.close();
        }
        return check;
    }
}