所需软件
IDEA最新版 MySQL5.7.19 Tomcat 9 Maven3.6项目结构
配置database.properties文件
jdbc.driver=com.mysql.jdbc.Driverjdbc.url=jdbc:mysql://localhost:3306/ssmbuild?useSSL=true&useUnicode=true&characterEncoding=utf8jdbc.username=rootjdbc.password=123456数据库导入需要的包
mysql mysql-connector-java 5.1.47 二、编写数据库对应的实体类及Dao层com.kuang.pojo.Book
package com.kuang.pojo;public class Book {private int bookID;private String bookName;private int bookCounts;private String detail;public Book() {}public Book(int bookID, String bookName, int bookCounts ,String detail) {this.bookID = bookID;this.bookName = bookName;this.bookCounts = bookCounts;this.detail=detail;}public int getBookID() {return bookID;}public void setBookID(int bookID) {this.bookID = bookID;}public String getBookName() {return bookName;}public void setBookName(String bookName) {this.bookName = bookName;}public int getBookCounts() {return bookCounts;}public void setBookCounts(int bookCounts) {this.bookCounts = bookCounts;}public String getDetail() {return detail;}public void setDetail(String detail) {this.detail = detail;}@Overridepublic String toString() {return "Book{" +"bookID=" + bookID +", bookName='" + bookName + '\'' +", bookCounts=" + bookCounts +", detail='" + detail + '\'' +'}';}}对应Dao层接口;com.kuang.dao.BookDao
package com.kuang.dao;import com.kuang.pojo.Book;import java.util.List;public interface BookDao {//增加一个Bookint addBook(Book book);//根据id删除一个bookint deleteBookById(int id);//更新bookint updateBook(Book book);//根据id查询,返回一个bookBook queryBookById(int id);//查询全部bookList queryAllBook();}编写接口对应的Mapper文件。需要导入MyBatis的包
org.mybatis mybatis 3.4.6编写BookMapper.xml文件
insert into ssmbuild.books(bookName, bookCounts, detail)value (#{bookName},#{bookCounts},#{detail})delete from ssmbuild.books where bookID=#{bookID}update ssmbuild.booksset bookName= #{bookName},bookCounts = #{bookCounts},detail = #{detail}where bookID=#{bookID}select *from ssmbuild.bookswhere bookID=#{bookID}select *fromssmbuild.books编写Mybatis配置文件,配置别名,注册映射文件
编写Service层的接口和实现类
package com.kuang.service;import com.kuang.pojo.Book;import java.util.List;//BookService:底下需要去实现,调用dao层public interface BookService {//增加一个Bookint addBook(Book book);//根据id删除一个Bookint deleteBookById(int id);//更新Bookint updateBook(Book book);//根据id查询,返回一个BookBook queryBookById(int id);//查询全部Book,返回list集合List queryAllBook();} package com.kuang.service;import com.kuang.dao.BookDao;import com.kuang.pojo.Book;import java.util.List;public class BookServiceImpl implements BookService {//调用dao层的操作,设置一个set接口,方便Spring管理private BookDao bookDao;public void setBookDao(BookDao bookDao){this.bookDao=bookDao;}@Overridepublic int addBook(Book book) {return bookDao.addBook (book);}@Overridepublic int deleteBookById(int id) {return bookDao.deleteBookById (id);}@Overridepublic int updateBook(Book book) {return bookDao.updateBook (book);}@Overridepublic Book queryBookById(int id) {return bookDao.queryBookById (id);}@Overridepublic List queryAllBook() {return bookDao.queryAllBook ();}} 三、配置Spring整合MyBatis我们这里数据源使用c3p0连接池;我们来导入相关jar包
com.mchange c3p0 0.9.5.2 org.mybatis mybatis-spring 1.3.1 org.springframework spring-jdbc 4.3.24.RELEASE