oraclejoin.java

一个oracle和JSP做的论坛

package hcit.common;

import java.sql.*;
import oracle.jdbc.internal.OracleTypes;

public class Oraclejoin {

	// 输入参数
	String sql = null; 	// --查询条件
	int p_curpage = 1;
	int pageSize = 10;
	String orderby="c_date";

	// 输出参数
	String totalRecord; // 总记录数
	String totalPage; 	// 总页数
	ResultSet curRd; 	// 当前页记录集合


	DBConnect db = new DBConnect();

	public ResultSet getPage() {
		String procedure = "{call join (?,?,?,?,?,?,?,?) }";
		CallableStatement cstmt;
		try {
			cstmt = db.conn.prepareCall(procedure);
			cstmt.setString(1, sql); // --查询条件
			cstmt.setInt(2, p_curpage); // --当前页
			cstmt.setInt(3, pageSize); // --每页显示记录条数
			cstmt.setString(4, orderby); // --设定排序列
			cstmt.setString(5, "desc"); // --设定排序列


			cstmt.registerOutParameter(6, OracleTypes.INTEGER);// 总记录数
			cstmt.registerOutParameter(7, OracleTypes.INTEGER);// --总页数
			cstmt.registerOutParameter(8, OracleTypes.CURSOR); // --返回的结果集
			cstmt.executeUpdate();

			curRd = (ResultSet) cstmt.getObject(8); // 取出结果集
			totalRecord = cstmt.getObject(6).toString();
			totalPage = cstmt.getObject(7).toString();

		} catch (SQLException e) {
			System.out.println("oraclejoin Error " + e);
		}
		return curRd;
	}

	public void close() {
		try {
			if (db != null)
				db.free();
		} catch (SQLException e) {
			e.printStackTrace();
			System.out.println("Oraclejoin类-->关闭异常!");
		}
	}

	public int getP_curpage() {
		return p_curpage;
	}
	public void setP_curpage(int p_curpage) {
		this.p_curpage = p_curpage;
	}

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

	public String getTotalPage() {
		return totalPage;
	}
	public void setTotalPage(String totalPage) {
		this.totalPage = totalPage;
	}

	public String getTotalRecord() {
		return totalRecord;
	}
	public void setTotalRecord(String totalRecord) {
		this.totalRecord = totalRecord;
	}

	public String getSql() {
		return sql;
	}
	public void setSql(String sql) {
		this.sql = sql;
	}

	public String getOrderby() {
		return orderby;
	}

	public void setOrderby(String orderby) {
		this.orderby = orderby;
	}
}