Mybatis-plus使用Wappers的简单查询

阳光穿透心脏的1/2处 2022-02-02 05:25 191阅读 0赞

Mybatis-plus依然可以使用生成的\*\*Mapper.xml，在其中写sql语句来查询，但是一般的简单的增删改查语句我们可以使用plus的另外一种用法实现，小编能力有限，不知道专业术语怎么描述，接下来直接上代码

### 实体类(通过反向生成出来的,可以看上一篇文章) ###

package com.ipzoe.ndk.domain.entity;
    
    import com.baomidou.mybatisplus.annotation.IdType;
    import com.baomidou.mybatisplus.extension.activerecord.Model;
    import com.baomidou.mybatisplus.annotation.TableId;
    import java.io.Serializable;
    import lombok.Data;
    import lombok.EqualsAndHashCode;
    import lombok.experimental.Accessors;
    
    @Data
    @EqualsAndHashCode(callSuper = false)
    @Accessors(chain = true)
    public class AdminUser extends Model<AdminUser> {
    
        public static  final AdminUser INSTANCE = new AdminUser();
    
        private static final long serialVersionUID = 1L;
    
        @TableId(value = "id", type = IdType.AUTO)
        private Integer id;
        private String sysUserName;
        private String sysUserPwd;
        private String userPhone;
    
        @Override
        protected Serializable pkVal() {
            return this.id;
        }
    
    }

### serviceImpl ###

package com.ipzoe.ndk.service.impl;
    
    import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
    import com.baomidou.mybatisplus.core.toolkit.Wrappers;
    import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
    import com.ipzoe.ndk.domain.entity.AdminUser;
    import com.ipzoe.ndk.mapper.AdminUserMapper;
    import com.ipzoe.ndk.service.AdminUserService;
    import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
    import org.springframework.stereotype.Service;
    
    
    @Service
    public class AdminUserServiceImpl extends ServiceImpl<AdminUserMapper, AdminUser> implements AdminUserService {
    
        @Override
        public Object getList() {
            return AdminUser.INSTANCE.selectList(Wrappers.<AdminUser>query().orderByDesc("id"));
        }
    }

## 其他的都在实体类继承的      Model<实体>中 ##

方法可以自己看，欢迎补充