Struts 下数据源的配置

最新推荐文章于 2024-09-19 14:54:23 发布

ytuwlg

最新推荐文章于 2024-09-19 14:54:23 发布

阅读量470

点赞数

文章标签： struts sqlserver microsoft import encoding jdbc

本文链接：https://blog.csdn.net/ytuwlg/article/details/1828142

版权

<?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="sky/data" type="org.apache.commons.dbcp.BasicDataSource">
      <set-property property="password" value="20981242" />
      <set-property property="minCount" value="5" />
      <set-property property="maxCount" value="5" />
      <set-property property="username" value="wlg" />
      <set-property property="driverClassName" value="com.microsoft.jdbc.sqlserver.SQLServerDriver" />
      <set-property property="description" value="sky/data" />
      <set-property property="url" value="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=exam" />
      <set-property property="readOnly" value="false" />
      <set-property property="autoCommit" value="true" />
      <set-property property="setloginTimeout" value="20000" />
    </data-source>

</data-sources>
<form-beans >
    <form-bean name="loginForm" type="com.sky.struts.form.LoginForm" />

</form-beans>

______________________________________________________________________________________________________________
import javax.servlet.ServletContext;
import javax.sql.DataSource;

ServletContext context=servlet.getServletContext();
DataSource data=(DataSource)context.getAttribute("sky/data");
Connection conn=data.getConnection();
______________________________________________________________________________________________________________
javax.sql.DataSource data=getDataSource(request,"sky/data"); //getDataSource()为action 类的一个方法