struts数据源的配置

最新推荐文章于 2017-01-10 18:39:09 发布

jinhj2003

最新推荐文章于 2017-01-10 18:39:09 发布

阅读量99

点赞数

分类专栏： Struts2 文章标签： Struts SQL Java Servlet XML

本文链接：https://blog.csdn.net/jinhj2003/article/details/83429603

版权

Struts2 专栏收录该内容

6 篇文章 0 订阅

订阅专栏

3个包:可以到apche去下载 commons-dpcp,commons-pool ,servlet-api.

在struts-config.xml中配置是:

<data-sources>
<data-source key="org.apache.struts.action.DATA_SOURCE" type="org.apache.commons.dbcp.BasicDataSource">
<set-property property="url" value="jdbc:mysql://127.0.0.1:3306/jxtv3" />
<set-property property="username" value="root" />
<set-property property="password" value="1234" />
<set-property property="minCount" value="1" />
<set-property property="maxCount" value="10" />
<set-property property="driverClassName" value="com.mysql.jdbc.Driver" />
</data-source>

</data-sources>

在struts中应用:

javax.sql.DataSource ds = null;
java.sql.Connection conn = null;
java.sql.Statement stmt = null;
ds = getDataSource(request);
conn = ds.getConnection();
stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY);
java.sql.ResultSet rs = stmt
.executeQuery("SELECT * FROM zjy_tb ORDER BY id");

while (rs.next()) {

System.out.println(rs.getString(1));
}
// return null;
request.getSession().setAttribute("conn",ds);
return mapping.findForward("ok");
}