JDBC 關於大文字資料

大文字資料Clob，在不同的資料庫中型別名不一致，有的是text格式，有的是clob，還有其他一些格式

package test;

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;
import java.util.Date;

public class ClobTest {

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

    static void create() throws SQLException, IOException {
        Connection conn = null;
        PreparedStatement ps = null;
        ResultSet rs = null;
        Reader reader = null;
        try {
            conn = JdbcUtils.getConnection();
            //3，Statement用於“運送”sql語句和sql語句執行結果
            String sql = "insert into clob_test(big_text) values (?)";

            ps = conn.prepareStatement(sql);
            //ps.setAsciiStream(int parameterIndex, InputStream x, int length)
            File file = new File("src/test/ClobTest.java");
            reader = new BufferedReader(new FileReader(file));
            ps.setCharacterStream(1, reader,file.length());
            //4,執行sql
            int count = ps.executeUpdate();

System.out.println(count);

        } finally {
            JdbcUtils.free(rs, ps, conn);
            if(reader!=null) {
                reader.close();//為了方便這樣寫了
            }
        }
    }

    private static void read() throws ClassNotFoundException, SQLException, IOException {
        Connection conn = null;
        Statement st = null;
        ResultSet rs = null;
        Date bithday = null;
        try {
            conn = JdbcUtils.getConnection();

            st = conn.createStatement();

            rs = st.executeQuery("select big_text from clob_test");

            while(rs.next()) {

                Clob clob = rs.getClob(1);
                BufferedReader reader = new BufferedReader(clob.getCharacterStream());

                //Reader rd = rs.getCharacterStream(1);//這樣也可以的
                //String s = rs.getString(1);//String也可以關鍵是你的記憶體有沒有那麼大
                File file = new File("src/ClobTest_bak.java");
                BufferedWriter writer = new BufferedWriter(new FileWriter(file));
                String line = null;
                while((line=reader.readLine())!=null) {
                    writer.write(line);
                    writer.newLine();
                    writer.flush();
                }
                writer.close();
                reader.close();
            }
        } finally {
            JdbcUtils.free(rs, st, conn);
        }

}
}

JDBC 關於大文字資料

相關文章