1.创建数据库及表,添加数据
USE mybatis_plus;
DROP TABLE IF EXISTS users;
CREATE TABLE users(
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)
);
SELECT * FROM users;
INSERT INTO users(id,NAME,age,email)
VALUES(1,'jone',18,'123456qq.com'),
(2,'jone2',18,'123456qq.com'),
(3,'jone3',18,'123456qq.com'),
(4,'jone4',18,'123456qq.com'),
(5,'jone5',18,'123456qq.com')
2.创建一个SpringBoot项目,添加依赖和application.properties
pom.xml:
<dependencies>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter</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>
<!--mybatis-plus-->
<dependency>
<groupId>com.baomidou</groupId>
<artifactId>mybatis-plus-boot-starter</artifactId>
<version>3.0.5</version>
</dependency>
<!--mysql-->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
</dependency>
<!--lombok简化实体类依赖-->
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
</dependency>
</dependencies>
application.properties:
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
spring.datasource.url=jdbc:mysql://localhost:3306/mybatis_plus?serverTimezone=GMT%2B8
spring.datasource.username=root
spring.datasource.password=ok
3.编写mapper和entity层
Users:
package com.atguigu.mpdemo01.entity;
import lombok.Data;
@Data
public class Users {
private Long id;
private String name;
private Integer age;
private String email;
}
UsersMapper:
package com.atguigu.mpdemo01.mapper;
import com.atguigu.mpdemo01.entity.Users;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.springframework.stereotype.Repository;
@Repository
public interface UsersMapper extends BaseMapper<Users> {
}
注意:启动类上要加注解@MapperScan("com.atguigu.mpdemo01.mapper")
package com.atguigu.mpdemo01;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
@SpringBootApplication
@MapperScan("com.atguigu.mpdemo01.mapper")
public class Mpdemo01Application {
public static void main(String[] args) {
SpringApplication.run(Mpdemo01Application.class, args);
}
}
4.测试
package com.atguigu.mpdemo01;
import com.atguigu.mpdemo01.entity.Users;
import com.atguigu.mpdemo01.mapper.UsersMapper;
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
public class Mpdemo01ApplicationTests {
@Autowired
private UsersMapper usersMapper;
//查询users表所有数据
@Test
public void findAll() {
List<Users> users = usersMapper.selectList(null);
System.out.println(users);
}
}