package?Graduate;
import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.util.Vector;

import?javax.swing.table.AbstractTableModel;

public?class?AccessModel?extends?AbstractTableModel{

	//定義操作數據庫
	private?String?sdbdriver?=?“sun.jdbc.odbc.JdbcOdbcDriver“;
	private?String?sconnstr?=?“jdbc:odbc:MyData“;
	private?Connection?con?=?null;
	private?ResultSet??rs??=?null;
	private?PreparedStatement?ps=?null?;
	Vector?rowDatacolumnNames;

	public?AccessModel（）
	{
		columnNames?=?new?Vector（）;
		rowData????=?new?Vector（）;
		//設置列名
		columnNames.add（“準考證號“）;
		columnNames.add（“考生姓名“）;
		columnNames.add（“報考年度“）;
		columnNames.add（“報考專業“）;
		columnNames.add（“是否應屆“）;
		columnNames.add（“政治“）;
		columnNames.add（“數學“）;
		columnNames.add（“英語“）;
		columnNames.add（“專業基礎課“）;
		try?
		{
			Class.forName（sdbdriver）;
			con?=?DriverManager.getConnection（sconnstr?“sa“?“Mother2008520“）;
			System.out.println（“鏈接數據庫成功！“）;
		
			ps?=?con.prepareStatement（“select?*?from?ExamStud“）;
			rs?=?ps.executeQuery（）;
			while（rs.next（））
			{
				Vector?v?=new?Vector（）;
				v.add（rs.getString（1））;
				v.add（rs.getString（2））;
				v.add（rs.getString（3））;
				v.add（rs.getString（4））;
				v.add（rs.getString（5））;
				v.add（rs.getString（6））;
				v.add（rs.getString（7））;
				v.add（rs.getString（8））;
				v.add（rs.getString（9））;
				rowData.add（v）;
			}
		}?
		catch?（ClassNotFoundException?e）?
		{
			System.err.println（“Class.forName（）:?“?+?e.getMessage（））;
		}?
		catch?（SQLException?e）
		{
			System.out.print（“數據庫鏈接失敗!“）;
			System.out.println（“getConnection（）:?“?+?e.getMessage（））;
		}	
		finally
		{
			try
			{
				if（rs?!=?null）?rs.close（）;
				if（ps?!=?null）?ps.close（）;
				if（con!=?null）?con.close（）;
			}
			catch（Exception?e）
			{
				e.getStackTrace（）;
			}
		}
	}

	@Override
	public?int?getRowCount（）?{
		return?this.rowData.size（）;
	}

	@Override
	public?int?getColumnCount（）{
		return?this.columnNames.size（）;
	}

	@Override
	//獲得
	public?object?getValueAt（int?rowIndex?int?columnIndex）?{
	
		return?（（Vector）this.rowData.get（rowIndex））.get（columnIndex）;
	}
	
	@Override
	//獲取每列的列名
	public?String?getColumnName（int?column）?{
		
		return?（String）this.columnNames.get（column）;
	}

}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件????????514??2014-05-13?00:28??PostGrad\.classpath

?????文件????????384??2014-05-13?00:27??PostGrad\.project

?????文件????????598??2014-05-13?00:27??PostGrad\.settings\org.eclipse.jdt.core.prefs

?????文件???????3852??2014-05-16?20:50??PostGrad\bin\Graduate\AccessModel.class

?????文件???????3694??2014-05-17?01:41??PostGrad\bin\Graduate\LevelModel.class

?????文件???????3805??2014-05-17?01:43??PostGrad\bin\Graduate\MsgModel.class

?????文件???????9537??2014-05-17?01:43??PostGrad\bin\Graduate\PostGrad.class

?????文件???????2457??2014-05-16?20:50??PostGrad\src\Graduate\AccessModel.java

?????文件???????2291??2014-05-17?01:41??PostGrad\src\Graduate\LevelModel.java

?????文件???????2444??2014-05-17?01:43??PostGrad\src\Graduate\MsgModel.java

?????文件???????9684??2014-05-17?01:43??PostGrad\src\Graduate\PostGrad.java

?????目錄??????????0??2014-05-17?19:42??PostGrad\bin\Graduate

?????目錄??????????0??2014-05-17?19:42??PostGrad\src\Graduate

?????目錄??????????0??2014-05-13?00:27??PostGrad\.settings

?????目錄??????????0??2014-05-14?22:20??PostGrad\bin

?????目錄??????????0??2014-05-13?00:27??PostGrad\src

?????目錄??????????0??2014-05-13?00:27??PostGrad

-----------?---------??----------?-----??----

????????????????39260????????????????????17