package?common_TableModel;

import?java.sql.ResultSet;
import?java.sql.ResultSetmetaData;
import?java.sql.SQLException;

import?javax.swing.table.AbstractTableModel;
/**
?*?繼承AbstractTableModel
?*?@author?GaoCaili
?*
?*/
public?class?ResultSetTableModel?extends?AbstractTableModel{
	private?ResultSet?rs;
	private?ResultSetmetaData?rsmd;
	
	/**
	?*?構造方法
	?*?@param?rs??ResultSet結果集
	?*/
	public?ResultSetTableModel（ResultSet?rs）?{
		this.rs?=?rs;
		
		try?{
			rsmd?=?rs.getmetaData（）;		//獲取ResultSet對象中列的類型和屬性信息的對象		
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}
		
	}
	/**
	?*?重寫getColumnName方法返回列名
	?*/
	public?String?getColumnName（int?c）?{
		try?{
			return?rsmd.getColumnName（c?+?1）;	//根據ResultSetmetaData對象獲取列名
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
			return?““;
		}
	}
	/**
	?*?	重寫getColumnClass方法返回每一列的.class文件
	?*/
	public?Class?getColumnClass（int?column）?{
	????Class?returnValue;??
	????if?（（column?>=?0）?&&?（column?	????	returnValue?=?getValueAt（0?column）.getClass（）;??		//獲取.class文件
	????}?else?{??
	????????returnValue?=?object.class;??
	????}??
	????return?returnValue;??
	}
	/**
	?*?	重寫getRowCount方法返回行數
	?*/
	@Override
	public?int?getRowCount（）?{
		try?{
			rs.last（）;				//將光標移動到rs對象的最后一行
			return?rs.getRow（）;		//獲取rs當前的行號返回
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
			return?0;
		}
		
	}
	/**
	?*?	重寫getColumnCount方法返回列數
	?*/
	@Override
	public?int?getColumnCount（）?{
		try?{
			return?rsmd.getColumnCount（）;		//獲取結果集中的列數
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
			return?0;
		}
	}
	/**
	?*?	重寫getValueAt方法返回?columnIndex?和?rowIndex?位置的單元格值
	?*/
	@Override
	public?object?getValueAt（int?rowIndex?int?columnIndex）?{
		try?{
			rs.absolute（rowIndex?+?1）;
			return?rs.getobject（columnIndex?+?1）;
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
			
		}
		return?null;
	}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2019-01-13?14:53??8002117022高彩麗\
?????文件???????88064??2019-01-02?23:08??8002117022高彩麗\8002117022高彩麗大作業任務書.doc
?????文件??????569856??2019-01-04?17:13??8002117022高彩麗\8002117022高彩麗實驗報告.doc
?????目錄???????????0??2019-01-03?14:45??8002117022高彩麗\common\
?????文件?????????474??2018-12-27?10:36??8002117022高彩麗\common\.classpath
?????文件?????????382??2018-12-27?10:30??8002117022高彩麗\common\.project
?????目錄???????????0??2019-01-03?14:45??8002117022高彩麗\common\.settings\
?????文件?????????642??2018-12-27?10:30??8002117022高彩麗\common\.settings\org.eclipse.jdt.core.prefs
?????目錄???????????0??2019-01-03?14:45??8002117022高彩麗\common\bin\
?????目錄???????????0??2019-01-03?14:45??8002117022高彩麗\common\bin\common_TableModel\
?????文件????????1934??2019-01-04?17:09??8002117022高彩麗\common\bin\common_TableModel\ResultSetTableModel.class
?????目錄???????????0??2019-01-03?14:45??8002117022高彩麗\common\bin\connection_database\
?????文件????????2407??2019-01-04?17:07??8002117022高彩麗\common\bin\connection_database\JDBCUtils.class
?????目錄???????????0??2019-01-03?14:45??8002117022高彩麗\common\lib\
?????文件?????1007505??2018-12-27?10:36??8002117022高彩麗\common\lib\mysql-connector-java-5.1.47-bin.jar
?????目錄???????????0??2019-01-03?14:45??8002117022高彩麗\common\src\
?????目錄???????????0??2019-01-03?14:45??8002117022高彩麗\common\src\common_TableModel\
?????文件????????2119??2019-01-04?17:09??8002117022高彩麗\common\src\common_TableModel\ResultSetTableModel.java
?????目錄???????????0??2019-01-03?14:45??8002117022高彩麗\common\src\connection_database\
?????文件????????2363??2019-01-04?17:07??8002117022高彩麗\common\src\connection_database\JDBCUtils.java
?????目錄???????????0??2019-01-03?14:45??8002117022高彩麗\teaching_aids_system?（student?version）\
?????文件?????????527??2019-01-02?15:39??8002117022高彩麗\teaching_aids_system?（student?version）\.classpath
?????文件?????????414??2019-01-02?13:25??8002117022高彩麗\teaching_aids_system?（student?version）\.project
?????目錄???????????0??2019-01-03?14:45??8002117022高彩麗\teaching_aids_system?（student?version）\.settings\
?????文件?????????642??2019-01-02?13:25??8002117022高彩麗\teaching_aids_system?（student?version）\.settings\org.eclipse.jdt.core.prefs
?????目錄???????????0??2019-01-03?14:45??8002117022高彩麗\teaching_aids_system?（student?version）\bin\
?????目錄???????????0??2019-01-03?14:45??8002117022高彩麗\teaching_aids_system?（student?version）\bin\chat\
?????目錄???????????0??2019-01-03?14:45??8002117022高彩麗\teaching_aids_system?（student?version）\bin\chat\bean\
?????文件????????1478??2019-01-04?17:03??8002117022高彩麗\teaching_aids_system?（student?version）\bin\chat\bean\ChatMethod.class
?????目錄???????????0??2019-01-03?14:45??8002117022高彩麗\teaching_aids_system?（student?version）\bin\chat\ui\
?????文件????????1251??2019-01-04?17:02??8002117022高彩麗\teaching_aids_system?（student?version）\bin\chat\ui\Chat$1.class
............此處省略160個文件信息