Struts-config中如何获取数据源的连接?

Question

<data-sources><data-source type=”org.apche.commons.dbcp.BasicDataSource”><set-property property=”autoCommit” value=”true”/><set-property property=”description” value=”MySQL Data Source”/><set-property property=”driverClass” value=”com.mysql.jdbc.Driver”/><set-property property=”maxCount” value=”10”/><set-property property=”minCount” value=”2”/><set-property property=”user” value=”root”/><set-property property=”password” value=””/><set-property property=”url” value=”jdbc:mysql://localhost:3306/addressbooksample”/>
</data-source>

Answer 1

能过DBCP这些包把data-source引入进来即可

Answer 2

把commons-pool.jar,commons-dbcp.jar,commons-collection.jar三个包放在lib里，然后在action中：
            dataSource = (DataSource)servlet.getServletContext().getAttribute("empTable");"empTable is your datasource's key"
            conn = dataSource.getConnection();
            String sqlQuery = new SqlBean().paperInfoQuery(courseName);//your query function.
            prpStmt = conn.prepareStatement(sqlQuery);
            paperResultSet = prpStmt.executeQuery();