springboot mysql多条件查询实现功能

一晃本咸鱼好多年没有写码了，今天写个丢人的多条件 查询吧，

别人家的查询：

自己家的查询只有一个项，太简陋了，

于是粗略改了一下；

分析需求：加入客户电话，客户意向，一起去查询；

 

1、页面：bootstrap+jquery+layui

   <div class="panel-body" style="padding:5px;margin-top: -20px;">
        
        <div class="pull-left search" style="margin-left: 10px">
      			
<div class="row">
	  <div class="col-xs-4" style="padding: 10px;">客户电话：</div>
	  <div class="col-xs-4">
	  	<input class="form-control" id="input_titlethree" style="display:inline;width: 220px;" placeholder="请输入客户电话查询" type="text"/>
	  </div>
</div>

<div class="row">  
	  <div class="col-xs-4" style="padding: 10px;">学生名：</div>
	  <div class="col-xs-5">
	  	<input class="form-control" id="input_title" style="display:inline;width: 220px;" placeholder="请输入实习生名查询" type="text"/>
	  </div>
</div>

<div class="row">  
	  <div class="col-xs-4" style="padding: 10px;">客户意向：</div>
	  <div class="col-xs-5">
	  	<input class="form-control" id="input_titleTwo" style="display:inline;width: 220px;" placeholder="请输入客户意向查询" type="text"/>
	  </div>
</div>  

<div class="row"> 
	  <div class="col-xs-4">
		   <button id="button_selectJjTaizhang" style="margin-top: 10px;" class="btn btn-primary">查询</button>
	  </div>
	   <div class="col-xs-8" style="padding: 15px;margin-left:-30px;">
		<span style="color: #666666;font-size: 16px;">(台账更新至3.17号)</span>
	  </div>
</div>  
           
</div>

<table .....</table>

</div>

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 List<jiangjinTaizhang> findJjTaizhang(String testInput,String testInputTwo,String testInputThree);

3、实现方法：jiangjinTaizhangServiceImpl

    @Override
    public List<jiangjinTaizhang> findJjTaizhang(String testInput,String testInputTwo,String testInputThree) {
        return jm.selectJjTaizhangUrl("%" + testInput+ "%" , "%"+ testInputTwo +"%","%"+ testInputThree+"%");
    }
    

4、整合Mybaitis，Mapper接口：jiangjinTaizhangMapper

@Mapper
public interface jiangjinTaizhangMapper extends MyMapper<jiangjinTaizhang>{
	
    List<jiangjinTaizhang> selectJjTaizhangUrl(@Param("student") String student,
    		@Param("kehuyixiang") String kehuyixiang,@Param("kehuphone") String kehuphone);
}

5、controller：jiangjinTaizhangController

    @RequestMapping("/findJjTaizhang")
    @ResponseBody
    public List<jiangjinTaizhang> findJjTaizhang(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  id="selectJjTaizhangUrl"  resultMap="BaseResultMap" >
        select * from jiangjin_taizhang
        <where>
            <if test="student!=null"> student like  #{student} </if>
            <if test="kehuyixiang!=null"> and kehuyixiang like #{kehuyixiang}</if>
            <if test="kehuphone!=null"> and kehuphone like #{kehuphone}</if>
            
        </where>
    </select>

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