【SSM 整合项目】图书管理系统(1)

// 根据 id 查询, 返回一个 Book

Books queryBookById(int id);

// 查询全部 Book, 返回 list 集合

List queryAllBook();

}

编写接口对应的 Mapper.xml 文件

---

需要导入 MyBatis 的包；

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

insert into ssmbuild.books(bookName, bookCounts, detail)

values (#{bookName}, #{bookCounts}, #{detail})

delete from ssmbuild.books

where bookID=#{bookId}

update ssmbuild.books

set bookName=#{bookName},

bookCounts=#{bookCounts},

detail=#{detail}

where bookID=#{bookID}

select * from ssmbuild.books

where bookID=#{bookID}

select * from ssmbuild.books

编写 Service 层的接口和实现类

---

BookerService 接口：

package com.yusael.service;

import com.yusael.pojo.Books;

import java.util.List;

public interface BookService {

// 增加一个Book

int addBook(Books books);

// 根据 id 删除一个 Book

int deleteBookById(int id);

// 更新 Book

int updateBook(Books books);

// 根据 id 查询, 返回一个 Book

Books queryBookById(int id);

// 查询全部 Book, 返回 list 集合

List queryAllBook();

}

BookServiceImpl 实现类：

package com.yusael.service;

import com.yusael.dao.BookMapper;

import com.yusael.pojo.Books;

import java.util.List;

public class BookServiceImpl implements BookService {

// 调用dao层的操作, 设置一个set接口, 方便Spring管理

private BookMapper bookMapper;

public BookMapper getBookMapper() {

return bookMapper;

}

public int addBook(Books books) {

return bookMapper.addBook(books);

}

public int deleteBookById(int id) {

return bookMapper.deleteBookById(id);

}

public int updateBook(Books books) {

return bookMapper.updateBook(books);

}

public Books queryBookById(int id) {

return bookMapper.queryBookById(id);

}

public List queryAllBook() {

return bookMapper.queryAllBook();

}

}

Spring 整合

============================================================================

配置 Spring 整合 MyBatis，我们这里数据源使用 c3p0 连接池；

编写 Spring 整合 Mybatis

---

编写 Spring 整合 Mybatis 的相关的配置文件：spring-dao.xml

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

<beans xmlns=“http://www.springframework.org/schema/beans”

xmlns:xsi=“http://www.w3.org/2001/XMLSchema-instance”

xmlns:context=“http://www.springframework.org/schema/context”

xsi:schemaLocation="http://www.springframework.org/schema/beans

http://www.springframework.org/schema/beans/spring-beans.xsd

http://www.springframework.org/schema/context

https://www.springframework.org/schema/context/spring-context.xsd">

<context:property-placeholder location=“classpath:database.properties”/>

Spring 整合 service 层