build/classes/config/mybatis/mapper/admin/FacilityMapper.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.ischoolbar.programmer.dao.admin.FacilityDao">
	<!-- 公共设施插入操作 -->
	<insert id="add" parameterType="com.ischoolbar.programmer.entity.admin.Facility">
		insert into facility(fac_id,fac_name,fac_count,startTime,status) 
		values(null,#{fac_name},#{fac_count},#{startTime},#{status})
	</insert>
	<!-- 公共设施编辑操作 -->
	<update id="edit" parameterType="com.ischoolbar.programmer.entity.admin.Facility">
		update facility set fac_name=#{fac_name},fac_count=#{fac_count},startTime=#{startTime},status=#{status} 
		where fac_id = #{fac_id}
	</update>
	<!-- 公共设施信息搜索查询 -->
	<select id="findList" parameterType="Map" resultType="com.ischoolbar.programmer.entity.admin.Facility">
		select * from facility where 1=1 
		<if test="fac_name != null">
			and fac_name like '%${fac_name}%' 
		</if>
		<if test="status != null">
			and status = #{status} 
		</if>
		<if test="offset != null and pageSize != null">
			limit #{offset},#{pageSize}
		</if>
	</select>
	<!-- 获取所有公共设施 -->
	<select id="findAll" parameterType="Map" resultType="com.ischoolbar.programmer.entity.admin.Facility">
		select * from facility 
		<if test="offset != null and pageSize != null">
			limit #{offset},#{pageSize}
		</if>
	</select>
	<!-- 模糊搜索总条数 -->
	<select id="getTotal" parameterType="Map" resultType="Integer">
		select count(*) from facility where 1=1 
		<if test="fac_name != null">
			and fac_name like '%${fac_name}%' 
		</if>
		<if test="status != null">
			and status = #{status} 
		</if>
	</select>
	<!-- 删除公共设施信息 -->
	<delete id="delete" parameterType="Long">
		delete from facility where fac_id = ${value}
	</delete>
</mapper>