parentbean.java

“JSP数据库项目案例导航”一书从第一章到第十一章各章实例的源程序文件以及数据库文件。 注意： 1. 本书中的案例提供的数据库环境不同

	/**修改记录*/
	public int updateRecord(Vector vect)
	{
		/**Vector:第1项 表名(String)
		//		 第2项 列名(Vector[Field(String),Value(String,CLOB,BLOB),Type("CHAR","NUM","TIME","CLOB","BLOB")])
		//		 第3项 条件(String sql)*/

		//临时变量
		String sqlSet = "";//形如(Name='name',ID=9)
		String field = "";
		String value = "";
		String type = "";

		int i = 1;
		int n = vect.size();
		for(;i<(n-1);i++)
		{
			//对某一个字段
			Vector v_t = (Vector)vect.get(i);
			field = (String)v_t.get(0);
			value = (String)v_t.get(1);
			if (value.indexOf("'")!=-1)
			{
				value = value.replaceAll("'","''");
			}
			type = (String)v_t.get(2);

			//组合字段SQL
			if(sqlSet.equals(""))sqlSet = " ";
			else sqlSet = sqlSet + ",";
			sqlSet = sqlSet + field + "=";
			if(value.equals("")&&type.equals("NUM"))//为空时
			{
				sqlSet = sqlSet + "null";
			}
			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);
	}

	/**删除记录*/
	public int deleteRecord(String sql)
	{
		return db.ExecuteSQL(sql);
	}
	/**执行语句*/
	public 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 Vector getOnePage(String sql,int page,int records,boolean useDic)
	{
		return db.getOnePage(sql,page,records,useDic);
	}

	/**为某一个字段进行重新排序*/
	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())
			{
				closeRs();
				closePstm();
				closeStm();
				closeConn();
				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){}

		
	}
*/
	
}