“实训基地住宿管理”详细设计.docVIP

“实训基地住宿管理”详细设计 北京实训基地 文档修订记录 版本编号 说明 日期 变更人 批准日期 批准人 1.0 创建 2011.9.21 刘春阳 实体类（包entity） public class Building { private int id; private String name; private String location; private String describe; private boolean deleted; } public class Room { private int id; private String number; private int floor; private int bed_count; private Building building; private boolean deleted; } public class Student { private int id; private String number; private String name; private String id_card; private String gender; private Calendar birthday; private String mobile; private String email; private String qq; private Calendar createtime; private Class1 class1; } public class Live { private int id; private Room room; private Student student; private Calendar begintime; private Calendar endtime; } public class Grade { private int id; private String name; private Calendar starttime; private boolean deleted; } public class Class1 { private int id; private String name; private String major; private Grade grade; private boolean deleted; } public class Admin { private int id; private String loginname; private String password; private String name; private String id_card; private String gender; private Calendar birthday; private String mobile; private String email; private String qq; } 数据库 /* Navicat MySQL Data Transfer Source Server : localhost_3306 Source Server Version : 50143 Source Host : localhost:3306 Source Database : dormitory Target Server Type : MYSQL Target Server Version : 50143 File Encoding : 65001 Date: 2011-09-16 15:35:03 */ SET FOREIGN_KEY_CHECKS=0; -- -- Table structure for `admin` -- DROP TABLE IF EXISTS `admin`; CREATE TABLE `admin` ( `id` int(11) NOT NULL AUTO_INCREMENT, `loginname` varchar(255) DEFAULT NULL, `password` varchar(255) DEFAULT NULL, `name` varchar(255) DEFAULT NULL, `id_card` varchar(255) DEFAULT NULL, `gender` varchar(255) DEFAULT NULL, `birthday` date