JDBC获取字段信息

public Map<String, Object> getDbTableData(Datasource datasource) throws ClassNotFoundException, SQLException {
		// TODO Auto-generated method stub
		JDBCMySql jdbc = new JDBCMySql();
		String sql = "SELECT * FROM " + datasource.getDatasourceName() + "." + datasource.getTableselect() + " LIMIT "
				+ datasource.getViewlines();
		Connection conn = jdbc.operateMySql(datasource);
		PreparedStatement ps = conn.prepareStatement(sql);
		Map<String, Object> result = new HashMap<>();
		List<List<String>> list = new ArrayList<List<String>>();
		List<String> listcoltype = new ArrayList<>();
		List<String> listcol = new ArrayList<>();
		// 结果集处理
		ResultSet rs = ps.executeQuery(sql);
		ResultSetMetaData md = rs.getMetaData(); // 获得结果集结构信息,元数据
		int columnCount = md.getColumnCount(); // 获得列数
		for (int i = 1; i <= columnCount; i++) {
			listcol.add(md.getColumnName(i));
		}
		for (int i = 1; i <= columnCount; i++) {
			listcoltype.add(md.getColumnTypeName(i));
		}
		list.add(listcol);
		while (rs.next()) {
			List<String> listevery = new ArrayList<>();
			for (int i = 1; i <= columnCount; i++) {
				if(rs.getObject(i)!=null){
					listevery.add(rs.getObject(i).toString());
				}else{
					listevery.add("");
				}
			}
			list.add(listevery);
		}
		ps.close();
		conn.close();
		result.put("result", list);
		result.put("listcoltype", listcoltype);
		return result;
	}