/*
Navicat MySQL Data Transfer

Source Server         : zcc
Source Server Version : 50537
Source Host           : localhost:3306
Source Database       : school

Target Server Type    : MYSQL
Target Server Version : 50537
File Encoding         : 65001

Date: 2024-09-20 18:11:22
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for book
-- ----------------------------
DROP TABLE IF EXISTS `book`;
CREATE TABLE `book` (
  `bookId` int(11) NOT NULL AUTO_INCREMENT,
  `bookName` varchar(255) NOT NULL,
  `bookWriter` varchar(255) NOT NULL,
  `bookType` varchar(255) NOT NULL,
  PRIMARY KEY (`bookId`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of book
-- ----------------------------
INSERT INTO `book` VALUES ('2', '西游记2', '吴承恩2', '小说2');
INSERT INTO `book` VALUES ('3', '三国演义', '罗贯中', '小说');
INSERT INTO `book` VALUES ('4', '水浒传', '施耐庵', '小说');
INSERT INTO `book` VALUES ('5', '红楼梦', '曹雪芹1', '小说1');

-- ----------------------------
-- Table structure for student
-- ----------------------------
DROP TABLE IF EXISTS `student`;
CREATE TABLE `student` (
  `stuId` int(11) NOT NULL AUTO_INCREMENT,
  `stuName` varchar(255) NOT NULL,
  `stuSex` varchar(255) NOT NULL,
  `stuAge` int(11) NOT NULL,
  PRIMARY KEY (`stuId`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of student
-- ----------------------------
INSERT INTO `student` VALUES ('2', 'zcc', '男', '25');
INSERT INTO `student` VALUES ('3', '小陈', '女', '20');
INSERT INTO `student` VALUES ('4', '小周', '女', '22');
INSERT INTO `student` VALUES ('5', '德华', '女', '22');
INSERT INTO `student` VALUES ('6', '德华', '女', '22');

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `userId` int(11) NOT NULL AUTO_INCREMENT,
  `userName` varchar(255) NOT NULL,
  `passWord` varchar(255) NOT NULL,
  `realName` varchar(255) NOT NULL,
  PRIMARY KEY (`userId`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES ('2', 'lll', '123123', '李四');
INSERT INTO `user` VALUES ('3', 'xiaochen', '123456', '小陈');
INSERT INTO `user` VALUES ('4', 'xiaozhou', '123456', '小周');
INSERT INTO `user` VALUES ('5', 'kkk', '123456', '小康');