Struts 连接mysql的jdbc

Question

没听说过datasource配置在struts-config.xml的。用webserver的连接池啊

Answer 1

<data-sources>
   <data-source type="org.apache.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/databaseName" />  
   </data-source>
</data-sources>

Answer 2

还要把mySql的jdbc驱动复制到lib目录中

Answer 3

<data-sources> 
    <data-source key="mysql">
      <set-property value="org.gjt.mm.mysql.Driver" property="driverClass" />
      <set-property value="jdbc:mysql://localhost:3306/newshop" property="url" />
      <set-property value="4" property="maxCount" />
      <set-property value="2" property="minCount" />
      <set-property value="root" property="user" />
      <set-property property="password" />
    </data-source>
<data-sources>然后在类中通过ActionServlet的findDateSource("mysql")得到连接

Answer 4

大哥有没有把数据库连接写到XML的例子!给我看看！谢了！

Answer 5

我已经把mysql-connector-java-3.0.10-stable-bin.jar放到lib中.配置也跟ses127127(ses) 
配置的一样,还是出错?