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>