1. 基本环境搭建
- 数据库创建
CREATE DATABASE ssmbuild;
USE ssmbuild;
CREATE TABLE `books`(
`bookID` INT NOT NULL AUTO_INCREMENT COMMENT '书id',
`bookName` VARCHAR(100) NOT NULL COMMENT '书名',
`bookCounts` INT NOT NULL COMMENT '数量',
`detail` VARCHAR(200) NOT NULL COMMENT '描述',
KEY `bookID`(`bookID`)
)ENGINE=INNODB DEFAULT CHARSET=utf8
INSERT INTO `books`(`bookID`,`bookName`,`bookCounts`,`detail`)VALUES
(1,'Java',1,'从入门到放弃'),
(2,'MySQL',10,'从删库到跑路'),
(3,'Linux',5,'从进门到进牢')
- 利用Maven导入依赖包
<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
<modelVersion>4.0.0</modelVersion>
<groupId>com.shang</groupId>
<artifactId>ssmbuild</artifactId>
<version>1.0-SNAPSHOT</version>
<dependencies>
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version> 4.13</version>
<scope>test</scope>
</dependency>
<!--数据库驱动-->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.49</version>
</dependency>
<!--数据库连接池-->
<dependency>
<groupId>com.mchange</groupId>
<artifactId>c3p0</artifactId>
<version>0.9.5.5</version>
</dependency>
<!--servlet jsp-->
<dependency>
<groupId>javax.servlet</groupId>
<artifactId>servlet-api</artifactId>
<version>3.0-alpha-1</version>
</dependency>
<dependency>
<groupId>javax.servlet.jsp</groupId>
<artifactId>jsp-api</artifactId>
<version>2.2.1-b03</version>
</dependency>
<dependency>
<groupId>javax.servlet</groupId>
<artifactId>jstl</artifactId>
<version>1.2</version>
</dependency>
<!--mybatis-->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.5.5</version>
</dependency>
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis-spring</artifactId>
<version>2.0.5</version>
</dependency>
<!--spring-->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-webmvc</artifactId>
<version> 5.2.6.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-jdbc</artifactId>
<version> 5.2.6.RELEASE</version>
</dependency>
<!--lombok-->
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
<version>1.18.12</version>
</dependency>
</dependencies>
<!--静态资源导出问题-->
<build>
<resources>
<resource>
<directory>src/main/java</directory>
<includes>
<include>**/*.properties</include>
<include>**/*.xml</include>
</includes>
<filtering>false</filtering>
</resource>
<resource>
<directory>src/main/resources</directory>
<includes>
<include>**/*.properties</include>
<include>**/*.xml</include>
</includes>
<filtering>false</filtering>
</resource>
</resources>
</build>
</project>
注意导入静态资源过滤
2. 相应测试代码编写
- 创建相应的文件,文件目录结构如图
- dao目录下创建BookMapper.java文件和BookMapper.xml配置文件
package com.shang.dao;
import com.shang.pojo.Books;
import org.apache.ibatis.annotations.Param;
import java.util.List;
public interface BookMapper {
//增删改查操作
int addBook(Books books);
int deleteBookById(@Param("bookID") int id);
int updateBookByid(Books books);
Books queryBookById(@Param("bookID") int id);
List<Books> queryAllBooks();
}
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.shang.dao.BookMapper">
<insert id="addBook" parameterType="books" >
insert into ssmbuild.books (bookID,bookName,bookCounts,detail)
values (#{bookID},#{bookName},#{bookCounts},#{detail})
</insert>
<delete id="deleteBookById" >
delete from ssmbuild.books
<where>
bookID = #{bookID}
</where>
</delete>
<update id="updateBookByid" parameterType="books">
update ssmbuild.books
<set>
bookName = #{bookName},
bookCounts = #{bookCounts},
detail = #{detail}
</set>
<where>
bookID = #{bookID}
</where>
</update>
<select id="queryBookById" resultType="books">
select * from ssmbuild.books
<where>
bookID = #{bookID}
</where>
</select>
<select id="queryAllBooks" resultType="books">
select * from ssmbuild.books
</select>
</mapper>
== 创建完成后需要在mybatis.xml中进行注册==
- 在pojo目录下创建Books.java文件
package com.shang.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;
}
- service目录下创建BooksService接口及实现类
BookService.java
package com.shang.service;
import com.shang.pojo.Books;
import org.apache.ibatis.annotations.Select;
import java.util.List;
public interface BookService {
//增删改查操作
int addBook(Books books);
int deleteBookById(int id);
int updateBookByid(Books books);
Books queryBookById(int id);
List<Books> queryAllBooks();
}
BookServiceImpl.java
package com.shang.service;
import com.shang.dao.BookMapper;
import com.shang.pojo.Books;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import java.util.List;
@Service("bookServiceImpl")
public class BookServiceImpl implements BookService {
BookMapper bookMapper;
@Autowired
public void setBookMapper(BookMapper bookMapper) {
this.bookMapper = bookMapper;
}
public int addBook(Books books) {
return bookMapper.addBook(books);
}
public int deleteBookById(int id) {
return bookMapper.deleteBookById(id);
}
public int updateBookByid(Books books) {
return bookMapper.updateBookByid(books);
}
public Books queryBookById(int id) {
return bookMapper.queryBookById(id);
}
public List<Books> queryAllBooks() {
return bookMapper.queryAllBooks();
}
}
- 在controller目录下编写BookController.java文件
package com.shang.controller;
import com.shang.pojo.Books;
import com.shang.service.BookService;
import com.shang.service.BookServiceImpl;
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.RequestMapping;
import java.util.List;
@Controller
@RequestMapping("/book")
public class BookController {
@Autowired
@Qualifier("bookServiceImpl")
private BookService bookService;
@RequestMapping("/allbook")
public String listAllBooks(Model model)
{
List<Books> books = bookService.queryAllBooks();
model.addAttribute("msg",books);
return "book";
}
}
- 在WEB-INF下创建jsp目录,在其中编写测试界面
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
<title>书籍展示</title>
</head>
<body>
${msg}
</body>
</html>
- 配置Tomcat,启动服务器