目录
2.配置Springboot配置文件application.yml
前言
springboot项目结构:
一、Springboot整合Mybatis实现SSM框架
1. pom.xml中引入相关包
2. 配置Springboot配置文件(application.yml或者application.properties)
3. 建立封装实体类User(com.mybatis_demo.pojo.User.java)
4. 建立数据层接口(public interface UserMapper.java 各种数据表操作方法)
5. (这一步必要时才建立,因为可以使用注解替代了)建立数据层接口类的对应映射的XML文件,mapper.UserMapper.xml
6. 建立service层,业务处理层UserService.java和UserServiceImpl.java
7. 建立RestController请求控制层
8. 在启动引导类添加@MapperScan("com.mybatis_demo.mapper")扫描你的mapper接口(数据层dao接口)所在的包。或者在数据层dao接口的每个接口类单独添加@Mapper注解扫描
二、上代码
1.maven的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>
<groupId>com</groupId>
<artifactId>mybatis_demo</artifactId>
<version>0.0.1-SNAPSHOT</version>
<name>mybatis_demo</name>
<description>Demo project for Spring Boot</description>
<properties>
<java.version>1.8</java.version>
<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
<project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>
<spring-boot.version>2.3.7.RELEASE</spring-boot.version>
</properties>
<dependencies>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>2.1.4</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<scope>runtime</scope>
</dependency>
<!--lombok简化代码-->
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-test</artifactId>
<scope>test</scope>
<exclusions>
<exclusion>
<groupId>org.junit.vintage</groupId>
<artifactId>junit-vintage-engine</artifactId>
</exclusion>
</exclusions>
</dependency>
</dependencies>
<dependencyManagement>
<dependencies>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-dependencies</artifactId>
<version>${spring-boot.version}</version>
<type>pom</type>
<scope>import</scope>
</dependency>
</dependencies>
</dependencyManagement>
<build>
<plugins>
<plugin>
<groupId>org.apache.maven.plugins</groupId>
<artifactId>maven-compiler-plugin</artifactId>
<version>3.8.1</version>
<configuration>
<source>1.8</source>
<target>1.8</target>
<encoding>UTF-8</encoding>
</configuration>
</plugin>
<plugin>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-maven-plugin</artifactId>
<version>2.3.7.RELEASE</version>
<configuration>
<mainClass>com.mybatis_demo.MybatisDemoApplication</mainClass>
</configuration>
<executions>
<execution>
<id>repackage</id>
<goals>
<goal>repackage</goal>
</goals>
</execution>
</executions>
</plugin>
</plugins>
</build>
</project>
2.配置Springboot配置文件application.yml
# 应用名称
spring:
application:
name: mybatis_demo
datasource:
driver-class-name: com.mysql.cj.jdbc.Driver
url: jdbc:mysql://localhost:3306/mydb?useUnicode=true&characterEncoding=utf8&serverTimezone=UTC
username: root
password: 123456
# 应用服务 WEB 访问端口
server:
port: 8080
mybatis:
#定义表映射对象实体类的包存放路径,但是如果mybatis的SQL语句XML文件中使用了resultType="com.mybatis_demo.pojo.User"属性指定全路径,
#那么此配置不生效。此处如果配置了type-aliases-package属性,那么SQL语句XML文件中可以resultType="User"这样直接设置实体名。
type-aliases-package: com.mybatis_demo.pojo
#接口的配置文件的位置(映射在class编译路径下的)
mapper-locations: classpath:mapper/*Mapper.xml
logging:
level:
com:
mbp:
demo:
mapper: debug
3.建立封装实体类User.java
package com.mybatis_demo.pojo;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
import java.util.Date;
/**
* @author lv
* @date 2022年11月6日21点00分
* 封装数据的实体bean,(lombok简化代码)
*/
@Data
@NoArgsConstructor
@AllArgsConstructor
public class User {
private Integer id;
private String username;
private String password;
private String nickname;
private Date addtime;
}
4.建立数据层接口UserMapper.java
说明:* 在使用Mybatis持久层框架来操作数据库时,我们可以使用@Mapper注解和@MapperScan注解来将Mapper接口类交给Sprinig进行管理(注入bean到spring容器)
* @Mapper映射一个数据层接口类操作数据库,而@MapperScan配置在启动类上映射一个包下的所有数据层接口类操作数据库
package com.mybatis_demo.mapper;
import com.mybatis_demo.pojo.User;
import org.apache.ibatis.annotations.*;
import java.util.List;
/**
* @author lv
* @date 2022年11月6日21点00分
* 在使用Mybatis持久层框架来操作数据库时,我们可以使用@Mapper注解和@MapperScan注解来将Mapper接口类交给Sprinig进行管理(注入bean到spring容器)
* @Mapper映射一个数据层接口类操作数据库,而@MapperScan配置在启动类上映射一个包下的所有数据层接口类操作数据库
*/
//@Mapper
public interface UserMapper {
@Select("select * from users")
public List<User> selectAll();
//@Select("select * from users where id=#{id}")
public User selectOne(Integer id);
@Insert("insert into users(id,username,password,nickname,addtime) values(#{id},#{username},#{password},#{nickname},NOW())")
public int adduser(User user);
@Delete("delete from users where id=#{id}")
public int del(Integer id);
@Update("update users set username=#{username} where id=#{id}")
public int update(User user);
}
5.建立service层,业务处理层
UserService.java
package com.mybatis_demo.service;
import com.mybatis_demo.pojo.User;
import java.util.List;
/**
* @author lv
* @date 2022年11月6日21点00分
* 业务层接口类
*/
public interface UserService {
public List<User> selectAll();
public User selectOne(Integer id);
public boolean adduser(User user);
public boolean del(Integer id);
public boolean update(User user);
}
UserServiceImpl.java
package com.mybatis_demo.service.impl;
import com.mybatis_demo.mapper.UserMapper;
import com.mybatis_demo.pojo.User;
import com.mybatis_demo.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import java.util.List;
/**
* @author lv
* @date 2022年11月6日21点00分
* 业务层接口类实现,使用@Service这个注解
*/
@Service
public class UserServiceImpl implements UserService {
@Autowired
private UserMapper userMapper;
@Override
public List<User> selectAll() {
return userMapper.selectAll();
}
@Override
public User selectOne(Integer id) {
return userMapper.selectOne(id);
}
@Override
public boolean adduser(User user) {
int add = userMapper.adduser(user);
if(add>0){
return true;
}
return false;
}
@Override
public boolean del(Integer id) {
int del = userMapper.del(id);
if(del>0){
return true;
}
return false;
}
@Override
public boolean update(User user) {
int update = userMapper.update(user);
if(update>0){
return true;
}
return false;
}
}
6.建立RestController请求控制层
package com.mybatis_demo.controller;
import com.mybatis_demo.pojo.User;
import com.mybatis_demo.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;
import java.util.List;
/**
* @author lv
* @date 2022年11月6日21点00分
* rest控制层,使用了不同的动词请求方法(@RequestMapping,@GetMapping,@PostMapping,@DeleteMapping,@PutMapping)
* https://blog.csdn.net/weixin_45266846/article/details/120180991
*/
@RestController
@RequestMapping("/user")
public class UserController {
//自动装配
@Autowired
private UserService userService;
@RequestMapping("/hi")
public String hello(){
return "hello!";
}
@GetMapping("/userAll")
public List<User> all(){
return userService.selectAll();
}
@PostMapping("/userAdd")
public String adduser(@RequestBody User user){
String str=null;
boolean flag = userService.adduser(user);
if(flag){
str="添加成功";
}else{
str="添加失败!";
}
return str;
}
@DeleteMapping("/userDel/{id}")
public String del(@PathVariable int id){
String str=null;
boolean del = userService.del(id);
if(del){
str="添加成功";
}else{
str="添加失败!";
}
return str;
}
@PutMapping("/update")
public boolean update(@RequestBody User user){
return userService.update(user);
}
/**
* 根据id查询单个用户,采用的mybatis数据接口层 XML文件实现SQL语句
* @param id
* @return
*/
@GetMapping("/selOneUser/{id}")
public User selOneUser(@PathVariable int id){
return userService.selectOne(id);
}
}
7.在启动引导类添加@MapperScan注解
package com.mybatis_demo;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
@SpringBootApplication
//扫描你的mapper接口所在的包
@MapperScan("com.mybatis_demo.mapper")
public class MybatisDemoApplication {
public static void main(String[] args) {
SpringApplication.run(MybatisDemoApplication.class, args);
}
}
8.运行测试
启动项目引导类,使用Postman工具测试如下,
添加数据:(采用了@MapperScan注解实现sping扫描到数据dao层接口方法实现SQL语句请求)
再来测试使用XML文件映射实现SQL查询。添加UserMapper.xml配置文件实现按id查询,添加在resources\mapper目录下。
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<!--命名空间映射到com.mybatis_demo.mapper.UserMapper类-->
<mapper namespace="com.mybatis_demo.mapper.UserMapper">
<!--public User selectOne(Integer id);-->
<select id="selectOne" resultType="com.mybatis_demo.pojo.User">
select * from users where id=#{id}
</select>
</mapper>
Postman测试结果: