一、<data-sources>元素: <data-sources>可包括多个<data-source>元素,<data-source>元素配置形式如下:
<data-source type="org.apache.commons.dbcp.basicdatasource"> <set-property property="autocommit" value="true"/>
<set-property property="driverclass" value="......"/>
<set-property property="url" value="......"/>
<set-property property="maxcount" value="10"/>
<set-property property="mincount" value="2"/>
<set-property property="user" value="....."/>
<set-property property="password" value="......"/>
</data-source>
配置了数据源后,可以通过以下代码访问数据源:
public actionforward
execute(actionmapping mapping,
actionform form,
httpservletrequest request,
httpservletresponse response) throws exception
{
javax.sql.datasource datasource;
java.sql.connection myconnection;
try {
datasource = getdatasource(request);
myconnection = datasource.getconnection();
// do what you wish with myconnection
} catch (sqlexception sqle) {
getservlet().log("connection.process", sqle);
} finally {
//enclose this in a finally block to make
//sure the connection is closed
try {
myconnection.close();
} catch (sqlexception e) {
getservlet().log("connection.close", e);
}
}
}
当在配置文件中声明多个数据源时,此时需要为每一个数据源分配一个唯一的key 值,通过该值来访问特定的数据源。例如:
data-sources>
<data-source key="a" type="org.apache.commons.dbcp.basicdatasource">
... properties as before ...
</data-source>
<data-source key="b" type="org.apache.commons.dbcp.basicdatasource">
... properties as before ...
</data-source>
...
</data-sources>
此时可通过如下代码访问数据源:
datasourcea = getdatasource(request, "a");
datasourceb = getdatasource(request, "b");
文章整理:西部数码--专业提供域名注册、虚拟主机服务
http://www.west263.com
以上信息与文章正文是不可分割的一部分,如果您要转载本文章,请保留以上信息,谢谢!


