20200911

xiaoyong931011

2020-09-11 070ded4549fc048fd5d2622326d558878f607aa2

20200911

 src/main/resources/mapper/helpCenter/HelpCenterNoticeDao.xml

New file
@@ -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>

 src/main/resources/mapper/helpCenter/HelpCenterTypeDao.xml

New file
@@ -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>