期末大作业-基于asp.net+mysql的图书管理系统源码.zip

/* Navicat MySQL Data Transfer Source Server : local Source Server Version : 50712 Source Host : localhost:3306 Source Database : bookims Target Server Type : MYSQL Target Server Version : 50712 File Encoding : 65001 Date: 2019-07-21 16:30:55 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for `address` -- ---------------------------- DROP TABLE IF EXISTS `address`; CREATE TABLE `address` ( `address_id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) DEFAULT NULL, `region` varchar(45) DEFAULT NULL, `name` varchar(45) DEFAULT NULL, PRIMARY KEY (`address_id`), UNIQUE KEY `addressid_UNIQUE` (`address_id`) ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of address -- ---------------------------- INSERT INTO `address` VALUES ('3', '1', '重庆市沙坪坝区', 'ffrrere'); INSERT INTO `address` VALUES ('4', '1', '重庆市南岸区', '222'); INSERT INTO `address` VALUES ('5', '1', '重庆市渝北区', '33'); -- ---------------------------- -- Table structure for `book` -- ---------------------------- DROP TABLE IF EXISTS `book`; CREATE TABLE `book` ( `book_id` int(11) NOT NULL AUTO_INCREMENT, `book_name` varchar(45) DEFAULT NULL, `book_author` varchar(45) DEFAULT NULL, `status` int(11) DEFAULT NULL, `book_price` varchar(45) DEFAULT NULL, `book_pic` varchar(100) DEFAULT NULL, PRIMARY KEY (`book_id`) ) ENGINE=InnoDB AUTO_INCREMENT=133 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of book -- ---------------------------- INSERT INTO `book` VALUES ('4', 'Java', 'joba', '0', '26.0', 'images/java.jpg'); INSERT INTO `book` VALUES ('7', 'JavaWeb', 'aa', '0', '31', 'images/javaweb.jpg'); INSERT INTO `book` VALUES ('8', 'Python', 'aaa', '0', '43', 'images/python.jpg'); INSERT INTO `book` VALUES ('10', 'C ', 'ss', '0', '53', 'images/c.jpg'); INSERT INTO `book` VALUES ('11', 'Asp.net', 'kk', '0', '52', 'images/asp.jpg'); INSERT INTO `book` VALUES ('13', '三国演义', '罗贯中', '0', '65', 'images/sanguoyanyi.jpg'); INSERT INTO `book` VALUES ('14', '西游记', '吴承恩', '1', '67', 'images/xiyouji.jpg'); INSERT INTO `book` VALUES ('15', '水浒传', '施耐庵', '1', '67', 'images/shuihuzhuan.png'); INSERT INTO `book` VALUES ('51', '白夜行', '东野圭吾', '1', '120', 'images/baiyexing.jpg'); INSERT INTO `book` VALUES ('52', '红楼梦', '曹雪芹', '1', '75', 'images/hongloumeng.jpg'); INSERT INTO `book` VALUES ('54', '三体', '刘慈欣', '1', '24', 'images/santi.jpg'); INSERT INTO `book` VALUES ('55', '梦里花落知多少', '三毛', '0', '12', 'images/sanmao.jpg'); INSERT INTO `book` VALUES ('56', '深入分析JavaWeb', '1', '1', '64', 'images/srfxJavaWeb.jpg'); INSERT INTO `book` VALUES ('121', '1', '1', null, '1', null); INSERT INTO `book` VALUES ('125', '2', '2', null, '2', null); INSERT INTO `book` VALUES ('127', '3', '3', null, '3', null); -- ---------------------------- -- Table structure for `cart` -- ---------------------------- DROP TABLE IF EXISTS `cart`; CREATE TABLE `cart` ( `id` int(11) NOT NULL AUTO_INCREMENT, `userid` int(11) DEFAULT NULL, `bookid` int(11) DEFAULT NULL, `addressid` int(11) DEFAULT NULL, `number` int(11) DEFAULT NULL, `state` int(11) DEFAULT NULL, `time` varchar(45) DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `id_UNIQUE` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of cart -- ---------------------------- -- ---------------------------- -- Table structure for `feedback` -- ---------------------------- DROP TABLE IF EXISTS `feedback`; CREATE TABLE `feedback` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(45) DEFAULT NULL, `content` varchar(45) DEFAULT NULL, `username` varchar(45) DEFAULT NULL, `time` varchar(45) DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `id_UNIQUE` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of feedback -- ---------------------------- INSERT INTO `feedback` VALUES ('1', '1', '1', '1', '1'); -- ---------------------------- -- Table structure for `file` -- ---------------------------- DROP TABLE IF EXISTS `file`; CREATE TABLE `file` ( `file_des` varchar(255) DEFAULT NULL, `file_name` varchar(255) DEFAULT NULL, `fileId` int(11) NOT NULL AUTO_INCREMENT, `file_url` varchar(255) DEFAULT NULL, PRIMARY KEY (`fileId`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of file -- ---------------------------- INSERT INTO `file` VALUES ('aaa', 'test.ppt', '1', 'D:\\backup\\study\\academic\\softwareTest\\SQA&ST1.pptx'); INSERT INTO `file` VALUES ('sasas', 'asas.docx', '3', 'D:\\backup\\study\\academic\\softwareTest\\SQA&ST1.pptx'); INSERT INTO `file` VALUES ('sasas', 'sasasa.text', '4', 'D:\\backup\\study\\academic\\softwareTest\\SQA&ST1.pptx'); -- ---------------------------- -- Table structure for `record` -- ---------------------------- DROP TABLE IF EXISTS `record`; CREATE TABLE `record` ( `record_Id` int(11) NOT NULL AUTO_INCREMENT, `book_id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `start_date` varchar(100) NOT NULL, `deadline` varchar(100) NOT NULL, PRIMARY KEY (`record_Id`) ) ENGINE=InnoDB AUTO_INCREMENT=162 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of record -- ---------------------------- INSERT INTO `record` VALUES ('148', '11', '700033', '2019年02月17日', '2019年03月19日'); INSERT INTO `record` VALUES ('149', '4', '700033', '2019年02月19日', '2019年03月21日'); INSERT INTO `record` VALUES ('150', '13', '700034', '2019年02月28日', '2019年03月30日'); INSERT INTO `record` VALUES ('151', '55', '700034', '2019年02月28日', '2019年03月30日'); INSERT INTO `record` VALUES ('152', '0', '700033', '2019-04-28', '2019-04-28'); INSERT INTO `record` VALUES ('153', '0', '700033', '2019-05-23', '2019-05-23'); INSERT INTO `record` VALUES ('154', '0', '700033', '2019-05-23', '2019-05-23'); INSERT INTO `record` VALUES ('155', '0', '700033', '2019-05-23', '2019-05-23'); INSERT INTO `record` VALUES ('156', '0', '700033', '2019-05-23', '2019-05-23'); INSERT INTO `record` VALUES ('157', '10', '700033', '2019-05-23', '2019-05-23'); INSERT INTO `record` VALUES ('158', '11', '700033', '2019-05-23', '2019-05-23'); INSERT INTO `record` VALUES ('159', '10', '700033', '2019-05-23', '2019-05-23'); INSERT INTO `record` VALUES ('160', '11', '700033', '2019-05-23', '2019-05-23'); INSERT INTO `record` VALUES ('161', '11', '700033', '2019-05-23', '2019-05-23'); -- ---------------------------- -- Table structure for `results` -- ---------------------------- DROP TABLE IF EXISTS `results`; CREATE TABLE `results` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(255) DEFAULT NULL, `content` longtext, `url` longtext, `word` varchar(255) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=648 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of results -- ---------------------------- INSERT INTO `results` VALUES ('382', 'hao123导航-上网从这里开始', '<div class=\"c-abstract\">\n hao\n <em>123</em>是汇集全网优质网址及资源的中文上网导航。及时收录影视、音乐、小说、游戏等分类的网址和内容,让您的网络生活更简单精彩。上网,从hao\n <em>123</em>开始。\n</div>', 'http://www.baidu.com/link?url=F0X-4YAmqsg51qbPWjvCvJltsGSCqHbQvAgIG2g21XjnZqjJlr2mZUB0DoYOAcM-', '123'); INSERT INTO `results` VALUES ('383', '123_百度文库', '<div class=\"c-abstract op_tieba2_container\"> \n <div>\n 共有\n <strong>1060000</strong>篇和\n <em>123</em>相关的文档。 \n </div> \n <div class=\"op_tieba2_tablinks_container c-row\"> \n <a title=\"\" href=\"http://www.baidu.com/link?url=CO5JK7Ag90NoGiEXCiKdL5iTuKO9ljoullswB3TjZtdoE1n1PxhXlXz4PeUyLHG-gpJpEPGEKVdY-FfsgDHqLTgMQ0gOT2Ywuh9egQuBygG\" target=\"_blank\">SOD123