springMVC之增删改查&@PathVariable注解

一、s pring MVC增删改查&@PathVariable注解

定义方法

package com.zking.ssm.mapper;

import com.zking.ssm.model.Book;
import org.springframework.stereotype.Repository;

import java.util.List;
@Repository
public interface BookMapper {
    List<Book> queryPager(Book book);

    Book querySingleBook(Integer bookId);

    void update(Book book);

    void delete(Integer bookId);

    void insert(Book book);
}

编写sql语句

<?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="com.zking.ssm.mapper.BookMapper" >
    <sql id="baseSql">
      book_id,book_name,book_price
    </sql>
    <insert id="insert">
        insert into tb_book(book_name,book_price)
        values(#{bookName},#{bookPrice})
    </insert>
    <delete id="delete">
        delete from tb_book where book_id=#{bookId}
    </delete>
    <update id="update">
      update tb_book set book_name=#{bookName},book_price=#{bookPrice}
      where book_id=#{bookId}
    </update>
    <select id="queryPager" resultType="com.zking.ssm.model.Book">
        select <include refid="baseSql"/> from tb_book where true
        <if test="null != bookName and '' != bookName">
          and book_name like concat('%',#{bookName},'%')
        </if>
        order by book_id desc
    </select>
    <select id="querySingleBook" resultType="com.zking.ssm.model.Book">
        select <include refid="baseSql"/>
        from tb_book where book_id = #{bookId}
    </select>
</mapper>

控制层

package com.zking.ssm.controller;

import com.zking.ssm.model.Book;
import co