From d57fc1094625792b20d5ec713bcf9dfb1901ed68 Mon Sep 17 00:00:00 2001
From: fwq <582742538@qq.com>
Date: 星期五, 01 九月 2023 10:17:15 +0800
Subject: [PATCH] 增加Excel解析不为空的校验
---
src/main/java/com/hx/common/service/impl/CommonDaoImpl.java | 41 +++++++++++++++++++++++++++++++++--------
1 files changed, 33 insertions(+), 8 deletions(-)
diff --git a/src/main/java/com/hx/common/service/impl/CommonDaoImpl.java b/src/main/java/com/hx/common/service/impl/CommonDaoImpl.java
index 4bc281b..8ccd28d 100644
--- a/src/main/java/com/hx/common/service/impl/CommonDaoImpl.java
+++ b/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.mybatisTool.SqlParam;
+import com.hx.common.dao.mapper.CommonMapper;
import com.hx.mybatisTool.SqlSentence;
import org.apache.ibatis.session.SqlSessionFactory;
import org.springframework.stereotype.Service;
@@ -29,10 +29,23 @@
return sqlSessionFactory.openSession().insert(getStatement(mapperClass,"insert"),entity);
}
- /**鑾峰彇鏉℃暟*/
@Override
- public <T extends Serializable> int selectCount(Class<?> mapperClass,SqlParam sqlParam) {
- return sqlSessionFactory.openSession().selectOne(getStatement(mapperClass,"selectCount"),sqlParam);
+ public <T extends Serializable> int insertById(Class<?> mapperClass, T entity) {
+ return sqlSessionFactory.openSession().insert(getStatement(mapperClass,"insertById"),entity);
+ }
+
+ /**鑾峰彇鏉℃暟
+ * @return*/
+ @Override
+ public <T extends Serializable> int selectCount(Class<?> mapperClass, SqlSentence sqlSentence) {
+ return sqlSessionFactory.openSession().selectOne(getStatement(mapperClass,"selectCount"),sqlSentence);
+ }
+
+ /**鑾峰彇鏉℃暟
+ * @return*/
+ @Override
+ public <T extends Serializable> int selectCountSql(Class<?> mapperClass, SqlSentence sqlSentence) {
+ return sqlSessionFactory.openSession().selectOne(getStatement(mapperClass,"selectCountSql"),sqlSentence);
}
/**鑾峰彇鍒楄〃*/
@@ -73,8 +86,8 @@
/**鏇存柊*/
@Override
- public <T extends Serializable> int updateWhere(Class<?> mapperClass,SqlParam sqlParam) {
- return sqlSessionFactory.openSession().update(getStatement(mapperClass,"updateWhere"),sqlParam);
+ public <T extends Serializable> int updateWhere(Class<?> mapperClass,SqlSentence sqlSentence) {
+ return sqlSessionFactory.openSession().update(getStatement(mapperClass,"updateWhere"),sqlSentence);
}
/**鍏ㄩ儴瀛楁鏇存柊*/
@@ -85,8 +98,8 @@
/**鍒犻櫎*/
@Override
- public <T extends Serializable> int deleteWhere(Class<?> mapperClass,SqlParam sqlParam) {
- return sqlSessionFactory.openSession().delete(getStatement(mapperClass,"deleteWhere"),sqlParam);
+ public <T extends Serializable> int deleteWhere(Class<?> mapperClass,SqlSentence sqlSentence) {
+ return sqlSessionFactory.openSession().delete(getStatement(mapperClass,"deleteWhere"),sqlSentence);
}
/**鍒犻櫎*/
@@ -95,4 +108,16 @@
return sqlSessionFactory.openSession().delete(getStatement(mapperClass,"deleteById"),object);
}
+ /**鏇存柊sql璇彞锛堝叏璇彞锛�*/
+ @Override
+ public <T extends Serializable> int updateSentence(SqlSentence 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);
+ }
+
}
--
Gitblit v1.8.0