通用Mapper在SpringBoot中的简单使用

最新推荐文章于 2025-01-14 09:16:06 发布

大阿冬

最新推荐文章于 2025-01-14 09:16:06 发布

阅读量245

点赞数 1

CC 4.0 BY-SA版权

本文链接：https://blog.youkuaiyun.com/xswlXAD/article/details/89643300

本文介绍了如何在SpringBoot项目中使用通用Mapper，从引入依赖到配置数据库，再到定义实体和Mapper接口，最后进行测试，步骤详细清晰。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

引入依赖

	<properties>
		<java.version>1.8</java.version>
		<pagehelper.version>1.2.3</pagehelper.version>
		<tk.version>2.0.2</tk.version>
		<druid.version>1.1.8</druid.version>
	</properties>

	<dependencies>
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-web</artifactId>
		</dependency>
		<dependency>
			<groupId>com.github.pagehelper</groupId>
			<artifactId>pagehelper-spring-boot-starter</artifactId>
			<version>${pagehelper.version}</version>
		</dependency>
		<dependency>
			<groupId>tk.mybatis</groupId>
			<artifactId>mapper-spring-boot-starter</artifactId>
			<version>${tk.version}</version>
		</dependency>
		<dependency>
			<groupId>mysql</groupId>
			<artifactId>mysql-connector-java</artifactId>
			<scope>runtime</scope>
		</dependency>
        </dependencies>

SpringBoot入口类加注解

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

@SpringBootApplication
@MapperScan("com.xiaoadong.venux.mapper")//启用通用mapper的扫描器，值为mapper接口所在的包
public class VenuxApplication {

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

}

定义实体

import lombok.Data;
import tk.mybatis.mapper.annotation.KeySql;

import javax.persistence.Id;
import javax.persistence.Table;


/**
 * 数据库建表语句
DROP TABLE IF EXISTS tb_user;
 CREATE TABLE tb_user(
 uid INT(11) NOT NULL AUTO_INCREMENT,
 username VARCHAR(50) NOT NULL UNIQUE,
 `password` VARCHAR(150) NOT NULL,
 salt VARCHAR(150) NOT NULL,
 email VARCHAR(60) NOT NULL,
 PRIMARY KEY (uid)
 ) ENGINE=INNODB;
 */
@Data
@Table(name = "tb_user")
public class User {
    @Id
    @KeySql(useGeneratedKeys = true)
    private Long uid;
    private String username;
    private String password;
    private String salt;
    private String email;
}

定义Mapper接口（即dao）

import com.xiaoadong.venux.pojo.User;
import tk.mybatis.mapper.common.Mapper;

public interface UserMapper extends Mapper<User> {
}

配置数据库

spring:
  ##数据库连接信息
  datasource:
    url: jdbc:mysql://localhost:3306/venux
    username: root
    password: 20180524
    driver-class-name: com.mysql.jdbc.Driver

测试

import com.xiaoadong.venux.pojo.User;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;
import org.springframework.test.context.junit4.SpringRunner;

import static org.junit.Assert.*;

@SpringBootTest
@RunWith(SpringRunner.class)
public class UserMapperTest {

    @Autowired
    UserMapper userMapper;

    @Test
    public void insertOne(){
        User user = new User();
        user.setUsername("xiaoadong");
        user.setPassword("123");
        user.setSalt("123");
        user.setEmail("dsad");

        int i = userMapper.insertSelective(user);
        System.out.println(i);

    }

    @Test
    public void selectOne(){
        User user = new User();
        user.setUid(1L);
        User user1 = userMapper.selectOne(user);
        System.out.println(user1);
    }

}