android图书管理系统+javaweb后台服务器代码
代码就不贴了，可以自行下载
1.登陆界面
2.添加图书界面
3.查询图书界面
4.借书，还书，删除图书
5.个人借的书
6.数据库建表语句，有3张表
CREATE TABLE `book_man_sys_user` (
`id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`username` VARCHAR(50) NOT NULL,
`password` VARCHAR(50) NOT NULL,
`token` VARCHAR(50) NULL DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE INDEX `username` (`username`)
)
COLLATE='utf8_general_ci'
ENGINE=InnoDB
;
CREATE TABLE `book_man_sys_books` (
`id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`bookname` VARCHAR(50) NOT NULL,
`author` VARCHAR(50) NOT NULL,
`category` VARCHAR(50) NOT NULL,
`count` INT(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE INDEX `bookname` (`bookname`)
)
COLLATE='utf8_general_ci'
ENGINE=InnoDB
;
CREATE TABLE `book_man_sys_borrow` (
`id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`uname` VARCHAR(50) NOT NULL,
`bname` VARCHAR(50) NOT NULL,
`author` VARCHAR(50) NOT NULL,
`category` VARCHAR(50) NOT NULL,
`borrowtime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
)
COLLATE='utf8_general_ci'
ENGINE=InnoDB
;