Spring连接MySQL、Oracle和SQL Server

1. applicationContext.xml的配置如下：
2. <?xml version= "1.0" encoding= "UTF-8"?>
3. <beans
4. xmlns= "http://www.springframework.org/schema/beans"
5. xmlns:xsi= "http://www.w3.org/2001/XMLSchema-instance"
6. xsi:schemaLocation= "http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.0.xsd">
7. <bean id= "dataSource" class= "org.apache.commons.dbcp.BasicDataSource">
8. <!-- 连接MySQL-->
9. <property name= "driverClassName" value= "com.mysql.jdbc.Driver"></property>
10. <property name= "url" value= "jdbc:mysql://localhost:3306/mytest"></property>
11. <property name= "username" value= "root"></property>
12. <property name= "password" value= "root"></property>
14. <!-- 连接Oracle
15. <property name= "driverClassName" value= "oracle.jdbc.driver.OracleDriver"></property>
16. <property name= "url" value= "jdbc:oracle:thin:@localhost:1521:orcl"></property>
17. <property name= "username" value= "scott"></property>
18. <property name= "password" value= "tiger"></property>
19. -->
20. <!-- 连接SQL Server
21. <property name= "driverClassName" value= "com.microsoft.sqlserver.jdbc.SQLServerDriver"></property>
22. <property name= "url" value= "jdbc:sqlserver://localhost:1433;databaseName=test"></property>
23. <property name= "username" value= "sa"></property>
24. <property name= "password" value= "yuji"></property>
25. -->
26. <property name= "maxActive" value= "100"></property>
27. <property name= "maxIdle" value= "30"></property>
28. <property name= "maxWait" value= "500"></property>
29. <property name= "defaultAutoCommit" value= "true"></property>
30. </bean>
31. <bean id= "sessionFactory" class= "org.springframework.orm.hibernate3.LocalSessionFactoryBean">
32. <property name= "dataSource" ref= "dataSource"></property>
33. <property name= "hibernateProperties">
34. <props>
35. <!-- MySQL的方言-->
36. <prop key= "hibernate.dialect">org.hibernate.dialect.MySQLDialect</prop>
38. <!-- Oracle的方言
39. <prop key= "hibernate.dialect">org.hibernate.dialect.OracleDialect</prop>
40. -->
41. <!-- SQL Server的方言
42. <prop key= "hibernate.dialect">org.hibernate.dialect.SQLServerDialect</prop>
43. -->
44. <prop key= "hibernate.show_sql"> true</prop>
45. </props>
46. </property>
47. <property name= "mappingResources">
48. <list>
49. <value>com/test/bean/User.hbm.xml</value>
50. </list>
51. </property>
52. </bean>
53. <bean id= "userDao" class= "com.test.dao.impl.UserDAOImpl" scope= "singleton">
54. <property name= "sessionFactory">
55. <ref bean= "sessionFactory"/>
56. </property>
57. </bean>
58. <bean id= "userService" class= "com.test.service.impl.UserServiceImpl">
59. <property name= "userDao" ref= "userDao"></property>
60. </bean>
61. <bean id= "saveUserAction" class= "com.test.action.user.SaveUserAction" scope= "prototype">
62. <property name= "service" ref= "userService"></property>
63. </bean>
64. <bean id= "listUserAction" class= "com.test.action.user.ListUserAction" scope= "prototype">
65. <property name= "service" ref= "userService"></property>
66. </bean>
67. <bean id= "removeUserAction" class= "com.test.action.user.RemoveUserAction" scope= "prototype">
68. <property name= "service" ref= "userService"></property>
69. </bean>
70. </beans>

1. Hibernate SQL方言 (hibernate.dialect)
2. 数据库
3. hibernate方言
4. DB2 org.hibernate.dialect.DB2Dialect
5. DB2 AS/ 400 org.hibernate.dialect.DB2400Dialect
6. DB2 OS390 org.hibernate.dialect.DB2390Dialect
7. PostgreSQL org.hibernate.dialect.PostgreSQLDialect
8. MySQL org.hibernate.dialect.MySQLDialect
9. MySQL with InnoDB org.hibernate.dialect.MySQLInnoDBDialect
10. MySQL with MyISAM org.hibernate.dialect. MySQLMyISAMDialect
11. Oracle (any version) org.hibernate.dialect.OracleDialect
12. Oracle 9i/10g org.hibernate.dialect.Oracle9Dialect
13. Sybase org.hibernate.dialect.SybaseDialect
14. Sybase Anywhere org.hibernate.dialect.SybaseAnywhereDialect
15. Microsoft SQL Server org.hibernate.dialect.SQLServerDialect
16. SAP DB org.hibernate.dialect.SAPDBDialect
17. Informix org.hibernate.dialect.InformixDialect
18. HypersonicSQL org.hibernate.dialect.HSQLDialect
19. Ingres org.hibernate.dialect.IngresDialect
20. Progress org.hibernate.dialect.ProgressDialect
21. Mckoi SQL org.hibernate.dialect.MckoiDialect
22. Interbase org.hibernate.dialect.InterbaseDialect
23. Pointbase org.hibernate.dialect.PointbaseDialect
24. FrontBase org.hibernate.dialect.FrontbaseDialect
25. Firebird org.hibernate.dialect.FirebirdDialect
26.