sqlresult.java

J2EE eclipse 下开发数据库一个插件

/*
 * Created on 2003-6-2
 *
 */
package com.tanghan.db;

import java.sql.ResultSet;
import java.util.List;

/**
 * 执行SQL语句后的结果
 *
 * @author Jerry Tang
 * @version v0.1.0
 * @copyright  (C) 2003 Tanghan Studio
 *
 */
public class SQLResult {
	/**SQL语句执行结果为一个字符串*/
	public static final int STRING = 10;

	/**SQL语句执行结果为一个数组*/
	public static final int STRINGARRAY2 = 20;

	/**SQL语句执行结果为一个结果集*/
	public static final int RESULTSET = 30;

	/**SQL语句执行结果为一个记录数*/
	public static final int COUNT = 40;

	/**SQL语句执行结果为一个列表*/
	public static final int LIST = 50;
	
	/**回传参数的类型*/
	private int resultType = STRING;
	
	private List list = null;
	
	private int count = 0;
	
	private String string = null;
	
	private String[][] stringArray2 = null;
	
	private ResultSet resultSet =null;
	
	public SQLResult(String str){
		string = str;
		resultType = STRING;
	}

	public SQLResult(){
	}	
	
	public SQLResult(int cot){
		count = cot;
		resultType = COUNT;
	}	

	public SQLResult(List ls){
		list = ls;
		resultType = LIST;
	}	
	
	public SQLResult(ResultSet res){
		resultSet = res;
		resultType = RESULTSET;
	}	
	public SQLResult(String[][] strArray){
		stringArray2 = strArray;
		resultType = STRINGARRAY2;
	}	
	/**
	 * @return
	 */
	public int getCount() {
		return count;
	}

	/**
	 * @return
	 */
	public List getList() {
		return list;
	}

	/**
	 * @return
	 */
	public ResultSet getResultSet() {
		return resultSet;
	}

	/**
	 * @return
	 */
	public int getResultType() {
		return resultType;
	}

	/**
	 * @return
	 */
	public String getString() {
		return string;
	}

	/**
	 * @return
	 */
	public String[][] getStringArray2() {
		return stringArray2;
	}

	/**
	 * @param i
	 */
	public void setCount(int i) {
		count = i;
		resultType = COUNT;
	}

	/**
	 * @param list
	 */
	public void setList(List list) {
		this.list = list;
		resultType = LIST;
	}

	/**
	 * @param set
	 */
	public void setResultSet(ResultSet set) {
		resultSet = set;
		resultType = RESULTSET;
	}

	/**
	 * @param i
	 
	public void setResultType(int i) {
		resultType = i;
	}*/

	/**
	 * @param string
	 */
	public void setString(String string) {
		this.string = string;
		resultType = STRING;
	}

	/**
	 * @param strings
	 */
	public void setStringArray2(String[][] strings) {
		stringArray2 = strings;
		resultType = STRINGARRAY2;
	}

}