操作jdbc利用集合和反射对数据表中的记录进行遍历

private static List<Object> test8(String tabname, String clname)
			throws Exception {

		Class<?> cl = Class.forName(clname);
		Connection conn = getConnection();
		String sql = "select *from " + tabname;
		List<Object> list = new ArrayList<Object>();
		PreparedStatement ps = conn.prepareStatement(sql);
		ResultSet rs = ps.executeQuery();
		while (rs.next()) {
			Object obj = cl.newInstance();// 新建一个实例对象
			Field[] fl = cl.getDeclaredFields();// 获取userinfo的字段存进数组
			for (Field f : fl) {// 对字段进行遍历
				f.setAccessible(true);
				String name = f.getName();// 获取属性名字
				Object value = rs.getObject(name);// 根据属性名字获得表里面的值
				f.set(obj, value);// 设置字段的值
			}
			list.add(obj);// 遍历完一行记录，添加进一个对象，并添加进list集合
		}
		rs.close();
		ps.close();
		conn.close();
		return list;
	}

	private static Connection getConnection() throws Exception {
		// TODO Auto-generated method stub