配置Mybatis

一、加载jar包

       

<!--mybatis配置--><dependency>    <groupId>org.mybatis</groupId>    <artifactId>mybatis</artifactId>    <version>${mybatis.version}</version></dependency><dependency>    <groupId>org.mybatis</groupId>    <artifactId>mybatis-spring</artifactId>    <version>1.2.2</version></dependency>

二、配置文件

       

<!--读取db.properties文件--><!--<context:property-placeholder location="classpath:db.properties"/>--><bean class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">    <property name="location" value="classpath:db.properties"/></bean><!--配置dbcp连接池--><bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">    <property name="driverClassName" value="${jdbc.driverClassName}"/>    <property name="url" value="${jdbc.url}"/>    <property name="username" value="${jdbc.username}"/>    <property name="password" value="${jdbc.password}"/>    <property name="initialSize" value="1"/>    <property name="maxActive" value="2"/>    <property name="maxIdle" value="1"/>    <property name="minIdle" value="0"/>    <property name="maxWait" value="60000"/></bean><bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">    <property name="dataSource" ref="dataSource"/>    <property name="typeAliasesPackage" value="com.test.common.model,com.test.open.model,com.test.secure.model"/>    <property name="mapperLocations" value="classpath:com/test/**/mapper/*.xml"/></bean><bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">    <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>    <property name="basePackage" value="com.test.**.mapper"/></bean>

三、mapper文件节点分析

<?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.tisson.ipran.open.authentication.persistence.SysUserMapper">
<resultMap id="sysUserResultMap" type="cn.tisson.ipran.open.authentication.domain.SysUser">      <id property="userId" column="USER_ID" jdbcType="VARCHAR"/>      <result property="userName" column="USER_NAME" jdbcType="VARCHAR"/>      <result property="password" column="PASSWORD" jdbcType="VARCHAR"/>      <result property="email" column="EMAIL" jdbcType="VARCHAR"/>      <result property="isValid" column="IS_VALID" jdbcType="CHAR"/>      <result property="createDate" column="CREATE_DATE" jdbcType="DATE"/>      <result property="updateDate" column="UPDATE_DATE" jdbcType="DATE"/>      <result property="passErrorCount" column="PASSERRORCOUNT" jdbcType="NUMERIC"/>      <association  property="sysRole" column="ROLE_ID" javaType="SysRole"           select="getSysRoleById" />      <collection property="sysRights" column="ROLE_ID" ofType="SysRight"               select="getSysRightsByRoleId"/> </resultMap>
<select id="countSysScript"  resultType="int" parameterType="cn.tisson.ipran.secure.sysautojob.domain.SysScriptBean">   select count(1) from (      <include refid="sql"/> 
      <include refid="whereSql"/> 
   )</select>
<sql id="whereSql">   where 1=1    <if test="actionId != null and actionId != ''">      and s.action_id = #{actionId}   </if>   order by s.action_id,s.save_date</sql> 
<insert id="addSysScript" parameterType="cn.tisson.ipran.secure.sysautojob.domain.SysScriptBean">    insert into ACTION_MODEL_SCRIPT_RELATION (biz_type,action_id, action_sub_id,model_id, script_id,des, net_type, save_date)        values (#{bizTypeId,jdbcType=VARCHAR},#{actionId,jdbcType=VARCHAR},#{actionSubId,jdbcType=VARCHAR}, #{modelId,jdbcType=VARC   HAR},    #{scriptId,jdbcType=VARCHAR},    #{scriptDescribe,jdbcType=VARCHAR},    #{netType,jdbcType=VARCHAR}, sysdate)</insert>
<delete id="deleteSysScript" parameterType="cn.tisson.ipran.secure.sysautojob.domain.SysScriptBean">   delete from res_tunnel_biz_script       where action_id=#{actionId,jdbcType=VARCHAR}         and model_id=#{modelId,jdbcType=VARCHAR}         and action_sub_id= #{actionSubId,jdbcType=VARCHAR}</delete>

<update id="updateSysScript" parameterType="cn.tisson.ipran.secure.sysautojob.domain.SysScriptBean">   update ACTION_MODEL_SCRIPT_RELATION       <set>      des = #{scriptDescribe,jdbcType=VARCHAR}   </set>   where    biz_type=#{bizTypeId,jdbcType=VARCHAR}   and action_id=#{actionId,jdbcType=VARCHAR}        and model_id=#{modelId,jdbcType=VARCHAR}        and action_sub_id= #{actionSubId,jdbcType=VARCHAR} </update>


  </mapper>

四、分页节点

<select id="selectPageNewSysScript" resultMap="BaseResultMap" parameterType="cn.tisson.ipran.secure.sysautojob.domain.SysScriptBean">   <include refid="cn.tisson.ipran.common.page.persistence.NumberMapper.Pagination_Head_Clause"/>      <include refid="newSql"/>  <include refid="cn.tisson.ipran.common.page.persistence.NumberMapper.Pagination_Tail_Clause"/></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.tisson.ipran.common.page.persistence.NumberMapper">   <sql id="Pagination_Head_Clause">      <if test="fromNumber != null and toNumber != null">         <![CDATA[select * from ( select tdata.*, ROWNUM ROWNUM_ from ( ]]>      </if>   </sql>   <sql id="Pagination_Tail_Clause" >      <if test="fromNumber != null and toNumber != null">         <![CDATA[) tdata where rownum <= #{toNumber} ) where rownum_ > #{fromNumber}]]>      </if>   </sql></mapper>