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/CommonService.java | 42 ++++++++++++++++++++++++++++++++++-------- 1 files changed, 34 insertions(+), 8 deletions(-) diff --git a/src/main/java/com/hx/common/service/CommonService.java b/src/main/java/com/hx/common/service/CommonService.java index 94fbdd9..81e1adb 100644 --- a/src/main/java/com/hx/common/service/CommonService.java +++ b/src/main/java/com/hx/common/service/CommonService.java @@ -1,5 +1,4 @@ package com.hx.common.service; -import com.hx.mybatisTool.SqlParam; import com.hx.mybatisTool.SqlSentence; import java.io.Serializable; @@ -21,12 +20,27 @@ */ <T extends Serializable> int insert(Class<?> mapperClass, T entity); + /**鏂板锛岃繑鍥炰富閿� + * @param mapperClass mapper绫� + * @param entity 瀹炰綋绫� + * @return 鏉℃暟 + */ + <T extends Serializable> int insertById(Class<?> mapperClass, T entity); + /**鏌ヨ鏉℃暟 * @param mapperClass mapper绫� - * @param sqlParam 鏌ヨ鍙傛暟绫� + * @param sqlSentence 鏌ヨ鍙傛暟绫� * @return 杩斿洖鏉℃暟 */ - <T extends Serializable> int selectCount(Class<?> mapperClass, SqlParam sqlParam); + <T extends Serializable> int selectCount(Class<?> mapperClass, SqlSentence sqlSentence); + + /**鏌ヨ鏉℃暟 + * @param mapperClass mapper绫� + * @param sqlSentence 鏌ヨ鍙傛暟绫� + * @return 杩斿洖鏉℃暟 + */ + <T extends Serializable> int selectCountSql(Class<?> mapperClass, SqlSentence sqlSentence); + /**鏌ヨ鍒楄〃锛岃繑鍥炲疄浣撶被鐨凩ist * @param mapperClass mapper绫� @@ -72,10 +86,10 @@ /**鏇存柊锛岃繑鍥炴洿鏂版暟閲� * @param mapperClass mapper绫� - * @param sqlParam 鏌ヨ鍙傛暟绫� + * @param sqlSentence 鏌ヨ鍙傛暟绫� * @return 杩斿洖鏉℃暟 */ - <T extends Serializable> int updateWhere(Class<?> mapperClass, SqlParam sqlParam); + <T extends Serializable> int updateWhere(Class<?> mapperClass, SqlSentence sqlSentence); /**鏇存柊锛岃繑鍥炴洿鏂版暟閲� * @param mapperClass mapper绫� @@ -86,10 +100,10 @@ /**鍒犻櫎锛岃繑鍥炲垹闄ゆ暟閲� * @param mapperClass mapper绫� - * @param sqlParam 鏌ヨ鍙傛暟绫� + * @param sqlSentence 鏌ヨ鍙傛暟绫� * @return 杩斿洖鏉℃暟 */ - <T extends Serializable> int deleteWhere(Class<?> mapperClass, SqlParam sqlParam); + <T extends Serializable> int deleteWhere(Class<?> mapperClass, SqlSentence sqlSentence); /**鍒犻櫎锛岃繑鍥炲垹闄ゆ暟閲� * @param mapperClass mapper绫� @@ -97,5 +111,17 @@ * @return 杩斿洖鏉℃暟 */ <T extends Serializable> int deleteById(Class<?> mapperClass, Object object); - + + /**鏇存柊sql璇彞锛堝叏璇彞锛� + * @param sqlSentence 鏌ヨ鍙傛暟绫� + * @return 杩斿洖鏉℃暟 + */ + <T extends Serializable> int updateSentence(SqlSentence sqlSentence); + + /**鏌ヨ鏉℃暟璇彞锛堝叏璇彞锛� + * @param sqlSentence 鏌ヨ鍙傛暟绫� + * @return 杩斿洖鏉℃暟 + */ + <T extends Serializable> int selectCountSql(SqlSentence sqlSentence); + } \ No newline at end of file -- Gitblit v1.8.0