struts中數據源的配置
?<data-sources>
? <data-source key="dataSource">
?? <set-property property="driverClass"?value="oracle.jdbc.driver.OracleDriver" />
?? <set-property property="url"?value="jdbc:oracle:thin:@127.0.0.1:1521:oracle9i" />
?? <set-property property="maxCount" value="5"/>
?? <set-property property="minCount" value="2"/>
? <set-property property="user" value="scott"/>
? <set-property property="password" value="tiger"/>
? <set-property property="autoCommit" value="true"/>
? </data-source>
?</data-sources>
<data-sources>
??? <data-source key="A" type="org.apache.commons.dbcp.BasicDataSource">
????? <set-property property="driverClassName"
????????? value="com.microsoft.jdbc.sqlserver.SQLServerDriver" />
????? <set-property property="url"
????????? value="jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=mystruts;SelectMethod=cursor" />
????? <set-property property="username" value="sa" />
????? <set-property property="password" value="yourpwd" />
????? <set-property property="maxActive" value="10" />
????? <set-property property="maxWait" value="5000" />
????? <set-property property="defaultAutoCommit" value="false" />
????? <set-property property="defaultReadOnly" value="false" />
??? </data-source>
? </data-sources>