dboperation.java

保存图片信息到数据库 数据库Oracle 里面用到的库需要自己重新建立

	 * @param elemType
	 *            元素类型
	 */
	public synchronized void saveElemInfo(String serviceID, String billID,
			String elemID, String elemName, String elemType) {
		String sqlStr = "insert into YEMIANYUANSUXXB(FUWUBIANHAO, DANZHENGBIANHAO, "
				+ "YUANSUBIANHAO, YUANSUMINGCHENG, YUANSULEIXING) values(?, ? , ?, ?, ?)";
		try {
			PreparedStatement preState = dbCon.prepareStatement(sqlStr);
			preState.setString(1, serviceID);
			preState.setString(2, billID);
			preState.setString(3, elemID);
			preState.setString(4, elemName);
			preState.setString(5, elemType);
			preState.execute();
		} catch (SQLException sqlExe) {
			System.out.println("保存角色信息失败!");
			sqlExe.printStackTrace();
		}
	}

	/**
	 * 保存事件信息到数据库
	 * 
	 * @param serviceID
	 *            服务编号
	 * @param billID
	 *            单证编号
	 * @param eventID
	 *            事件编号
	 * @param eventName
	 *            事件名称
	 */
	public synchronized void saveEventInfo(String serviceID, String billID,
			String eventID, String eventName) {
		String sqlStr = "insert into YEMIANSHIJIANXXB(FUWUBIANHAO, DANZHENGBIANHAO, "
				+ "SHIJIANBIANHAO, SHIJIANMINGCHENG) values(?, ? , ?, ?)";
		try {
			PreparedStatement preState = dbCon.prepareStatement(sqlStr);
			preState.setString(1, serviceID);
			preState.setString(2, billID);
			preState.setString(3, eventID);
			preState.setString(4, eventName);
			preState.execute();
		} catch (SQLException sqlExe) {
			System.out.println("保存角色信息失败!");
			sqlExe.printStackTrace();
		}
	}

	/**
	 * 
	 * @param serviceID
	 *            服务编号
	 * @param dbServiceID
	 *            数据库服务编号
	 * @param driver
	 *            数据库驱动名
	 * @param connType
	 *            数据库连接诶类型
	 * @param url
	 *            数据库连接url
	 * @param userName
	 *            数据库用户名
	 * @param passWord
	 *            数据库用户密码
	 */
	public synchronized void saveDBInfo(String serviceID, String dbServiceID,
			String driver, String connType, String url, String userName,
			String passWord) {
		String sqlStr = "insert into SHUJUKUFUWU(FUWUBIANHAO, SHUJUKUFUWUBIANHAO, QUDONGQI, "
				+ "LIANJIELEIXING, FUWU_URL, YOGNHUMING, MIMA) values(?, ? , ?, ?, ?, ? , ?)";
		try {
			PreparedStatement preState = dbCon.prepareStatement(sqlStr);
			preState.setString(1, serviceID);
			preState.setString(2, dbServiceID);
			preState.setString(3, driver);
			preState.setString(4, connType);
			preState.setString(5, url);
			preState.setString(6, userName);
			preState.setString(7, passWord);
			preState.execute();
		} catch (SQLException sqlExe) {
			System.out.println("保存数据库信息失败!");
			sqlExe.printStackTrace();
		}
	}

	/**
	 * 
	 * @param serviceID
	 *            服务编号
	 * @param dbServiceID
	 *            数据库服务编号
	 * @param tableID
	 *            数据库表编号
	 * @param tableName
	 *            数据库表名
	 */
	public synchronized void saveDBTableInfo(String serviceID,
			String dbServiceID, String tableID, String tableName) {
		String sqlStr = "insert into SHUJUKUBIAOXXB(FUWUBIANHAO, SHUJUKUBIANHAO, BIAOBIANHAO, "
				+ "MINGCHENG) values(?, ? , ?, ?)";
		try {
			PreparedStatement preState = dbCon.prepareStatement(sqlStr);
			preState.setString(1, serviceID);
			preState.setString(2, dbServiceID);
			preState.setString(3, tableID);
			preState.setString(4, tableName);
			preState.execute();
		} catch (SQLException sqlExe) {
			System.out.println("保存数据库表信息失败!");
			sqlExe.printStackTrace();
		}
	}

	/**
	 * 保存数据库字段到数据库
	 * 
	 * @param serviceID
	 *            服务编号
	 * @param dbServiceID
	 *            数据库服务编号
	 * @param tableID
	 *            数据库表编号
	 * @param fieldID
	 *            字段编号
	 * @param fieldType
	 *            字段类型
	 * @param fieldName
	 *            字段名称
	 * @param fieldLength
	 *            字段长度
	 */
	public synchronized void saveDBFieldInfo(String serviceID,
			String dbServiceID, String tableID, String fieldID,
			String fieldType, String fieldName, String fieldLength) {
		String sqlStr = "insert into SHUJUKUZIDUANXXB(FUWUBIANHAO, SHUJUKUBIANHAO, SHUJUKUBIAOBIANHAO, "
				+ "ZIDUANBIANHAO, ZIDUANMING, SHUJULEIXING, CHANGDU) values(?, ? , ?, ?, ?, ?, ?)";
		try {
			PreparedStatement preState = dbCon.prepareStatement(sqlStr);
			preState.setString(1, serviceID);
			preState.setString(2, dbServiceID);
			preState.setString(3, tableID);
			preState.setString(4, fieldID);
			preState.setString(5, fieldName);
			preState.setString(6, fieldType);
			preState.setString(7, fieldLength);
			preState.execute();
		} catch (SQLException sqlExe) {
			System.out.println("保存数据库字段信息失败!");
			sqlExe.printStackTrace();
		}
	}

	/**
	 * 保存跳转信息信息到数据库
	 * 
	 * @param serviceID
	 *            服务编号
	 * @param flowID
	 *            流编号
	 * @param wfjumpidStr
	 *            跳转编号
	 * @param nameNodeStr
	 *            跳转名称
	 * @param commentNodeStr
	 *            跳转注释
	 */
	public synchronized void saveWfjumplistInfo(String serviceID,
			String flowID, String wfjumpidStr, String nameNodeStr,
			String commentNodeStr) {
		String sqlStr = "insert into TIAOZHUANXXB(FUWUBIANHAO, GONGZUOLIUBIANHAO, TIAOZHUANBIANHAO, TIAOZHUANMINGCHENG,TIAOZHUANZHUSHI)values(?, ? , ?, ?, ?)";
		try {
			PreparedStatement preState = dbCon.prepareStatement(sqlStr);
			preState.setString(1, serviceID);
			preState.setString(2, flowID);
			preState.setString(3, wfjumpidStr);
			preState.setString(4, nameNodeStr);
			preState.setString(5, commentNodeStr);
			preState.execute();
		} catch (SQLException sqlExe) {
			System.out.println("保存跳转信息失败!");
			sqlExe.printStackTrace();
		}
	}

	/**
	 * 保存图元信息到数据库
	 * 
	 * @param serviceID
	 *            服务编号
	 * @param flowID
	 *            工作流编号
	 * @param fobjectIDStr
	 *            图元编号
	 * @param fobjectnodetypeStr图元类型
	 */
	public synchronized void saveWfobjectsInfo(String serviceID, String flowID,
			String fobjectIDStr, String fobjectnodetypeStr) {
		String sqlStr = "insert into TUYUANXXB(FUWUBIANHAO, GONGZUOLIUBIANHAO,TUYUANBIANHAO,TUYUANLEIXING)values(?, ? , ?, ?)";
		try {
			PreparedStatement preState = dbCon.prepareStatement(sqlStr);
			preState.setString(1, serviceID);
			preState.setString(2, flowID);
			preState.setString(3, fobjectIDStr);
			preState.setString(4, fobjectnodetypeStr);
			preState.execute();
		} catch (SQLException sqlExe) {
			System.out.println("保存图元信息失败!");
			sqlExe.printStackTrace();
		}
	}

	/**
	 * 保存连接线信息到数据库
	 * 
	 * @param serviceID
	 *            服务编号
	 * @param flowID
	 *            工作流编号
	 * @param fconnIDStr
	 *            连接线编号
	 * @param fconnNameStr
	 *            连接线名称
	 * @param fconnObjsourStr
	 *            源图元编号
	 * @param fconnObjdestStr
	 *            目标图元编号
	 */
	public synchronized void saveWfconnsInfo(String serviceID, String flowID,
			String fconnIDStr, String fconnNameStr, String fconnObjsourStr,
			String fconnObjdestStr) {
		String sqlStr = "insert into LIANJIEXIANXXB(FUWUBIANHAO, GONGZUOLIUBIANHAO, LIANJIEXIANBIANHAO, LIANJIEXIANMINGCHENG,YUANTUYUANBIANHAO,MUBIAOTUYUANBIANHAO)values(?, ? , ?, ?, ?, ?)";
		try {
			PreparedStatement preState = dbCon.prepareStatement(sqlStr);
			preState.setString(1, serviceID);
			preState.setString(2, flowID);
			preState.setString(3, fconnIDStr);
			preState.setString(4, fconnNameStr);
			preState.setString(5, fconnObjsourStr);
			preState.setString(6, fconnObjdestStr);
			preState.execute();
		} catch (SQLException sqlExe) {
			System.out.println("保存连接线信息失败!");
			sqlExe.printStackTrace();
		}
	}

	/**
	 * 保存流程基本信息到数据库
	 * 
	 * @param serviceID
	 *            服务编号
	 * @param flowID
	 *            流程编号
	 * @param workflowNameStr
	 *            工作编号
	 * @param startUpStr
	 *            启动者
	 * @param managerStr
	 *            管理者
	 * @param excludelistStr
	 *            排除
	 */
	public synchronized void saveWorkflowInfo(String serviceID, String flowID,
			String workflowNameStr, String startUpStr, String managerStr,
			String excludelistStr) {
		String sqlStr = "insert into LIUCHENGJIBENXXB(FUWUBIANHAO, GONGZUOLIUBIANHAO, LIUCHENGMING,QIDOGNZHE, GUANLIZHE,PAICHU)values(?, ? , ?, ?, ?, ?)";
		try {
			PreparedStatement preState = dbCon.prepareStatement(sqlStr);
			preState.setString(1, serviceID);
			preState.setString(2, flowID);
			preState.setString(3, workflowNameStr);
			preState.setString(4, startUpStr);
			preState.setString(5, managerStr);
			preState.setString(6, excludelistStr);
			preState.execute();
		} catch (SQLException sqlExe) {
			System.out.println("保存流程基本信息失败!");
			sqlExe.printStackTrace();
		}
	}

	/**
	 * 保存活动信息到数据库
	 * 
	 * @param serviceID
	 *            服务编号
	 * @param flowID
	 *            流程编号
	 * @param wfactividStr
	 *            活动编号
	 * @param wfactivNameStr
	 *            活动名称
	 * @param wfactivCommentStr
	 *            活动注释
	 * @param wfactivOwnerStr
	 *            活动所有者
	 */
	public synchronized void saveWfactivlistInfo(String serviceID,
			String flowID, String wfactividStr, String wfactivNameStr,
			String wfactivCommentStr, String wfactivOwnerStr) {
		String sqlStr = "insert into HUODONGXXB(FUWUBIANHAO, LIUCHENGBIANHAO, HUODONGBIANHAO, HUODONGMINGCHENG,HUODONGZHUSHI,HUODONGSUOYOUZHE)values(?, ? , ?, ?, ?, ?)";
		try {
			PreparedStatement preState = dbCon.prepareStatement(sqlStr);
			preState.setString(1, serviceID);
			preState.setString(2, flowID);
			preState.setString(3, wfactividStr);
			preState.setString(4, wfactivNameStr);
			preState.setString(5, wfactivCommentStr);
			preState.setString(6, wfactivOwnerStr);
			preState.execute();
		} catch (SQLException sqlExe) {
			System.out.println("保存活动信息失败!");
			sqlExe.printStackTrace();
		}
	}

	public static void main(String[] args) throws SQLException {
		DBOperation d = new DBOperation();
		d.connet2DB();
		String s = d.getFileID();
		System.out.println(s);
	}
}