?主要功能介紹:本寵物領(lǐng)養(yǎng)系統(tǒng)主要用于寵物領(lǐng)養(yǎng),此外,還具備了寵物周邊商城購買的功能。主要通過管理員和用戶來進(jìn)行寵物領(lǐng)養(yǎng)。針對待領(lǐng)養(yǎng)的寵物數(shù)據(jù),系統(tǒng)主要需要記錄寵物信息、寵物領(lǐng)養(yǎng)數(shù)據(jù)等等。系統(tǒng)使用B/S架構(gòu)技術(shù)去實現(xiàn),以MVC模式開發(fā)整個Web應(yīng)用。寵物信息則是使用MySQL數(shù)據(jù)庫存儲。系統(tǒng)共由管理員、用戶組成。其中管理員具有最高權(quán)限,能夠查看平臺的所有數(shù)據(jù)。用戶使用,主要是查看自己需要的寵物,并可以提交領(lǐng)養(yǎng)信息。除了寵物領(lǐng)養(yǎng)模塊,本系統(tǒng)還具備寵物周邊商城購買功能。對于寵物日用品、寵物零食等都可以通過該系統(tǒng)進(jìn)行購買。用戶能夠提交購買訂單,并由管理員發(fā)貨。
項目類型:JavaWeb源碼?
用戶類型:2個角色(管理員+用戶)
主要技術(shù):Jsp+Servlet+MySQL+Jquery(前端Bootstrap)
開發(fā)工具:Eclipse/Idea均可使用,有兩個不同的版本
數(shù)據(jù)庫:MySQL
數(shù)據(jù)庫表:8張
??演示視頻在底部??
??文末獲取聯(lián)系??
目錄
01管理員功能
1.0用戶管理模塊
1.1寵物類別管理模塊
1.2寵物信息管理模塊
1.3課程管理模塊
1.4寵物商品管理模塊
1.5周邊商場訂單管理模塊
1.6寵物領(lǐng)養(yǎng)管理模塊
1.7評論管理模塊
02用戶端
2.1?用戶端首頁
2.2寵物搜索頁面
2.3寵物領(lǐng)養(yǎng)頁面
2.4周邊商城
2.5領(lǐng)養(yǎng)記錄模塊
2.6商城訂單模塊
2.7評論模塊
03項目結(jié)構(gòu)
04數(shù)據(jù)庫設(shè)計
05演示視頻
01管理員功能
1.0用戶管理模塊
1.1寵物類別管理模塊
1.2寵物信息管理模塊
1.3課程管理模塊
1.4寵物商品管理模塊
1.5周邊商場訂單管理模塊
1.6寵物領(lǐng)養(yǎng)管理模塊
1.7評論管理模塊
02用戶端
2.1?用戶端首頁
2.2寵物搜索頁面
2.3寵物領(lǐng)養(yǎng)頁面
2.4周邊商城
2.5領(lǐng)養(yǎng)記錄模塊
2.6商城訂單模塊
2.7評論模塊
03項目結(jié)構(gòu)
04數(shù)據(jù)庫設(shè)計
文章來源:http://www.zghlxwxcb.cn/news/detail-761685.html
05演示視頻
【原創(chuàng)】基于JavaWeb的寵物領(lǐng)養(yǎng)系統(tǒng)文章來源地址http://www.zghlxwxcb.cn/news/detail-761685.html
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for admin
-- ----------------------------
DROP TABLE IF EXISTS `admin`;
CREATE TABLE `admin` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
`nickname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '賬號',
`username` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '姓名',
`pwd` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '密碼',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of admin
-- ----------------------------
INSERT INTO `admin` VALUES (1, '超管', '1', '1');
-- ----------------------------
-- Table structure for category
-- ----------------------------
DROP TABLE IF EXISTS `category`;
CREATE TABLE `category` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '寵物類型id',
`cname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '類型名稱',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of category
-- ----------------------------
INSERT INTO `category` VALUES (1, '犬類');
INSERT INTO `category` VALUES (2, '貓科類');
INSERT INTO `category` VALUES (4, '倉鼠');
-- ----------------------------
-- Table structure for orders
-- ----------------------------
DROP TABLE IF EXISTS `orders`;
CREATE TABLE `orders` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '領(lǐng)養(yǎng)記錄id',
`uid` int(11) DEFAULT NULL COMMENT '領(lǐng)養(yǎng)人id',
`uname` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '領(lǐng)養(yǎng)人姓名',
`uphone` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '領(lǐng)養(yǎng)人手機',
`uaddress` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '領(lǐng)養(yǎng)人地址',
`pid` int(11) DEFAULT NULL COMMENT '寵物id',
`pname` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '寵物名稱',
`ctime` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '領(lǐng)養(yǎng)時間',
`state` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '審核狀態(tài)(0 待審核 1 同意領(lǐng)養(yǎng) 2 拒絕領(lǐng)養(yǎng))',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 41 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
-- ----------------------------
-- Records of orders
-- ----------------------------
INSERT INTO `orders` VALUES (37, 20, '1', '1', '1', 25, '4455', '2022-03-18 00:25', '2');
INSERT INTO `orders` VALUES (38, 20, '1', '1', '1', 25, '4455', '2022-03-18 00:26', '0');
INSERT INTO `orders` VALUES (39, 20, '狄', '18020187141', '123123', 30, '小黑黑1', '2022-11-10 20:10', '1');
INSERT INTO `orders` VALUES (40, 15, 'zhangsan5', '15526101205', '湖南長沙5', 29, '貓咪', '2023-08-08 20:44', '0');
-- ----------------------------
-- Table structure for payrecord
-- ----------------------------
DROP TABLE IF EXISTS `payrecord`;
CREATE TABLE `payrecord` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '購買訂單di',
`uid` int(11) DEFAULT NULL COMMENT '下單人id',
`pid` int(11) DEFAULT NULL COMMENT '商品id',
`ctime` varchar(222) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '下單時間',
`rno` varchar(222) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '訂單號',
`num` int(11) DEFAULT NULL COMMENT '數(shù)量',
`uname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '收件人姓名',
`phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '收件人手機',
`address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '收件人地址',
`pay` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '下單方式(1貨到付款,2支付寶,3微信)',
`state` int(255) DEFAULT NULL COMMENT '訂單狀態(tài)',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of payrecord
-- ----------------------------
INSERT INTO `payrecord` VALUES (7, 15, 3, '2023-08-08 20:37', '20230808203713839', 1, '張三', '18020185141', '南京', '微信支付', 0);
INSERT INTO `payrecord` VALUES (8, 15, 2, '2023-08-08 20:40', '20230808204006258', 2, '張三', '18020185141', '無錫', '微信支付', 0);
INSERT INTO `payrecord` VALUES (9, 15, 1, '2023-08-08 20:44', '20230808204420509', 3, '張三', '18020185141', '無錫', '微信支付', 1);
-- ----------------------------
-- Table structure for pet
-- ----------------------------
DROP TABLE IF EXISTS `pet`;
CREATE TABLE `pet` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '寵物id',
`name` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '寵物名稱',
`type` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '寵物類型',
`sex` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '寵物性別',
`birthday` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '寵物出生日期',
`photo` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '寵物圖片',
`state` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '領(lǐng)養(yǎng)狀態(tài)',
`ctime` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '錄入時間',
`detail` varchar(2555) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '寵物介紹',
`description` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '寵物描述',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 31 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
-- ----------------------------
-- Records of pet
-- ----------------------------
INSERT INTO `pet` VALUES (23, '小黑黑', '犬類', '公', '2022-6-7', '933d7f36-92db-46b0-8c04-fe44e463191f.png', '0', '2022-03-18 00:24', '小黑黑是一只拉布拉多的狗子,性格溫順,不到處拉屎!', '<p>小黑黑是一只拉布拉多的狗子,性格溫順,不到處拉屎!</p><p><img src=\"/pet/ueditor/jsp/upload/image/20221110/1668082051749041503.png\" title=\"1668082051749041503.png\" alt=\"18482c63-4c29-40d0-995d-7ed87c7f3a84.png\"/></p>');
INSERT INTO `pet` VALUES (24, '小黑黑', '犬類', '公', '2022-6-7', '933d7f36-92db-46b0-8c04-fe44e463191f.png', '0', '2022-03-18 00:24', '小黑黑是一只拉布拉多的狗子,性格溫順,不到處拉屎!', '<p>小黑黑是一只拉布拉多的狗子,性格溫順,不到處拉屎!</p><p><img src=\"/pet/ueditor/jsp/upload/image/20221110/1668082051749041503.png\" title=\"1668082051749041503.png\" alt=\"18482c63-4c29-40d0-995d-7ed87c7f3a84.png\"/></p>');
INSERT INTO `pet` VALUES (25, '小黑黑', '犬類', '公', '2022-6-7', '933d7f36-92db-46b0-8c04-fe44e463191f.png', '0', '2022-03-18 00:24', '小黑黑是一只拉布拉多的狗子,性格溫順,不到處拉屎!', '<p>小黑黑是一只拉布拉多的狗子,性格溫順,不到處拉屎!</p><p><img src=\"/pet/ueditor/jsp/upload/image/20221110/1668082051749041503.png\" title=\"1668082051749041503.png\" alt=\"18482c63-4c29-40d0-995d-7ed87c7f3a84.png\"/></p>');
INSERT INTO `pet` VALUES (26, '小黑黑', '犬類', '公', '2022-6-7', '933d7f36-92db-46b0-8c04-fe44e463191f.png', '0', '2022-11-09 17:25', '小黑黑是一只拉布拉多的狗子,性格溫順,不到處拉屎!', '<p>小黑黑是一只拉布拉多的狗子,性格溫順,不到處拉屎!</p><p><img src=\"/pet/ueditor/jsp/upload/image/20221110/1668082051749041503.png\" title=\"1668082051749041503.png\" alt=\"18482c63-4c29-40d0-995d-7ed87c7f3a84.png\"/></p>');
INSERT INTO `pet` VALUES (27, '咪咪', '犬類', '公', '2022-6-7', '2236f580-6e4b-49de-be9e-546591323b4d.jpeg', '0', '2022-11-09 17:26', '小黑黑是一只拉布拉多的狗子,性格溫順,不到處拉屎!', '<p>小黑黑是一只拉布拉多的狗子,性格溫順,不到處拉屎!</p><p><img src=\"/pet/ueditor/jsp/upload/image/20221110/1668082051749041503.png\" title=\"1668082051749041503.png\" alt=\"18482c63-4c29-40d0-995d-7ed87c7f3a84.png\"/></p>');
INSERT INTO `pet` VALUES (28, '虎子', '犬類', '公', '2022-6-7', '04ec8d4e-28a8-4e94-a362-2148a2d3456a.jpeg', '0', '2022-11-09 17:26', '小黑黑是一只拉布拉多的狗子,性格溫順,不到處拉屎!', '<p>小黑黑是一只拉布拉多的狗子,性格溫順,不到處拉屎!</p><p><img src=\"/pet/ueditor/jsp/upload/image/20221110/1668082051749041503.png\" title=\"1668082051749041503.png\" alt=\"18482c63-4c29-40d0-995d-7ed87c7f3a84.png\"/></p>');
INSERT INTO `pet` VALUES (29, '貓咪', '犬類', '公', '2022-6-7', '7b09562a-a39f-445c-abd5-fbd81086db6a.jpeg', '11', '2022-11-09 17:26', '小黑黑是一只拉布拉多的狗子,性格溫順,不到處拉屎!', '<p>小黑黑是一只拉布拉多的狗子,性格溫順,不到處拉屎!</p><p><img src=\"/pet/ueditor/jsp/upload/image/20221110/1668082051749041503.png\" title=\"1668082051749041503.png\" alt=\"18482c63-4c29-40d0-995d-7ed87c7f3a84.png\"/></p>');
INSERT INTO `pet` VALUES (30, '小黑黑1', '貓科類', '公', '2022-6-7', '9953cb99-77b4-4fa4-a494-167659522d91.jpeg', '1', '2022-11-09 18:08', '小黑黑是一只拉布拉多的狗子,性格溫順,不到處拉屎!', '<p>小黑黑是一只拉布拉多的狗子,性格溫順,不到處拉屎!</p><p><img src=\"/pet/ueditor/jsp/upload/image/20221110/1668082051749041503.png\" title=\"1668082051749041503.png\" alt=\"18482c63-4c29-40d0-995d-7ed87c7f3a84.png\"/></p>');
-- ----------------------------
-- Table structure for pinglun
-- ----------------------------
DROP TABLE IF EXISTS `pinglun`;
CREATE TABLE `pinglun` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '評論id',
`order` int(11) DEFAULT NULL COMMENT '領(lǐng)養(yǎng)記錄id',
`content` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '評論內(nèi)容',
`pid` int(11) DEFAULT NULL COMMENT '對應(yīng)寵物id',
`pname` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '寵物名稱',
`uid` int(11) DEFAULT NULL COMMENT '領(lǐng)養(yǎng)人id',
`uname` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '領(lǐng)養(yǎng)人姓名',
`utime` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '發(fā)布時間',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 27 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
-- ----------------------------
-- Records of pinglun
-- ----------------------------
INSERT INTO `pinglun` VALUES (9, 5, '湖南長沙5', 4, '柯基貓', 15, 'zhangsan', '2022-03-12 14:31');
INSERT INTO `pinglun` VALUES (10, 5, '222', 4, '柯基貓', 15, 'zhangsan', '2022-03-12 21:45');
INSERT INTO `pinglun` VALUES (11, 13, '222', 6, '小六1', 18, '22', '2022-03-12 21:46');
INSERT INTO `pinglun` VALUES (12, 17, '123asdasd\nasdasd', 19, '444', 20, '1', '2022-03-13 11:34');
INSERT INTO `pinglun` VALUES (13, 17, '222', 19, '444', 20, '1', '2022-03-13 11:54');
INSERT INTO `pinglun` VALUES (14, 17, '333', 19, '444', 20, '1', '2022-03-13 11:55');
INSERT INTO `pinglun` VALUES (15, 17, '222', 19, '444', 20, '1', '2022-03-17 21:19');
INSERT INTO `pinglun` VALUES (16, 17, '2222', 19, '444', 20, '1', '2022-03-17 21:19');
INSERT INTO `pinglun` VALUES (17, 17, '111', 19, '444', 20, '1', '2022-03-17 21:19');
INSERT INTO `pinglun` VALUES (18, 21, '222', 22, '4444', 20, '1', '2022-03-17 22:41');
INSERT INTO `pinglun` VALUES (19, 21, '22222', 22, '4444', 20, '1', '2022-03-17 22:41');
INSERT INTO `pinglun` VALUES (20, 21, '3333', 22, '4444', 20, '1', '2022-03-17 22:41');
INSERT INTO `pinglun` VALUES (21, 38, '2020\n', 25, '4455', 20, '1', '2022-03-18 00:27');
INSERT INTO `pinglun` VALUES (22, 38, '222', 25, '4455', 20, '1', '2022-03-18 00:27');
INSERT INTO `pinglun` VALUES (23, 38, '444', 25, '4455', 20, '1', '2022-03-18 00:27');
INSERT INTO `pinglun` VALUES (24, 37, '20', 25, '4455', 20, '1', '2022-11-09 17:45');
INSERT INTO `pinglun` VALUES (25, 39, '123123', 30, '小黑黑1', 20, '狄', '2022-11-10 20:12');
INSERT INTO `pinglun` VALUES (26, 39, '可愛小狗', 30, '小黑黑1', 20, '狄', '2022-11-10 20:12');
-- ----------------------------
-- Table structure for product
-- ----------------------------
DROP TABLE IF EXISTS `product`;
CREATE TABLE `product` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '商品id',
`pname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '名稱',
`pid` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '類型,對應(yīng)寵物類型',
`price` double(10, 2) DEFAULT NULL COMMENT '價格',
`title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '標(biāo)題',
`detail` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '詳情',
`ctime` varchar(223) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '錄入時間',
`pno` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '商品編號',
`weight` double(22, 0) DEFAULT NULL COMMENT '重量',
`type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '包裝方式',
`img` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '圖片',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of product
-- ----------------------------
INSERT INTO `product` VALUES (1, '火腿腸', '1', 2.00, '4這是一件適用狗狗的用品4這是一件適用狗狗的用品4這是一件適用狗狗的用品4這是一件適用狗狗的用品4這是一件適用狗狗的用品4這是一件適用狗狗的用品', '<p>小黑黑是一只拉布拉多的狗子,性格溫順,不到處拉屎!</p><p><img src=\"/pet/ueditor/jsp/upload/image/20221110/1668082051749041503.png\" title=\"1668082051749041503.png\" alt=\"18482c63-4c29-40d0-995d-7ed87c7f3a84.png\"/></p>', '2022-11-09 23:55', 'A-002', 5, '2', '57cbdea3-b664-49b6-a1eb-1f9ba34a2bc2.jpg');
INSERT INTO `product` VALUES (2, '蘋果', '1', 3.00, '4這是一件適用狗狗的用品4這是一件適用狗狗的用品4這是一件適用狗狗的用品4這是一件適用狗狗的用品4這是一件適用狗狗的用品4這是一件適用狗狗的用品', '<p>小黑黑是一只拉布拉多的狗子,性格溫順,不到處拉屎!</p><p><img src=\"/pet/ueditor/jsp/upload/image/20221110/1668082051749041503.png\" title=\"1668082051749041503.png\" alt=\"18482c63-4c29-40d0-995d-7ed87c7f3a84.png\"/></p>', '2022-11-10 00:00', '002', 3, '盒', '34bde658-a5bd-4f2c-8086-853c1af77359.jpg');
INSERT INTO `product` VALUES (3, '貓用貓薄荷', '2', 4.00, '貓薄荷', '<p>小黑黑是一只拉布拉多的狗子,性格溫順,不到處拉屎!</p><p><img src=\"/pet/ueditor/jsp/upload/image/20221110/1668082051749041503.png\" title=\"1668082051749041503.png\" alt=\"18482c63-4c29-40d0-995d-7ed87c7f3a84.png\"/></p>', '2022-11-10 00:01', '001', 4, '顆', '528e2237-0ce6-4055-9c6f-06f51b215f98.jpeg');
-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '用戶id',
`realname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '用戶名',
`sex` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '用戶性別',
`phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '手機號',
`address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '住址',
`pwd` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '密碼',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 24 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES (15, 'zhangsan5', '男', '15526101205', '湖南長沙5', '123456');
INSERT INTO `user` VALUES (16, '李四', '男', '13397649345', '湖南長沙', '123123');
INSERT INTO `user` VALUES (17, '王五1', '男', '15526101203', '湖南長沙1', '123123');
SET FOREIGN_KEY_CHECKS = 1;
到了這里,關(guān)于【】JavaWeb的寵物領(lǐng)養(yǎng)系統(tǒng)(Web寵物領(lǐng)養(yǎng)系統(tǒng)畢業(yè)設(shè)計)的文章就介紹完了。如果您還想了解更多內(nèi)容,請在右上角搜索TOY模板網(wǎng)以前的文章或繼續(xù)瀏覽下面的相關(guān)文章,希望大家以后多多支持TOY模板網(wǎng)!