```
第一步
先写公共查询类
public static List executeQuery(String sql, Object[] params) {
List list = new ArrayList();
Connection conn = null;
PreparedStatement pstmt = null;
ResultSet rs = null;
try {
//连接数据库
conn = UtilDB.getConnection();
//创建预处理命令
pstmt = conn.prepareStatement(sql);
//为预处理命令设置参数
UtilDB.setParams(pstmt, params);
//执行查询
rs = pstmt.executeQuery();
//获取元数据
ResultSetMetaData metaData = rs.getMetaData();
//获取返回的结果集有多少列
int count = metaData.getColumnCount();
while (rs.next()) {
//声明map 存储一行的数据
Map map = new HashMap();
for (int i = 1; i <= count; i++) {
//获取列名 列名的下标从1 开始
// String columnName = metaData.getColumnName