应急队伍列表

songhuangfeng123

2022-07-04 bf31de2596425a42f33155ad6161da5ea6b3cbf9

应急队伍列表

 emergency/emergency-service/src/main/java/com/gkhy/safePlatform/emergency/query/EmergencyTeamQuery.java

@@ -2,4 +2,31 @@

public class EmergencyTeamQuery {

    private String team_name ;

    private String team_level ;

    public String getTeam_name() {
        return team_name;
    }

    public void setTeam_name(String team_name) {
        this.team_name = team_name;
    }

    public String getTeam_level() {
        return team_level;
    }

    public void setTeam_level(String team_level) {
        this.team_level = team_level;
    }

    @Override
    public String toString() {
        return "EmergencyTeamDBQuery{" +
                "team_name='" + team_name + '\'' +
                ", team_level='" + team_level + '\'' +
                '}';
    }
}

 emergency/emergency-service/src/main/java/com/gkhy/safePlatform/emergency/query/db/EmergencyTeamDBQuery.java

@@ -2,4 +2,31 @@

public class EmergencyTeamDBQuery {

    private String team_name ;

    private String team_level ;

    public String getTeam_name() {
        return team_name;
    }

    public void setTeam_name(String team_name) {
        this.team_name = team_name;
    }

    public String getTeam_level() {
        return team_level;
    }

    public void setTeam_level(String team_level) {
        this.team_level = team_level;
    }

    @Override
    public String toString() {
        return "EmergencyTeamDBQuery{" +
                "team_name='" + team_name + '\'' +
                ", team_level='" + team_level + '\'' +
                '}';
    }
}

 emergency/emergency-service/src/main/java/com/gkhy/safePlatform/emergency/repository/EmergencyTeamInfoRepository.java

@@ -12,5 +12,7 @@

@Repository
public interface EmergencyTeamInfoRepository extends BaseMapper<EmergencyTeamInfo> {

    List<EmergencyTeamInfoPageDO> selectEmergencyTeamList(Page<EmergencyTeamInfoPageDO> page, @Param("query") EmergencyTeamDBQuery emergencyTeamDBQuery);

}

 emergency/emergency-service/src/main/resource/config/mapper/emergency/EmergencyTeamInfoMapper.xml

对比新文件
@@ -0,0 +1,21 @@
<?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.gkhy.safePlatform.emergency.repository.EmergencyTeamInfoRepository">

    <resultMap type="com.gkhy.safePlatform.emergency.entity.EmergencyTeamInfoPageDO" id="pageResult">
        <id column="id" property="id" jdbcType="BIGINT"/>
        <result column="team_level" property="teamLevel" />
        <result column="team_name" property="teamName" />
        <result column="principal_phone" property="principalPhone" />
        <result column="team_desc" property="teamDesc" />
    </resultMap>

    <select id="selectEmergencyTeamList" resultMap="pageResult">
        select id,`team_level`,`team_name`,`principal_phone`,`team_desc` from emergency_team where del_flag = 0
        <if test="query.teamName != null  and query.teamName != ''"> and `team_name` like concat('%', #{query.teamName}, '%')</if>
        <if test="query.teamLevel != null  and query.teamLevel != ''"> and `team_level` = #{query.teamLevel}</if>
    </select>

</mapper>