EasyUI+JavaWeb奖助学金管理系统[4]-项目构建

秒速五厘米 2022-12-22 06:23 140阅读 0赞

***[点此查看全部文字教程、视频教程、源代码][Link 1]***

### 本文目录 ###

*  1. 本章任务
 *  2. 构建数据库
 *  3. 构建项目
 *  4. 导入easyui
 *  5. 小结

# 1. 本章任务 #

本章实际构建数据库和Java Web项目。

# 2. 构建数据库 #

使用navicat连接mysql，构建名为scholar-system的数据库，并执行如下sql语句完成初始化。

-- ----------------------------
    -- Table structure for depart
    -- ----------------------------
    DROP TABLE IF EXISTS `depart`;
    CREATE TABLE `depart`  (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '机构名称',
      `type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '机构类型(school/college/class)',
      `parentId` int(255) NULL DEFAULT -1 COMMENT '上级机构',
      PRIMARY KEY (`id`) USING BTREE
    ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
    
    -- ----------------------------
    -- Table structure for flow
    -- ----------------------------
    DROP TABLE IF EXISTS `flow`;
    CREATE TABLE `flow`  (
      `id` int(11) NOT NULL,
      `studentId` int(11) NULL DEFAULT NULL,
      `studentName` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
      `projectId` int(11) NULL DEFAULT NULL,
      `projectName` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
      `content` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
      `classUserId` int(11) NULL DEFAULT NULL,
      `classAdvice` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
      `collegeUserId` int(11) NULL DEFAULT NULL,
      `collegeAdvice` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
      `schoolUserId` int(11) NULL DEFAULT NULL,
      `schoolAdvice` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
      `currentUserId` int(11) NULL DEFAULT NULL,
      `currentNode` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'class/college/shcool/success/return',
      PRIMARY KEY (`id`) USING BTREE
    ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
    
    -- ----------------------------
    -- Table structure for menu
    -- ----------------------------
    DROP TABLE IF EXISTS `menu`;
    CREATE TABLE `menu`  (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
      `path` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
      PRIMARY KEY (`id`) USING BTREE
    ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
    
    -- ----------------------------
    -- Table structure for project
    -- ----------------------------
    DROP TABLE IF EXISTS `project`;
    CREATE TABLE `project`  (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT 'award/help',
      `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '',
      `about` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '',
      PRIMARY KEY (`id`) USING BTREE
    ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
    
    -- ----------------------------
    -- Table structure for question
    -- ----------------------------
    DROP TABLE IF EXISTS `question`;
    CREATE TABLE `question`  (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `userId` int(11) NULL DEFAULT NULL,
      `userName` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
      `departId` int(11) NULL DEFAULT NULL,
      `departName` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
      `content` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
      `reply` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
      PRIMARY KEY (`id`) USING BTREE
    ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
    
    -- ----------------------------
    -- Table structure for rolemenu
    -- ----------------------------
    DROP TABLE IF EXISTS `rolemenu`;
    CREATE TABLE `rolemenu`  (
      `id` int(11) NOT NULL,
      `roleId` int(11) NULL DEFAULT NULL,
      `menuId` int(11) NULL DEFAULT NULL,
      PRIMARY KEY (`id`) USING BTREE
    ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
    
    -- ----------------------------
    -- Table structure for user
    -- ----------------------------
    DROP TABLE IF EXISTS `user`;
    CREATE TABLE `user`  (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `userName` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '',
      `loginName` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '',
      `password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '',
      `role` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT 'schoolmaster/collegemaster/classmaster/student',
      `departId` int(11) NULL DEFAULT -1,
      PRIMARY KEY (`id`) USING BTREE
    ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
    
    SET FOREIGN_KEY_CHECKS = 1;

# 3. 构建项目 #

使用eclipse创建名为scholar-system的`Dynamic Web Project`，并建立如下包：

1.  org.maoge.scholar.servlet包：存放serlvet
2.  org.maoge.scholar.utils包：存放工具类
3.  org.maoge.scholar.dao包：数据库操作类
4.  org.maoge.scholar.model包：存放数据库实体类

# 4. 导入easyui #

下载jquery版easyui，地址`https://www.jeasyui.cn/jeasyui/download/v16.php`。

下载解压后将所有文件拷贝到WebContent/easyui目录下备用。

# 5. 小结 #

大功告成，最后项目结构如下：

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dvc2hpc2FuZ3Nhbmc_size_16_color_FFFFFF_t_70_pic_center]

[Link 1]: https://studyingpanda.blog.csdn.net/article/details/105329926
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dvc2hpc2FuZ3Nhbmc_size_16_color_FFFFFF_t_70_pic_center]: /images/20221120/34246fe1b5c14f3590ec4cfe387ba062.png