From cfaa0a74bf5a5f87c172f867f2a7371298f4c241 Mon Sep 17 00:00:00 2001
From: 18516761980 <4761516tqsxp>
Date: 星期五, 10 九月 2021 14:27:04 +0800
Subject: [PATCH] #
---
src/main/java/com/zy/common/service/erp/ErpSqlServer.java | 28 ++++++++++++++++++++++++++++
1 files changed, 28 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/zy/common/service/erp/ErpSqlServer.java b/src/main/java/com/zy/common/service/erp/ErpSqlServer.java
index 126c479..2cf48c9 100644
--- a/src/main/java/com/zy/common/service/erp/ErpSqlServer.java
+++ b/src/main/java/com/zy/common/service/erp/ErpSqlServer.java
@@ -2,9 +2,14 @@
import com.core.common.Cools;
import com.zy.common.properties.ErpDbProperties;
+import lombok.extern.slf4j.Slf4j;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
+import java.io.ByteArrayInputStream;
+import java.io.ByteArrayOutputStream;
+import java.io.ObjectInputStream;
+import java.io.ObjectOutputStream;
import java.sql.*;
import java.util.ArrayList;
import java.util.HashMap;
@@ -15,6 +20,7 @@
* 绠�鍗曟寔涔呭眰妗嗘灦
* Created by vincent on 2020/11/26
*/
+@Slf4j
@Service
public class ErpSqlServer {
@@ -61,11 +67,13 @@
/********************************* 鏍稿績灞� *********************************/
/*****************************************************************************/
+
private List<Map<String, Object>> executeQuery(String sql) {
try {
Connection conn = getConn();
pstm = conn.prepareStatement(sql);
rs = pstm.executeQuery();
+// List<Map<String, Object>> maps = convertList(rs);
return convertList(rs);
} catch (Exception e) {
e.printStackTrace();
@@ -82,6 +90,8 @@
return pstm.executeUpdate();
} catch (Exception e) {
e.printStackTrace();
+ log.error("鏇存柊ERP涓棿琛ㄥけ璐�===>>" + sql);
+ log.error("鏇存柊ERP涓棿琛ㄥけ璐�===>>" + e);
return 0;
} finally {
release();
@@ -133,10 +143,28 @@
if (conn != null) {
try {
conn.close();
+ conn = null;
} catch (SQLException e) {
e.printStackTrace();
}
}
}
+ /**
+ * 娣辨嫹璐�
+ */
+ public ArrayList deepClone(List list) throws Exception {
+ // 搴忓垪鍖�
+ ByteArrayOutputStream bos = new ByteArrayOutputStream();
+ ObjectOutputStream oos = new ObjectOutputStream(bos);
+
+ oos.writeObject(list);
+
+ // 鍙嶅簭鍒楀寲
+ ByteArrayInputStream bis = new ByteArrayInputStream(bos.toByteArray());
+ ObjectInputStream ois = new ObjectInputStream(bis);
+
+ return (ArrayList) ois.readObject();
+ }
+
}
--
Gitblit v1.9.1