src/main/resources/mappers/SecurityMapper.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.SecurityDao">
	<resultMap type="Security" id="SecurityResult">
		<result property="id" column="id" />
		<result property="userid" column="userid" />
		<result property="securityname" column="securityname" />
		<result property="securitypassward" column="securitypassward" />
		<result property="company" column="company" />
		<result property="dataid" column="dataid" />
		<result property="starttime" column="starttime" />
		<result property="endtime" column="endtime" />
		<result property="createtime" column="createtime" />
		<result property="updatetime" column="updatetime" />
	</resultMap>
	<select id="findSecurity" parameterType="Map" resultMap="SecurityResult">
		select * from t_security a,t_datadic b,t_user c,t_user_role d
		<where>
			a.dataid=b.id and a.userid=c.id and a.userid=d.userid
			<if test="username!=null and username!='' ">
				and c.username like #{username}
			</if>
			<if test="company!=null and company!='' ">
				and a.company like #{company}
			</if>
			<if test="dataid!=null and dataid!='' ">
				and a.dataid like #{dataid}
			</if>
			<if test="searchStarttime!=null and searchStarttime!='' ">
				and a.starttime&gt;=#{searchStarttime}
			</if>
			<if test="searchEndtime!=null and searchEndtime!='' ">
				and a.endtime&lt;=#{searchEndtime}
			</if>
			<if test="userid!=null and roleid!=1">
				and a.userid=#{userid}
			</if>
		</where>
		<if test="start!=null and size!=null">
			limit #{start},#{size}
		</if>
	</select>

	<select id="getTotalSecurity" parameterType="Map" resultType="Long">
		select count(*) from t_security a,t_datadic b,t_user c,t_user_role d
		<where>
			a.dataid=b.id and a.userid=c.id and a.userid=d.userid
			<if test="username!=null and username!='' ">
				and c.username like #{username}
			</if>
			<if test="company!=null and company!='' ">
				and a.company like #{company}
			</if>
			<if test="dataid!=null and dataid!='' ">
				and a.dataid like #{dataid}
			</if>
			<if test="searchStarttime!=null and searchStarttime!='' ">
				and a.starttime&gt;=#{searchStarttime}