SSM第一个项目

记录一下

框架如下：

思路：从下向上写

	数据库------>dao------>service------->controller------->view

DAO层（BookMapper接口）

package com.ssm.dao;

import com.ssm.model.Book;
import org.apache.ibatis.annotations.Param;


import java.util.List;

public interface BookMapper  {


//    添加方法 增删改查

    int addBook(Book book);

    int deleteBookById(@Param("book_id")int id);

    int updateBook(Book book);

    Book selectBookById(@Param("book_id")int id);

    List<Book> BookList();

    Book queryBookByname(String name);

}

Service层

service接口

package com.ssm.service;

import com.ssm.model.Book;

import java.util.List;

public interface BookService {

    int addBook(Book book);

    int deleteBookById(int id);

    int updateBook(Book book);

    Book selectBookById(int id);

    List<Book> BookList();

    Book queryBookByname(String name);

}

service代理类

package com.ssm.service;

import com.ssm.dao.BookMapper;
import com.ssm.model.Book;
import org.mybatis.spring.support.SqlSessionDaoSupport;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;

//@Service
public class BookServiceImpl implements BookService {


//    调用dao层
    private BookMapper bookMapper;

    public BookMapper getBookMapper() {
        return bookMapper;
    }

    public void setBookMapper(BookMapper bookMapper) {
        this.bookMapper = bookMapper;
    }

    public int addBook(Book book) {
        return bookMapper.addBook(book);
    }

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

    public int updateBook(Book book) {
        return bookMapper.updateBook(book);
    }

    public Book selectBookById(int id) {
        return bookMapper.selectBookById(id);
    }

    public List<Book> BookList() {
        return bookMapper.BookList();
    }

    public Book queryBookByname(String name) {
        return bookMapper.queryBookByname(name);
    }

}

Controller层

package com.ssm.controller;


import com.ssm.model.Book;
import com.ssm.service.BookService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.stereotype.Controller;
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;

@Controller
@RequestMapping("/book")
public class BookControllerImpl {


//    调用service层业务层
    @Autowired
    @Qualifier("bookServiceImpl")
    private BookService bookService;

//查询所有的书籍并展示到页面中
    @RequestMapping("/allbook")
    public String list(Model model){

        List<Book> list=bookService.BookList();

        model.addAttribute("list",list);

        return "allbook";
    }

//    查询指定id的书籍
    @RequestMapping("/ByIdBook")
    public String selectBookById(Model model){

        Book book = bookService.selectBookById(1000);

        model.addAttribute("book",book);

        return "ByIdBook";
    }

//    跳转新增书籍页面
    @RequestMapping("/addPager")
    public String addPager(){

        return "addbook";
    }

    @RequestMapping("/addbook")
    public String addBook(Book book){
        System.out.println(book);
        bookService.addBook(book);
        return "redirect:/book/allbook";
    }

//跳转到修改界面
    @RequestMapping("/updatePager")
    public String updatePager(int id,Model model){

        Book book = bookService.selectBookById(id);
        model.addAttribute("SIDbook",book);
        return "updatebook";
    }

    @RequestMapping("updatebook")
    public String updatebook(Book book){

        System.out.println(book);
        bookService.updateBook(book);
        return "redirect:/book/allbook";
    }


    @RequestMapping("/detelebook/{book_id}")
    public String deletebook(@PathVariable("book_id") int id){

        bookService.deleteBookById(id);

        return "redirect:/book/allbook";

    }

//    查询书籍
    @RequestMapping("/selectBook")
    public String selectBook(String selectBookname,Model model){

        Book book = bookService.queryBookByname(selectBookname);
        //System.out.println(book);
        List<Book> list=new ArrayList<Book>();
        list.add(book);
        //System.out.println(list);
        model.addAttribute("list",list);
        return "allbook";

    }


}

效果如下：

加油，打拼起