blobinfo.java

java swing源码 欢迎下载 有问题请联系 我一定负责到底

/**
 * blob存储与读写
 */
package com.NCL;

import java.util.*;
import com.sinosoft.common.*;

public class BlobInfo{
	protected IndexMap propList;
	protected HashSet Property;
	private List strList = new ArrayList();
	protected String fMakeDate = "";
	protected String tMakeDate = "";
	private boolean EOF = false;
	private int COUNT;
	/**
	 * 构造函数
	 *
	 */
	public BlobInfo(){
		propList = new IndexMap();
		Property = new HashSet();
		Property.add("ID");						//自增长ID
		Property.add("TableID");				//表里某一条记录的ID
		Property.add("TableName");				//表名
		Property.add("Content");				//存储的内容
		Property.add("Note");					//备注
		Property.add("MakeDate");				//创建日期
	}
	/**
	 * 返回fMakeDate
	 * @return String
	 */
	public String getfMakeDate() {
		return fMakeDate;
	}
	/**
	 * 设置fMakeDate
	 * @param str 日期
	 */
	public void setfMakeDate(String str) {
		fMakeDate = str;
	}
	/**
	 * 返回tMakeDate
	 * @return String
	 */
	public String gettMakeDate() {
		return tMakeDate;
	}
	/**
	 * 设置tMakeDate
	 * @param str 日期
	 */
	public void settMakeDate(String str) {
		tMakeDate = str;
	}
	
	/**
	 * 在此映射中关联指定值与指定键
	 * @param name 指定键
	 * @param value 指定值
	 */
	public void setUpdateValue(String name,Object value){
		if(this.set(name,value)){
			Object[] uValue = new Object[2];
			uValue[0] = name;
			uValue[1] = value;
			strList.add(uValue);
		}
	}
	/**
	 * 在此映射中关联指定值与指定键
	 * @param name 指定键
	 * @param value 指定值
	 */
	public boolean set(String name, Object value){
		if(Property.contains(name)){
			propList.put(name,value);
			return true;
		}else
			return false;		
	}
	/**
	 * 返回指定键在此映射中所映射的值
	 * @param name 指定键
	 * @return
	 */
	public String get(String name){
		if (Property.contains(name)){
			String value = (String)propList.get(name);
			if(value != null && !value.equals(""))
				return value;
			else
				return "";
		}else 
			return "";
	}
	/**
	 * 返回COUNT
	 * @return int
	 */
	public int getCOUNT() {
		return COUNT;
	}
	/**
	 * 设置COUNT
	 * @param count
	 */
	public void setCOUNT(int count) {
		COUNT = count;
	}
	/**
	 * 返回EOF
	 * @return boolean
	 */
	public boolean isEOF() {
		return EOF;
	}
	/**
	 * 设置EOF
	 * @param eof
	 */
	public void setEOF(boolean eof) {
		EOF = eof;
	}
	/**
	 * 清空propList
	 *
	 */
	public void clear(){
		propList.clear();
	}
	/**
	 * 创建
	 * @param TableID 表ID
	 * @param TableName 表名
	 * @param Note 备注
	 * @param Content 内容
	 * @return boolean
	 */	
	public boolean create(String TableID,String TableName,String Note,String Content){
		this.clear();
		this.set("TableID",TableID);
		this.set("TableName",TableName);
		this.set("Note",Note);
		String sql = "INSERT into BlobInfo values(BLOBINFOID_SQE.nextval,?,?,EMPTY_BLOB(),?,sysdate)";
		DBAccess d  = new DBAccess();
		boolean bl = d.execute(sql,this.propList);
		if(!bl)return bl;
		this.clear();
		this.set("TableID",TableID);
		this.set("TableName",TableName);
		String ID = this.find(this, 1, 1);
		if(!Data.hasValue(ID))return false;
		WriteAndReadBLOB wb = new WriteAndReadBLOB();
		return wb.writeString("BlobInfo", "Content", "ID", ID, Content);
	}
	
	/**
	 * 删除
	 * @param agentPhotoID ID
	 * @return boolean
	 */
	public boolean delete(String agentPhotoID){
		DBAccess DBA= new DBAccess();
		String sql = "DELETE from BlobInfo WHERE id=?";		
		return DBA.executeDelete(sql,agentPhotoID);
	}
	
	/**
	 * 根据条件查询
	 * @param cm 对象
	 * @param pageSize 分页大小
	 * @param pageIndex 分页页码
	 * @return boolean
	 */
	public String find(BlobInfo cm,int pageSize,int pageIndex){
		String TableID = cm.get("TableID");					
		String TableName = cm.get("TableName");				
		String Note = cm.get("Note");				
		String fMakeDate = cm.getfMakeDate();
		String tMakeDate = cm.gettMakeDate();
		if(Data.hasValue(fMakeDate) && fMakeDate.length()!=10)return "";
		if(Data.hasValue(tMakeDate) && tMakeDate.length()!=10)return "";
		StringBuffer SQL = new StringBuffer("SELECT id from BlobInfo where 1=1");
		if(Data.hasValue(TableID))
			SQL.append(" and TableID=?");
		if(Data.hasValue(TableName))
			SQL.append(" and TableName=?");
		if(Data.hasValue(Note))
			SQL.append(" and Note=?");
		if(Data.hasValue(fMakeDate))
			SQL.append(" and MakeDate>=to_date('" + fMakeDate + "','yyyy-MM-dd')");
		if(Data.hasValue(tMakeDate))
			SQL.append(" and MakeDate<=to_date('" + tMakeDate + " 23:59:59','yyyy-MM-dd hh24:mi:ss')");
		SQL.append(" order by MakeDate desc");
		String result = "";
		DBAccess d  = new DBAccess();
		result = d.executeQuery(SQL.toString(),cm.propList,pageSize,pageIndex);
		setCOUNT(d.COUNT);
		setEOF(d.EOF);
		return result;	
	}
	
	/**
	 * 查询Note字段
	 * @param ID ID
	 * @return String
	 */
	public String getNote(String ID){
		String sql = "SELECT Note from BlobInfo where ID=?";
		DBAccess d  = new DBAccess();
		List l = new ArrayList();
		l.add(ID);
		l =	d.parseSQL(sql, l);
		if(l==null || l.size()==0)return "";
		return (String)l.get(0);
	}
	
	public static void main(String []ages){
	}
}