package com.test;
import java.sql.*;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

public class Migration {


	

	public static void main(String args[]) {
		Connection con;
		Statement sql; // 聲明Statement對象
		ResultSet rs;
		try {
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		} catch (ClassNotFoundException e) {
			System.out.println("" + e);
		}
		try {
			con = DriverManager.getConnection("jdbc:odbc:testdb", "", "");
			sql = con.createStatement();
			rs = sql.executeQuery("Select * FROM Student");
			ResultSetMetaData data = rs.getMetaData();
			List<Map<String,Object>> list=new ArrayList<Map<String,Object>>(); 

			while (rs.next()) {
				Map<String,Object> map=new HashMap<String,Object>();//每行記錄放到一個
				for (int i = 1; i <= data.getColumnCount(); i++) 
				{					
					// 獲得指定列的列名
					String columnName = data.getColumnName(i);
					// 獲得指定列的列值
					String columnValue = rs.getString(i);
					// 獲得指定列的數據類型					
					System.out.println("獲得列" + i + "的字段名稱:" + columnName+ ",值為:"+columnValue);										
					map.put(columnName, columnValue); 
				}
				list.add(map); 
			}
			for(int j=0;j<list.size();j++)
			{
				Map dataMap=list.get(j);
				System.out.println("name:"+dataMap.get("name")+",sex:"+dataMap.get("sex")+",age:"+dataMap.get("age"));
			
			}
			
			con.close();
		}

		catch (SQLException el) {
			el.printStackTrace();

		}
	}
}