mybatisx-Plus&Druid数据源

mybatisx-Plus的特性：

• 无入侵：只做增强不做改变、引入它不会对现有工程产生影响，如丝般顺滑
• 损耗小：启动即会自动注入基本CURD，性能基本无损耗，直接面向对象操作
• 支持 Lambda 形式调用:通过 Lambda 表达式，方便的编写各类查询条件，无需再担心字段写错
• 支持多种数据库:支持 MSQL、MariaDB、Oracle、DB2、H2、HSQL、SQLite、Postgre、SQLServer2005、SQLServer 等多种数据库等等

创建项目 ： 

 

关键依赖包： 

            <dependency>
                <groupId>org.projectlombok</groupId>
                <artifactId>lombok</artifactId>
                <optional>true</optional>
            </dependency>


            <dependency>
                <groupId>com.baomidou</groupId>
                <artifactId>mybatis-plus-spring-boot3-starter</artifactId>
                <version>3.5.7</version>
            </dependency>

            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-test</artifactId>
                <scope>test</scope>
            </dependency>
            <dependency>
                <groupId>junit</groupId>
                <artifactId>junit</artifactId>
                <scope>test</scope>
            </dependency>

 编写实体类： 

@Data
@TableName("sys_user")
public class SysUser implements Serializable {
  @TableId(type = IdType.AUTO)
  @TableField("usr_id")
  private Long usrId;
  @TableField("usr_name")
  private String usrName;
  private String usrPassword;
  private Long usrRoleId;
  private Integer usrFlag;

编写Mapper接口： 

public interface UserMapper extends BaseMapper<SysUser> {

}

测试 

@Test
    public void testFind(){
        QueryWrapper<SysUser> wrapper = new QueryWrapper<>();
        wrapper.eq("usr_name","MyBatis-Plus");
        wrapper.eq("usr_password" , "123456");
        List<SysUser> list = userMapper.selectList(wrapper);
        if (list != null){
            for (SysUser user:list) {
                System.out.println("usrId:"+user.getUsrId());
            }
        }