mybatis处理模糊查询

最近在用SSM+maven做一个项目，项目里面有个搜索功能，现在把mybatis处理模糊查询的过程分享一下。

searchCondition.java

package com.cd.bean;
/**
 * 搜索条件
 *@Author zhk
 *@Date 2018-2-5
 **/
public class SearchCondition {

    String keyword;//搜索关键词
    News news;//news对象
    Science science;

public SearchCondition() {
super();
    }
public String getKeyword() {
return keyword;
    }
public void setKeyword(String keyword) {
this.keyword = keyword;
    }
public News getNews() {
return news;
    }
public void setNews(News news) {
this.news = news;
    }
public Science getScience() {
return science;
    }
public void setScience(Science science) {
this.science = science;
    }   
}

SearchMapper.java

package com.cd.dao;

import java.util.List;

import com.cd.bean.News;
import com.cd.bean.SearchCondition;

/**
 * 搜索功能接口
 *@Author zhk
 *@Date 2018-2-4
 **/
public interface SearchMapper {

/**
 * 搜索
 * @param keyword
 * @return
 */
public List<SearchCondition> search(SearchCondition searchCondition);
}

SearchMapper.xml

 <!-- 设置映射 -->
<resultMap type="com.cd.bean.News" id="newsMap">
<id property="NEWS_ID" column="NEWS_ID"/>
<result property="NEWS_TITLE" column="NEWS_TITLE"/>
<result property="NEWS_CONTENT" column="NEWS_CONTENT"/>
<result property="NEWS_IMG" column="NEWS_IMG"/>
<result property="PUBLISH_DATE" column="PUBLISH_DATE"/>
<result property="NEWS_LEVEL" column="NEWS_LEVEL"/> 
</resultMap>
<!--searchCondition是个实体类，它封装了news对象-->
<select id="search" parameterType="searchCondition" resultMap="newsMap">
       select 
<include refid="Field"/>
        from 
<include refid="tableName"/>
<where> 
<if test="keyword != null and keyword != ''">
              NEWS_TITLE like CONCAT('%', #{keyword}, '%') 
</if>    
</where>     
</select>

SearchService.java

package com.cd.service.search.impl;
import java.util.List;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import com.cd.bean.News;
import com.cd.bean.SearchCondition;
import com.cd.dao.SearchMapper;
import com.cd.service.search.SearchService;

/**
 * 搜索功能
 *@Author zhk
 *@Date 2018-2-5
 **/
@Service("searchService")
public class SearchServiceImpl implements SearchService{

@Autowired
    SearchMapper searchMapper;

/**
 * 搜素
 */
@Override
public List<SearchCondition> search(SearchCondition searchCondition) throws Exception {
return searchMapper.search(searchCondition);
    }   
}

controller:

/**
 * 搜索功能
 * @return
 * @throws Exception
 */
@RequestMapping("/search")
public ModelAndView search(@RequestParam(value = "pn",defaultValue="1")Integer pn,@RequestParam(value="keyword")String keyword) throws Exception {
        ModelAndView mv = new ModelAndView();
        System.out.println("控制层："+keyword);
        SearchCondition sc = new SearchCondition();
        sc.setKeyword(keyword);
        PageHelper.startPage(pn, 15);//开始分页
        List<SearchCondition> list = searchService.search(sc);
if(list.isEmpty()){
            mv.addObject("keyword", keyword);
            mv.setViewName("search_error");
        }else{
            PageInfo page = new PageInfo(list,5);//设置分页信息
            mv.addObject("pageInfo", page);
            mv.setViewName("search_list");
        }
return mv;
    }

很简单哦