springmvc 多条件参数查询
jsp视图部分
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@page import="java.security.MessageDigest"%>
<c:set var="ctx" value="${pageContext.request.contextPath}" /> //获取项目根目录地址
<%@ taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt"%> //声明调用
//根据店铺名称或者所在机构查询 jquery部分
$('#btnSearch',navTab.getCurrentPanel()).click(function() { //navTab.getCurrentPanel() 表示取当前web下的ID
var psize = $("#nowPageSize",navTab.getCurrentPanel()).val();
var Searchinstid = $("#Searchinstid",navTab.getCurrentPanel()).val(); //获取查询的值
var Searchname = $("#Searchname",navTab.getCurrentPanel()).val();
if(Searchname == ""){
Searchname = "all";
}
Searchname = encodeURIComponent(encodeURIComponent(Searchname)); //编码 避免中文乱码问题
navTab.openTab("beauty", "${ctx}/beauty/Search/"+Searchname+"/"+Searchinstid, { title:"美容店管理", fresh:true, data:{page:1,rows:psize} });
}); //url传递参数
//查询字段部分
<div class="pageHeader">
<div class="searchBar">
<ul class="searchContent">
<li style="width:240px">
<label style="width:40px">名称：</label>
<input type="text" name="Searchname" id="Searchname" placeholder="请输入美容店名称" value="${Searchshopname }" /> //value="${Searchshopname }"接收后台的回写查询数据
</li>
<li>
<label style="width:60px">所在机构：</label>
<select style="height:22px" name="Searchinstid" id="Searchinstid" >
<c:forEach items="${insts }" var="shop">
<option value="${shop.id }" <c:if test="${shop.id==Searchinstitutionid}">selected </c:if>>${shop.institutionname }</option>//判断当前选项并保留
</c:forEach>
</select>
</li>
<li style="margin-left: -100px;"><button type="button" style="margin-right: 5px;" target="ajaxTodo" id="btnSearch" name="btnSearch">查询</button></li>
</ul>
</div>
</div>
-------------------------------------------------------------------------------------------------------------------------------------------------------
Controller控制器部分
//分页查询
@RequestMapping(value="/Search/{Searchname}/{Searchinstid}", method = RequestMethod.GET) // get方式传递接收地址参数
public String Search(
@RequestParam(required = false, defaultValue = "1") int page,
@RequestParam(required = false, defaultValue = "20") int rows,
@PathVariable("Searchname") String shopname, //获取传递的参数值
@PathVariable("Searchinstid") Integer institutionid,
HttpServletRequest request, Model model){
try {
shopname = URLDecoder.decode(shopname, "UTF-8"); //解码过程 避免中文乱码
} catch (Exception ex) {
}
if (shopname.equals("all")) { // 为空用all做中间转换
shopname = "";
}
PageHelper.startPage(page, rows);
List<BtyShop> list = btyshopService.SearchSearch(shopname,institutionid); //调用Service传参查询
request.setAttribute("pageInfo", new PageInfo<BtyShop>(list));
List<Inst> insts = instService.getAll();
request.setAttribute("insts", insts);
request.setAttribute("shoplist", list);
// 回写查询数据
model.addAttribute("Searchshopname", shopname);
model.addAttribute("Searchinstitutionid", institutionid);
return "basic/Beautyshop";
}
---------------------------------------------------------------------------------------------------------------------------------------------------
Service部分
public List<BtyShop> SearchSearch(String shopname, Integer institutionid) { //传递参数查询
Map<String,Object> param = new HashMap();
param.put("shopname", shopname);
param.put("institutionid", institutionid); //往集合中添加键值对
List<BtyShop> BtyShop=btyShopMapper.SearchSearch(param); //调用Mappper的方法查询，由于Mapper只能传一个参数，将多个参数转换为Map集合
return BtyShop;
}
-------------------------------------------------------------------------------------------------------------------------------------------------------
Mapper.java部分
List<BtyShop> SearchSearch(Map<String, Object> param); //只有一个方法跳转执行sql语句
-------------------------------------------------------------------------------------------------------------------------------------------------------
Mapper.xml部分 //配置sql语句
<select id="SearchSearch" resultMap="BaseResultMap" parameterType="java.util.Map" > //类型为map
select
<include refid="Base_Column_List" />
,(select b.institutionname from t_inst b where
s.institutionId=b.id)institutionname
from t_bty_shop s where status=1
<if test="institutionid!=null and institutionid!=''"> //判空即为不执行
<![CDATA[ AND institutionId =#{institutionid} ]]>
</if>
<if test="shopname!=null and shopname!=''">
<![CDATA[ AND shopName like CONCAT(CONCAT('%', #{shopname}),'%') ]]> //springmvc变量模糊查询写法
</if>
</select>
