共分spring容器自带连接池、项目中创建连接池、服务器创建连接池三种 5&]5*;Bv J
@"@a70WHk
1、spring容器自带连接池 .3!Wr*o
IqOg{#sm
<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource"> .sMs_ 5D
<property name="driverClassName"> s**<=M GK
<value>com.mysql.jdbc.Driver</value> 36d nS>4
</property> j\>LJai"
<property name="url"> h2l;xt
<value>jdbc:mysql://127.0.0.1:3306/test</value> ~9X^3.nI
</property> @AyteHK
<property name="username"> <izQ]\kL
<value>admin</value> /{M<FVXK+|
</property> YQVo7"`%
<property name="password"> &|v)
<value/> p/H.bG!z
</property> ,75)
</bean> *~rj!N?;
.RD<]BxJ
2、项目中创建连接池(一般利用开源项目)
=c8}^3L~7
qi-XNB`b
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close"> m|*B0GW
<property name="driverClassName"> z;OYPGvkw
<value>com.mysql.jdbc.Driver</value> Rr) 5[
</property> B2`S0 H
<property name="url"> }gp@0ri%5
<value>jdbc:mysql://127.0.0.1:3306/test</value> mHD_cgKN
</property> WT
*"V<Z
<property name="username"> R@e'=z[%1
<value>admin</value> ^-o{3Q(w
</property> /:dLqyQ_V
<property name="password"> l|5 h
<value/> m</m9h8
</property> e`*}?N4d
</bean> ]#/nn),Z
t,/ G
3、应用服务器创建数据源,项目中通过jndi访问,以tomcat为例 W4^L_p>Tm^
;vn0%g
<bean id="dataSource" class="org.springframework.jndi.JndiObjectFactoryBean"> kY0HP a
<property name="jndiName"> Hv,|XE@Y
<value>java:comp/env/jdbc/TestDB</value> Ufr@j` *
</property> ^r}c&@
</bean> ?R`S-
QcegT/vO
注意每种容器的jndi写法不同,所以java:comp/env/jdbc/TestDB为其全称,但在配置jndi时可能会是其中一部分,如tomcat配置jdbc/TestDB 0K!3Ny9(
4GYi'
配置错误会报javax.naming.NameNotFoundException: Name jdbc is not bound in this Context异常