求一段在struts-config.xml连接MYSQL数据库的代码！？多谢！

Question

<struts-config>
最前面加:
<data-sources>
<data-source>
<set-property property="maxCount" value="4" />
<set-property property="minCount" value="2" />
<set-property property="description"
value="MySQL Data Source Configuration" />
<set-property property="driverClass" value="org.gjt.mm.mysql.Driver" />
<set-property property="url" value="jdbc:mysql://localhost:3306/artimus" />
<set-property property="autoCommit" value="true" />
<set-property property="user" value="root" />
<set-property property="password" value="" />
</data-source>
</data-sources>

Answer 1

出现：
HTTP Status 404 - Servlet action is not available--------------------------------------------------------------------------------type Status reportmessage Servlet action is not availabledescription The requested resource (Servlet action is not available) is not available.

Answer 2

我把以前的MSSQL数据库连接的语句删了，换成你给我的代码，就出现上面情况，ACTION里面的数据库操作代码应该是通用的吧？

Answer 3

好象是配置的问题，以前配置MSSQL就出现过。

Answer 4

<struts-config>
<data-sources>
<data-source>
<set-property property="maxCount" value="4" />
<set-property property="minCount" value="2" />
<set-property property="description"
value="MySQL Data Source Configuration" />
<set-property property="driverClass" value="org.gjt.mm.mysql.Driver" />
<set-property property="url" value="jdbc:mysql://localhost:3306/artimus" />
<set-property property="autoCommit" value="true" />
<set-property property="user" value="root" />
<set-property property="password" value="" />
</data-source>
</data-sources>我自己用的

Answer 5

具体的XML文件，换成连接MSSQL的就可以。
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE struts-config PUBLIC "-//Apache Software Foundation//DTD Struts Configuration 1.1//EN" "http://jakarta.apache.org/struts/dtds/struts-config_1_1.dtd"><struts-config>
<!-- 
<data-sources>
    <data-source key="A" type="org.apache.commons.dbcp.BasicDataSource">
      <set-property property="driverClass"
          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="" />
      <set-property property="maxActive" value="10" />
      <set-property property="maxWait" value="50" />
      <set-property property="defaultAutoCommit" value="false" />
      <set-property property="defaultReadOnly" value="false" />
    </data-source>
  </data-sources>
 -->
 <!--jdbc:mysql://localhost:3306/testdb?useUnicode=true&characterEncoding=UTF-8就可以了 -->
<data-sources>
<data-source>
<set-property property="maxCount" value="4" />
<set-property property="minCount" value="2" />
<set-property property="description"
value="MySQL Data Source Configuration" />
<set-property property="driverClass" value="org.gjt.mm.mysql.Driver" />
<set-property property="url" value="jdbc:mysql://localhost:3306/test" />
<set-property property="autoCommit" value="true" />
<set-property property="user" value="root" />
<set-property property="password" value="" />
</data-source>
</data-sources>  
<form-beans>
    <form-bean name="userInfoForm" type="entity.UserInfoForm" />
    
    <form-bean name="seekForm" type="com.yourcompany.struts.form.SeekForm" />
  </form-beans>
  <global-exceptions />
  
<global-forwards /><action-mappings>
    <action
      attribute="userInfoForm"
      input="/logon.jsp"
      name="userInfoForm"
      path="/logonAction"
      type="action.LogonAction"
      validate="false">
      <forward name="success" path="/main.jsp" />
    </action>    <action
      attribute="seekForm"
      input="/seekuser.jsp"
      name="seekForm"
      path="/seek"
      type="com.yourcompany.struts.action.SeekAction" >
      <forward name="success1" path="/userpsw.jsp" />
      <forward name="faile" path="/error.jsp" />
    </action>
</action-mappings><message-resources parameter="com.yourcompany.struts.ApplicationResources" />
</struts-config>