新手求教struts中的数据库连接

Question

希望这一贴能帮到你
http://expert.csdn.net/Expert/topic/1222/1222114.xml?temp=.2062189

Answer 1

如果我把struts-config.xml中data-sources配置注释掉则没有问题，否则启动tomcat后运行jsp就出现如下错误（难道增加data-sources后还要增加什么actionmappings或actionformbeans？？？）：
javax.servlet.ServletException: Cannot find ActionMappings or ActionFormBeans collection
at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:463)
at org.apache.jsp.login$jsp._jspService(login$jsp.java:377)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:107)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.java:202)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:382)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:474)
...

Answer 2

struts-config.xml中：
<data-sources>
    <data-source autoCommit="false"
                 description=""
                 driverClass="oracle.jdbc.driver.OracleDriver"
                 maxCount="7"
                 minCount="3"
                 password="yamada"
                 url="jdbc:oracle:thin:@10.0.0.200:1521:datasource"
                 user="user"/>
    </data-sources>
jsp中：
java.sql.Connection sqlCon; Statement sqlStmt=null;java.sql.ResultSet sqlRst; java.lang.String strCon; java.lang.String strSQL;DataSource  dataSource = (DataSource)application.getAttribute("org.apache.struts.action.DATA_SOURCE");
sqlCon =dataSource.getConnection();
sqlStmt= sqlCon.createStatement();//prepare sql
            strSQL =""
//get Query's results
sqlRst = sqlStmt.executeQuery(strSQL);