From f9de2fc8e297fa3ce8f5ecfe4ad54b883500556f Mon Sep 17 00:00:00 2001
From: java110 <928255095@qq.com>
Date: 星期五, 12 十一月 2021 19:31:45 +0800
Subject: [PATCH] 优化代码
---
java110-db/src/main/java/com/java110/db/dao/impl/QueryServiceDAOImpl.java | 27 ++++++++++++++++++++-------
1 files changed, 20 insertions(+), 7 deletions(-)
diff --git a/java110-db/src/main/java/com/java110/db/dao/impl/QueryServiceDAOImpl.java b/java110-db/src/main/java/com/java110/db/dao/impl/QueryServiceDAOImpl.java
index a31393c..b6ee535 100755
--- a/java110-db/src/main/java/com/java110/db/dao/impl/QueryServiceDAOImpl.java
+++ b/java110-db/src/main/java/com/java110/db/dao/impl/QueryServiceDAOImpl.java
@@ -1,20 +1,16 @@
package com.java110.db.dao.impl;
-import com.java110.utils.util.StringUtil;
import com.java110.core.base.dao.BaseServiceDao;
+import com.java110.db.dao.IQueryServiceDAO;
import com.java110.entity.order.ServiceBusiness;
import com.java110.entity.service.ServiceSql;
-import com.java110.db.dao.IQueryServiceDAO;
+import com.java110.utils.util.StringUtil;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
-import java.sql.Connection;
-import java.sql.PreparedStatement;
-import java.sql.ResultSet;
-import java.sql.ResultSetMetaData;
-import java.sql.SQLException;
+import java.sql.*;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
@@ -39,6 +35,18 @@
*/
@Override
public List<Map<String, Object>> executeSql(String sql, Object[] params) {
+ return executeSql(sql, params, null);
+ }
+
+ /**
+ * 闃叉sql娉ㄥ叆 鏀归�犳垚鐩存帴鐢╬repareStatement 棰勫鐞唖ql
+ *
+ * @param sql
+ * @param params
+ * @return
+ */
+ @Override
+ public List<Map<String, Object>> executeSql(String sql, Object[] params, List<String> columns) {
logger.debug("----銆恞ueryServiceDAOImpl.executeSql銆戝叆鍙� : " + sql + " params= " + params);
Connection conn = null;
ResultSet rs = null;
@@ -55,6 +63,11 @@
rs = ps.executeQuery();
//绮鹃珦鐨勫湴鏂瑰氨鍦ㄨ繖閲岋紝绫籖esultSet鏈塯etMetaData()浼氳繑鍥炴暟鎹殑鍒楀拰瀵瑰簲鐨勫�肩殑淇℃伅锛岀劧鍚庢垜浠皢鍒楀悕鍜屽搴旂殑鍊间綔涓簃ap鐨勯敭鍊煎瓨鍏ap瀵硅薄涔嬩腑...
ResultSetMetaData rsmd = rs.getMetaData();
+ if (columns != null) {
+ for (int i = 1; i < rsmd.getColumnCount(); ++i) {
+ columns.add(rsmd.getColumnLabel(i));
+ }
+ }
while (rs.next()) {
Map<String, Object> map = new HashMap<String, Object>();
for (int i = 0; i < rsmd.getColumnCount(); i++) {
--
Gitblit v1.8.0