SSM整合(增删改查)

1- 环境基本要求

基本环境

• IDEA
• MySQL 5.7
• Tomcat 9
• Maven 3.6

2- 数据库环境

创建一个书籍数据的数据库表

-- 创建数据库
create database db_ssm;
-- 使用数据库
use db_ssm;

drop table if exists books;

-- 创建数据表
create table `books` (
	`bookid` int(10) not null auto_increment comment '书id',
	`bookname` varchar(100) not null comment '书名',
	`bookcounts` int(11) 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,'java编程并发实战'),
(2,'mysql',10,'mysql必知必会'),
(3,'linux',5,'现代操作系统'), 
(4,'c语言',2,'明解c语言');

3- 基本环境搭建

3.1 项目目录

​

3.2 pom依赖

<dependencies> 
    <!--Junit-->  
    <dependency> 
      <groupId>junit</groupId>  
      <artifactId>junit</artifactId>  
      <version>4.12</version> 
    </dependency>  
    <!--数据库驱动-->  
    <dependency> 
      <groupId>mysql</groupId>  
      <artifactId>mysql-connector-java</artifactId>  
      <version>5.1.47</version> 
    </dependency>  
    <!--数据库连接池-->  
    <dependency> 
      <groupId>com.alibaba</groupId>  
      <artifactId>druid</artifactId>  
      <version>1.1.10</version> 
    </dependency>  
    <!--Servlet - JSP -->  
    <dependency> 
      <groupId>javax.servlet</groupId>  
      <artifactId>servlet-api</artifactId>  
      <version>2.5</version> 
    </dependency>  
    <dependency> 
      <groupId>javax.servlet.jsp</groupId>  
      <artifactId>jsp-api</artifactId>  
      <version>2.2</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.2</version> 
    </dependency>  
    <dependency> 
      <groupId>org.mybatis</groupId>  
      <artifactId>mybatis-spring</artifactId>  
      <version>2.0.2</version> 
    </dependency>  
    <!--Spring-->  
    <dependency> 
      <groupId>org.springframework</groupId>  
      <artifactId>spring-webmvc</artifactId>  
      <version>5.1.9.RELEASE</version> 
    </dependency>  
    <dependency> 
      <groupId>org.springframework</groupId>  
      <artifactId>spring-jdbc</artifactId>  
      <version>5.1.9.RELEASE</version> 
    </dependency>  
    <!--Lombok-->  
    <dependency> 
      <groupId>org.projectlombok</groupId>  
      <artifactId>lombok</artifactId>  
      <version>1.16.10</version> 
    </dependency> 
</dependencies>  

3.3 静态资源导出

<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>

4- Mybatis层编写

4.1 数据库配置文件

database.properties

jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/db_ssm
jdbc.username=root
jdbc.password=root

4.2 MyBatis的核心配置文件

mybatis-config.xml