2017-02-22

一、实现色系管理模糊查询

1.color.html

<div class="page-container">
<div class="cl pd-5 bg-1 bk-gray"> <span class="l"><a href="javascript:;" onclick="_add()" class="btn btn-primary radius"><i class="Hui-iconfont">&#xe600;</i> 添加色系管理</a></span> <span class="r" style="line-height:31px;">共有数据：<strong>${totalrow}</strong> 条</span>
<span class="l ml-10" style="width: 170px">
<input type="text" class="input-text" placeholder="输入色系查询" value="${fcolor!}" id="fcolor" maxlength="20">
</span>
<input class="btn btn-primary ml-10" type="submit" value="查找" onclick="color_search()">
</div>

function color_search(){
fcolor = encodeURI($.trim($('#fcolor').val()));
if($.trim($('#fcolor').val())!=''){
var reg = /^[a-zA-Z0-9_\u0391-\uFFE5 ]{1,30}$/;
if(!reg.test($('#fcolor').val())){
layer.tips('不允许有特殊字符，最多20个字符', '#fcolor', {tips: [1, '#34495E']});return;
}
}
location.replace('/manage/iframe/product/color/1-' + fcolor );
}

2ManageProductCtrl.java

/*********************色系管理*********************/
//管理色系
public void color(){
Integer pageno = getParaToInt(0)==null?1:getParaToInt(0);
String fcolor = getPara(1);
try {
fcolor = URLDecoder.decode(fcolor==null?"":fcolor, "utf-8");
} catch (UnsupportedEncodingException e) {
e.printStackTrace();
}
Page<Record> page = MCDao.getColor(pageno, 16, fcolor);
setAttr("fcolor", fcolor);
setAttr("pageno", page.getPageNumber());
setAttr("totalpage", page.getTotalPage());
setAttr("totalrow", page.getTotalRow());
setAttr("colorlist", page.getList());
render("color.html");

}

3.MCDao.java

//获得色系列表
public static Page<Record> getColor(int pageno, int pagesize, String fcolor){
String sqlExceptSelect = " from f_color a where 1=1";
if(fcolor != ""){
sqlExceptSelect += " and a.name like '%"+ fcolor +"%'";
}
return Db.paginate(pageno, pagesize, "select id,name,jh", sqlExceptSelect);
}

二