// 根据 id 查询, 返回一个 Book
Books queryBookById(int id);
// 查询全部 Book, 返回 list 集合
List queryAllBook();
}
需要导入 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
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 整合 MyBatis,我们这里数据源使用 c3p0 连接池;
编写 Spring 整合 Mybatis 的相关的配置文件:spring-dao.xml
<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 的相关的配置文件:spring