共分spring容器自带连接池、项目中创建连接池、服务器创建连接池三种 9'B `]/L
`c$V$/IT
1、spring容器自带连接池 bt?5*ETA
~xFkU#
<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource"> QXK{bxwC
<property name="driverClassName"> W=?<<dVYD
<value>com.mysql.jdbc.Driver</value> ?J0y|
</property> z24q3 3O
<property name="url"> 2?Vd 5xkt
<value>jdbc:mysql://127.0.0.1:3306/test</value> 'g\4O3&_
</property> L4W5EO$
<property name="username"> R|(a@sL
<value>admin</value> ;$4\e)AB
</property> Pq$n5fZC!
<property name="password"> 1% ` Rs
<value/> ?r4>" [
</property> =3P)q"
</bean> %|oym.-I6
At;LO9T3z
2、项目中创建连接池(一般利用开源项目) h?U
O&(
"{t$nVJ
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close"> Vurqt_nb
<property name="driverClassName"> %cn<ych
G
<value>com.mysql.jdbc.Driver</value> SpBy3wd
</property> DEgXQ[
<property name="url"> 307I$*%W
<value>jdbc:mysql://127.0.0.1:3306/test</value> KI.hy2?e
</property> vY3h3o
<property name="username"> n@3>6_^rwT
<value>admin</value> Q>z8IlJ}
</property> y~V(aih}D
<property name="password"> *-X[u:
<value/> %BODkc Zh
</property> ?Bmb' 3
</bean> !4!~Lk=
bN.Pex
3、应用服务器创建数据源,项目中通过jndi访问,以tomcat为例 -{vD:Il=6
kJR`:J3DJ
<bean id="dataSource" class="org.springframework.jndi.JndiObjectFactoryBean"> L~3Pm%{@A
<property name="jndiName"> lB4WKn=?Kl
<value>java:comp/env/jdbc/TestDB</value> 6S#Cl>v
</property> 4qa.1j(R/
</bean> U<XG{<2
"dlVk~
注意每种容器的jndi写法不同,所以java:comp/env/jdbc/TestDB为其全称,但在配置jndi时可能会是其中一部分,如tomcat配置jdbc/TestDB /-s6<e!
;Rf'P}"]
配置错误会报javax.naming.NameNotFoundException: Name jdbc is not bound in this Context异常