- 首先新建一个Spring Boot项目。
- 导入依赖
- 编写XML文件
pom.xml
4.0.0 org.springframework.boot spring-boot-starter-parent 2.3.4.RELEASE com.example mystudydemo 0.0.1-SNAPSHOT mystudydemo Demo project for Spring Boot 1.8 org.springframework.boot spring-boot-starter-web org.springframework.boot spring-boot-starter-logging org.springframework.boot spring-boot-starter-test test org.springframework.boot spring-boot-starter-log4j2 org.apache.logging.log4j log4j-core 2.10.0 org.apache.logging.log4j log4j-api 2.10.0 org.projectlombok lombok true org.mybatis.spring.boot mybatis-spring-boot-starter 2.1.3 org.springframework.boot spring-boot-starter-thymeleaf mysql mysql-connector-java runtime org.springframework.boot spring-boot-starter-thymeleaf org.springframework.boot spring-boot-maven-plugin
Log4j2.xml
application.yml
spring:
datasource:
#用户名
username: root
#密码
password: 123456
# url需要指定时区serverTimezone为 GMT%2B8 :北京时间东八区
url: jdbc:mysql://localhost:3306/mybatis?serverTimezone=GMT%2B8&useUnicode=true&characterEncoding=utf-8&useSSL=true
# 新版的驱动类改成了com.mysql.cj.jdbc.Driver
driver-class-name: com.mysql.cj.jdbc.Driver
# 使用mybatis配置文件时需要指明
thymeleaf:
prefix: classpath:/templates/
suffix: .html
mode: LEGACYHTML5
encoding: UTF-8
cache: false
server:
servlet:
context-path:
port: 8080
application.properties
#配置Mybatis #mybatis.config-location=classpath:mybatis/mybatis-config.xml mybatis.mapper-locations=classpath:mybatis/mapper/*.xml mybatis.type-aliases-package=com.example.mystudydemo.entity
User.java
package com.example.mystudydemo.entity;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
import java.util.Date;
@Data
@NoArgsConstructor
@AllArgsConstructor
public class User {
Integer id;
String username;
String password;
String yourName;
String sex;
Integer age;
String yourPhone;
String yourMail;
Date ctime;
Date uptime;
}
UserMapper.java
package com.example.mystudydemo.dao;
import com.example.mystudydemo.entity.User;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import java.util.List;
@Mapper
public interface UserMapper {
//获取所有数据
List getAllUser();
//获取一条数据
User selectUserById(@Param("id") Integer id);
//新增一条数据
Integer insertUser(@Param("user") User user);
//新增多条数据
Boolean addUserMassages(@Param("list") List list);
//新增多条数据
Boolean insertUserMassages(@Param("list") List list);
//更新数据
Boolean updateUser(@Param("user") User user);
//删除数据
Boolean deleteFromUser(@Param("id") Integer id);
Boolean deleteFromUsers(@Param("list") List list);
User getUserByUserName(@Param("username") String username);
}
UserMapper.xml
id,username,password,youname,sex,age,youphone,youmail,ctime,uptime
数据表图片入下,懒得写SQL语句了。
到此,就用Mybatis实现了对单表的增删改查了。



