Spring整合Hibernate|MyBatis

发表于 | 分类于

Spring 整合 Hibernate

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
<!-- 配置 Hibernate -->
<context:property-placeholder location="classpath:bookSys.properties" ignore-unresolvable="true"/>
<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method="close">
  <property name="driverClass" value="${bookSys.driver}"/>  <!--数据库连接驱动-->
  <property name="jdbcUrl" value="${bookSys.url}"/>     <!--数据库地址-->
  <property name="user" value="${bookSys.username}"/>   <!--用户名-->
  <property name="password" value="${bookSys.password}"/>   <!--密码-->
  <property name="maxPoolSize" value="40"/>      <!--最大连接数-->
  <property name="minPoolSize" value="1"/>       <!--最小连接数-->
  <property name="initialPoolSize" value="10"/>      <!--初始化连接池内的数据库连接-->
  <property name="maxIdleTime" value="20"/>  <!--最大空闲时间-->
</bean>
<!-- 配置 SessionFactory -->
<bean id="sessionFactory"  class="org.springframework.orm.hibernate5.LocalSessionFactoryBean">
  <property name="dataSource" ref="dataSource"/>
  <property name="packagesToScan" value="com.lujinbiao.entity"/>
  <property name="hibernateProperties">
    <props>
    <prop key="show_sql">true</prop>
    <prop key="hibernate.dialect">org.hibernate.dialect.MySQL5Dialect</prop>
    <prop key="hibernate.connection.url">jdbc:mysql://localhost:3306/bookSys</prop>
    <prop key="hibernate.connection.driver_class">com.mysql.jdbc.Driver</prop>
    </props>
  </property>
</bean>
<!-- 事务管理器 -->
<bean id="transactionManager" class="org.springframework.orm.hibernate5.HibernateTransactionManager">
  <property name="sessionFactory" ref="sessionFactory"/>
</bean>
<tx:annotation-driven transaction-manager="transactionManager"/>

Spring 整合 MyBatis

1
2
3
4
5
6
引入依赖
<dependency>
	<groupId>org.mybatis</groupId>
	<artifactId>mybatis-spring</artifactid>
	<version>1.3.0</version>
</dependency>
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
数据源
<bean id="dataSource" class="org.apache.ibatis.datasource.pooled.PooledDataSource">
	<property name="driver value=""/>
	<property name="url" value="/>
	<property name="username" value=""/>
	<property name="password" value=""/>
</bean>

注册 Bean
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
	<property name="configLocation" value="classpath:mybatis-config.xml"/>
	<property name="dataSource" value="dataSource"/>
		<array>
			<value>classpath:**/mapper/*.xml</value>
		</array>
		<property name="typeAliasesPackage" value="包名"/>
</bean>
  • configLocation：mybatis配置文件的路径。
  • dataSource：配置数据源，必选。
  • mapperLocations：配置 SqlSessionFactoryBean 扫描 XML 映射文件的路径。
  • typeAliasesPackage：配置包中类的别名