数据库连接工具将结果集封装成map或List<Map>

废话不说，直接上代码

import java.io.IOException;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.util.Properties;

/**
 * @author aionbo
 * @description 建立连接
 * @date  2017年12月11日  下午4:07:19
 */
public class DBUtil {

//  private static Properties properties = new Properties();
//  
//  static{
//      InputStream is = DBUtils.class.getResourceAsStream("/sys.properties");
//      try {
//          properties.load(is);
//      } catch (IOException e) {
//          e.printStackTrace();
//      }
//  }

    public static final String driverName = "com.mysql.jdbc.Driver";
    public static final String url = "jdbc:mysql://localhost:3306/wxss?useSSL=false&useUnicode=true&characterEncoding=utf8";
    public static final String username = "root";
    public static final String pwd = "123456";

    public static Connection getMysqlConnection(){
        Connection conn =null;
        try {
            Class.forName(driverName);
            conn = DriverManager.getConnection(url, username, pwd);
        } catch (Exception e) {
            e.printStackTrace();
        }
        return conn;
    }

}

查询封装数据

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;


/**
 * @author aionbo
 * @description 查询封装数据
 * @date  2017年12月11日  下午7:11:52
 */
public class BaseDao {

    /**
     * 获取list结果集
     * @param sql
     * @return
     */
    public static List<Map<String, Object>> findListBySql(String sql) {
        List<Map<String, Object>> list = new ArrayList<Map<String, Object>>();
        Connection connection = null;
        Statement st = null;
        ResultSet rs = null;
        try
        {
            connection = DBUtil.getMysqlConnection();
            st = connection.createStatement();
            rs = st.executeQuery(sql);
            ResultSetMetaData md = rs.getMetaData();
            int columnCount = md.getColumnCount();
            while (rs.next()) {
                Map<String, Object> rowData = new HashMap<String, Object>();
                for (int i = 1; i <= columnCount; i++) {
                    rowData.put(md.getColumnName(i), rs.getObject(i));
                }
                list.add(rowData);
            }
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            closeResources(rs,st,connection);
        }
        return list;
    }


    /**
     * 获取map结果集
     * @param sql
     * @return
     */
    public static Map<String, Object> findMapBySql(String sql) {
        Map<String, Object> map = new HashMap<>();
        Connection connection = null;
        Statement st = null;
        ResultSet rs = null;
        try {
            connection = DBUtil.getMysqlConnection();
            st = connection.createStatement();
            rs = st.executeQuery(sql);
            ResultSetMetaData md = rs.getMetaData();
            int columnCount = md.getColumnCount();
            while (rs.next()) {
                for (int i = 1; i <= columnCount; i++) {
                    map.put(md.getColumnName(i), rs.getObject(i));
                }
            }
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            closeResources(rs,st,connection);
        }
        return map;
    }

    public static void closeResources(ResultSet rs,Statement st,Connection connection)
    {
        try
        {
            if (rs != null)
            {
                rs.close();
            }
            if (st != null)
            {
                st.close();
            }
            if (connection != null)
            {
                connection.close();
            }
        }
        catch (SQLException e)
        {
            e.printStackTrace();
        }
    }


    public static void main(String[] args) {
        List<Map<String, Object>> list = BaseDao.findListBySql("select * from  user");
        System.out.println(list.get(1).get("name"));
    }

}