三大数据库分页功能JDBC实现操作

最终运行效果

JDBC基础知识

如果童鞋们对JDBC基础知识不够熟练，可以看看这篇文章脑补一下。

https://blog.csdn.net/qq_43674132/article/details/95171884

数据库表结构定义（以Oracle数据库为例）

---学生表
CREATE TABLE Student(    
SNO VARCHAR2(7) PRIMARY  KEY,
Sname VARCHAR2(18),
SSex CHAR(3),
Sage SMALLINT,
Sdept VARCHAR2(50)
);
---课程表
CREATE TABLE Course(
Cno VARCHAR2(4) PRIMARY KEY,
Cname VARCHAR2(50),
Cpno VARCHAR2(4),--前导课
Ccredit NUMBER(2,0)
);
---选课表
CREATE TABLE SC(
Sno VARCHAR2(7),
Cno VARCHAR2(4),
Grade NUMBER(3,0),
PRIMARY KEY(Sno,Cno),
FOREIGN KEY (Sno) REFERENCES  Student(Sno),
FOREIGN KEY (Cno) REFERENCES  Course(Cno)
);
测试数据：

insert into student(sno,sname,ssex,sage,sdept) values('9512101','李勇','男',19,'计算机系');
insert into student(sno,sname,ssex,sage,sdept) values('9512102','刘晨','男',20,'计算机系');
insert into student(sno,sname,ssex,sage,sdept) values('9512103','王敏','女',20,'计算机系');
insert into student(sno,sname,ssex,sage,sdept) values('9521101','张立','男',22,'信息系');
insert into student(sno,sname,ssex,sage,sdept) values('9521102','吴宾','女',21,'信息系');
insert into student(sno,sname,ssex,sage,sdept) values('9521103','张海','男',20,'信息系');
insert into student(sno,sname,ssex,sage,sdept) values('9531101','钱小平','女',18,'数学系');
insert into student(sno,sname,ssex,sage,sdept) values('9531102','王大力','男',19,'数学系');
insert into student(sno,sname,ssex,sage,sdept) values('9512104','张健','男',19,'计算机系');
insert into student(sno,sname,ssex,sage,sdept) values('9512105','张齐朴','男',19,'计算机系');
insert into student(sno,sname,ssex,sage,sdept) values('9512106','何世焱','男',19,'计算机系');
insert into student(sno,sname,ssex,sage,sdept) values('9512107','乔勇','男',19,'计算机系');
insert into student(sno,sname,ssex,sage,sdept) values('9512108','余天璞','男',19,'计算机系');
insert into student(sno,sname,ssex,sage,sdept) values('9512109','郑德祥','男',19,'计算机系');
insert into student(sno,sname,ssex,sage,sdept) values('9512110','沈忱','男',19,'计算机系');
insert into student(sno,sname,ssex,sage,sdept) values('9512111','杜达林','男',19,'计算机系');
insert into student(sno,sname,ssex,sage,sdept) values('9512112','方科','男',19,'计算机系');
insert into student(sno,sname,ssex,sage,sdept) values('9512113','崔昌瑞','男',19,'计算机系');
insert into student(sno,sname,ssex,sage,sdept) values('9512114','蔡基利','男',19,'计算机系');
insert into student(sno,sname,ssex,sage,sdept) values('9512115','陈礼锐','男',19,'计算机系');
insert into student(sno,sname,ssex,sage,sdept) values('9512116','刘大伟','男',19,'计算机系');
insert into student(sno,sname,ssex,sage,sdept) values('9512117','杨宝宏','男',19,'计算机系');
insert into student(sno,sname,ssex,sage,sdept) values('9512118','陈立淦','男',19,'计算机系');
insert into student(sno,sname,ssex,sage,sdept) values('9512119','肖克','男',19,'计算机系');
insert into student(sno,sname,ssex,sage,sdept) values('9512120','郭清吉','男',19,'计算机系');
insert into student(sno,sname,ssex,sage,sdept) values('9512121','代磊','男',19,'计算机系');
insert into student(sno,sname,ssex,sage,sdept) values('9512122','刘斌龙','男',19,'计算机系');
insert into student(sno,sname,ssex,sage,sdept) values('9512123','陈少鹏','男',19,'计算机系');
insert into student(sno,sname,ssex,sage,sdept) values('9512124','张嘉伟','男',19,'计算机系');
insert into student(sno,sname,ssex,sage,sdept) values('9512125','李博古','男',19,'计算机系');
insert into student(sno,sname,ssex,sage,sdept) values('9512126','金力','男',19,'计算机系');
insert into student(sno,sname,ssex,sage,sdept) values('9512127','张景峰','男',19,'计算机系');
insert into student(sno,sname,ssex,sage,sdept) values('9512128','张仁涛','男',19,'计算机系');
insert into student(sno,sname,ssex,sage,sdept) values('9512129','裴晓斌','男',19,'计算机系');
insert into student(sno,sname,ssex,sage,sdept) values('9512130','李成','男',19,'计算机系');
insert into student(sno,sname,ssex,sage,sdept) values('9512131','王龙','男',19,'计算机系');
insert into student(sno,sname,ssex,sage,sdept) values('9512132','史成林','男',19,'计算机系');
insert into stud