mysql 粗略条件查询_springboot mysql多条件查询实现功能

js：获取页面输入的值

/**

查询信息

*/

$("#button_selectJjTaizhang").click(function(){

var testInput=$("#input_title").val(); //实习生姓名

var testInputTwo=$("#input_titleTwo").val(); //客户意向/业态

var testInputThree=$("#input_titlethree").val();//客户电话

var a1=testInput == '' || testInput == undefined || testInput == null;

var a2=testInputThree == '' || testInputThree == undefined || testInputThree == null;

if (a1 && a2) {

layer.msg("请输入实习生姓名或者 客户电话 进行查询！",{icon:1});

} else {

$("#list_showjjtaizhang").bootstrapTable('refresh',{url:"findJjTaizhang",query:{testInput:testInput,testInputTwo:testInputTwo,testInputThree:testInputThree}});

}

});

2、后端接口：jiangjinTaizhangService

//查询(模糊查询：kehephone，student)

public ListfindJjTaizhang(String testInput,String testInputTwo,String testInputThree);

3、实现方法：jiangjinTaizhangServiceImpl

[email protected]

public ListfindJjTaizhang(String testInput,String testInputTwo,String testInputThree) {

return jm.selectJjTaizhangUrl("%" + testInput+ "%" , "%"+ testInputTwo +"%","%"+ testInputThree+"%");

}

4、整合Mybaitis，Mapper接口：jiangjinTaizhangMapper

@Mapper

public interface jiangjinTaizhangMapper extends MyMapper{

ListselectJjTaizhangUrl(@Param("student") String student,

@Param("kehuyixiang") String kehuyixiang,@Param("kehuphone") String kehuphone);

}

5、controller：jiangjinTaizhangController

@RequestMapping("/findJjTaizhang")

@ResponseBody

public ListfindJjTaizhang(HttpServletRequest request) {

String testInput=request.getParameter("testInput");

String testInputTwo=request.getParameter("testInputTwo");

String testInputThree=request.getParameter("testInputThree");

logger.info("selectJjTaizhangUrl===="+testInput);

System.out.println("测试获取的值："+testInput+","+testInputTwo+","+testInputThree);

return jjtz.findJjTaizhang(testInput,testInputTwo,testInputThree);

}

6、封装sql语句：jiangjinTaizhangMapper.xml

select * from jiangjin_taizhang

student like #{student}

and kehuyixiang like #{kehuyixiang}

and kehuphone like #{kehuphone}

以上代码都以贡献，有疑问在群提出→_→

版权所有 IT知识库 CopyRight © 2009-2015 IT知识库 IT610.com , All Rights Reserved.

京ICP备09083238号