Struts数据源配置及调用方法

在struts-config.xml里面配置如下：

   <!-- ============ DataSource Pool ============ -->
    <data-sources>
      <data-source>
        <set-property property="autoCommit" value="false"/>
        <set-property property="description" value="Database for Crm of Enterprice"/>
        <set-property property="driverClass" value="com.microsoft.jdbc.sqlserver.SQLServerDriver"/>
        <set-property property="maxCount" value="5"/>
        <set-property property="minCount" value="1"/>
        <set-property property="url" value="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=struts"/>
        <set-property property="user" value="sa"/>
        <set-property property="password" value="sa"/>
      </data-source>
    </data-sources>

调用方法为：

import java.sql.DataSource;

DataSourece ds = (DataSource)servlet.getServletContext().getAttribute("org.apache.struts.action.Data_source");

Connection conn = ds.getConnection();

PreparedStatement pstmt = conn.prepareStatement("select * from test");

ResultSet rs = pstmt.executeQuery();

这样就OK了。