mybatisplus 示例练习1

新建springboo工程，

导入依赖

        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-boot-starter</artifactId>
            <version>3.5.1</version>
        </dependency>
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
            <optional>true</optional>
        </dependency>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.47</version>
        </dependency>

配置application.properties

#springboot默认数据源
spring.datasource.type=com.zaxxer.hikari.HikariDataSource
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.url=jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf-8&useSSL=false&serverTimeZone=UTC
spring.datasource.username=root
spring.datasource.password=mysql123
#默认日志
mybatis-plus.configuration.log-impl=org.apache.ibatis.logging.stdout.StdOutImpl

实体类

User.java

package com.shrimpking.pojo;

import com.baomidou.mybatisplus.annotation.TableName;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.EqualsAndHashCode;
import lombok.Getter;
import lombok.NoArgsConstructor;
import lombok.Setter;
import lombok.ToString;

/**
 * Created by IntelliJ IDEA.
 *
 * @Author : Shrimpking
 * @create 2023/6/9 21:16
 */
//@NoArgsConstructor
//@AllArgsConstructor
//@Getter
//@Setter
//@ToString
//@EqualsAndHashCode
@Data
@TableName("q_user")
public class User
{
    private Long id;

    private String name;

    private Integer age;

    private String email;

}

@Data是lombok的注解，表示自动生成实体类的无参构造，读取，设置方法等。

@Data是一个复合注解，内含Getter,Setter,tostring，NoArgsContructor,EqualsAndHashcode.

实体类中id类型Long，是因为springboot支持使用mybatis-plus，而mybatis-plus中默认对数据库主键id采用雪花算法产生，数据较长，一般数据库表中设置id字段的类型为bigint，所以在java中对应设定为Long类型。

数据库，建表

create table q_user(
	id bigint(20) not null,
	name varchar(20) not null,
	age int(11),
	email varchar(50),
	primary key(id)
);

insert into q_user values (1,'a1',22,'xx@xx.com');
insert into q_user values (2,'a2',20,'xx@xx.com');
insert into q_user values (3,'b1',23,'xx@xx.com');
insert into q_user values (4,'b2',10,'xx@xx.com');
insert into q_user values (5,'c3',30,'xx@xx.com');

Mapper接口

UserMapper.java

package com.shrimpking.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.shrimpking.pojo.User;
import org.springframework.stereotype.Repository;

import java.util.Map;

/**
 * Created by IntelliJ IDEA.
 *
 * @Author : Shrimpking
 * @create 2023/6/9 21:23
 */
@Repository
public interface UserMapper extends BaseMapper<User>
{
    /**
     * 根据id查询用户信息
     */
    Map<String,Object> selectMapById(Long id);
}

需要继承mybatisplus的BaseMapper接口

Mapper实现

UserMapper.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">

<mapper namespace="com.shrimpking.mapper.UserMapper">

    <select id="selectMapById" resultType="map">
        select id,name,age,email from q_user where id=#{id}
    </select>

</mapper>

测试

MyTest.java

package com.shrimpking;

import com.shrimpking.mapper.UserMapper;
import com.shrimpking.pojo.User;
import org.junit.jupiter.api.Test;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;

import java.util.Arrays;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

/**
 * Created by IntelliJ IDEA.
 *
 * @Author : Shrimpking
 * @create 2023/6/9 21:27
 */
@SpringBootTest
public class MyTest
{
    @Autowired
    private UserMapper userMapper;

    @Test
    public void testSelectList()
    {
        //SELECT id,name,age,email FROM q_user
        //查询全部用户信息
        List<User> userList = userMapper.selectList(null);
        for (User user : userList)
        {
            System.out.println(user);
        }
    }

    @Test
    public void testInsert()
    {
        //INSERT INTO q_user ( id, name, age, email ) VALUES ( ?, ?, ?, ? )
        //新增一个用户,并获取自增的id
        User user = new User();
        user.setName("zhang");
        user.setAge(99);
        user.setEmail("qq@qq.com");
        int result = userMapper.insert(user);
        System.out.println("result: " + result);
        System.out.println("id: " + user.getId());
    }

    @Test
    public void testDelete()
    {
        //DELETE FROM q_user WHERE id=?
        //根据id删除一个用户
        int result = userMapper.deleteById(5L);
        System.out.println("result: " + result);
    }

    @Test
    public void testDelete2()
    {
        //DELETE FROM q_user WHERE name = ? AND age = ?
        //根据多个条件删除用户
        Map<String,Object> map = new HashMap<>();
        map.put("name","zhang");
        map.put("age",99);
        int result = userMapper.deleteByMap(map);
        System.out.println("result: " + result);
    }

    @Test
    public void testDelete3()
    {
        //DELETE FROM q_user WHERE id IN ( ? , ? , ? )
        //根据id批量删除用户
        List<Long> list = Arrays.asList(1L, 2L, 3L);
        int result = userMapper.deleteBatchIds(list);
        System.out.println("result:" + result);
    }

    @Test
    public void testUpdate()
    {
        //UPDATE q_user SET name=?, email=? WHERE id=?
        //根据id，修改用户信息
        User user = new User();
        user.setId(4L);
        user.setName("剩余用户");
        user.setEmail("yy@yy.com");
        int result = userMapper.updateById(user);
        System.out.println("result: " + result);
    }

    @Test
    public void testSelect()
    {
        //SELECT id,name,age,email FROM q_user WHERE id=?
        //根据id查询一个用户
        User user = userMapper.selectById(1L);
        System.out.println(user);
    }

    @Test
    public void testSelect2()
    {
        //SELECT id,name,age,email FROM q_user WHERE id IN ( ? , ? , ? )
        //根据多个id批量查询多个用户信息
        List<Long> list = Arrays.asList(1L, 2L, 3L);
        List<User> userList = userMapper.selectBatchIds(list);
        userList.forEach(System.out::println);
    }

    @Test
    public void testSelect3()
    {
        //SELECT id,name,age,email FROM q_user WHERE name = ? AND age = ?
        //根据多个条件查询多个用户信息
        Map<String,Object> map = new HashMap<>();
        map.put("name","a2");
        map.put("age",20);
        List<User> userList = userMapper.selectByMap(map);
        for (User user : userList)
        {
            System.out.println(user);
        }
    }

    @Test
    public void testSelect4()
    {
        //SELECT id,name,age,email FROM q_user
        List<User> userList = userMapper.selectList(null);
        userList.forEach(System.out::println);
    }

    @Test
    public void testSelect5()
    {
        //select id,name,age,email from q_user where id=?
        //自定义，根据id查询用户
        Map<String, Object> map = userMapper.selectMapById(1L);
        System.out.println(map);
    }
}