Spring配置

changyy_1988

浏览: 21559 次
性别:
来自: 郑州

最近访客更多访客>>

woodding2008

704233326

NSDaBen

962685987962685987

博主相关

博客

微博

相册

留言

关于我

文章分类

社区版块

存档分类

spring中的数据源 Spring配置

1 使用Spring自带的DriverManagerDataSource
<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName">
  <value>com.microsoft.jdbc.sqlserver.SQLServerDriver</value>
</property>
<property name="url">
  <value>jdbc:Microsoft.sqlserver://localhost:1433/db</value>
</property>
<property name="username">
  <value>cyy</value>
</property>
<property name="password">
  <value>0922</value>
</property>
</bean>
<bean id="transactionManger" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource">
  <ref bean="dataSource"/>
</property>
</bean>
2 使用DBCP连接池
若在Spring中使用DBCP连接池，需要引入commons-collectons.jar,commons-dbcp.jar,commons-pool.jar
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
<property name="driverClassName">
  <value>com.microsoft.jdbc.sqlserver.SQLServerDriver</value>
</property>
<property name="url">
  <value>jdbc:Microsoft.sqlserver://localhost:1433/db</value>
</property>
<property name="username">
  <value>cyy</value>
</property>
<property name="password">
  <value>0922</value>
</property>
</bean>
<bean id="transactionManger" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource">
  <ref bean="dataSource"/>
</property>
</bean>
3 使用Tomcat提供的JNDI
A：配置Tomcat的Server.xml文件
<Context path="/cyyProject" reloadable="true" docBase="D:\workspace\cyyproject\WebRoot" workDir="D:\workspace\cyyproject\WebRoot">
  <Resource name="jdbc/db"
     auth="Container"
     type="javax.sql.DataSource"
     factory="org.apache.tomcat.dbcp.BasicDataSourceFactory"
     driverClassName="com.microsoft.jdbc.sqlserver.SQLServerDriver"
     url="jdbc:Microsoft:sqlserver://localhost:1422/db"
     username="cyy"
     password="0922"
     maxIdle="10000" // 最大空闲时间
     maxWait="10000" // 最大等待时间
     removeAbandoned="true"
     removeAbandonedTimeout="10"
     logAbandoned="true"/>
</Context>
B：编写Spring配置文件
<bean id="dataSource" class="org.springframework.jndi.JndiObjectFactoryBean">
<property name="jndiName">
  <value>jdbc/db</value>
<property>
</bean>
<bean id="transactionManger" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource">
  <ref bean="dataSource"/>
</property>
</bean>
4 使用Hibernate
<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName">
  <value>com.microsoft.jdbc.sqlserver.SQLServerDriver</value>
</property>
<property name="url">
  <value>jdbc:Microsoft.sqlserver://localhost:1433/db</value>
</property>
<property name="username">
  <value>cyy</value>
</property>
<property name="password">
  <value>0922</value>
</property>
</bean>
//使用Hibernate的SessionFactory
<bean id="sessionFactory" class="org.springframework.orm.hibernate.LocalSessionFactoryBean">
<property name="dataSource">
  <ref local="dataSource">
</property>
<property name="mappingResources">
  <list>
   <value>daxx.hbm.xml</value>
  </list>
</property>
<property name="hibernateProperties">
  <props key="hibernate.dialect">
   hibernate.dialect.SQLServerDialect
  </props>
  <props key="hibernate.show_sql">
   ture
  </props>
</property>
</bean>
<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="sessionFactory">
  <ref bean="sessionFactory">
</property>
</bean>
5 使用Ibatis
<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName">
  <value>com.microsoft.jdbc.sqlserver.SQLServerDriver</value>
</property>
<property name="url">
  <value>jdbc:Microsoft.sqlserver://localhost:1433/db</value>
</property>
<property name="username">
  <value>cyy</value>
</property>
<property name="password">
  <value>0922</value>
</property>
</bean>
// 使用Ibatis
<bean id="sqlMap" class="org.springframework.orm.ibatis.SqlMapClientFactoryBean">
<property name="configLocation">
  <value>WEB/sqlmapConfig.xml</value>
<property>
</bean>
<bean id="transactionManger" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource">
  <ref bean="dataSource"/>
</property>
</bean>