oracle的blob和clob字段的处理

/**
* first of all,login the oracle's sqlplus with your userName and password
* in this sample
* SID = oracle
* userName = jiaoxue
* password = jiaoxue
*
* create the two test tables for use with the following statements
* CREATE TABLE TESTBLOB (id NUMBWE(20), name VARCHER2(20), blobattr BLOB);
* CREATE TABLE TESTCLOB (id NUMBWE(20), name Varchar2(20), blobattr BLOB);
*
*/
package com.thomas.blog_clob;

import java.io.BufferedInputStream;
import java.io.BufferedOutputStream;
import java.io.BufferedReader;
import java.io.BufferedWriter;
import java.io.ByteArrayInputStream;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.FileReader;
import java.io.FileWriter;
import java.io.IOException;
import java.io.OutputStream;
import java.io.Reader;
import java.io.Writer;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class BlobAndClobTest {

public static void main(String[] args){
//insertStringIntoBlob();
//getStringFromBlob();
//insertByteArrayIntoBlob();

//insertFileIntoBlob();
//getFileFromBlob();
//modifyFileIntoBlob();
//modifyAFileIntoBlobClearly();

//insertStringIntoClob();
//getStringFromClob();
//insertFileIntoClob();
//getFileFromClob();
//modifyFileArrayIntoClob();
modifyFileArrayIntoClobClearly();
}


/********************************************************************************
* 字符串和blob之间的转换 *
********************************************************************************/
public static void insertStringIntoBlob() {
Connection con = null;
Statement stmt = null;
ResultSet rs = null;
boolean defaultCommit = true;
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
con = DriverManager.getConnection("jdbc:oracle:thin:@192.168.1.254:1521:oracle", "jiaoxue","jiaoxue");
defaultCommit = con.getAutoCommit();

 1/10    1 2 3 4 5 6 下一页 尾页