Oracle10g 操作大对象-优快云博客

本文链接：https://blog.youkuaiyun.com/ThinkingInjavaztf/article/details/83708590

本文介绍了一个Java程序，该程序使用Oracle JDBC驱动实现从数据库中获取员工姓名，并演示了如何使用OraclePreparedStatement进行大容量数据（CLOB类型）的插入，突破常规长度限制。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

package com.ztf.getResult;

import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

import oracle.jdbc.driver.OraclePreparedStatement;

import com.ztf.getImp.IgetResult;

import com.ztf.util.GetConnection;

public class getRestult implements IgetResult {

public void getEmpEname(){

Connection conn = null;

String sql="select ename from emp";

Statement st =null;

ResultSet rs =null;

conn = GetConnection.getConnection();

try {

st = conn.createStatement();

rs = st.executeQuery(sql);

while(rs.next()){

System.out.println(rs.getString("ename"));

}

} catch (SQLException e) {

e.printStackTrace();

}

finally{

try {

rs.close();

st.close();

conn.close();

} catch (SQLException e) {

e.printStackTrace();

}

}

}

/*

* 用Statement进行测试最大插入的字符为为4000 字符

*/

/*

public void InsertClob() {

Connection conn = null;

Statement st = null;

String sql ="INSERT INTO T VALUES(2,'"+getStr(4001,"a")+"')";

try {

conn = GetConnection.getConnection();

st = conn.createStatement();

st.executeQuery(sql);

conn.commit();

System.out.println("插入成功");

} catch (SQLException e) {

e.printStackTrace();

}

}

*/

/*

* 用PraperStatement测试能插入的最大的长度；

* 为：

*/

/*

public void InsertClob() {

Connection conn = null;

PreparedStatement ps = null;

String sql ="INSERT INTO T VALUES(10,?)";

conn = GetConnection.getConnection();

try {

ps= conn.prepareStatement(sql);

ps.setString(1, getStr(60000,"s"));

ps.executeUpdate();

conn.commit();

System.out.println(" 插入成功");

} catch (SQLException e) {

e.printStackTrace();

}

finally{

try {

conn.close();

ps.close();

} catch (SQLException e) {

e.printStackTrace();

}

}

}

*/

/*

*要想插入数据不受限制可以用Oracle提供的方法来插入数据

*OraclePrapredStatement

*/

public void InsertClob() {

Connection conn = null;

String sql="INSERT INTO T VALUES(10,?)";

OraclePreparedStatement rps;

try {

conn = GetConnection.getConnection() ;

rps = (OraclePreparedStatement) conn.prepareStatement(sql);

rps.setString(1, getStr(1000000,"X"));

rps.executeQuery();

conn.commit();

} catch (Exception e) {

e.printStackTrace();

}

}

private String getStr(int x,String str){

String strx="";

for(int i=0 ;i<x;i++){

strx +=str;

}

return strx;

}

}