package com.yanshu.service;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import com.yanshu.util.JdbcUtil;
public class Test {
public static List<Map<String, Object>> queryAll(String sql,Map<Integer, Object> conditionMap){
Connection conn = null;
PreparedStatement pstmt = null;
ResultSet rs = null;
List<Map<String, Object>> resultList = new ArrayList<Map<String, Object>>();
try {
conn =JdbcUtil.getConn();
pstmt = conn.prepareStatement(sql);
if(conditionMap!=null&&conditionMap.size()!=0){
int paramNum = conditionMap.size();
for(int i=1;i<=paramNum;i++){
Object paramValue = conditionMap.get(i);
if("java.lang.Integer".equalsIgnoreCase(paramValue.getClass().getName())){
pstmt.setInt(i, Integer.parseInt(paramValue.toString()));
}else if("java.lang.String".equalsIgnoreCase(paramValue.getClass().getName())){
pstmt.setString(i, paramValue.toString());
}
}
}
rs = pstmt.executeQuery();
ResultSetMetaData rsmd = rs.getMetaData();
int columnNum = rsmd.getColumnCount();
while(rs.next()){
Map<String, Object> dataMap = new HashMap<String, Object>(0);
for(int i=1;i<=columnNum;i++){
dataMap.put(rsmd.getColumnName(i), rs.getObject(i));
}
resultList.add(dataMap);
}
} catch (Exception e) {
e.printStackTrace();
}finally{
}
return resultList;
}
public static void main(String[] args) {
String sql = "select * from emp";
List<Map<String, Object>> resultList = queryAll(sql, null);
System.out.println(resultList);
}
}
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import com.yanshu.util.JdbcUtil;
public class Test {
public static List<Map<String, Object>> queryAll(String sql,Map<Integer, Object> conditionMap){
Connection conn = null;
PreparedStatement pstmt = null;
ResultSet rs = null;
List<Map<String, Object>> resultList = new ArrayList<Map<String, Object>>();
try {
conn =JdbcUtil.getConn();
pstmt = conn.prepareStatement(sql);
if(conditionMap!=null&&conditionMap.size()!=0){
int paramNum = conditionMap.size();
for(int i=1;i<=paramNum;i++){
Object paramValue = conditionMap.get(i);
if("java.lang.Integer".equalsIgnoreCase(paramValue.getClass().getName())){
pstmt.setInt(i, Integer.parseInt(paramValue.toString()));
}else if("java.lang.String".equalsIgnoreCase(paramValue.getClass().getName())){
pstmt.setString(i, paramValue.toString());
}
}
}
rs = pstmt.executeQuery();
ResultSetMetaData rsmd = rs.getMetaData();
int columnNum = rsmd.getColumnCount();
while(rs.next()){
Map<String, Object> dataMap = new HashMap<String, Object>(0);
for(int i=1;i<=columnNum;i++){
dataMap.put(rsmd.getColumnName(i), rs.getObject(i));
}
resultList.add(dataMap);
}
} catch (Exception e) {
e.printStackTrace();
}finally{
}
return resultList;
}
public static void main(String[] args) {
String sql = "select * from emp";
List<Map<String, Object>> resultList = queryAll(sql, null);
System.out.println(resultList);
}
}