package?com.test;

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

import?javax.swing.table.AbstractTableModel;

	public?class?Model?extends?AbstractTableModel?{

		Vector?rowData?colunNames;
		PreparedStatement?ps=null;
		Connection?ct=null;
		ResultSet?rs=null;
		
		public?void?init（String?sql）{	
			
			if（sql.equals（““））{
				sql=“select?*?from?stu“;
			}
			
			colunNames=new?Vector（）;
			colunNames.add（“編號“）;
			colunNames.add（“姓名“）;
			colunNames.add（“性別“）;
			colunNames.add（“年齡“）;
			colunNames.add（“特點“）;
			colunNames.add（“能力“）;
			
			rowData=new?Vector（）;
			try?{
				Class.forName（“com.microsoft.sqlserver.jdbc.SQLServerDriver“）;
				ct=DriverManager.getConnection（“jdbc:sqlserver://127.0.0.1:1433;DatabaseName=戰(zhàn)斗小組“?“sa“?“123456123“）;
				ps=ct.prepareStatement（sql）;
				rs=ps.executeQuery（）;
				
				while（rs.next（））{
				Vector?hang=new?Vector（）;
				hang.add（rs.getString（1））;
				hang.add（rs.getString（2））;
				hang.add（rs.getString（3））;
				hang.add（rs.getString（4））;
				hang.add（rs.getString（5））;
				hang.add（rs.getString（6））;
				
				rowData.add（hang）;
				}
			}
			catch（Exception?e）{
				e.printStackTrace（）;
				
			}finally{
				try{
					if（rs!=null）?rs.close（）;
					if（ps!=null）?ps.close（）;
					if（ct!=null）?ct.close（）;
					
				}catch（Exception?e）{
					e.printStackTrace（）;
				}
			}
			
			
		}
		
			public?Model（String?sql）{

				this.init（sql）;
		/*	colunNames=new?Vector（）;
			colunNames.add（“110“）;
			colunNames.add（“220“）;
			colunNames.add（“330“）;
			colunNames.add（“440“）;
			colunNames.add（“550“）;
			colunNames.add（“660“）;
			
			rowData=new?Vector（）;
			try?{
				Class.forName（“com.microsoft.sqlserver.jdbc.SQLServerDriver“）;
				ct=DriverManager.getConnection（“jdbc:sqlserver://127.0.0.1:1433;DatabaseName=D618“?“sa“?“123456123“）;
				ps=ct.prepareStatement（sql）;
				rs=ps.executeQuery（）;
				
				while（rs.next（））{
				Vector?hang=new?Vector（）;
				hang.add（rs.getString（1））;
				hang.add（rs.getString（2））;
				hang.add（rs.getString（3））;
				hang.add（rs.getString（4））;
				hang.add（rs.getString（5））;
				hang.add（rs.getString（6））;
				
				rowData.add（hang）;
				}
			}
			catch（Exception?e）{
				e.printStackTrace（）;
				
			}finally{
				try{
					if（rs!=null）?rs.close（）;
					if（ps!=null）?ps.close（）;
					if（ct!=null）?ct.close（）;
					
				}catch（Exception?e）{
					e.printStackTrace（）;
				}
			}
			*/
			
		}
		
		public?Model（）{

		this.init（““）;
		
		/*	colunNames=new?Vector（）;
			colunNames.add（“110“）;
			colunNames.add（“220“）;
			colunNames.add（“330“）;
			colunNames.add（“440“）;
			colunNames.add（“550“）;
			colunNames.add（“660“）;
			
			rowData=new?Vector（）;
			try?{
				Class.forName（“com.microsoft.sqlserver.jdbc.SQLServerDriver“）;
				ct=DriverManager.getConnection（“jdbc:sqlserver://127

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

?????文件????????422??2014-12-07?23:48??stu\.classpath

?????文件????????381??2014-12-07?23:48??stu\.project

?????文件????????670??2014-12-08?21:02??stu\.settings\org.eclipse.jdt.core.prefs

?????文件????????106??2014-12-08?21:02??stu\.settings\org.eclipse.ltk.core.refactoring.prefs

?????文件???????3043??2015-03-12?20:23??stu\bin\com\test\Model.class

?????文件???????1395??2015-03-12?20:23??stu\bin\com\test\test1.class

?????文件???????2886??2015-03-12?20:23??stu\bin\com\test\Test2.class

?????文件???????3718??2015-03-12?20:23??stu\bin\com\test\Test4.class

?????文件???????3042??2015-03-13?13:21??stu\bin\com\test1\setModel.class

?????文件???????4468??2015-03-13?13:14??stu\bin\com\test1\StuAdd.class

?????文件???????4966??2015-03-12?20:23??stu\bin\com\test1\Test3.class

?????文件????????243??2015-03-13?13:36??stu\readme.txt

?????文件???????4252??2014-12-10?23:22??stu\src\com\test\Model.java

?????文件????????856??2014-12-10?23:20??stu\src\com\test\test1.java

?????文件???????1647??2014-12-10?23:24??stu\src\com\test\Test2.java

?????文件???????2486??2014-12-10?23:24??stu\src\com\test\Test4.java

?????文件???????4254??2015-03-13?13:21??stu\src\com\test1\setModel.java

?????文件???????3245??2015-03-13?13:14??stu\src\com\test1\StuAdd.java

?????文件???????4330??2014-12-11?23:37??stu\src\com\test1\Test3.java

?????目錄??????????0??2015-03-13?13:23??stu\bin\com\test

?????目錄??????????0??2015-03-13?13:23??stu\bin\com\test1

?????目錄??????????0??2015-03-13?13:23??stu\src\com\test

?????目錄??????????0??2015-03-13?13:23??stu\src\com\test1

?????目錄??????????0??2015-03-13?13:23??stu\bin\com

?????目錄??????????0??2015-03-13?13:23??stu\src\com

?????目錄??????????0??2015-03-13?13:23??stu\.settings

?????目錄??????????0??2015-03-13?13:23??stu\bin

?????目錄??????????0??2015-03-13?13:23??stu\src

?????目錄??????????0??2015-03-13?13:24??stu

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

............此處省略2個文件信息