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<实体>中
方法可以自己看,欢迎补充