if(type.equals("CHAR"))//字符串
			{
				sqlSet = sqlSet + "'" + value + "'";
			}
			else if(type.equals("NUM"))//數值
			{
				sqlSet = sqlSet + value;
			}
			else if(type.equals("TIME"))//日期
			{
				sqlSet = sqlSet + "to_date('yyyy-MM-dd HH:mm:ss','" + value + "')";
			}
			else if(type.equals("CLOB"))//clob類型
			{
			}
			else if(type.equals("BLOB"))//blob類型
			{
			}
		}

		String sql = "update " + (String)vect.get(0) + " set " + sqlSet;
		String sqlWhere = (String)vect.get(vect.size()-1);
		if(!sqlWhere.equals(""))
		{
			sql = sql + " where " + sqlWhere;
		}
		return db.ExecuteSQL(sql);
	}

	/**刪除記錄*/
	protected int deleteRecord(String sql)
	{
		return db.ExecuteSQL(sql);
	}
	/**執行語句*/
	protected int executeUpdate(String sql)
	{
		return db.ExecuteSQL(sql);
	}



	/**產生唯一編號*/
	public int makeID(String table,String field1,String field2,String value1,boolean type1)
	{
		return db.makeID(table,field1,field2,value1,type1);
	}
 	public int makeID(String table,String field1,String field2,String field3,String value1,String value2,boolean type1,boolean type2)
	{
		return db.makeID(table,field1,field2,field3,value1,value2,type1,type2);
	}

	public int makeID_Add1(String table,String field1,String field2,String value1,boolean type1)
	{
		return db.makeID(table,field1,field2,value1,type1);
	}
 	public int makeID_Add1(String table,String field1,String field2,String field3,String value1,String value2,boolean type1,boolean type2)
	{
		return db.makeID(table,field1,field2,field3,value1,value2,type1,type2);
	}

	/**將名稱轉換為編號*/
	public int toID(String table,String field1,String field2,String value1)
	{
		return db.toID(table,field1,field2,value1);
	}

	/**將編號轉換為名稱*/
	public String toName(String table,String field1,String field2,String value1)
	{
		return db.toName(table,field1,field2,value1);
	}

	/**寫數據庫時某一個字段的存儲類型*/
	protected Vector addVector(String field,String value,String type)
	{
		Vector vect = new Vector();
		vect.add(field);
		vect.add(value);
		vect.add(type);
		return vect;
	}

	/**分頁時取得一頁的數據量*/
	public Vector getOnePage(String sql,int page,int records)
	{
		return db.getOnePage(sql,page,records);
	}

	/**為某一個字段進行重新排序*/
	public int setSort(String table,String field1,String field2,String wherestr,String orderstr,boolean b)
	{
		return db.setSort(table,field1,field2,wherestr,orderstr,b);
	}

	/**查詢CLOB類型值*/
	public String QueryCLOB(String table,String wherestr,String clobfield)
	{
		return db.QueryCLOB(table,wherestr,clobfield);
	}

	/**修改CLOB類型值*/
	public int UpdateCLOB(String table,String wherestr,String clobfield,String clobvalue)
	{
		return db.UpdateCLOB(table,wherestr,clobfield,clobvalue);
	}

	/**查詢BLOB類型值*/
	public String QueryBLOB(String table,String wherestr,String blobfield)
	{
		return db.QueryBLOB(table,wherestr,blobfield);
	}

	/**修改BLOB類型值*/
	public int UpdateBLOB(String table,String wherestr,String blobfield,String blobvalue)
	{
		return db.UpdateBLOB(table,wherestr,blobfield,blobvalue);
	}
	/**查詢BLOB類型值*/
	public String QueryBLOB_JNDI(String table,String wherestr,String blobfield)
	{
		return db.QueryBLOB_JNDI(table,wherestr,blobfield);
	}

	/**修改BLOB類型值*/
	public int UpdateBLOB_JNDI(String table,String wherestr,String blobfield,String blobvalue)
	{
		return db.UpdateBLOB_JNDI(table,wherestr,blobfield,blobvalue);
	}


	/**數據庫信息*/
	public Hashtable getDataBaseInfo()
	{
		return db.getDataBaseInfo();
	}
	
	/**數據表列表*/
	public Vector getTableList()
	{
		return db.getTableList();
	}
	
	/**數據表的結構*/
	public Vector getTableStruct(String table)
	{
		return db.getTableStruct(table);
	}

	/**取得數據集內容*/
	public Vector getResultSetData(ResultSet rs)
	{
		return db.getResultSetData(rs);
	}

	/**創建申明對象*/
	public void prepareStatement(String sql)
	{
		db.prepareStatement(sql);
	}

	/**執行查詢*/
	public void executeQuery()
	{
		db.executeQuery();
	}

	/**轉向下一條*/
	public boolean next()
	{ 
		return db.next();
	}

	/**取得數據并根據數據類型轉化為字符串*/
	public String getObject(String field,String sqlType)
	{
		return db.getObject(field,sqlType);
	}

	/**根據數據類型保存到數據庫*/
	public void setObject(int index,String value,String sqlType)
	{
		db.setObject(index,value,sqlType);
	}
	
	/**執行更新*/
	public void executeUpdate()
	{
		db.executeUpdate();
	}

	/**關閉申明對象*/
	public void closePstm()
	{
		db.closePstm();
	}
	
	/**關閉游標*/
	public void closeRs()
	{
		db.closeRs();
	}
	
	public Vector getDataBySql(String sql)
	{
		return db.getData(sql);
	}

	public boolean getAutoCommit()
	{
		return db.getAutoCommit();
	}

	public void closeAutoCommit()
	{
		db.closeAutoCommit();
	}
	
	public void commit()
	{
		db.commit();
	}
	
	public void rollback()
	{
		db.rollback();
	}

	public void openAutoCommit()
	{
		db.openAutoCommit();
	}

	public void createStatement()
	{
		db.createStatement();
	}

	public void clearBatch()
	{
		db.clearBatch();
	}

	public void addBatch(String sql)
	{
		db.addBatch(sql);
	}
	public int[] executeBatch()
	{
		return db.executeBatch();
	}

	public void closeStm() { db.closeStm(); }	

	public static void main(String args[])
	{
		ParentBean mb = new ParentBean();
		
		
		System.out.println("begin\r\n\r\n");

		//修改方法
		//Vector vect = new Vector();
		//vect.add("test");
		////vect.add(mb.addVector("ID","100","NUM"));
		//vect.add(mb.addVector("NAME","libohua","CHAR"));
		//vect.add("");
		//System.out.println(mb.updateRecord(vect));

		//新增方法
		//vect.clear();
		////vect.add(mb.addVector("ID","100","NUM"));
		//vect.add(mb.addVector("NAME","libohua","CHAR"));
		//vect.add("");
		//System.out.println(mb.insertRecord(vect));

		//分頁方法
		//System.out.println(mb.getOnePage("select * from css",2,3));


		System.out.println("\r\n\r\nend");
	}
	protected void finalize()
	{
		try
		{
			if(getConn()!=null&&!getConn().isClosed())
			{
				count++;
				float m = (float)Runtime.getRuntime().totalMemory()/1024/1024;
				if(memcount != m || m>30)
				{
					memcount = m;
					//System.out.println("\r\nJVM IS USING MEMORY:"+memcount+"M");
					//System.out.println("JVM MAX MEMORY: "+Runtime.getRuntime().maxMemory()/1024/1024+"M");
				}
				//System.out.println("  JVM自動垃圾回收一個連接,共回收個數為："+count);
			}
		}
		catch(SQLException sqle){}

		closeRs();
		closePstm();
		closeStm();
		closeConn();
	}
}