📄 split_page.java
字号:
package dlut;
import java.sql.*;
import java.util.*;
public class Split_Page {
private ResultSet rs = null;
private ResultSetMetaData rsmd = null;
private int rowCount;
private int pageCount;
private int pageSize;
public void initialize(ResultSet rs, int pageSize) {
this.pageSize = pageSize;
try {
this.rs = rs;
this.rsmd = this.rs.getMetaData();
if (this.rs != null) {
this.rs.last();
this.rowCount = this.rs.getRow();
this.rs.first();
this.pageCount = (this.rowCount - 1) / this.pageSize + 1;
} else {
this.rowCount = 0;
}
} catch (SQLException ex) {
System.out.println(ex.toString());
}
}
public Vector getPage(int ipage) {
Vector vData = new Vector();
int n = ipage;
int m = 0;
m = (n - 1) * this.pageSize + 1;
try {
if (this.rs != null) {
if (n != 1) {
this.rs.absolute(m);
}
for (int i = 0; i < this.pageSize; i++) {
String[] sData = new String[10];
for (int j = 0; j < this.rsmd.getColumnCount(); j++) {
sData[j] = this.rs.getString(j + 1);
}
if (sData == null) {
break;
}
vData.addElement(sData);
this.rs.next();
}
}
} catch (SQLException Ex) {
System.out.println(Ex.toString());
}
return vData;
}
public int getPageCount() {
return this.pageCount;
}
public int getRowCount() {
return this.rowCount;
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -