共分spring容器自带连接池、项目中创建连接池、服务器创建连接池三种 EaXDY<
nps"nggk
1、spring容器自带连接池 ?QfomTT
Y%A
KN
<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource"> 1?N$I}?
<property name="driverClassName"> bJ6@
B<
<value>com.mysql.jdbc.Driver</value> T_1p1Sg
</property> ?)V}_%fVv
<property name="url"> Wk*t-
<value>jdbc:mysql://127.0.0.1:3306/test</value> 2-!n+#Cdf
</property> Th(F^W9
<property name="username"> Q]NGd 0 J
<value>admin</value> Isna
KcLM
</property> _z(ydL*
<property name="password"> kx_PMpc
<value/> WA&&*ae5`
</property> D"RxI)"HP
</bean> 5xF R7%_&
'-k~qQk)6
2、项目中创建连接池(一般利用开源项目) KIfR4,=Q|
=gb(<`{>
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close"> -yn;Jo2-
<property name="driverClassName"> ]psx\ZMa
<value>com.mysql.jdbc.Driver</value> Z/>0P* F
</property> maopr$r
<property name="url"> %/(>>*}Kw|
<value>jdbc:mysql://127.0.0.1:3306/test</value> u]%>=N(^2
</property> |#D$9+
<property name="username"> YDMimis\H5
<value>admin</value> 5{uK;Vxse
</property> "t\gkJyK
<property name="password"> HD95>%
<value/> F&I ;E i
</property> u/8urxpy
</bean> z}[qk:
r$Z_Kwe.|&
3、应用服务器创建数据源,项目中通过jndi访问,以tomcat为例 l[J'FR:
30Z RKrW"~
<bean id="dataSource" class="org.springframework.jndi.JndiObjectFactoryBean"> }7H8Y}m
<property name="jndiName"> *1[v08?!
<value>java:comp/env/jdbc/TestDB</value> +Eh^j3W
</property> g,
%xGQ4+
</bean> ~yvOR`2Gg
IO\>U(:vx
注意每种容器的jndi写法不同,所以java:comp/env/jdbc/TestDB为其全称,但在配置jndi时可能会是其中一部分,如tomcat配置jdbc/TestDB &
M wvj
~e!b81
配置错误会报javax.naming.NameNotFoundException: Name jdbc is not bound in this Context异常