import?java.sql.*;
import?javax.swing.table.*;
public?class?ConnectDB?
{
	private?Connection?connection;
???	public?ConnectDB（String?driverString?url）?throws?ClassNotFoundExceptionSQLException
	{
????	this.connection=null;
????	Class.forName（driver）;
????	this.connection=DriverManager.getConnection（url）;
????}
????public?void?finalize（）?throws?SQLException
????{
????	connection.close（）;
????}
????public?int?dataUpdate（String?sql）?throws?SQLException
????{
????	Statement?statement=this.connection.createStatement（）;
????	int?result=statement.executeUpdate（sql）;
????	statement.close（）;
????	return?result;
????}
????public?int?select（String?sqlDefaultTableModel?dtm）throws?SQLException
????{
????	Statement?statement=this.connection.createStatement（）;
????	ResultSet?resultset=statement.executeQuery（sql）;
????	ResultSetmetaData?rsmd=resultset.getmetaData（）;
????	int?c=rsmd.getColumnCount（）;
????	int?r=0;
????	String?[]data=new?String[c];
????	while（resultset.next（））
????	{
????		for（int?i=0;i????		{
????			data[i]=resultset.getString（i+1）;
????			if（data[i]!=null）
????				data[i]=data[i].trim（）;
????		}
????		dtm.addRow（data）;
????		r++;
????	}
????	return?r;
????}
}

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

?????文件????????394??2010-12-28?11:59??試題管理系統\.project

?????文件???????1232??2010-12-28?23:08??試題管理系統\src\ConnectDB.java

?????文件??????31873??2011-01-04?09:22??試題管理系統\src\PaperSystem.java

?????文件??????26503??2011-01-04?09:22??試題管理系統\bin\PaperSystem.class

?????文件???????2242??2010-12-30?08:12??試題管理系統\bin\ConnectDB.class

?????文件????????629??2010-12-28?11:59??試題管理系統\.settings\org.eclipse.jdt.core.prefs

?????文件????????432??2010-12-28?12:01??試題管理系統\.classpath

?????文件???????4510??2011-01-02?23:40??試題管理系統\試題管理系統.sql

?????文件????????337??2011-01-04?09:20??試題管理系統\nullnull

?????文件?????????18??2010-12-28?12:03??試題管理系統\幫助.txt

?????文件????????300??2011-01-03?00:24??試題管理系統\試卷1.txt

?????文件????????337??2011-01-04?09:21??試題管理系統\試卷5.txt

?????目錄??????????0??2010-12-28?11:59??試題管理系統\src

?????目錄??????????0??2010-12-28?11:59??試題管理系統\bin

?????目錄??????????0??2010-12-28?11:59??試題管理系統\.settings

?????目錄??????????0??2010-12-28?11:59??試題管理系統

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

????????????????68807????????????????????16