增加Excel解析不为空的校验

fwq

2023-09-01 d57fc1094625792b20d5ec713bcf9dfb1901ed68

 src/main/java/com/hx/common/service/impl/CommonDaoImpl.java

@@ -1,7 +1,7 @@
package com.hx.common.service.impl;

import com.hx.common.dao.CommonDao;
import com.hx.common.dao.CommonMapper;
import com.hx.common.dao.mapper.CommonMapper;
import com.hx.mybatisTool.SqlSentence;
import org.apache.ibatis.session.SqlSessionFactory;
import org.springframework.stereotype.Service;
@@ -27,6 +27,11 @@
    @Override
    public <T extends Serializable> int insert(Class<?> mapperClass,T entity) {
        return sqlSessionFactory.openSession().insert(getStatement(mapperClass,"insert"),entity);
    }

    @Override
    public <T extends Serializable> int insertById(Class<?> mapperClass, T entity) {
        return sqlSessionFactory.openSession().insert(getStatement(mapperClass,"insertById"),entity);
    }

    /**获取条数
@@ -106,8 +111,13 @@
    /**更新sql语句（全语句）*/
    @Override
    public <T extends Serializable> int updateSentence(SqlSentence sqlSentence) {
        return sqlSessionFactory.openSession().delete(getStatement(CommonMapper.class,"updateSentence"),sqlSentence);
        return sqlSessionFactory.openSession().update(getStatement(CommonMapper.class,"updateSentence"),sqlSentence);
    }

    /**查询条数（全语句）*/
    @Override
    public <T extends Serializable> int selectCountSql(SqlSentence sqlSentence) {
        return sqlSessionFactory.openSession().selectOne(getStatement(CommonMapper.class,"selectCountSql"),sqlSentence);
    }

}