src/com/chhj/news/mapper/INewsTypeMapper.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.chhj.news.dao.INewsTypeDao">
	<resultMap type="NewsType" id="newsTypeResultMap">
		<!-- id -->
		<id property="id" column="id" />
		<!-- 创建时间 -->
		<result property="createDate" column="y_create_date" />
		<!-- 更新时间 -->
		<result property="updateDate" column="y_update_date" />
		<!-- 删除状态 -->
		<result property="deteleState" column="y_detele_state" />
		<!-- 操作人 -->
		<result property="operatorId" column="y_operator_id" />
		<!-- 类型名 -->
		<result property="name" column="y_type_name" />
	</resultMap>

	<sql id="allColumnSql">
		id,
		y_create_date,
		y_update_date,
		y_detele_state,
		y_operator_id,
		y_type_name
	</sql>
	
	<!-- 通过类型查询 -->
	<select id="listNewsTypeByPage" resultMap="newsTypeResultMap">
		SELECT <include refid="allColumnSql"/>
		FROM y_news_type
		WHERE y_detele_state = 0
		<if test="name!='' and name != null">
			AND y_type_name like '%${name}%'
		</if>
		ORDER BY y_create_date DESC
	</select>
	<select id="listNewsTypeByPageCount" resultType="int">
		SELECT count(id)
		FROM y_news_type
		WHERE y_detele_state = 0
	</select>
	
	<!-- 查询所有 -->
	<select id="listNewsTypeAll" resultMap="newsTypeResultMap">
		SELECT <include refid="allColumnSql"/>
		FROM y_news_type
		WHERE y_detele_state = 0
		ORDER BY y_create_date DESC
	</select>
	<!-- 查询所有 -->
	<select id="listNewsTypeById" resultMap="newsTypeResultMap">
		SELECT <include refid="allColumnSql"/>
		FROM y_news_type
		WHERE y_detele_state = 0
		AND id = #{id}
		ORDER BY y_create_date DESC
	</select>
	
	<!-- 新增 -->