[ Oracle的Clob字段一般的数据库系统没有。它的读方法也有些不同。下面是一段读的代码包括了JavaBean的数据库连接和Clob的实现方法:1 db.java连接数据库的JavaBean:pack
CLOB用于存储大量的字符数据,读取CLOB的JDBC代码如下所示
import java.sql.*;
import java.io.*;
public class ReadClob {
public static void main(String[] args) {
PreparedStatement pstmt = null;
ResultSet rset = null;
BufferedReader reader = null;
Connection conn = null;
String driver = "oracle.jdbc.driver.OracleDriver";
String strUrl = "jdbc:oracle:thin@127.0.0.1:1521:ORCL";
try {
Class.forName(driver);
conn = DriverManager.getConnection(strUrl, "scott", "tiger");
pstmt = conn
.prepareStatement("select v_clob form ord where ORD_id =?");
pstmt.setInt(1, 1);
rset = pstmt.executeQuery();