从ResultSet中取值

ResultSet rs = st.executeQuery(sql);
ResultSetMetaData metaData = rs.getMetaData();//获取键名
int columnCount = metaData.getColumncount();//获取键值
StringBuffer sbf = new StringBuffer();
while(rs.next){
	for(int i = 1;i<=columnCount;i++){
		String str = rs.getString();
		sbf.append(metaData.getColumnName(i)+";"+str+",")
	}
}
sbf =  sbf.substring(0,sbf.lastIndexof(","));

也可以放进map中