websphere中利用struts的JSP如何连接mysql数据库？

Question

可以直接使用struts带的连接池啊，在struts-config.xml中进行配置
<data-sources>
        <data-source type="org.apache.commons.dbcp.BasicDataSource">            
            <set-property property="driverClassName" value="com.microsoft.jdbc.sqlserver.SQLServerDriver" />
            <set-property property="url" value="jdbc:microsoft:sqlserver://192.168.1.10:1433;DatabaseName=db1;SelectMethod=cursor" />            
            <set-property property="username" value="sa" />
            <set-property property="password" value="sa" />
            <set-property property="maxActive" value="20" />
            <set-property property="maxWait" value="5000" />
            <set-property property="defaultAutoCommit" value="true" />
            <set-property property="defaultReadOnly" value="false" />
            <set-property property="validationQuery" value="SELECT 1" />
            <set-property property="removeAbandoned" value="true" />
            <set-property property="removeAbandonedTimeout" value="120" />            
            <set-property property="encoding" value="false" />            
        </data-source>
    </data-sources>
http://www.javayou.com