package?flight.assist;

import?java.sql.*;
/**
?*?數(shù)據(jù)庫訪問輔助類，使用了Singleton軟件設(shè)計(jì)模式
?*/
public?class?DatabaseManager?{
??private?static?DatabaseManager?instance;
??private?Connection?con;
??private?ResultSet?rs;
??private?Statement?stmt;

??public?static?DatabaseManager?getInstance（）?{
????if?（instance?==?null）?{
??????instance?=?new?DatabaseManager（）;
????}
????return?instance;
??}

??private?DatabaseManager（）?{
????try?{
??????String?url?=?“jdbc:odbc:flight“;
??????Class.forName（“sun.jdbc.odbc.JdbcOdbcDriver“）;
??????con?=?DriverManager.getConnection（url）;
??????stmt?=?con.createStatement（ResultSet.TYPE_SCROLL_SENSITIVE
?????????????????????????????????ResultSet.CONCUR_UPDATABLE）;
????}
????catch?（SQLException?sqle）?{
??????System.out.println（sqle.toString（））;
????}
????catch?（ClassNotFoundException?cnfex）?{
??????cnfex.printStackTrace（）;
????}
??}

??public?ResultSet?getResult（String?strSQL）?{
????try?{
??????rs?=?stmt.executeQuery（strSQL）;
??????return?rs;
????}
????catch?（SQLException?sqle）?{
??????System.out.println（sqle.toString（））;
??????return?null;
????}

??}

??public?int?updateSql（String?strSQL）?{
????try?{
??????int?i?=?stmt.executeUpdate（strSQL）;
??????con.commit（）;
??????return?i;
????}
????catch?（SQLException?sqle）?{
??????System.out.println（sqle.toString（））;
??????return?-1;
????}
??}

??public?void?closeConnection（）?{
????try?{
??????con.close（）;
??????this.instance=null;
????}
????catch?（SQLException?sqle）?{
??????System.out.println（sqle.toString（））;
????}
??}
}

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----

?????文件???????6136??2006-03-08?17:26??FlightManagement\FlightManagement.jpx.local

?????文件???????2542??2006-02-27?19:28??FlightManagement\FlightManagement.jpx

?????文件???????3803??2006-03-07?18:46??FlightManagement\src\flight\assist\SeatInfo.java

?????文件???????1588??2006-03-07?18:06??FlightManagement\src\flight\assist\DatabaseManager.java

?????目錄??????????0??2006-02-27?19:10??FlightManagement\src\flight\assist

?????文件???????1183??2006-03-07?18:46??FlightManagement\src\flight\Main\Main.java

?????文件???????3774??2006-03-07?18:46??FlightManagement\src\flight\Main\Interface.java

?????目錄??????????0??2006-02-27?19:12??FlightManagement\src\flight\Main

?????文件???????8591??2006-03-07?18:46??FlightManagement\src\flight\manage\DeletePanel.java

?????文件???????7205??2006-03-07?18:46??FlightManagement\src\flight\manage\InsertPanel.java

?????文件???????7569??2006-03-07?17:55??FlightManagement\src\flight\manage\UpdatePanel.java

?????文件????????737??2006-03-07?18:46??FlightManagement\src\flight\manage\Management.java

?????文件???????3231??2006-03-07?17:54??FlightManagement\src\flight\manage\FlightList.java

?????目錄??????????0??2006-02-27?19:12??FlightManagement\src\flight\manage

?????文件???????7040??2006-03-07?18:46??FlightManagement\src\flight\query\CommonQuery.java

?????文件??????11469??2006-03-07?18:46??FlightManagement\src\flight\query\ComprehenQuery.java

?????文件????????504??2006-03-07?18:46??FlightManagement\src\flight\query\Query.java

?????文件???????2322??2006-03-07?18:19??FlightManagement\src\flight\query\ResultTable.java

?????目錄??????????0??2006-02-27?19:12??FlightManagement\src\flight\query

?????文件??????22267??2006-03-07?18:41??FlightManagement\src\flight\ticketbook\TicketBook.java

?????文件??????15795??2006-03-07?18:26??FlightManagement\src\flight\ticketbook\Clientframe.java

?????文件????????846??2006-03-07?17:57??FlightManagement\src\flight\ticketbook\BookInfo.java

?????目錄??????????0??2006-02-27?19:12??FlightManagement\src\flight\ticketbook

?????文件??????17663??2006-03-07?18:45??FlightManagement\src\flight\ticketrefund\TicketRefund.java

?????目錄??????????0??2006-02-27?19:12??FlightManagement\src\flight\ticketrefund

?????目錄??????????0??2006-02-27?19:09??FlightManagement\src\flight

?????目錄??????????0??2006-02-27?19:09??FlightManagement\src

?????文件???????5595??2006-03-07?18:46??FlightManagement\classes\package?cache\flight.Main.dep2

?????文件??????16574??2006-03-08?16:19??FlightManagement\classes\package?cache\flight.manage.dep2

?????文件???????5231??2006-02-27?20:55??FlightManagement\classes\package?cache\flight.tuipiao.dep2

............此處省略259個(gè)文件信息