Java CLOB类代码示例

import oracle.sql.CLOB; //导入依赖的package包/类
/**
 * Método responsável pela exportação de aplicação
 *
 * @since APEX 3 Parcial
 * @since APEX 4 Parcial
 * @since APEX 5
 * @throws java.sql.SQLException
 * @throws java.io.IOException
 */
private void exportFile() throws SQLException, IOException {
    String vFileName;
    CLOB vClob = getFile();
    BigDecimal vCount = new BigDecimal(1);
    Connection vConn = getConn();
    try (PreparedStatement vPS = vConn.prepareStatement(getStmt(IS_WORKSPACE))) {
        vPS.setBigDecimal(1, getApplicationId());
        try (ResultSet vRS = vPS.executeQuery()) {
            while (vRS.next()) {
                vCount = vRS.getBigDecimal(1);
            }
        }
    }
    vFileName = vCount == new BigDecimal(0) ? "f" + getApplicationId() + ".sql" : "ws" + getApplicationId() + ".sql";
    writeClobToFile(vClob, vFileName);
}
 

import oracle.sql.CLOB; //导入依赖的package包/类
/**
 * Método responsável pela extração de aplicação
 *
 * @since APEX 3 Parcial
 * @since APEX 4 Parcial
 * @since APEX 5
 * @return Aplicação
 * @throws java.sql.SQLException
 * @throws java.io.IOException
 */
private CLOB getFile() throws SQLException, IOException {
    CLOB vClob;
    Connection vConn = getConn();
    try (OracleCallableStatement vOCS = (OracleCallableStatement) vConn.prepareCall(getStmt(EXPORT_APPLICATION))) {
        vOCS.registerOutParameter(1, 2005);
        vOCS.setBigDecimal(2, getApplicationId());
        if (getApexVersion() >= APEX_VERSION_4) {
            vOCS.setString(3, isExpPubReports() ? "Y" : "N");
            vOCS.setString(4, isExpSavedReports() ? "Y" : "N");
            vOCS.setString(5, isExpIRNotifications() ? "Y" : "N");
            vOCS.setString(6, isExpTranslations() ? "Y" : "N");
        }
        if (getApexVersion() >= APEX_VERSION_5) {
            vOCS.setString(7, isExpAppMapping() ? "Y" : "N");
            vOCS.setString(8, isExpOriginalIds() ? "Y" : "N");
        }
        vOCS.execute();
        vClob = vOCS.getCLOB(1);
    }
    return vClob;
}
 

import oracle.sql.CLOB; //导入依赖的package包/类
/**
 * Método getFeedback
 *
 * @since APEX 4
 * @return oralce.sql.CLOB
 * @throws java.sql.SQLException
 * @throws java.io.IOException
 */
private CLOB getFeedback() throws SQLException, IOException {
    CLOB vClob;
    Connection vConn = getConn();
    try (OracleCallableStatement vOCS = (OracleCallableStatement) vConn.prepareCall(getStmt(getDeploymentSystem() == null ? EXPORT_FEEDBACK_DEVELOPMENT : EXPORT_FEEDBACK_DEPLOYMENT))) {
        vOCS.registerOutParameter(1, 2005);
        vOCS.setBigDecimal(2, getWorkspaceId());
        if (getDeploymentSystem() == null) {
            vOCS.setDate(3, getExpFeedbackSince());
        } else {
            vOCS.setString(3, getDeploymentSystem());
            vOCS.setDate(4, getExpFeedbackSince());
        }
        vOCS.execute();
        vClob = vOCS.getCLOB(1);
    }
    return vClob;
}
 

import oracle.sql.CLOB; //导入依赖的package包/类
/**
 * Método de expotação
 *
 * @since APEX 3 Parcial
 * @since APEX 4 Parcial
 * @since APEX 5
 * @return oracle.sql.CLOB
 * @throws java.sql.SQLException
 * @throws java.io.IOException
 */
public CLOB get() throws SQLException, IOException {
    CLOB vClob = null;
    iniciarStmts();
    if (isExpWorkspace()) {
        if (getApexVersion() >= APEX_VERSION_4) {
            vClob = getWorkspace();
        }
    } else if (isExpFeedback()) {
        if (getApexVersion() >= APEX_VERSION_4) {
            vClob = getFeedback();
        }
    } else if (isExpFiles()) {
        if (getApexVersion() >= APEX_VERSION_4) {
            vClob = getStaticFiles();
        }
    } else {
        vClob = getFile();
    }
    if (!isExternalConn()) {
        closeConnection();
    }
    return vClob;
}
 

import oracle.sql.CLOB; //导入依赖的package包/类
public final CLOB getTemporaryClob() {
  checkOpen();
  CLOB lCLOB;

  try {
    lCLOB = CLOB.createTemporary(
      mDatabaseConnection.unwrap(OracleConnection.class)
    , true /*isCached*/
    , CLOB.DURATION_SESSION /* Only duration_session in client side java applications */
    );
  }
  catch (SQLException e) {
    throw new ExInternal("Temporary clob cannot be created", e);
  }
  return lCLOB;
}
 

import oracle.sql.CLOB; //导入依赖的package包/类
@Test
public void pumpMessages() throws Exception {
	java.util.logging.LogManager.getLogManager().getLogger("").setLevel(Level.FINEST);
	SLF4JBridgeHandler.removeHandlersForRootLogger();
	SLF4JBridgeHandler.install();

	log.info("Creating UNIT TEST Class");

	createOracleAQQueue();

	Clob message = CLOB.createTemporary(dbConnection, false, CLOB.DURATION_SESSION);
	message.setString(1, TEST_MESSAGE);

	String plsql = String.format("begin mdb_aq.send_message('" + DB_SCHEMA_NAME + ".%1$s', ?); end;", oracleQueueName);
	CallableStatement statement = dbConnection.prepareCall(plsql);
	statement.setClob(1, message);
	statement.execute();
	statement.close();
	message.free();
}
 

import oracle.sql.CLOB; //导入依赖的package包/类
@Before
public void setUp() throws SQLException, IOException, MjdbcException {
    MockitoAnnotations.initMocks(this);

    when(stmt.getConnection()).thenReturn(conn);
    when(conn.createARRAY(any(String.class), any(Object[].class))).thenReturn(array);

    when(blob.setBinaryStream(1)).thenReturn(output);
    when(clob.setAsciiStream(1)).thenReturn(output);

    when(input.read(any(byte[].class))).thenReturn(-1);
    when(input.read(any(byte[].class), any(int.class), any(int.class))).thenReturn(-1);

    when(blob.getBinaryStream()).thenReturn(input);
    when(clob.getAsciiStream()).thenReturn(input);

    params = new QueryParameters();

    params.set("array_list", Arrays.asList("Superman"), MjdbcTypes.ARRAY);
    params.set("blob_byte", "Batman", MjdbcTypes.BLOB);
    params.set("clob_byte", "Wolverine", MjdbcTypes.CLOB);

    params.set("array", array, MjdbcTypes.ARRAY);
    params.set("blob", blob, MjdbcTypes.BLOB);
    params.set("clob", clob, MjdbcTypes.CLOB);
}
 

import oracle.sql.CLOB; //导入依赖的package包/类
@Test
public void testGetCount() throws Exception {

    QueryStatCtl ctl=(QueryStatCtl) ApplicationContextUtil.getBean("QueryStatCtl");

    StringBuilder sb=new StringBuilder();
    sb.append("clob:");
    for (int i=0;i<300;i++){
        sb.append("1");
    }

    Map<String,Object> obj=(Map<String,Object>)ctl.testPro("testPro",
                                                            "dataType配置为varchar",
                                                            100,
                                                            "2010-08-22",
                                                           new Date(),sb.toString(),"blob:hello".getBytes());

    System.out.println(obj.get("p_info")+"\n");

    CLOB demo = (CLOB)obj.get("p_outclob");
    System.out.println(demo.getSubString(1, (int) demo.length()) +"\n");

    BLOB blob = (BLOB)obj.get("p_outblob");
    System.out.println(new String(blob.getBytes(1,(int)blob.length()),"UTF-8")+"\n");

    Object result=obj.get("p_cursor");
    if(result instanceof String){
        log.info(obj.get("p_cursor").toString());
    }else{
        for (Person person:(List<Person>)result){
            log.info(person.getName()+"   "+person.getSchool()+"    "+person.getAge().toLocaleString()+"   "+person.getId());
        }
    }
}
 

import oracle.sql.CLOB; //导入依赖的package包/类
/**
 * Método responsável pela extração de espaços de trabalho
 *
 * @since APEX 4
 * @return Espaço de trabalho
 * @throws java.sql.SQLException
 * @throws java.io.IOException
 */
private CLOB getWorkspace() throws SQLException, IOException {
    CLOB vClob;
    Connection vConn = getConn();
    try (OracleCallableStatement vOCS = (OracleCallableStatement) vConn.prepareCall(getStmt(EXPORT_WORKSPACE))) {
        vOCS.registerOutParameter(1, 2005);
        vOCS.setBigDecimal(2, getWorkspaceId());
        vOCS.setBoolean(3, isExpTeamdevdata());
        vOCS.setBoolean(4, isExpTeamdevdata() ? isExpMinimal() : false);
        vOCS.execute();
        vClob = vOCS.getCLOB(1);
    }
    return vClob;
}
 

import oracle.sql.CLOB; //导入依赖的package包/类
/**
 * Método responsável pela exportação de arquivos estáticos
 *
 * @since APEX 4
 * @return Arquivos estáticos
 * @throws java.sql.SQLException
 * @throws java.io.IOException
 */
private CLOB getStaticFiles() throws SQLException, IOException {
    CLOB vClob;
    Connection vConn = getConn();
    try (OracleCallableStatement vOCS = (OracleCallableStatement) vConn.prepareCall(getStmt(EXPORT_STATIC_FILES))) {
        vOCS.registerOutParameter(1, 2005);
        vOCS.setBigDecimal(2, getWorkspaceId());
        vOCS.execute();
        vClob = vOCS.getCLOB(1);
    }
    return vClob;
}
 

import oracle.sql.CLOB; //导入依赖的package包/类
/**
 * Gera arquivo em disco
 *
 * @param pClob
 * @param pFileName
 * @throws java.sql.SQLException
 * @throws java.io.IOException
 */
private void writeClobToFile(CLOB pClob, String pFileName) throws SQLException, IOException {
    CLOB vClob = pClob;
    boolean vCtrl = true;
    FileOutputStream vFOS;
    OutputStreamWriter vOSW;
    try (Reader vReader = vClob.getCharacterStream()) {
        File vFile = new File(getPath() + pFileName);
        vFile.delete();
        vFile.createNewFile();
        vFOS = new FileOutputStream(vFile);
        vOSW = new OutputStreamWriter(vFOS, "UTF-8");
        BufferedReader vBR = new BufferedReader(vReader);
        String vLine;
        while ((vLine = vBR.readLine()) != null) {
            vLine = vLine + "\n";
            if (vCtrl) {
                if (vLine.indexOf("set define") != 0) {
                    continue;
                }
                vCtrl = false;
                vOSW.write(vLine, 0, vLine.length());
                continue;
            }
            if (isSkipExportDate() && vLine.indexOf("--   Date and Time:") == 0) {
                continue;
            }
            vOSW.write(vLine, 0, vLine.length());
        }
        vOSW.flush();
        debugMessage("Wrote " + vFile.length() + " bytes to " + vFile.getAbsolutePath(), true);
    }
    vOSW.close();
    vFOS.close();
}
 

import oracle.sql.CLOB; //导入依赖的package包/类
public SQLXML convertClobToSQLXML(Clob pClob) {
  //TODO make database agnostic
  try {
    return XMLType.createXML(mDatabaseConnection.unwrap(OracleConnection.class), (CLOB) pClob);
  }
  catch(SQLException e) {
    throw new ExInternal("XMLType can not be created",e);
  }
}
 

import oracle.sql.CLOB; //导入依赖的package包/类
/**
 * Frees a temporary CLOB. If the CLOB is not temporary, this method does nothing.
 * @param pTempClob CLOB to be freed.
 */
public final void freeTemporaryClob(CLOB pTempClob) {
  checkOpen();
  try {
     if(pTempClob!=null && pTempClob.isTemporary()) {
       pTempClob.freeTemporary();
     }
  }
  catch (SQLException e) {
    throw new ExInternal("Temporary clob cannot be freed", e);
  }
}
 

import oracle.sql.CLOB; //导入依赖的package包/类
@Override
public Object getObject(UCon pUCon) throws SQLException {

  //As this is an XML fragment there is no direct way to bind it using the JDBC APIs, which all expect a SQLXML
  //object to be a valid XML document. Workaround is to use the Oracle EXTRACT function on a wrapped version of the
  //fragment, to create a SQLXML object which represents the fragment.

  CLOB lClob = pUCon.getTemporaryClob();
  try {
    Writer lClobWriter = lClob.setCharacterStream(0);
    //Add a parent "root" node to wrap the fragment
    lClobWriter.write("<root>" + mSelectedNodes.outputNodesToString() + "</root>");
    lClobWriter.close();
  }
  catch (IOException | SQLException e) {
      throw new ExInternal("Error Writing to temporary clob for xmltype fragment", e);
  }

  // send the clob to the dataase and extact the xml root
  PreparedStatement lExtractStatement = pUCon.getJDBCConnection().prepareStatement(CLOB_TO_XML_FRAGMENT_CONVERSION_SQL);
  lExtractStatement.setClob(1, lClob);

  //Execute the query and increment the result set
  mFragmentResultSet = lExtractStatement.executeQuery();
  mFragmentResultSet.next();

  //Now the object returned should be an xml fragment
  mSQLXML = mFragmentResultSet.getSQLXML(1);

  lClob.freeTemporary();
  lExtractStatement.close();

  return mSQLXML;
}
 

import oracle.sql.CLOB; //导入依赖的package包/类
@Override
public Object getLOBForBinding(UCon pUCon, BindSQLType pBindTypeRequired, DOM pDOM) {
  if(pBindTypeRequired == BindSQLType.CLOB) {
    return mFetchedCLOB;
  }
  else if (pBindTypeRequired == BindSQLType.XML) {
    return pUCon.convertClobToSQLXML(mFetchedCLOB);
  }
  else {
    throw new ExInternal("Don't know how to bind XML LOB as a " + pBindTypeRequired + ")");
  }
}