-
Library.zip下载
资源介绍
以下提供数据库建立文件
/*
Navicat MySQL Data Transfer
Source Server : localhost_3306
Source Server Version : 80013
Source Host : localhost:3306
Source Database : db_books
Target Server Type : MYSQL
Target Server Version : 80013
File Encoding : 65001
Date: 2018-12-21 12:55:28
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for tb_books-
-- ----------------------------
DROP TABLE IF EXISTS `tb_books`;
CREATE TABLE `tb_books` (
`ID` int(255) unsigned NOT NULL AUTO_INCREMENT,
`ISBN` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`book_name` varchar(255) DEFAULT NULL,
`book_price` decimal(10,2) DEFAULT NULL,
`book_author` varchar(255) DEFAULT NULL,
`published_house` varchar(255) DEFAULT NULL,
`book_category` varchar(255) DEFAULT NULL,
`borrower_name` varchar(255) DEFAULT NULL,
`borrower_phone` varchar(255) DEFAULT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
-- ----------------------------
-- Records of tb_books
-- ----------------------------
INSERT INTO `tb_books` VALUES ('1', '978-7-100-10618-4', 'Othello', '56.00', 'W. William Shakespeare', 'Shanghai World Book Publishing Company', 'G792', 'Mark', '13503383632');
INSERT INTO `tb_books` VALUES ('2', '978-7-111-29544-0', 'BBC Doctor Who: 12 Doctors, 12 Stories ，12 Postcards', '69.00', ' BBC', ' BBC', 'TP312', 'Mark', '13503383632');
INSERT INTO `tb_books` VALUES ('3', '978-7-115-21687-8', 'The Poetry of Pablo Neruda', '59.00', 'Pablo Neruda,Ilan Stavans,Firuz Kazemzadeh', ' FSG BOOKS', 'TP311.5', null, null);
INSERT INTO `tb_books` VALUES ('5', '978-7-300-11134-6', 'Cereal City Guide PARIS CITY GUIDE', '59.00', 'Rich Stapleton', ' Cereal Magazine', 'F830', null, null);
INSERT INTO `tb_books` VALUES ('6', '978-7-302-23755-6', 'Cereal City Guide Copenhagen CITY GUIDE', '36.00', ' Rich Stapleton', ' Cereal Magazine', 'TP312', null, null);
INSERT INTO `tb_books` VALUES ('7', '978-7-302-27544-2', 'George W. Bush And the Southern Takeover of American Politics', '29.00', 'Michael Lind', 'New America Books', 'TP312', null, null);
INSERT INTO `tb_books` VALUES ('8', '978-7-302-29391-0', 'How Liberals Hurt Those They Claim to Help', '34.50', 'Mona Charen', ' Sentinel', 'TP393.0', 'Mark', '13503383632');
INSERT INTO `tb_books` VALUES ('9', '978-7-5117-0157-2', 'Lincoln in the Bardo', '16.00', 'George Saunders', 'Bloomsbury Publishing PLC','I', null, null);
INSERT INTO `tb_books` VALUES ('10', '978-7-5327-5110-5', 'A Song of Ice and Fire Box Set', '58.00', 'George R. R. Martin',' HarperCollins UK','I', null, null);
INSERT INTO `tb_books` VALUES ('11', '978-7-5399-3321-4', 'The New World Champion Paper Airplane Book','28.50', 'John M. Collins',' Ten Speed Press', 'I207.23', null, null);
INSERT INTO `tb_books` VALUES ('23', '978-7-5399-5488-2', 'Introduction to Linear Algebra', '34.00', 'Gilbert Strang', ' Wellesley College', 'I', null, null);
-- ----------------------------
-- Table structure for tb_user
-- ----------------------------
DROP TABLE IF EXISTS `tb_user`;
CREATE TABLE `tb_user` (
`id` int(255) unsigned NOT NULL AUTO_INCREMENT,
`user` varchar(255) DEFAULT NULL,
`passwd` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
-- ----------------------------
-- Records of tb_user
-- ----------------------------
INSERT INTO `tb_user` VALUES ('1', 'root', 'root');