build/classes/com/java1234/mappers/DataDicMapper.xml

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

<?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.java1234.dao.DataDicDao">

	<resultMap type="DataDic" id="DataDicResult">
		<result property="id" column="id"/>
		<result property="dataDicName" column="dataDicName"/>
		<result property="dataDicValue" column="dataDicValue"/>
	</resultMap>
	
	<select id="findDataDic" parameterType="Map" resultMap="DataDicResult">
		select * from t_datadic
		<where>
			<if test="dataDicName!=null and dataDicName!='' ">
				and dataDicName = #{dataDicName}
			</if>
			<if test="dataDicValue!=null and dataDicValue!='' ">
			 	and dataDicValue like #{dataDicValue}
			</if>
		</where>
		<if test="start!=null and size!=null">
			limit #{start},#{size}
		</if>
	</select>
	
	<select id="findAllDataDicName" resultMap="DataDicResult">
		SELECT DISTINCT dataDicName FROM t_datadic
	</select>
	
	<select id="getTotalDataDic" parameterType="Map" resultType="Long">
		select count(*) from t_datadic
		<where>
			<if test="dataDicName!=null and dataDicName!='' ">
				and dataDicName = #{dataDicName}
			</if>
			<if test="dataDicValue!=null and dataDicValue!='' ">
			 	and dataDicValue like #{dataDicValue}
			</if>
		</where>
	</select>
	
	<insert id="addDataDic" parameterType="DataDic">
		insert into t_datadic values(null,#{dataDicName},#{dataDicValue})
	</insert>
	
	<update id="updateDataDic" parameterType="DataDic">
		update t_datadic
		<set>
			<if test="dataDicName!=null and dataDicName!='' ">
				dataDicName=#{dataDicName},
			</if>
			<if test="dataDicValue!=null and dataDicValue!='' ">
				dataDicValue=#{dataDicValue},
			</if>
		</set>
		where id=#{id}
	</update>