JSP+Servlet+JavaBean编程

图书管理设计步骤: 1.设计数据库 1-1 设计用户表 CREATE TABLE USER( uid INT(11) PRIMARY KEY, uname VARCHAR(32) NOT NULL, upassword VARCHAR(32) NOT NULL ); //插入数据 INSERT INTO USER(uid,uname,upassword) VALUES(1,'陈明','123456'); INSERT INTO USER(uid,uname,upassword) VALUES(2,'刘洋','123456'); INSERT INTO USER(uid,uname,upassword) VALUES(3,'周岗涛','123456'); 1-2 设计图书表: CREATE TABLE book( bid INT(11) PRIMARY KEY, bname VARCHAR(32) NOT NULL, price VARCHAR(32) NOT NULL, publishTime DATE NOT NULL ); INSERT INTO book(bid,bname,price,publishTime) VALUES(1,'简爱','100','2018-4-10'); INSERT INTO book(bid,bname,price,publishTime) VALUES(2,'鲁兵逊漂流','80','2018-3-10'); INSERT INTO book(bid,bname,price,publishTime) VALUES(3,'心际关系心理学','60','2018-2-10'); INSERT INTO book(bid,bname,price,publishTime) VALUES(4,'影响力','40','2018-1-10'); INSERT INTO book(bid,bname,price,publishTime) VALUES(5,'社会心理学','20','2017-12-10'); INSERT INTO book(bid,bname,price,publishTime) VALUES(6,'高等数学(A)','30','2017-11-10'); INSERT INTO book(bid,bname,price,publishTime) VALUES(7,'高等数学(B)','50','2017-10-10'); INSERT INTO book(bid,bname,price,publishTime) VALUES(8,'线性代数','70','2017-9-10'); INSERT INTO book(bid,bname,price,publishTime) VALUES(9,'离散数学','90','2017-8-10'); INSERT INTO book(bid,bname,price,publishTime) VALUES(10,'数据结构','110','2017-7-10'); INSERT INTO book(bid,bname,price,publishTime) VALUES(11,'java编程思想','120','2017-6-10'); INSERT INTO book(bid,bname,price,publishTime) VALUES(12,'javaEE架构','130','2017-5-10'); INSERT INTO book(bid,bname,price,publishTime) VALUES(13,'Spring源码解析','140','2017-4-10'); INSERT INTO book(bid,bname,price,publishTime) VALUES(14,'mybaits深入浅出','150','2017-3-10'); INSERT INTO book(bid,bname,price,publishTime) VALUES(15,'SSH框架整合','160','2017-2-10'); INSERT INTO book(bid,bname,price,publishTime) VALUES(16,'SSM框架整合(二)','170','2017-1-10'); INSERT INTO book(bid,bname,price,publishTime) VALUES(17,'java入门到放弃','180','2018-5-10');