src/main/resources/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.finance.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="getDatadicIncome" resultType="Datadic">
 		select * from t_datadic where datadicname="收入类型"
 	</select>
 	<select id="getDatadicPay" resultType="Datadic">
 		select * from t_datadic where datadicname="支出类型"
 	</select>
 	
 	<select id="getDatadicSecurity" resultType="Datadic">
 		select * from t_datadic where datadicname="证券类型"
 	</select>
 	<select id="getDatadicTrade" resultType="Datadic">
 		select * from t_datadic where datadicname="证券流水账类型"
 	</select>
 	
 	<select id="getDatadicname" resultType="Datadic">
 		select distinct(datadicname) from t_datadic
 	</select>
 	
 	<select id="findDatadic" parameterType="Map" resultMap="DatadicResult">
		select * from t_datadic
		<where>
		    <if test="datadicname!=null and datadicname!='' ">
				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="getTotalDatadic" parameterType="Map" resultType="Long">
		select count(*) from t_datadic
		<where>
		    <if test="datadicname!=null and datadicname!='' ">
				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>