SSM整合案例-书籍管理

1.功能接受及页面效果展示

这是SSM整合的案例，可以对书籍进行增删改查的管理，优化了分页查询和模糊查询，配置拦截器对未登陆的用户进行拦截转到登录页面。前端的代码在我的个人博客中(点击进入)

1.1欢迎页

1.2 登录页

1.3 书籍展示页

1.4 新增书籍表单页

1.5 修改书籍表单页

2.dao层

目录结构:

BookMapper

import com.lysong.pojo.Books;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;

import java.util.List;

public interface BookMapper {
   
    //增加一本书
    int addBook(Books books);

    //删除一本书
    int deleteBookById(int id);

    //更新一本书
    int updateBook(Books books);

    //查询一本书
    Books queryBookById(int id);

    //查询全部的书
    List<Books> queryAllBook(@Param(value = "curPage")int curPage,@Param(value = "pageSize")int pageSize);

    //根据书名查书
    List<Books> queryBookByName(@Param(value = "bookName")String bookName,@Param(value = "curPage")int curPage,@Param(value = "pageSize")int pageSize);

    //查询总数
    int queryBookCount();

    //查询书名的总数
    int queryBookCountByName(@Param(value = "bookName")String bookName);



}

BookMapper.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.lysong.dao.BookMapper">
    <insert id="addBook" parameterType="Books">
        insert into ssmbuild.books(bookName, bookCounts, detail)
        values (#{bookName},#{bookCounts},#{detail});
    </insert>

    <delete id="deleteBookById" parameterType="int">
        delete from ssmbuild.books where bookID = #{bookID}
    </delete>

    <update id="updateBook" parameterType="Books">
        update ssmbuild.books set bookName=#{bookName},bookCounts=#{bookCounts},detail=#{detail}
        where bookID = #{bookID}
    </update>
    
    <select id="queryBookById" resultType="Books">
        select * from ssmbuild.books
        where bookID=#{bookID}
    </select>
    <select id="queryBookCount"  resultType="int">
        select count(*) from ssmbuild.books;
    </select>

    <select id="queryAllBook" resultType="Books">
        select * from ssmbuild.books limit #{curPage},#{pageSize};
    </select>

    <select id="queryBookByName"  resultType="Books">
        select * from ssmbuild.books
        <where>
            <if test