From a1bdc450eabe8d9a342dc4a578e157b73fdabf29 Mon Sep 17 00:00:00 2001
From: chenjiahe <763432473@qq.com>
Date: 星期日, 08 十月 2023 11:41:27 +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