操作CLOB数据

操作CLOB数据。使用的是oracle驱动

代码如下：

package com.j2ee14.ch7;

import java.io.File;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.InputStream;
import java.sql.Blob;
import java.sql.Clob;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;

public class ClobTest {
	Connection conn= null;
	
	public void addClob(){
		try{
			PreparedStatement pstmt=conn.prepareStatement("insert into clobtest values(1,?)");
			File file=new File("c:\\test.txt");
			FileInputStream fis=new FileInputStream(file);
			pstmt.setAsciiStream(1, fis,(int)file.length());
			pstmt.executeUpdate();
			pstmt.close();
			fis.close();
		}catch(Exception e){
			e.printStackTrace();
		}
	}

	public void createTable(){
		try{
			conn.createStatement().execute("create table clobtest(id int,myfile clob)");
		}catch(Exception e){
			e.printStackTrace();
		}
	}
	
	public void getClob(){
		try{
			Statement stmt= conn.createStatement();
			ResultSet rst=stmt.executeQuery("select * from clobtest where id=1");
			rst.next();
			Clob blob=rst.getClob("myfile");
			FileOutputStream out = new FileOutputStream(new File("c:/k2.txt"));
			InputStream in= blob.getAsciiStream();
			int i;
			while((i=in.read())!= -1)
				out.write(i);
			in.close();
			out.close();
		}catch(Exception e){
			e.printStackTrace();
		}
	}
	
	public static void main(String[] args)throws Exception {
		Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
		ClobTest test=new ClobTest();
		test.conn=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl","bill","bill");
		test.createTable();
		test.addClob();
		test.getClob();
		
	}
}

 

上面数据库的连接时用普通用户和密码。

执行后结果是数据库orcl中多了一张clobtest表。

 

c盘下多了一个k2.txt,如下图;