用jdbc访问大段文本数据

package it.cast.jdbc;

import java.io.BufferedReader;
import java.io.BufferedWriter;
import java.io.File;
import java.io.FileNotFoundException;
import java.io.FileReader;
import java.io.FileWriter;
import java.io.IOException;
import java.io.Reader;
import java.io.Writer;
import java.sql.Clob;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class ClobTest {

    public static void main(String[] args) throws IOException {
        read();
    }

    static void create() throws IOException {
        Connection conn = null;
        PreparedStatement ps = null;
        ResultSet rs = null;

        try {
            // 建立连接
            conn = jdbcUtils.getConnection();

            // 创建语句
            String sql = "insert into clob_test(big_text) values (?)";

            ps = conn.prepareStatement(sql);

            File file = new File("src/it/cast/jdbc/Base.java");
            Reader reader = new BufferedReader(new FileReader(file));

            ps.setCharacterStream(1, reader, (int) file.length());

            // 执行语句
            int i = ps.executeUpdate();
            reader.close();

            System.out.println(i);

        } catch (SQLException e) {

            e.printStackTrace();
        } finally {
            jdbcUtils.free(rs, ps, conn);
        }
    }

    static void read() throws IOException {
        Connection conn = null;
        Statement st = null;
        ResultSet rs = null;

        try {

            // 建立连接
            conn = jdbcUtils.getConnection();

            // 创建语句
            st = conn.createStatement();

            String sql = "select big_text from clob_test";

            // 执行语句
            rs = st.executeQuery(sql);

            while (rs.next()) {
                Clob clob = rs.getClob(1);
                Reader reader = clob.getCharacterStream();
                File file = new File("jdbcUtils_bak.java");
                Writer writer = new BufferedWriter(new FileWriter(file));
                char[] buff = new char[1024];

                for (int i = 0; (i = reader.read(buff)) > 0;) {
                    writer.write(buff, 0, i);
                }

                writer.close();
                reader.close();
            }

        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            jdbcUtils.free(rs, st, conn);
        }
    }

}