parentbean.java

这是一个用jsp+Oracle开发的联系人客户关系管理系统！

			value = (String)v_t.get(1);
			if (value.indexOf("'")!=-1)
			{
				value = value.replaceAll("'","''");
			}
			type = (String)v_t.get(2);

			//组合字段SQL
			if(sqlField.equals(""))sqlField = "(";
			else sqlField = sqlField + ",";
			sqlField = sqlField + field;

			//组合值SQL
			if(sqlValue.equals(""))sqlValue = "(";
			else sqlValue = sqlValue + ",";
			if(value.equals(""))//为空时
			{
				sqlValue = sqlValue + "null";
			}
			else if(type.equals("CHAR"))//字符串
			{
				sqlValue = sqlValue + "'" + value + "'";
			}
			else if(type.equals("NUM"))//数值
			{
				sqlValue = sqlValue + value;
			}
			else if(type.equals("TIME"))//日期
			{
				sqlValue = sqlValue + "to_date('yyyy-MM-dd HH:mm:ss','" + value + "')";
			}
			else if(type.equals("CLOB"))//clob类型
			{
				sqlValue = sqlValue + "empty_clob()";
			}
			else if(type.equals("BLOB"))//blob类型
			{
				sqlValue = sqlValue + "empty_blob()";
			}
		}

		sqlField = sqlField + ")";
		sqlValue = sqlValue + ")";
		String sql = "insert into " + (String)vect.get(0) + sqlField + " values" + sqlValue;
		return db.ExecuteSQL(sql);
	}

	/**修改记录*/
	protected 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);
	}

	/**删除记录*/
	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 static void main(String args[]) throws Exception
	{
		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(mb.FilesPath);

		System.out.println("\r\n\r\nend");
	}
}