oradbmethods.java

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

package com.webpublish.dbutil;

import java.io.BufferedReader;
import java.io.BufferedWriter;
import java.io.StringReader;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Vector;
import java.util.Date;

import com.webpublish.dbutil.OradbUtil;

import com.webpublish.util.StringUtils;


public class OradbMethods  {
	private ResultSet rs = null;
	public OradbMethods() {
		System.out.println("hello-----");
	}

public synchronized final String[][] getDateArr(String sqlStr,
			String[] FieldsArr, int[] adjustNumArr, int loopCount, int fieldNum) {
		String[][] DataArr = new String[loopCount][fieldNum + 1];
		try {
			OradbUtil OradbUtilstmt = new OradbUtil(
					"jdbc:oracle:thin:@192.168.0.101:1521:ora815", "db66user",
					"cbznw68j");
			/*if (rs == null) {
				conn = DBConnection.getConnOracle(
						"jdbc:oracle:thin:@192.168.0.101:1521:ora815",
						"db66user", "cbznw68j");
				this.stmt = conn.createStatement(
						java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE,
						java.sql.ResultSet.CONCUR_READ_ONLY);

				rs = stmt.executeQuery(sqlStr);*/
				rs = OradbUtilstmt.executeQuery(sqlStr);
		

			for (int i = 0; i < loopCount; i++) {
				if (rs.next()) {
					DataArr[i][0] = "1";
					for (int j = 0; j < fieldNum; j++) {
						DataArr[i][j + 1] = rs.getString(FieldsArr[j]);
						DataArr[i][j + 1] = StringUtils.AdjustFieldLen(
								DataArr[i][j + 1], adjustNumArr[j]);
					}
				} else {
					DataArr[i][0] = "0";
					for (int j = 0; j < fieldNum; j++) {
						DataArr[i][j + 1] = "";
					}
				}
			}
		} catch (SQLException e) {
		System.out.println(e.getMessage());
		}
		return DataArr;
	}
public synchronized int getRecordCount(String sqlstr) {
	int intRowCount = 0;
	try {
		OradbUtil OradbUtilstmt = new OradbUtil(
				"jdbc:oracle:thin:@192.168.0.101:1521:ora815", "db66user",
				"cbznw68j");
		rs = OradbUtilstmt.executeQuery(sqlstr);
		
		rs.last();
		intRowCount = rs.getRow();
	} catch (SQLException e) {
		e.printStackTrace();
		//ComStatic.GrainLog.errLog("获得记录总数是数据库出错！" + e.toString());
	} finally {
		//close();
	}
	return intRowCount;
}

	
	public static void main(String[] args) {
		OradbMethods togm = new OradbMethods();
		// System.out
		// .println(togm
		// .GetRecordCount("select dtbt1,dtbt2,wzlj,wznr,symb from Db66_wzdt
		// order by FBSJ desc,fbxh"));
		// togm.updateIdSequence("00000001", 2);
		
		// System.out.println(togm.getIdSequence("00000001"));
	}
	
}