package?com.cdd.derive;

import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.sql.Statement;
import?java.util.ArrayList;
import?java.util.List;
public?class?DeriveTable?{
????private?Connection?conn?;???//定義Connection對象
????public?Connection?getConn（）?{
????????try?{
????????????Class.forName（“net.sourceforge.jtds.jdbc.Driver“）;?//?加載數據庫驅動
????????}?catch?（ClassNotFoundException?e）?{
????????????e.printStackTrace（）;
????????}
????????String?url?=?“jdbc:jtds:sqlserver://localhost:1433;DatabaseName=db_database23“;?//?連接數據庫URL
????????String?userName?=?“sa“;?//?連接數據庫的用戶名
????????String?passWord?=?““;?//?連接數據庫密碼
????????try?{
????????????conn?=?DriverManager.getConnection（url?userName?passWord）;?//?獲取數據庫連接
????????????
????????}?catch?（SQLException?e）?{
????????????e.printStackTrace（）;
????????}
????????return?conn;?//?返回Connection對象
????}????
????//定義用子查詢作為派生的表方法
????
????public?List

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件?????????289??2013-11-18?11:56??.classpath
?????文件?????????379??2010-09-10?15:23??.project
?????文件?????????629??2010-09-10?15:23??.settings\org.eclipse.jdt.core.prefs
?????文件????????2909??2013-11-21?08:42??bin\com\cdd\derive\DeriveTable.class
?????文件????????1488??2013-11-21?08:42??bin\com\cdd\derive\Emp.class
?????文件?????????762??2013-11-21?08:42??bin\com\cdd\derive\FullMessage$1.class
?????文件?????????732??2013-11-21?08:42??bin\com\cdd\derive\FullMessage$2.class
?????文件????????3452??2013-11-21?08:42??bin\com\cdd\derive\FullMessage.class
?????文件?????????972??2013-11-21?08:42??bin\com\cdd\derive\LocalTableModel.class
?????文件?????????762??2013-11-21?08:42??bin\com\cdd\derive\Mostlyframe$1.class
?????文件????????2570??2013-11-21?08:42??bin\com\cdd\derive\Mostlyframe.class
?????文件?????????907??2013-11-21?08:42??bin\com\cdd\derive\MostlyModel.class
?????文件??????294726??2013-11-18?10:46??lib\jtds-1.2.2.jar
?????文件????????3022??2010-09-10?15:23??src\com\cdd\derive\DeriveTable.java
?????文件????????1074??2010-09-10?15:23??src\com\cdd\derive\Emp.java
?????文件????????2885??2010-09-10?15:23??src\com\cdd\derive\FullMessage.java
?????文件?????????673??2010-09-10?15:23??src\com\cdd\derive\LocalTableModel.java
?????文件????????2086??2010-09-10?15:23??src\com\cdd\derive\Mostlyframe.java
?????文件?????????587??2010-09-10?15:23??src\com\cdd\derive\MostlyModel.java