DAY17 springMVC图书管理系统源码

package com.rzgsl.controller;

import com.rzgsl.pojo.Books;
import com.rzgsl.service.BookService;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestMapping;

import java.util.ArrayList;
import java.util.List;
//这里可以用注解，也可以xml配bean，配bean必须有set方法
//@Controller
@RequestMapping("/book")
public class BookController {

// @Autowired
// @Qualifier(“BookServiceImpl”)//一个接口有多个实现类，用@合格者 注解指定装载的Bean
private BookService bookService;
public void setBookService(BookService bookService) {
this.bookService = bookService;
}

//查询全部的书，返回到展示页面
@RequestMapping("/allBook")
public String list(Model model){
    List<Books> list = bookService.queryAllBook();
    model.addAttribute("list",list);
    return "allBook";
}
//跳转到增加书籍
@RequestMapping("/toAddBook")
public String toAddPaper(){
    return "addBook";
}
//添加书籍的请求
@RequestMapping("/addBook")
public String addBook(Books books){
    System.out.println("addBook"+books);
    bookService.addBook(books);
    return "redirect:/book/allBook";
}
//跳转到修改页面
@RequestMapping("/toUpdate")
public String toUpdatePaper(int id,Model model){
    Books books = bookService.queryBookById(id);
    model.addAttribute("Qbooks",books);
    return "updateBook";
}
//修改书籍的请求
@RequestMapping("/updateBook")
public String updatePaper(Books books){
    System.out.println("updateBook"+books);
    int i = bookService.updateBook(books);
    return "redirect:/book/allBook";
}
//删除书籍
//    Restful风格
@RequestMapping("toDelete/{bookN}")
public String toDelete(@PathVariable("bookN") int id){
    int i = bookService.deleteBookById(id);
    return "redirect:/book/allBook";
}
//按书名查询书籍
//list传参，前端forEach
@RequestMapping("/queryBook")
public String queryBook(String queryBookName,Model model){
    Books books = bookService.queryBookByName(queryBookName);
    //左边要用List，不能用ArrayList，否则if语句中的list会报错
    List<Books> list = new ArrayList<>();
    list.add(books);
    if(books==null){
        list = bookService.queryAllBook();

// 用erro，前端用erro接收，不成功，必须得用error
model.addAttribute(“error”,“Null”);
}
model.addAttribute(“list”,list);
return “allBook”;

}

}

package com.rzgsl.dao;

import com.rzgsl.pojo.Books;
import org.apache.ibatis.annotations.Param;

import java.util.List;

public interface BookMapper {
//Mapper接口负责参数绑定
// 增加一本书
int addBook(Books books);
// 删除一本书
int deleteBookById(@Param(“bookID”)int id);
// 修改一本书
int updateBook(Books books);
// 查询一本书
Books queryBookById(@Param(“bookID”) int id);
// 查询所有的书
List queryAllBook();
//通过书名查询
Books queryBookByName(@Param(“BookName”) String queryBookName);
}

<?xml version="1.0" encoding="UTF-8" ?>

<!--增加一个Book-->
<insert id="addBook" parameterType="com.rzgsl.pojo.Books">
  insert into ssmbuild.books(bookName,bookCounts,detail)
  values (#{bookName}, #{bookCounts}, #{detail})

<!--根据id删除一个Book-->
<delete id="deleteBookById" parameterType="int">
  delete from ssmbuild.books where bookID=#{bookID}

<!--更新Book-->
<update id="updateBook" parameterType="com.rzgsl.pojo.Books">
  update ssmbuild.books
  set bookName = #{bookName},bookCounts = #{bookCounts},detail = #{detail}
  where bookID = #{bookID}

<!--根据id查询,返回一个Book-->
<select id="queryBookById" resultType="com.rzgsl.pojo.Books">
  select * from ssmbuild.books
  where bookID = #{bookID}

<!--查询全部Book-->
<select id="queryAllBook" resultType="com.rzgsl.pojo.Books">
  SELECT * from ssmbuild.books

<select id="queryBookByName" resultType="Books">
    select * from ssmbuild.books
  where bookName = #{BookName}
</select>

package com.rzgsl.pojo;

import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;

@Data
@AllArgsConstructor
@NoArgsConstructor
public class Books {
private int bookID;
private String bookName;
private int bookCounts;
private String detail;
}

package com.rzgsl.service;

import com.rzgsl.pojo.Books;
import org.springframework.stereotype.Service;

import java.util.List;

public interface BookService {
// 增加一本书
int addBook(Books books);
// 删除一本书
int deleteBookById(int id);
// 修改一本书
int updateBook(Books books);
// 查询一本书
Books queryBookById(int id);
// 查询所有的书
List queryAllBook();
// 通过书名查询
Books queryBookByName (String queryBookName);
}

package com.rzgsl.service;

import com.rzgsl.dao.BookMapper;
import com.rzgsl.pojo.Books;

import java.util.List;

public class BookServiceImpl implements BookService {

//service调dao层
private BookMapper bookMapper;
public void setBookMapper(BookMapper bookMapper){
    this.bookMapper = bookMapper;
}
@Override
public int addBook(Books books) {
    return bookMapper.addBook(books);
}

@Override
public int deleteBookById(int id) {
    return bookMapper.deleteBookById(id);
}

@Override
public int updateBook(Books books) {
    return bookMapper.updateBook(books);
}

@Override
public Books queryBookById(int id) {
    return bookMapper.queryBookById(id);
}

@Override
public List<Books> queryAllBook()