mysql 数据源

 // struts config .xml

  <data-sources >
    <data-source key="mysql">

      <set-property property="password" value="test" />

      <set-property property="minCount" value="1" />

      <set-property property="maxCount" value="50" />

      <set-property property="user" value="test" />

      <set-property property="driverClass" value="com.mysql.jdbc.Driver" />

      <set-property property="description" value="" />

      <set-property property="url" value="jdbc:mysql://192.168.2.215:3306/test" />

      <set-property property="readOnly" value="false" />

      <set-property property="autoCommit" value="true" />

      <set-property property="loginTimeout" value="" />

    </data-source>

 

//java codes

 ServletContext sc=servlet.getServletContext();
  
  DataSource dataSource=(DataSource)sc.getAttribute("mysql");

   Connection conn=dataSource.getConnection();
   Statement stmt=conn.createStatement();
   ResultSet rs=stmt.executeQuery("select * from