基于JSP的大学生宿舍管理系统

基于JSP的大学生宿舍管理系统 功能完善 很适合毕业党，可用做 毕业设计 或者是 期末作业 课程设计

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个文件信息