Mybatis实现图书管理模糊查询

技术概要：mybatis、单例、jsp、mysql…

创建图书实体类Book

创建dao层接口，接口中创建查询全部图书和根据条件查询的方法

public interface BookMapper {
   
    List<Book> getBookList(Book book);
    List<Book> queryBook(Book book);
}

通过xml文件映射，实现数据库中数据的查询

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="cn.kgc.kb07.dao.BookMapper">
    <select id="getBookList" resultType="book" parameterType="book">
        select * from book;
    </select>
    <select id="queryBook" resultType="book" parameterType="book">
        SELECT o.*,b.book_name,u.user_name,bt.type_name FROM book b JOIN booktype bt ON b.book_type=bt.type_id
   JOIN outbook o ON o.`book_id`=b.`book_id` JOIN `user` u ON u.`user_id`=o.`uid`
   <where>
        <if test="book_name!=null and book_name!=''">
            and book_name like cancat("%",#{
   book_name},"%")
        </if>
        <if test="user_name!=null and user_name!=''">
            and user_name like cancat("%",#{
   user_name},"%")
        </if>
        <if test="user_name!=null and user_name!=''">
            and type_name like cancat("%",#{
   type_name},"%")
        </if>
    </where>
    </select>
</mapper>

创建service层接口，并建立对应的方法

public interface BookService {
   
    List<Book> getBookList(Book book);
    List<Book> queryBook(Book book);
}

创建service接口的实现类，完成各种判断并返回所需的结果集

public class BookServiceImpl implements BookService {
   
    private SqlSession session;
    public BookServiceImpl() {
   
        session= MapperConfig.getSession();
    }
    @Override
    public List<Book> getBookList(Book book) {
   
        List<Book> bookList=session.getMapper(BookMapper.class).getBookList(book);
        return bookList;
    }

    @Override
    public List<Book> queryBook(Book book) {
   
        List<Book> bookList=session.getMapper(BookMapper.class).queryBook(book