技术概要: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