Mybatis多条模糊查询(Like)及分页详细代码

最新推荐文章于 2024-08-10 16:15:08 发布

一程序一世界

最新推荐文章于 2024-08-10 16:15:08 发布

阅读量1.9k

点赞数 1

分类专栏： java 文章标签： java 框架 mybatis

本文链接：https://blog.csdn.net/Hello_word_2/article/details/82764314

版权

java 专栏收录该内容

12 篇文章 0 订阅

订阅专栏

话不多说代码呈上:

映射代码

<select id="selectLike" parameterType="hashmap"  resultType="com.dhw.vo.TRepoReditList">
select * from t_repo_redit_list 
<where>  
<if test="map.reportName!=''">and ReporterName like '%${map.reportName}%'</if>
<if test="map.mediumName!=''">and MediumName like '%${map.mediumName}%'</if>
</where> limit #{map1.page},#{map1.size}
</select>
 <select id="selectLikeSum"   resultType="int">
select count(*) from t_repo_redit_list 
 <where>  
<if test="reportName!=''">ReporterName like '%${reportName}%'</if>
<if test="mediumName!=''">and MediumName like '%${mediumName}%'</if>
</where> 
</select>

dao层代码:

public List<TRepoReditList> selectLike(@Param("map1")Map<String,Integer> map1,@Param("map")Map<String,String> map);
public int selectLikeSum(Map<String,String> m);

service层代码:

public List<TRepoReditList> selectLike(Map<String,Integer> map1,Map<String,String> map){
		return treporeditDao.selectLike(map1,map);
	}
	public int selectLikeSum(Map<String,String> m){
		return treporeditDao.selectLikeSum(m);
	}

controller层代码:

@RequestMapping("LikeReporter.do")
	public String selectLike(Model m,@RequestParam(defaultValue="1",required=false,value="page")Integer page,String name,String media ){
		Map<String,String> map= new HashMap<String, String>();
		map.put("reportName", name);
		map.put("mediumName", media);
		int sum=treporeditService.selectLikeSum(map);
		sum=sum%12==0?sum/12:sum/12+1;
		Map<String,Integer> map1= new HashMap<String, Integer>();
		map1.put("page",(page-1)*12);
		map1.put("size",12);
		m.addAttribute("repoReditList", treporeditService.selectLike(map1,map));
		m.addAttribute("nowpage", page);
		m.addAttribute("sum", sum);
		return "/WEB-INF/pages/files/listReporter.jsp";
	}

jsp略!!