package?com.zzk;

import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.sql.Statement;
import?javax.swing.JOptionPane;

/**
?*?@author?張振坤
?*/
public?class?QueryResultSet?{
????/**
?????*?定義靜態語句塊，用于加載數據庫驅動
?????*/
????static?{
????????try?{
????????????Class.forName（“net.sourceforge.jtds.jdbc.Driver“）;?//?加載數據庫驅動
????????}?catch?（ClassNotFoundException?e）?{
????????????e.printStackTrace（）;
????????}
????}
????
????/**
?????*?獲得查詢結果集
?????*/
????public?static?ResultSet?gainRecord（）?{
????????Connection?conn?=?null;?//?聲明連接
????????Statement?st?=?null;?//?聲明Statement對象
????????ResultSet?rs?=?null;?//?聲明結果集對象
????????try?{
????????????String?url?=?“jdbc:jtds:sqlserver://localhost:1433/db_

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件?????????427??2010-08-31?15:24??.classpath
?????文件?????????379??2010-12-31?14:04??.project
?????文件?????????133??2011-01-30?10:43??程序使用說明.txt
?????文件?????????629??2010-08-31?14:53??.settings\org.eclipse.jdt.core.prefs
?????文件????????1912??2011-02-14?10:44??bin\com\zzk\QueryResultSet.class
?????文件????????1550??2011-02-14?10:44??bin\com\zzk\ReportToExcelframe.class
?????文件?????1048576??2011-01-04?16:44??database\db_database_Data.MDF
?????文件?????1048576??2011-01-04?16:44??database\db_database_Log.LDF
?????文件??????294726??2012-03-01?17:11??lib\jtds-1.2.2.jar
?????文件?????1428690??2008-10-19?12:45??lib\poi-3.2-FINAL-20081019.jar
?????文件????????1485??2010-10-14?13:17??src\com\zzk\QueryResultSet.java
?????文件????????5952??2010-10-16?13:43??src\com\zzk\ReportToExcelframe.java