JDBC-用元数据将结果集封装为List对象

package com.db;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ResourceBundle;
/**
 * @author 赵永恩
 * 模板类DBUtils
 */
public final class DBUtils {
	static ResourceBundle bundle = ResourceBundle.getBundle("DBConfig");//DBConfig.properties配置文件的名称
	private static String driver = bundle.getString("driver");
	private static String url = bundle.getString("url");
	private static String username = bundle.getString("user");
	private static String password = bundle.getString("password");

    private DBUtils() {
    }
    // 加载驱动
    static {
        try {
            Class.forName(driver);
        } catch (ClassNotFoundException e) {
            System.out.println("驱动加载出错!");
        }
    }
    // 获得连接
    public static Connection getConnection() throws SQLException {
        return DriverManager.getConnection(url, username, password);
    }
    // 释放连接
    public static void free(ResultSet rs, Statement st, Connection conn) {
        try {
            if (rs != null) {
                rs.close(); // 关闭结果集
            }
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            try {
                if (st != null) {
                    st.close(); // 关闭Statement
                }
            } catch (SQLException e) {
                e.printStackTrace();
            } finally {
                try {
                    if (conn != null) {
                        conn.close(); // 关闭连接
                    }
                } catch (SQLException e) {
                    e.printStackTrace();
                }
            }
        }
    }
}

package com.db;

import java.sql.Connection;
import java.sql.DatabaseMetaData;
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;
/**
 * 
 * @author 赵永恩 
 * MetaOper: 通过ResultSetMetaData元数据,设置灵活查询语句
 * 
 */
public class MetaOper {
    public static void main(String[] args) {
        DbMeta();
        List<Map<String, Object>> datas = read("select * from site");
        System.out.println("----------List数据返回------------");
        System.out.print(datas);
    }
    // 通过结果集元数据封装List结果集
    public static List<Map<String, Object>> read(String sql) {
        Connection conn = null;
        PreparedStatement ps = null;
        ResultSet rs = null;
        try {
            conn = DBUtils.getConnection();
            ps = conn.prepareStatement(sql);
            rs = ps.executeQuery();
            ResultSetMetaData rsmd = ps.getMetaData();
            // 取得结果集列数
            int columnCount = rsmd.getColumnCount();
            // 构造泛型结果集
            List<Map<String, Object>> datas = new ArrayList<Map<String, Object>>();
            Map<String, Object> data = null;
            // 循环结果集
            while (rs.next()) {
                data = new HashMap<String, Object>();
                // 每循环一条将列名和列值存入Map
                for (int i = 1; i < columnCount+1; i++) {
                    data.put(rsmd.getColumnLabel(i), rs.getObject(rsmd
                            .getColumnLabel(i)));
                }
                // 将整条数据的Map存入到List中
                datas.add(data);
            }
            return datas;
        } catch (Exception e) {
            throw new RuntimeException();
        } finally {
            DBUtils.free(rs, ps, conn);
        }
    }
    // 通过数据库元数据获得服务器信息
    public static void DbMeta() {
        Connection conn = null;
        try {
            conn = DBUtils.getConnection();
            DatabaseMetaData dbma = conn.getMetaData();
            System.out.println("----------数据库信息------------");
            System.out.println("数据库名称: " + dbma.getDatabaseProductName());
            System.out.println("驱动版本: " + dbma.getDriverVersion());
        } catch (Exception e) {
            throw new RuntimeException();
        }
    }
}

读取配置文件的就不上传了。

代码运行结果:
----------数据库信息------------
数据库名称: MySQL
驱动版本: mysql-connector-java-5.0.8 ( Revision: ${svn.Revision} )
----------List数据返回------------
[{lastname=啡, age=22, firstname=咖}, {lastname=434, age=25, firstname=ni }]

网上地址：
http://361324767.blog.163.com/blog/static/11490252520109261022774/