package day02;

import java.sql.*;
public class Lab8 {

	public static void main(String[] args) {
		Connection con  = null;
		PreparedStatement ps = null;
		ResultSet rs = null;
		if(args.length!=1){
			System.out.println("Usage: jdbc day02.Lab8"+"tablename");
			return ;
		}
		String sql = null;
		sql = "select * from "+args[0];
		try{
			con = JdbcUtil.getConnection();
			ps = con.prepareStatement(sql);
			rs = ps.executeQuery();
			ResultSetMetaData md = rs.getMetaData();
			//讀取字段個數
			int colnum = md.getColumnCount();
			StringBuffer sb = new StringBuffer();
			for(int i=1;i<colnum;i++){
				sb.append(md.getColumnName(i));//獲得指定列的列名
				sb.append("->"+md.getColumnType(i)+"	");//獲得指定列的數據類型
				sb.append(md.getColumnTypeName(i)+"\n");
			}
			int id = 0;
			String name = null;
			while(rs.next()){
				for(int i=1;i<colnum;i++){
					id = rs.getInt(1);
					name = rs.getString(2);
					sb.append("id = " + id);
					sb.append("	name = " + name + "\n");
				}
				sb.append("\n");
			}
			System.out.println(sb.toString());
			System.out.println(md.getColumnTypeName(1));
			System.out.println(md.getColumnType(1));
		}catch(Exception e){
			e.printStackTrace();
		}
	}

}