jdbc存取blob所用的时间代码

文章作者 100test 发表时间 2007:12:01 14:43:30
来源 100Test.Com百考试题网

package com.jy.
import java.sql.Connection.
import java.sql.DriverManager.
import java.util.Date.
import java.util.Properties.
import java.io.*.
import java.net.URL.
import java.sql.*.
import oracle.jdbc.driver.OracleResultSet.
import oracle.sql.CLOB.
import oracle.sql.BLOB.
public class ClobTest {
public static void main(String[] args) {
String dbDriver = "oracle.jdbc.driver.OracleDriver".
String urlStr = "jdbc:oracle:thin:@192.168.0.1:1521:ora10".
String userid = "test".
String pwd = "test".
try {
Class.forName(dbDriver).
Connection conn = DriverManager.getConnection(urlStr, userid, pwd).
// 写clob
conn.setAutoCommit(false).
Statement pstmt = conn.createStatement().
ResultSet rs3 = null.
// 插入id
String idtmp = String.valueOf(new Date().getTime()).

long start = System.currentTimeMillis().
String sql = "insert into LOB_TEST (id,BLOB) values (’" idtmp
"’,empty_blob())".
pstmt.executeUpdate(sql).
conn.commit().
sql = "0select BLOB from LOB_TEST where id = ’" idtmp
"’ for 0update".
rs3 = pstmt.executeQuery(sql).
if (rs3.next()) {
Blob blob = rs3.getBlob(1).
OutputStream out = ((oracle.sql.BLOB) blob)
.getBinaryOutputStream().
byte[] b = new byte[((oracle.sql.BLOB) blob).getBufferSize()].
File file = new File("D:/old.dmp").
InputStream fin = new FileInputStream(file).
int len = 0.
while ((len = fin.read(b)) != -1)