jdbc操作oracle的blob

由于thin驱动对setBinaryStream支持很差，没办法，只有采用笨点的方法了

connOracle = JDBCDataSource.getJDBCDataSource("jdbc.informix")
					.getConnection();
			connOracle.setAutoCommit(false);
			BLOB blob = null;
			PreparedStatement pstmt = connOracle
					.prepareStatement("update ygjbxx set jbxx_photo=empty_blob() where jbxx_bh='"
							+ ygdh + "'");
			pstmt.executeUpdate();
			pstmt.close();
			PreparedStatement pstmt1 = connOracle
					.prepareStatement("select jbxx_photo from ygjbxx where jbxx_bh= ? for update");//for update必须要加
			pstmt1.setString(1, ygdh);
			ResultSet rset = pstmt1.executeQuery();
			if (rset.next()) {
				blob = (BLOB) rset.getBlob(1);
			}
			pstmt1.close();
			OutputStream out1 = blob.getBinaryOutputStream();
			int i = 0;
			while ((i = in.read()) != -1) {//InputStream为方法的参数
				out1.write(i);
			}
			out1.flush();
			out1.close();
			PreparedStatement pstmt2 = connOracle
					.prepareStatement("update ygjbxx set jbxx_photo=? where jbxx_bh='"
							+ ygdh + "'");
			pstmt2.setBlob(1, blob);
			pstmt2.executeUpdate();
			pstmt2.close();
			connOracle.commit();