前言:SpringBoot对ssm框架的整合,以mybatis为例,对数据库表进行简单的增删改查操作,由于annotation,所以十分简单。(文件路径为下,懒得提及了)
1.maven配置依赖
使用Spring Initializr可以直接创建项目,简单粗暴,勾选mysql驱动和mybatis frameworky以及lombok工具,pom.xml文件中依赖如下
<?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 https://maven.apache.org/xsd/maven-4.0.0.xsd">
<modelVersion>4.0.0</modelVersion>
<parent>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-parent</artifactId>
<version>2.6.4</version>
<relativePath/> <!-- lookup parent from repository -->
</parent>
<groupId>com.boot</groupId>
<artifactId>boot-mybatis</artifactId>
<version>0.0.1-SNAPSHOT</version>
<name>boot-mybatis</name>
<description>boot-mybatis</description>
<properties>
<java.version>8</java.version>
</properties>
<dependencies>
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>2.2.0</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<scope>runtime</scope>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-test</artifactId>
<scope>test</scope>
</dependency>
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter-test</artifactId>
<version>2.2.0</version>
<scope>test</scope>
</dependency>
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
<optional>true</optional>
</dependency>
</dependencies>
<build>
<plugins>
<plugin>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-maven-plugin</artifactId>
</plugin>
</plugins>
</build>
</project>
2.User类
package com.boot.domain;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
import lombok.ToString;
//lombok工具注解的使用自己查去,很方便的工具,需要掌握
@AllArgsConstructor
@NoArgsConstructor
@ToString
@Data
public class User {
private Integer id;
private String name;
private Integer achievement;
private String grade;
}
3.UserMapper接口,其中写入接口方法
package com.boot.mapper;
import com.boot.domain.User;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;
import org.springframework.stereotype.Repository;
import java.util.List;
//你就看注解编程牛不牛吧,很方便
@Mapper
@Repository
public interface UserMapper {
@Select("select * from t3_user")
public List<User> GetAllUser();
@Insert("insert into t3_user values(null,'王八蛋',100,'二')")
public void insertUser();
@Update("update t3_user set id = 6 where name = '王八蛋'")
public void updateUser();
}
4.application.yml配置文件中配置连接数据库
spring:
datasource:
url: jdbc:mysql://localhost:3306/mybatis?serveTimeZone=UTC
driver-class-name: com.mysql.cj.jdbc.Driver
username: root
password: 123456
5.测试文件中Junit测试
package com.boot;
import com.boot.domain.User;
import com.boot.mapper.UserMapper;
import org.junit.jupiter.api.Test;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;
import java.util.List;
@SpringBootTest
class BootMybatisApplicationTests {
@Autowired
private UserMapper userMapper;
@Test
public void testGetAllUser() {
List<User> users = userMapper.GetAllUser();
users.forEach(System.out::println);
}
@Test
public void testInsertUser(){
userMapper.insertUser();
}
@Test
public void testUpdateUser(){
userMapper.updateUser();
}
}
6.各个方法的结果
(1)查询全部信息
(2)增加与修改功能(结果体现在第六行数据,其余数据为建立表时添加的数据)
7.总结
其实mybatis框架进行这些功能也是很方便的,但是再经过springboot整合后更加容易了,spring和springmvc相关内容用springboot实现也非常容易,就如spring的bean扫描和mvc中的部署都可以简易实现,部署web也不需要使用tomcat服务,十分便利,这个文章只是提高入门参考,内容还是需要深入学习。