2-JSP_JDBC_真分页

-- 删除表 DROP TABLE person ; -- 建立person表 CREATE TABLE person ( -- 生成一个流水号，观察显示的记录数 id int AUTO_INCREMENT NOT NULL PRIMARY KEY , -- 用户的登陆ID uid varchar(32) , -- 用户的真实姓名 name varchar(32) , -- 用户的登陆密码 password varchar(20) ) ; -- 插入测试数据 INSERT INTO person(uid,name,password) VALUES ('LXH01','李兴华01','MLDN01') ; INSERT INTO person(uid,name,password) VALUES ('LXH02','李兴华02','MLDN02') ; INSERT INTO person(uid,name,password) VALUES ('LXH03','李兴华03','MLDN03') ; INSERT INTO person(uid,name,password) VALUES ('LXH04','李兴华04','MLDN04') ; INSERT INTO person(uid,name,password) VALUES ('LXH05','李兴华05','MLDN05') ; INSERT INTO person(uid,name,password) VALUES ('LXH06','李兴华06','MLDN06') ; INSERT INTO person(uid,name,password) VALUES ('LXH07','李兴华07','MLDN07') ; INSERT INTO person(uid,name,password) VALUES ('LXH08','李兴华08','MLDN08') ; INSERT INTO person(uid,name,password) VALUES ('LXH09','李兴华09','MLDN09') ; INSERT INTO person(uid,name,password) VALUES ('LXH10','李兴华10','MLDN10') ; INSERT INTO person(uid,name,password) VALUES ('LXH11','李兴华11','MLDN11') ; INSERT INTO person(uid,name,password) VALUES ('LXH12','李兴华12','MLDN12') ; INSERT INTO person(uid,name,password) VALUES ('LXH13','李兴华13','MLDN13') ; INSERT INTO person(uid,name,password) VALUES ('LXH14','李兴华14','MLDN14') ; INSERT INTO person(uid,name,password) VALUES ('LXH15','李兴华15','MLDN15') ; INSERT INTO person(uid,name,password) VALUES ('LXH16','李兴华16','MLDN16') ; INSERT INTO person(uid,name,password) VALUES ('LXH17','李兴华17','MLDN17') ; INSERT INTO person(uid,name,password) VALUES ('LXH18','李兴华18','MLDN18') ; INSERT INTO person(uid,name,password) VALUES ('LXH19','李兴华19','MLDN19') ; INSERT INTO person(uid,name,password) VALUES ('LXH20','李兴华20','MLDN20') ; INSERT INTO person(uid,name,password) VALUES ('LXH21','李兴华21','MLDN21') ; INSERT INTO person(uid,name,password) VALUES ('LXH22','李兴华22','MLDN22') ; INSERT INTO person(uid,name,password) VALUES ('LXH23','李兴华23','MLDN23') ;