From d28ee263b8a6fb95c9fe2add2ec58b7561d3fee9 Mon Sep 17 00:00:00 2001
From: jialh <1972868360@qq.com>
Date: 星期一, 20 四月 2026 16:33:01 +0800
Subject: [PATCH] 水电话费
---
java110-db/src/main/java/com/java110/db/dao/impl/QueryServiceDAOImpl.java | 31 ++++++++++++++++++++++---------
1 files changed, 22 insertions(+), 9 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..924cf3d 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.entity.order.ServiceBusiness;
-import com.java110.entity.service.ServiceSql;
import com.java110.db.dao.IQueryServiceDAO;
+import com.java110.dto.system.ServiceBusiness;
+import com.java110.dto.system.ServiceSql;
+import com.java110.utils.util.StringUtil;
import org.slf4j.Logger;
-import org.slf4j.LoggerFactory;
+import com.java110.core.log.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 = 0; i < rsmd.getColumnCount(); i++) {
+ columns.add(rsmd.getColumnLabel(i+1));
+ }
+ }
while (rs.next()) {
Map<String, Object> map = new HashMap<String, Object>();
for (int i = 0; i < rsmd.getColumnCount(); i++) {
--
Gitblit v1.8.0