Posted on 2007-12-08 10:55
探佚 阅读(217)
评论(0) 编辑 收藏 所属分类:
Java EE技术
一、struts-config.xml文件中<datasource>的配置：
DBCP (导入commons-dbcp-1.2.jar和commons-pool-1.3.jar)
struts-config.xml配置:
<data-source key="dataSource" type="org.apache.commons.dbcp.BasicDataSource">
<set-property property="driverClassName" value="" />
<set-property property="url" value="" />
<set-property property="username" value="sa" />
<set-property property="password" value="" />
</data-source>
C3P0 (导入c3p0-0.8.5.2.jar)
struts-config.xml配置:
<data-source key="dataSource" type="com.mchange.v2c3p0.DriverManagerDataSource">
<set-propertyproperty="driverClass" value="" />
<set-property property="jdbcUrl" value="" />
<set-property property="user" value="sa" />
<set-property property="password" value="" />
</data-source>
二、在插件中实例化我们自己DBManager中的DataSource
public class MyPlugIn implements PlugIn{
// 从struts-config.xml文件的<data-sourec>中读取数据源信息
public void init(ActionServlet actionServlet, ModuleConfig moduleConfig)
throws ServletException {
ServletContext sc = (DataSource)actionServlet.getServletContext;
DataSource dataSource = sc.getAttribute("pubsDS");
DBManager.dataSource = dataSource;
}
}
三、通过DataSource中获得Connection，而DriverMangaer.getConnection()已经成为过去
public class DBManager {
public static DataSource dataSource;
private Connection conn = null;
private Statement st = null;
private ResultSet rs = null;
public DBManager() {
this.getConnection();
}
private void getConnection() {
try {
this.conn = dataSource.getConnection();
this.st = conn.createStatement();
} catch (SQLException e) {
e.printStackTrace();
}
}
}