共分spring容器自带连接池、项目中创建连接池、服务器创建连接池三种 UCmy$aW
Z}0xK6
1、spring容器自带连接池 gsEcvkj*
LFxk.-{=
<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource"> +%,oq]<[,
<property name="driverClassName"> LI3L~6A>
<value>com.mysql.jdbc.Driver</value> )P
b$
</property> h9imS\gfr
<property name="url"> W!\%v"
<value>jdbc:mysql://127.0.0.1:3306/test</value> kiN,N]-V
</property> G%l')e)9Gq
<property name="username"> )4qspy3
<value>admin</value> C{^I}p
</property> LXxQI(RO
<property name="password"> p&Qm[!
<value/> dL+yd0b*
</property> ZAy/u@qt
</bean> \db=]L=|
CC"a2Hu/
2、项目中创建连接池(一般利用开源项目) @w.DN)GPo
L>1y[
Q
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close"> wGT>Xh!
<property name="driverClassName"> gt.F[q3
<value>com.mysql.jdbc.Driver</value> ;>6~}lMgJ
</property> wE=I3E %
<property name="url"> `W@jo~y<
<value>jdbc:mysql://127.0.0.1:3306/test</value> DjN1EP\Xx
</property> pGR3
<property name="username"> 3b0|7@_E
<value>admin</value> ohx$;j
</property> |4pl}:g/Z
<property name="password"> ?qSwV.l]d
<value/> 2bw), W
</property> xSM1b5=Pu
</bean> nj;3U^
^swj!da
3、应用服务器创建数据源,项目中通过jndi访问,以tomcat为例 h
x5M)8#+
j}/).O
<bean id="dataSource" class="org.springframework.jndi.JndiObjectFactoryBean"> `W+-0F@Y?@
<property name="jndiName"> bfncO[Q,?
<value>java:comp/env/jdbc/TestDB</value> `S-l.zSZ4B
</property> ~F,YBX
</bean> d`flYNg4
TW(X#T@Z6I
注意每种容器的jndi写法不同,所以java:comp/env/jdbc/TestDB为其全称,但在配置jndi时可能会是其中一部分,如tomcat配置jdbc/TestDB { ?jXPf
]R}(CaT1
配置错误会报javax.naming.NameNotFoundException: Name jdbc is not bound in this Context异常