3天用java 实现的图书管理系统 写的非常粗糙 可能会更新这个课设。。 大牛请绕道， 小白作品 Server version 5.7.26 MySQL Community Server (GPL)

mysql show tables; +-----------------------+ Tables_in_bookmanager +-----------------------+ admin
book
student
+-----------------------+ 3 rows in set (0.00 sec)

mysql desc admin - ; +-----------+--------------+------+-----+---------+-------+ Field Type Null Key Default Extra +-----------+--------------+------+-----+---------+-------+ ma_id varchar(100) NO PRI NULL
ma_name varchar(20) NO NULL
ma_pwd varchar(20) NO NULL
telnmuber varchar(40) NO NULL
sex varchar(2) YES NULL
+-----------+--------------+------+-----+---------+-------+ 5 rows in set (0.13 sec)

mysql desc book; +------------+--------------+------+-----+---------+-------+ Field Type Null Key Default Extra +------------+--------------+------+-----+---------+-------+ ISBN varchar(100) NO NULL
book_id varchar(20) NO PRI NULL
title varchar(20) NO NULL
type varchar(100) NO NULL
author varchar(100) NO NULL
press varchar(100) NO NULL
press_time varchar(100) NO NULL
price varchar(100) NO NULL
count varchar(100) NO NULL
+------------+--------------+------+-----+---------+-------+ 9 rows in set (0.14 sec)

mysql desc student; +------------+--------------+------+-----+---------+-------+ Field Type Null Key Default Extra +------------+--------------+------+-----+---------+-------+ stu_id varchar(100) NO PRI NULL
stu_pwd varchar(20) NO NULL
stu_name varchar(20) NO NULL
stu_sex varchar(20) NO NULL
faculites varchar(40) NO NULL
limit varchar(10) NO NULL
stu_number varchar(40) NO NULL
+------------+--------------+------+-----+---------+-------+ 7 rows in set (0.15 sec

java version 1.8.0_201