grainoraviewdata.java

博克后台的开发,有很多使用的方法和例子可以提供给大家学习

package com.webpublish.dbutil;

import java.io.*;
import com.webpublish.config.ComStatic;
import oracle.jdbc.driver.OracleResultSet;
//import oracle.sql.CLOB;
import java.sql.Clob;

public class GrainOraViewData {
	private String klzdrecid = "klzdrecid"; // 唯一颗粒标识符

	private String wzklxxflid = "wzklxxflid"; // 网站分类

	private String wzklgname = "wzklgname"; // 网站颗粒名称

	private String wzklgkind = "wzklgkind"; // 网站颗粒类型

	private String wzklgtype = "wzklgtype"; // 网站颗粒类别

	private String wzklifpage = "wzklifpage"; // 是否分页 sffy

	private String wzklpmod = "wzklpmod"; // 发布模式 fbzl

	private String wzklcpath = "wzklcpath"; // 生成路径 sclj

	private String wzklcname = "wzklcname"; // 生成文件名 scwj

	private String wzklppurl = "wzklppurl"; // 颗粒发布页面URL

	private String klmbtmecro = "klmbtmecro"; // 循环模板宏 thdg

	private String klmbltemp = "klmbltemp"; // 循环模板 thmb

	private String klmbnoltemp = "klmbnoltemp"; // 非循环模板

	private String klzddbtype = "klzddbtype"; // 数据库类型 sjzl

	private String klzddbconn = "klzddbconn"; // 数据库连接信息 sjlj

	private String klzddbsql = "klzddbsql"; // 查询语句 cxyj

	private String klzdfields = "klzdfields"; // 查询字段序列 cxzd

	private String klzdmacro = "klzdmacro"; // 字段替换宏序列 zdth

	private String klzdnolnum = "klzdnolnum"; // 非循环纪录数 fhjl

	private String klzdlrnum = "klzdlrnum"; // 循环纪录数 mjsl

	private String klzdlnum = "klzdlnum"; // 循环次数 (scsl-fhjl) % mjsl

	private String klzdptseq = "klzdptseq"; // 发布时段 （通过位与运算确定是否发布）

	public String KLZDRECID = "";

	public String WZKLXXFLID = "";

	public String WZKLGNAME = "";

	public String WZKLGKIND = "";

	public String WZKLGTYPE = "";

	public String WZKLIFPAGE = "";

	public String WZKLPMOD = "";

	public String WZKLCPATH = "";

	public String WZKLCNAME = "";

	public String WZKLPPURL = "";

	public String KLMBTMECRO = "";

	public String KLMBLTEMP = "";

	public String KLMBNOLTEMP = "";

	public String KLZDDBTYPE = "";

	public String KLZDDBCONN = "";

	public String KLZDDBSQL = "";

	public String KLZDFIELDS = "";

	public String KLZDMACRO = "";

	public String KLZDNOLNUM = "";

	public String KLZDLRNUM = "";

	public String KLZDLNUM = "";

	public String KLZDPTSEQ = "";

	public boolean getPubDbInfo(String SqlStr, String recid) {
		boolean getsign = false;

		OradbUtil OradbUtilPstmt = new OradbUtil(SqlStr);
		try {
			OradbUtilPstmt.setString(1, recid);
			OradbUtilPstmt.rs = OradbUtilPstmt.executeQuery();

			if (OradbUtilPstmt.rs.next()) {
				KLZDRECID = OradbUtilPstmt.rs.getString(klzdrecid);
				WZKLXXFLID = OradbUtilPstmt.rs.getString(wzklxxflid);
				WZKLGNAME = OradbUtilPstmt.rs.getString(wzklgname);
				WZKLGKIND = OradbUtilPstmt.rs.getString(wzklgkind);
				WZKLGTYPE = OradbUtilPstmt.rs.getString(wzklgtype);
				WZKLIFPAGE = OradbUtilPstmt.rs.getString(wzklifpage);
				WZKLPMOD = OradbUtilPstmt.rs.getString(wzklpmod);
				WZKLCPATH = OradbUtilPstmt.rs.getString(wzklcpath);
				WZKLCNAME = OradbUtilPstmt.rs.getString(wzklcname);
				WZKLPPURL = OradbUtilPstmt.rs.getString(wzklppurl);
				KLMBTMECRO = OradbUtilPstmt.rs.getString(klmbtmecro);
				KLMBLTEMP = OradbUtilPstmt.rs.getString(klmbltemp);

				KLMBNOLTEMP = "";
				Clob clob = ((OracleResultSet) OradbUtilPstmt.rs)
						.getCLOB(klmbnoltemp);
				if (clob != null) {
					Reader is = clob.getCharacterStream();
					BufferedReader br = new BufferedReader(is);
					String s = br.readLine();
					while (s != null) {
						KLMBNOLTEMP += s;
						s = br.readLine();
					}
				}

				KLZDDBTYPE = OradbUtilPstmt.rs.getString(klzddbtype);
				KLZDDBCONN = OradbUtilPstmt.rs.getString(klzddbconn);
				KLZDDBSQL = OradbUtilPstmt.rs.getString(klzddbsql);
				KLZDFIELDS = OradbUtilPstmt.rs.getString(klzdfields);
				KLZDMACRO = OradbUtilPstmt.rs.getString(klzdmacro);
				KLZDNOLNUM = OradbUtilPstmt.rs.getString(klzdnolnum);
				KLZDLRNUM = OradbUtilPstmt.rs.getString(klzdlrnum);
				KLZDLNUM = OradbUtilPstmt.rs.getString(klzdlnum);
				KLZDPTSEQ = OradbUtilPstmt.rs.getString(klzdptseq);

				getsign = true;
			}
			OradbUtilPstmt.rs.close();
			return getsign;
		} catch (Exception e) {
			OradbUtilPstmt.close();
			//ComStatic.GrainLog.logString = "执行查询语句:" + SqlStr + "时出错!";
			//ComStatic.GrainLog.errLog(e.toString());
			return false;
		} finally {

		}
	}

	public static void main(String[] args) {
		GrainOraViewData gov = new GrainOraViewData();
		String SqlStr = ComStatic.getDbConfig.getProperty("SelectGrainRecord");
		gov.getPubDbInfo(SqlStr, "00000001");
		System.out.println(gov.KLMBNOLTEMP);
	}
}