欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页

spring4+mybatis3 集成实例(一)

程序员文章站 2022-05-29 13:26:53
...

 

<?xml version="1.0" encoding="UTF-8" ?>
<beans xmlns="http://www.springframework.org/schema/beans"
 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:context="http://www.springframework.org/schema/context"
 xmlns:p="http://www.springframework.org/schema/p" xmlns:aop="http://www.springframework.org/schema/aop"
 xmlns:tx="http://www.springframework.org/schema/tx"
 xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.0.xsd
    http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.0.xsd http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-4.0.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.0.xsd">
   
    <!-- 说明:下面有的Bean配置提供了多种方案,请根据需要采用某一种(别忘了注释掉其他同类方案) -->

 <!-- 自动加载属性配置文件 -->
 <context:property-placeholder location="classpath:jdbc.properties" />
 
 <!-- 自动扫描Spring注解配置 -->
 <context:component-scan base-package="cn" />
 
<!--  <bean id="applicationUtil" class="job.SpringContextHolder"/> -->


 
 <!-- spring 整合mybatis -->
 <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
  <property name="url" value="${url}"></property>
  <property name="driverClassName" value="${driverClassName}"></property>
  <property name="username" value="root"></property>
  <property name="password" value="password"></property>
  <!--连接池启动时的初始化-->
  <property name="initialSize" value="2"></property>
  <!--连接池的最大值-->
  <property name="maxActive" value="100"></property>
  <!-- 最大空闲值-->
  <property name="maxIdle" value="20"></property>
  <!-- 最小空闲值-->
  <property name="minIdle" value="10"></property>
  <property name="validationQuery" value="${validationQuery}"></property>
 </bean>
 <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
  <property name="dataSource" ref="dataSource"></property>
  <property name="mapperLocations" value="classpath:cn/mapper/*.xml"></property>
  <property name="configLocation" value="classpath:configuration.xml"></property>
 </bean>
 <!-- 配置扫描器 -->
 <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
  <property name="basePackage" value="cn.mapper"></property>
  <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"></property>
 </bean>
 
 <!-- spring的事务管理器 -->
 <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
  <property name="dataSource" ref="dataSource"></property>
 </bean>
 
 <!-- 注解方式配置事务 -->
 <tx:annotation-driven transaction-manager="transactionManager"/>
</beans>

 

需要加入spring-mybatis集成jar包:http://mybatis.github.io/spring/

 

@Repository
public interface UserMapper {

 public abstract int delete(String userId);
 
 public abstract int insert(User user);
 
 public abstract int update(User user);
 
 public abstract User selectById(String userId);
 
 public abstract List<User> select();
}

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
<mapper namespace="cn.mapper.UserMapper" >


 <resultMap id="userDomain" type="cn.domain.User">
  <id property="userId" column="USERID" ></id>
  <result property="userName" column="USERNAME"></result>
  <result property="birthday" column="BIRTHDAY"></result>
  <result property="salary" column="SALARY"></result>
  
<!--   <result property="birthdayStr" column="BIRTHDAY" typeHandler="cn.util.MyDateHandler"></result> -->
  <result property="birthdayStr" column="BIRTHDAY" typeHandler="myDateHandler"></result>
 </resultMap>
 
 <sql id="userFields">
  USERID, USERNAME, BIRTHDAY, SALARY
 </sql>

 <select id="selectById" parameterType="string" resultType="cn.domain.User">
  select
  <include refid="userFields"></include>
  from user
  where USERID = #{userId}
 </select>
 
 <select id="select" resultMap="userDomain">
  select
  <include refid="userFields"></include>
  from user
 </select>

 <insert id="insert" parameterType="cn.domain.User" >
  insert into user
  <trim prefix="(" suffix=")" suffixOverrides=",">
   <if test="userId != null">
    USERID,
   </if>
   <if test="userName != null">
    USERNAME,
   </if>
   <if test="birthday != null">
    BIRTHDAY,
   </if>
   <if test="salary != null">
    SALARY,
   </if>
  </trim>
  
  <trim prefix="values (" suffix=")" suffixOverrides=",">
   <if test="userId != null">
    #{userId},
   </if>
   <if test="userName != null">
    #{userName},
   </if>
   <if test="birthday != null">
    #{birthday},
   </if>
   <if test="salary != null">
    #{salary},
   </if>
  </trim>
 </insert>
 
 <update id="update" parameterType="cn.domain.User">
  update user
  set USERNAME = #{userName},
   BIRTHDAY = #{birthday},
   SALARY   = #{salary}
  where USERID = #{userId}
 </update>
 
 <delete id="delete" parameterType="string">
  delete from user where USERID = #{userId}
 </delete>
</mapper>

相关标签: spring4+mybatis3集成