脚手架搭建之 集成通用mapper

1.引入 通用mapper

   		<dependency>
            <groupId>tk.mybatis</groupId>
            <artifactId>mapper-spring-boot-starter</artifactId>
            <version>2.1.5</version>
        </dependency>

2.配置 通用mapper

mapper:
  style: normal
  enum-as-simple-type: true
  identity: MYSQL
  check-example-entity-class: true

3. 通用mapper 公共方法抽取

AbstractBaseMapper.java

@RegisterMapper
public interface AbstractBaseMapper<T extends BaseEntity<Long>> extends BaseMapper<T>, ConditionMapper<T>, InsertListMapper<T>, IdsMapper<T> {
}

BaseService.java

public interface BaseService<T extends BaseEntity<Long>> {

    void save(T model);//持久化

    void save(List<T> models);//批量持久化

    void deleteById(Long id);//通过主鍵刪除

    void deleteByIds(String ids);//批量刪除 eg：ids -> “1,2,3,4”

    void update(T model);//更新

    T findById(Long id);//通过ID查找

    T findBy(String fieldName, Object value) throws TooManyResultsException; //通过Model中某个成员变量名称（非数据表中column的名称）查找,value需符合unique约束

    List<T> findByIds(String ids);//通过多个ID查找//eg：ids -> “1,2,3,4”

    List<T> findByCondition(Condition condition);//根据条件查找

    List<T> findAll();//获取所有

    List<Map<String, Object>> query(String sql);

    long selectCount(T model);

    public List<T> findByObj(T model);
}

AbstractBaseServiceImpl.java

@Service
public abstract class AbstractBaseServiceImpl<T extends BaseEntity<Long>> implements BaseService<T> {

    @Autowired
    private AbstractBaseMapper<T> baseDao;

    @Autowired
    private JdbcTemplate jdbcTemplate;

    private final Class<T> modelClass;

    public AbstractBaseServiceImpl() {
        ParameterizedType pt = (ParameterizedType) this.getClass().getGenericSuperclass();
        modelClass = (Class<T>) pt.getActualTypeArguments()[0];
    }

    @Override
    public void save(T model) {
        this.baseDao.insert(model);
    }

    @Override
    public void save(List<T> models) {
        this.baseDao.insertList(models);
    }

    @Override
    public void deleteById(Long id) {
        this.baseDao.deleteByPrimaryKey(id);
    }

    @Override
    public void deleteByIds(String ids) {
        this.baseDao.deleteByIds(ids);
    }

    @Override
    public void update(T model) {
        this.baseDao.updateByPrimaryKeySelective(model);
    }

    @Override
    public T findById(Long id) {
        return this.baseDao.selectByPrimaryKey(id);
    }

    @Override
    public T findBy(String fieldName, Object value) throws TooManyResultsException {
        try {
            T model = modelClass.newInstance();
            Field field = modelClass.getDeclaredField(fieldName);
            field.setAccessible(true);
            field.set(model, value);
            return this.baseDao.selectOne(model);
        } catch (ReflectiveOperationException e) {
            throw new ServiceException(e.getMessage(), e);
        }
    }

    @Override
    public List<T> findByIds(String ids) {
        return this.baseDao.selectByIds(ids);
    }

    @Override
    public List<T> findByCondition(Condition condition) {
        return this.baseDao.selectByCondition(condition);
    }

    @Override
    public List<T> findAll() {
        return this.baseDao.selectAll();
    }

    @Override
    public List<Map<String, Object>> query(String sql) {
        return this.jdbcTemplate.queryForList(sql);
    }

    @Override
    public long selectCount (T model){
       return this.baseDao.selectCount(model);
    }

    @Override
    public List<T> findByObj(T model){
       return this.baseDao.select(model);
    }
}