Spring配置文件中配置数据库连接(mysql,sqlserver,oracle)

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
<bean id="dataSource"

class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName" value="com.microsoft.sqlserver.jdbc.SQLServerDriver" />
<property name="url"
value="jdbc:sqlserver://localhost:1433;database=liubag;integratedSecurity=false" />
<property name="username" value="sa" />
<property name="password" value="sa123456" />

</bean>

<spring:bean id="propertyConfigurer" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">

<spring:property name="locations">

<spring:list>

<spring:value>classpath:conf/jdbc.properties</spring:value>

</spring:list>

</spring:property>

</spring:bean>



<spring:bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"

destroy-method="close">

<spring:property name="driverClassName"

value="${jdbc.driverClassName}" />

<spring:property name="url"

value="${jdbc.url}" />

<spring:property name="username" value="${jdbc.username}" />

<spring:property name="password" value="${jdbc.password}" />

<spring:property name="maxActive" value="30" />

<spring:property name="maxIdle" value="10" />

<spring:property name="maxWait" value="1000" />

<spring:property name="defaultAutoCommit" value="true" />

</spring:bean>



jdbc.properties配置文件中连接数据库配置：



#sqlserver数据源配置

jdbc.driverClassName=com.microsoft.sqlserver.jdbc.SQLServerDriver

jdbc.url=jdbc:sqlserver://192.168.1.60:1408;DatabaseName=test

jdbc.username=sa

jdbc.password=1



#mysql数据源配置

jdbc.driverClassName=com.mysql.jdbc.Driver

jdbc.url=jdbc:mysql://192.168.1.60:3306/test

jdbc.username=root

jdbc.password=root

1
2
3
4
5
6
7
8
9
10
11
12
13
14
jdbc.driverClassName=oracle.jdbc.driver.OracleDriver

jdbc.url=jdbc:oracle:thin:@10.60.17.9:1521:orcl

jdbc.username=admin

jdbc.password=admin

 <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"> 
       <property name="driverClassName" value="com.microsoft.sqlserver.jdbc.SQLServerDriver"></property> 
       <property name="url" value="jdbc:sqlserver://localhost:1433;Database=myhib;useUnicode=true&amp;characterEncoding=UTF-8"></property> 
       <property name="username" value="sa"></property> 
       <property name="password" value="我自己的密码"></property>
</bean>