共分spring容器自带连接池、项目中创建连接池、服务器创建连接池三种 #M{qMJHDo
/!2`pv
1、spring容器自带连接池 i(pHJP:a:
2,dWD<h
<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource"> T\n6^@.>
<property name="driverClassName"> ~uH_y-
<value>com.mysql.jdbc.Driver</value> 04jvrde8-O
</property> yq49fEgc@U
<property name="url"> 6F!B*lr
<value>jdbc:mysql://127.0.0.1:3306/test</value> (M"rpG>L
</property> ~5`oNa
<property name="username"> 5?F5xiW
<value>admin</value> t[J=8rhER
</property> oz>2P.7
<property name="password"> Q&N#q53
<value/> BGBHA"5fz
</property> _crhBp5@T3
</bean> !ig&8:
`:Gzjngc
2、项目中创建连接池(一般利用开源项目) JC%&d1
4MS#`E7LrC
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close"> s:7/\h
<property name="driverClassName"> ?"r=08
<value>com.mysql.jdbc.Driver</value> 3r,~-6
</property> 'St6a*
<property name="url"> )PTvw>
<value>jdbc:mysql://127.0.0.1:3306/test</value> ZaU8eg7
</property> k`Ifl)
<property name="username"> uZtN,Un
<value>admin</value> +:uz=~mo`
</property> 'Zp{
<property name="password"> i? ~-%
<value/> n'v\2(&uYN
</property> -z~!%4 a
</bean> Ac|\~w[\
iW^J>aKy
3、应用服务器创建数据源,项目中通过jndi访问,以tomcat为例 nV7Vc;
o^vX\a?`u
<bean id="dataSource" class="org.springframework.jndi.JndiObjectFactoryBean"> l@Vv%w9H
<property name="jndiName"> uyxYCc
<value>java:comp/env/jdbc/TestDB</value> g/JF(nkP
</property> hp)^s7H
</bean> ey=KA t
X0u,QSt'O
注意每种容器的jndi写法不同,所以java:comp/env/jdbc/TestDB为其全称,但在配置jndi时可能会是其中一部分,如tomcat配置jdbc/TestDB @2/|rq
OIL8'xY.w
配置错误会报javax.naming.NameNotFoundException: Name jdbc is not bound in this Context异常