JavaWebDemo-增删改查.rar

/* Navicat Premium Data Transfer Source Server : MyJavaWebDemo1 Source Server Type : MySQL Source Server Version : 80022 Source Host : localhost:3306 Source Schema : javawebdemo1 Target Server Type : MySQL Target Server Version : 80022 File Encoding : 65001 Date: 15/03/2021 18:28:54 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for person -- ---------------------------- DROP TABLE IF EXISTS `person`; CREATE TABLE `person` ( `number` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `gender` tinyint NOT NULL, PRIMARY KEY (`number`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of person -- ---------------------------- INSERT INTO `person` VALUES ('A001', '小明', 1); INSERT INTO `person` VALUES ('A002', '小红', 0); INSERT INTO `person` VALUES ('A003', '小强', 1); INSERT INTO `person` VALUES ('A004', '张龙', 1); INSERT INTO `person` VALUES ('A005', '赵虎', 1); INSERT INTO `person` VALUES ('A006', '小丽', 0); INSERT INTO `person` VALUES ('A007', '乔峰', 1); SET FOREIGN_KEY_CHECKS = 1;