mybatis-plus01——quickStart

1. 引入依赖

<!--		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>

2. 配置数据库链接信息

当使用springboot2.1以上时，需要配置时区

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=xxxxxx

2.1以下时

spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.url=jdbc:mysql://localhost:3306/mybatis_plus
spring.datasource.username=root
spring.datasource.password=xxxxxx

3. 编写实体类及mapper接口继承BaseMapper

package com.minghao.entity;

import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;

@Data
@AllArgsConstructor
@NoArgsConstructor
public class User {
    private Long id;
    private String name;
    private Integer age;
    private String email;
}

package com.minghao.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.minghao.entity.User;
import org.springframework.stereotype.Repository;

@Repository
public interface UserMapper extends BaseMapper<User> {

}

4. 在启动类上加@MapperScan(mapper接口的包名)

package com.minghao;

import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;

@SpringBootApplication
@MapperScan("com.minghao.mapper")
public class Mpdemo1107Application {

	public static void main(String[] args) {
		SpringApplication.run(Mpdemo1107Application.class, args);
	}

}

5. 在测试类中注入并测试查询所有用户方法

class Mpdemo1107ApplicationTests {

	@Autowired
	private UserMapper userMapper;

	@Test
	public void findAll(){
		List<User> users = userMapper.selectList(null);
		for (User user : users) {
			System.out.println(user);
		}
	}
}