共分spring容器自带连接池、项目中创建连接池、服务器创建连接池三种 hO{&bY0
?u;m
],w!
1、spring容器自带连接池 8z7eL>)
D|<_96_m
<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource"> z C$F@
<property name="driverClassName"> e6H}L:;
<value>com.mysql.jdbc.Driver</value> KHx;r@{<
</property> Z__fwv.X[
<property name="url"> ;I80<SZ
<value>jdbc:mysql://127.0.0.1:3306/test</value> n%RaEL
</property> X2 ;72
<property name="username"> fVa z'R
<value>admin</value> BB9eQ:
xO
</property> =sv?))b`
<property name="password"> a5O$he
<value/> %C #Ps
</property> {q+gm1iC
</bean> #O,w{S
p,|)qr:M
2、项目中创建连接池(一般利用开源项目) )?B-en\
CS*lk!C
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close"> (fr=[m$`
<property name="driverClassName"> U(x$&um(l
<value>com.mysql.jdbc.Driver</value> f\=,_AQ
</property> 1M?x,N_W
<property name="url"> &e3}Vop
<value>jdbc:mysql://127.0.0.1:3306/test</value> RhT:]
</property> bF*Kb"!CF
<property name="username"> }?Pa(0=U
<value>admin</value> Oml3=TV
</property> -kP2Brm
<property name="password"> uh#E^~5S
<value/> 4T"L#o1
</property> qK@,O\
</bean> BT;1"l<
yLnTIE 3)
3、应用服务器创建数据源,项目中通过jndi访问,以tomcat为例 S;iD~> KP
8'fF{C
<bean id="dataSource" class="org.springframework.jndi.JndiObjectFactoryBean">
.#a7?LUH
<property name="jndiName"> s(s_v ?k
<value>java:comp/env/jdbc/TestDB</value> !Q%r4Nr
</property> k%sA+=
</bean> \k6OP
,If"4C!w
注意每种容器的jndi写法不同,所以java:comp/env/jdbc/TestDB为其全称,但在配置jndi时可能会是其中一部分,如tomcat配置jdbc/TestDB \>w 2D
:x3DuQP
配置错误会报javax.naming.NameNotFoundException: Name jdbc is not bound in this Context异常