特别长的字符串 想存到数据库中,的clob大字段中,大概4000字时报错,字符串太长,原因是sql语句大小不能超过4K,所以报这错,下面是我在网上找到的解决方法
package com.sinocec.model;
import java.io.BufferedReader;
import java.io.IOException;
import java.io.Writer;
import java.sql.Clob;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class ClobTest {
private static Connection conn;
static {
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
conn = DriverManager.getConnection(
"jdbc:oracle:thin:@192.168.1.11:1521:orcl","scott","tiger");
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
}
public static void main(String[] args) throws SQLException, IOException {
//testInsert();
//testUpdate();
//testRead();
}
private static void testInsert() throws SQLException {
String sql = "insert into TECDESIGNALBUM (td_id,FILENAME,note) values (350,'bb',empty_clob())";
Statement stm = conn.createStatement();
stm.execute(sql);
stm.close();
}
private static void testUpdate() throws SQLException, IOException {
String bigdata = "这是一个大字段。。。";
String sql = "select note from TECDESIGNALBUM where td_id = 350 for update";
Statement stm = conn.createStatement();
ResultSet rs = stm.executeQuery(sql);
while (rs.next()) {
Clob c = rs.getClob(1);
c.truncate(0);// clear
Writer w = c.setCharacterStream(1L);//The first position is 1
w.write(bigdata);
w.close();
c.setString(c.length(), bigdata);
conn.commit();
}
conn.close();
}
private static void testRead() throws SQLException, IOException {
String sql = "select content from test_clob where id = 1";
PreparedStatement pstm = conn.prepareStatement(sql);
ResultSet rs = pstm.executeQuery();
while (rs.next()) {
Clob clob = rs.getClob("content");
System.out.println("clob.getSubString(1, 2) --> " + clob.getSubString(1, 2));
System.out.println("clob.getSubString(1, (int)clob.length()) --> " +
clob.getSubString(1, (int)clob.length()));
BufferedReader r = new BufferedReader(clob.getCharacterStream());
String s;
while ((s = r.readLine()) != null) {
System.out.println(s);
}
r.close();
}
}
}