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;
	
	/**
	?*?構(gòu)造方法
	?*?@param?rs??ResultSet結(jié)果集
	?*/
	public?ResultSetTableModel（ResultSet?rs）?{
		this.rs?=?rs;
		
		try?{
			rsmd?=?rs.getmetaData（）;		//獲取ResultSet對(duì)象中列的類(lèi)型和屬性信息的對(duì)象		
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}
		
	}
	/**
	?*?重寫(xiě)getColumnName方法返回列名
	?*/
	public?String?getColumnName（int?c）?{
		try?{
			return?rsmd.getColumnName（c?+?1）;	//根據(jù)ResultSetmetaData對(duì)象獲取列名
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
			return?““;
		}
	}
	/**
	?*?	重寫(xiě)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;??
	}
	/**
	?*?	重寫(xiě)getRowCount方法返回行數(shù)
	?*/
	@Override
	public?int?getRowCount（）?{
		try?{
			rs.last（）;				//將光標(biāo)移動(dòng)到rs對(duì)象的最后一行
			return?rs.getRow（）;		//獲取rs當(dāng)前的行號(hào)返回
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
			return?0;
		}
		
	}
	/**
	?*?	重寫(xiě)getColumnCount方法返回列數(shù)
	?*/
	@Override
	public?int?getColumnCount（）?{
		try?{
			return?rsmd.getColumnCount（）;		//獲取結(jié)果集中的列數(shù)
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
			return?0;
		}
	}
	/**
	?*?	重寫(xiě)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;
	}
}

?屬性????????????大小?????日期????時(shí)間???名稱(chēng)
-----------?---------??----------?-----??----
?????目錄???????????0??2019-01-13?14:53??8002117022高彩麗\
?????文件???????88064??2019-01-02?23:08??8002117022高彩麗\8002117022高彩麗大作業(yè)任務(wù)書(shū).doc
?????文件??????569856??2019-01-04?17:13??8002117022高彩麗\8002117022高彩麗實(shí)驗(yàn)報(bào)告.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個(gè)文件信息