Mybatis-Plus学习笔记：P2-使用方式2-Spring+Mybatis+Mybatis Plus

• 1.Spring+Mybatis+Mybatis Plus实现User查询
• • 1.1新建spring项目，导入依赖，依赖于父工程的pom.xml
  • 1.2编写jdbc.properties
  • 1.3编写applicationContext.xml
  • 1.4实体类User
  • 1.5UserMapper接口
  • 1.5测试代码

    
        mpdemo
        org.jq
        1.0-SNAPSHOT
    
    4.0.0

    mybatis-plus-spring
    
        5.1.6.RELEASE
    
    
        
            org.springframework
            spring-webmvc
            ${spring.version}
        
        
            org.springframework
            spring-jdbc
            ${spring.version}
        
        
            org.springframework
            spring-test
            ${spring.version}
        
    

jdbc.driver=com.mysql.cj.jdbc.Driver
jdbc.url=jdbc:mysql://127.0.0.1:3306/mp?
useUnicode=true&characterEncoding=utf8&autoReconnect=true&allowMultiQueries=true&useSSL=false
jdbc.username=root
jdbc.password=123456

package com.jq.simple.pojo;

import com.baomidou.mybatisplus.annotation.TableName;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;

@Data
@NoArgsConstructor
@AllArgsConstructor
@TableName("tb_user")
public class User {
    private Long id;
    private String userName;
    private String password;
    private String name;
    private Integer age;
    private String email;
}

package com.jq.simple.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.jq.simple.pojo.User;


public interface UserMapper extends BaseMapper {

}

package com.jq.simple;

import com.jq.simple.mapper.UserMapper;
import com.jq.simple.pojo.User;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.test.context.ContextConfiguration;
import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;

import java.util.List;

@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration(locations ="classpath:applicationContext.xml")
public class TestMyabtisSpring {
    @Autowired
    private UserMapper userMapper;
    @Test
    public void testSelectList(){
        List users = this.userMapper.selectList(null);
        for (User user : users) {
            System.out.println(user);
        }
    }

}