From 070ded4549fc048fd5d2622326d558878f607aa2 Mon Sep 17 00:00:00 2001 From: xiaoyong931011 <15274802129@163.com> Date: Fri, 11 Sep 2020 16:13:56 +0800 Subject: [PATCH] 20200911 --- src/main/resources/mapper/helpCenter/HelpCenterNoticeDao.xml | 27 +++++++++++++++++++++++++++ src/main/resources/mapper/helpCenter/HelpCenterTypeDao.xml | 14 ++++++++++++++ 2 files changed, 41 insertions(+), 0 deletions(-) diff --git a/src/main/resources/mapper/helpCenter/HelpCenterNoticeDao.xml b/src/main/resources/mapper/helpCenter/HelpCenterNoticeDao.xml new file mode 100644 index 0000000..7b4d364 --- /dev/null +++ b/src/main/resources/mapper/helpCenter/HelpCenterNoticeDao.xml @@ -0,0 +1,27 @@ +<?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.xcong.excoin.modules.helpCenter.dao.HelpCenterNoticeDao"> + + <select id="getNewNoticeList" resultType="com.xcong.excoin.modules.helpCenter.entity.HelpCenterNoticeEntity"> + SELECT + * + FROM + help_center_notice + WHERE + article_notice = 1 + ORDER BY + create_time DESC + </select> + + <select id="getImportantNoticeList" resultType="com.xcong.excoin.modules.helpCenter.entity.HelpCenterNoticeEntity"> + SELECT + * + FROM + help_center_notice + WHERE + article_notice = 2 + ORDER BY + create_time DESC + </select> + +</mapper> \ No newline at end of file diff --git a/src/main/resources/mapper/helpCenter/HelpCenterTypeDao.xml b/src/main/resources/mapper/helpCenter/HelpCenterTypeDao.xml new file mode 100644 index 0000000..a9a7b9e --- /dev/null +++ b/src/main/resources/mapper/helpCenter/HelpCenterTypeDao.xml @@ -0,0 +1,14 @@ +<?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.xcong.excoin.modules.helpCenter.dao.HelpCenterTypeDao"> + + <select id="getNoticeTypeList" resultType="com.xcong.excoin.modules.helpCenter.entity.HelpCenterTypeEntity"> + SELECT + * + FROM + help_center_type + WHERE + status = 1 + </select> + +</mapper> \ No newline at end of file -- Gitblit v1.9.1