tool.java

加拿大达内科技有限公司配需java程序员的上课时的代码

package day03;

import java.sql.*;

public class Tool {
	private Connection con;
	private int pageSize;
	private PreparedStatement ps;
	private String sql = "select * from xun";
	private ResultSet rs;
	private ResultSetMetaData md;

	public Tool() {
		try {
			con = JdbcUtil.getConnection();
			ps = con.prepareStatement(sql, ResultSet.TYPE_SCROLL_INSENSITIVE,
					ResultSet.CONCUR_READ_ONLY);
			rs = ps.executeQuery();
			md = ps.getMetaData();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}

	public int countPageNum() {
		int pageNum = 0;
		try {
			rs.last();
			int recordNum = rs.getRow();
			pageNum = (recordNum + pageSize - 1) / pageSize;
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return pageNum;
	}

	public void setPageSize(int pageSize) {
		this.pageSize = pageSize;
	}

	public String getPage() {

	}

	public void release() {
		JdbcUtil.release(rs, ps, con);
	}

}