package?config;

public?class?GCON?{
????//數據庫連接信息
????public?static?final?String?DRIVER?=?“com.mysql.cj.jdbc.Driver“;

//????public?static?final?String?URL?=?“jdbc:mysql://localhost:3306/new?autoReconnect=true&useSSL=false&useUnicode=true&charaterEncoding=UTF“;
????public?static?final?String?URL=“jdbc:mysql://localhost:3306/new?useUnicode=true&characterEncoding=UTF-8&useSSL=false&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC“;
????//登錄時默認使用system用戶驗證登錄名與密碼是否正確
????public?static??String?USERNAME?=?“system“;

????public?static??String?PASSWORD?=?“1234“;

????public?static?final?String?SYSTEMUSERNAME?=?“system“;

????public?static?final?String?SYSTEMPASSWORD?=?“1234“;

????public?static?final?String?HOTELUSERNAME?=?“hotel“;

????public?static?final?String?HOTELPASSWORD?=?“1234“;

????public?static?int?status?=?1?;?//1是系統管理員??0?是賓館管理員;
????//訂單
????//查詢所有訂單信息
????public?static?final?String?SQL_ALL_ORDERS?=?“SELECT?*?FROM?orders“;
????//查詢管理員
????public?static?final?String?SQL_ALL_ADMINS?=?“SELECT?*?FROM?systemAdministrator“;

????//查詢所有房間
????public?static?final?String?SQL_ALL_ROOMS?=“SELECT?*?FROM?roomtypeandprice“?;

????public?static?final?String?SQL_ALL_WAITERS?=“SELECT?*?FROM?waiter“?;

????//查詢所有續費訂單
????public?static?final?String?SQL_ALL_TIME_EXTENSION_ORDERS?=?“SELECT?*?FROM?timeextension“;


????//----------------------jsp-----------------------//
????//客房管理
????public?static?final?String?SEARCH_ROOM?=?“1“;

????public?static?final?String?ADD_ROOM?=?“2“;

????public?static?final?String?EDIT_ROOM?=?“3“;

????public?static?final?String?DELETE_ROOM?=?“4“;

}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2018-04-18?08:05??databaseExper-hotelMaster-master\
?????目錄???????????0??2018-04-18?08:05??databaseExper-hotelMaster-master\.idea\
?????目錄???????????0??2018-04-18?08:05??databaseExper-hotelMaster-master\.idea\artifacts\
?????文件?????????281??2018-04-18?08:05??databaseExper-hotelMaster-master\.idea\artifacts\dbExper_war.xml
?????文件?????????794??2018-04-18?08:05??databaseExper-hotelMaster-master\.idea\artifacts\dbExper_war_exploded.xml
?????文件?????????626??2018-04-18?08:05??databaseExper-hotelMaster-master\.idea\compiler.xml
?????目錄???????????0??2018-04-18?08:05??databaseExper-hotelMaster-master\.idea\libraries\
?????文件?????????450??2018-04-18?08:05??databaseExper-hotelMaster-master\.idea\libraries\Maven__junit_junit_3_8_1.xml
?????文件?????????583??2018-04-18?08:05??databaseExper-hotelMaster-master\.idea\libraries\Maven__mysql_mysql_connector_java_8_0_8_dmr.xml
?????文件?????????288??2018-04-18?08:05??databaseExper-hotelMaster-master\.idea\libraries\tomcat.xml
?????文件?????????582??2018-04-18?08:05??databaseExper-hotelMaster-master\.idea\misc.xml
?????文件?????????254??2018-04-18?08:05??databaseExper-hotelMaster-master\.idea\modules.xml
?????文件?????????180??2018-04-18?08:05??databaseExper-hotelMaster-master\.idea\vcs.xml
?????文件?????????286??2018-04-18?08:05??databaseExper-hotelMaster-master\.idea\webContexts.xml
?????文件???????76339??2018-04-18?08:05??databaseExper-hotelMaster-master\.idea\workspace.xml
?????文件???????93492??2018-04-18?08:05??databaseExper-hotelMaster-master\PhysicalDataModel_1.pdb
?????文件???????93485??2018-04-18?08:05??databaseExper-hotelMaster-master\PhysicalDataModel_1.pdm
?????文件????????1399??2018-04-18?08:05??databaseExper-hotelMaster-master\dbExper.iml
?????目錄???????????0??2018-04-18?08:05??databaseExper-hotelMaster-master\out\
?????目錄???????????0??2018-04-18?08:05??databaseExper-hotelMaster-master\out\artifacts\
?????目錄???????????0??2018-04-18?08:05??databaseExper-hotelMaster-master\out\artifacts\dbExper_war_exploded\
?????目錄???????????0??2018-04-18?08:05??databaseExper-hotelMaster-master\out\artifacts\dbExper_war_exploded\meta-INF\
?????文件??????????83??2018-04-18?08:05??databaseExper-hotelMaster-master\out\artifacts\dbExper_war_exploded\meta-INF\MANIFEST.MF
?????文件????????1008??2018-04-18?08:05??databaseExper-hotelMaster-master\pom.xml
?????目錄???????????0??2018-04-18?08:05??databaseExper-hotelMaster-master\src\
?????目錄???????????0??2018-04-18?08:05??databaseExper-hotelMaster-master\src\config\
?????文件????????1770??2018-04-18?08:05??databaseExper-hotelMaster-master\src\config\GCON.java
?????目錄???????????0??2018-04-18?08:05??databaseExper-hotelMaster-master\src\display\
?????文件????????2005??2018-04-18?08:05??databaseExper-hotelMaster-master\src\display\ExtensionOrderView.java
?????文件?????????788??2018-04-18?08:05??databaseExper-hotelMaster-master\src\display\InComeView.java
?????文件????????2642??2018-04-18?08:05??databaseExper-hotelMaster-master\src\display\OrderView.java
............此處省略1623個文件信息