今天用struts datasouce成功连接mysql数据库,在此记录一下心得。
需要注意的是要将mysql-connector-java-5.0.5-bin.jar,commons-dbcp-1.2.2.jar,commons-pool-1.3.jar放到/WEB-INF/lib中。如果没有这些包,运行时会出现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;
}
}