图书馆管理系统Java源码+MySQl数据库

//创建users表 create table users(userid INT AUTO_INCREMENT primary key, username varchar(40), usersex varchar(40), userstudentid INT, usercollege varchar(40), userclassid varchar(40), userpassword varchar(40), usermail varchar(40), owe varchar(40)); //books表 create table books( bookid INT, bookname varchar(40), bookpress varchar(40), pressdate varchar(40), bookauthor varchar(40), bookcount INT, bookincount INT ); //创建borrowbooks create table borrowbooks( userid INT, bookid INT, bookname varchar(40), bookpress varchar(40), pressdate varchar(40), bookauthor varchar(40), bookstarttime varchar(40) ); //插入books表内容 insert into books values(101,'计算机组成原理','川大出版社','2005-03-19','张永强',3,3); insert into books values(102,'数据库','清华出版社','2007-10-04','周杰伦',2,2); insert into books values(103,'徐志摩诗集','永强出版社','2001-02-29','徐志摩',1,1); insert into books values(104,'高等数学','晶晶出版社','2008-04-01','周传雄',3,3); insert into books values(105,'中国历史','人民出版社','2010-01-01','温家宝',2,2); insert into books values(106,'盗梦空间','神话出版社','2010-02-25','mary',1,1);