搜索到
1
篇与
笔记分享
的结果
-
Mybatis-Plus 笔记总结 快速入门搭建步骤创建数据库mybatis_pluscreate database mybatis_plus use mybatis_plus CREATE TABLE user ( id BIGINT(20) NOT NULL COMMENT '主键ID', name VARCHAR(30) NULL DEFAULT NULL COMMENT '姓名', age INT(11) NULL DEFAULT NULL COMMENT '年龄', email VARCHAR(50) NULL DEFAULT NULL COMMENT '邮箱', PRIMARY KEY (id) ); INSERT INTO user (id, name, age, email) VALUES (1, 'Jone', 18, 'test1@baomidou.com'), (2, 'Jack', 20, 'test2@baomidou.com'), (3, 'Tom', 28, 'test3@baomidou.com'), (4, 'Sandy', 21, 'test4@baomidou.com'), (5, 'Billie', 24, 'test5@baomidou.com');编写项目这里是spring-boot 框架导入依赖<!--数据库驱动--> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> </dependency> <!--lombok--> <dependency> <groupId>org.projectlombok</groupId> <artifactId>lombok</artifactId> </dependency> <!--spring-plus的依赖--> <dependency> <groupId>com.baomidou</groupId> <artifactId>mybatis-plus-boot-starter</artifactId> <version>3.0.5</version> </dependency>导入了没有batis-plus 就不用导入mybatis了 ，这样容易冲突连接数据库 ！ 和mybatis相同（properties文件）spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver spring.datasource.url=jdbc:mysql://localhost:3306/mybatis_plus?useSSL=false&useUnicode=true&characterEncoding=utf-8 spring.datasource.username=root spring.datasource.password=root创建pojo实体类package com.xin.pojo; import lombok.AllArgsConstructor; import lombok.Data; import lombok.NoArgsConstructor; @Data @NoArgsConstructor @AllArgsConstructor public class User { private Long id; private String name; private Integer age; private String email; }Mapper接口package com.xin.Mapper; import com.baomidou.mybatisplus.core.mapper.BaseMapper; import com.xin.pojo.User; import org.apache.ibatis.annotations.Mapper; @Mapper //在对应的Mapper上继承基本的类 BaseMapper public interface UserMapper extends BaseMapper<User> { //所以的增删改查已经完成了！ }测试_使用:@SpringBootTest class MybatisPlus01ApplicationTests { //所有的方法来源它的父类BaesMapper @Autowired private UserMapper userMapper; @Test void contextLoads() { //查询全部用户 List<User> userList = userMapper.selectList(null); for (User user : userList) { System.out.println(user); } } }配置日志为了查看执行的SQL 语句 ，所以我们必须看日志# 日志配置 mybatis-plus.configuration.log-impl=org.apache.ibatis.logging.stdout.StdOutImplCURD扩展 /*测试添加方法*/ @Test public void textinsert(){ User user = new User(); user.setName("迪迦"); user.setAge(21); user.setEmail("123131314@qq.com"); int i = userMapper.insert(user); //自动生成ID System.out.println(i); }
