⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 split_page.java

📁 在eclispe下写的电子务平台
💻 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 + -