mybatis简单基础配置

最新推荐文章于 2024-11-12 20:24:03 发布

转载最新推荐文章于 2024-11-12 20:24:03 发布 · 125 阅读

java mabatis 专栏收录该内容

1 篇文章

订阅专栏

本文介绍了MyBatis的基本配置方法，包括通过applicationContext-mybatis.xml文件设置SqlSessionFactoryBean及MapperScannerConfigurer，同时展示了mapper.xml文件的具体用法，如定义映射器、插入更新操作等。

mybatis配置方式有很多，这里做个简单记录applicationContext-mybatis.xml文件如下

	<bean id="sqlSessionFactory-source" class="org.mybatis.spring.SqlSessionFactoryBean">
		<property name="dataSource" ref="dynamicDataSource" />
		<property name="mapperLocations" value="classpath:conf/mybatis/xxxx/*-mapper.xml" />
	</bean>

	<!-- scan for mappers and let them be autowired -->
	<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
		<property name="basePackage" value="com.xxx.dao" />
		<property name="sqlSessionFactoryBeanName" value="sqlSessionFactory-source" />
	</bean>

根据配置可以看出SqlSessionFactoryBean配置数据源和mapper的xml文件所在位置，MapperScannerConfigurer用来配置扫描基础目录以及引入SqlSessionFactoryBeanName

下面是mapper.xml的例子

<?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="com.xx.dao.AssetsFlowMapper">

    <resultMap id="assetsFlowMap" type="com.xx.api.bean.zz">
        <result property="debtId" column="debt_id"/>
        <result property="userId" column="user_id"/>
    </resultMap>

    <!-- 插入数据 -->
    <insert id="addAssetsFlow" parameterType="com.bean.AssetsFlow">
        <selectKey resultType="int" order="AFTER"
                   keyProperty="flowId">
            SELECT LAST_INSERT_ID() AS id
        </selectKey>
        INSERT INTO t_uls_assets_flow
        (debt_id,user_id)
        VALUES
        (#{debtId},#{userId})
    </insert>

    <!-- 更新数据 -->
    <update id="updateAssetsFlow" parameterType="com.bean.AssetsFlow">
        UPDATE t_uls_assets_flow
        <set>
            <if test="debtId != null">
                debt_id=#{debtId},
            </if>
            <if test="userId != null">
                user_id=#{userId},
            </if>
        </set>
        WHERE flow_id = #{flowId}
    </update>

    <!-- 搜索条件 -->
    <sql id="selectWhere">
        <where>
            <if test="debtId != null">
                AND debt_id=#{debtId}
            </if>
            <if test="userId != null">
                AND user_id=#{userId}
            </if>
        </where>
    </sql>

    <!-- 数据总量 -->
    <select id="getxxxCount" resultType="int" parameterType="Map">
        SELECT count(1)
        FROM
        xxxx
        <include refid="selectWhere"></include>
    </select>


</mapper>

接下来就是AssetsFlowMapper接口写上相应的方法，使用@Repository注入即可使用

当然基本的注解扫描，组件扫描必不可少

<context:component-scan base-package="com.xxx.*"/>