大段文本写入数据库
package zucc.edu.cn.jdbc;
import java.io.BufferedReader;
import java.io.File;
import java.io.FileReader;
import java.io.IOException;
import java.io.Reader;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
public class ClobTest {
public static void main(String[] args) throws SQLException, IOException {
create();
}
public static void create() throws SQLException, IOException {
Connection conn = null;
PreparedStatement ps = null;
ResultSet rs = null;
try {
// 2.建立连接
conn = jdbcUtils.getinstance().getConnection();
// 3.创建执行SQL的语句
String sql = "insert into clob_test (big_text) value (?)";
ps = conn.prepareStatement(sql);
File file = new File("src/zucc/edu/cn/jdbc/jdbcUtils.java");
Reader reader = new BufferedReader(new FileReader(file));
ps.setCharacterStream(1, reader, (int)file.length());
// 4.执行语句
ps.executeUpdate();
reader.close();
} finally {
// 6.释放资源
jdbcUtils.free(rs, ps, conn);
}
}
}
1 package zucc.edu.cn.jdbc;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;...........................
读取数据库里的大段文本
public static void read() throws SQLException, IOException {
Connection conn = null;
PreparedStatement ps = null;
ResultSet rs = null;
try {
// 2.建立连接
conn = jdbcUtils.getinstance().getConnection();
// 3.创建执行SQL的语句
String sql = "select big_text from clob_test";
ps = conn.prepareStatement(sql);
// 4.执行语句
rs = ps.executeQuery();
// 5.处理结果
while (rs.next()) {
// Clob clob = rs.getClob(1);
// Reader reader = clob.getCharacterStream();
Reader reader = rs.getCharacterStream(1);
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; i++) {
writer.write(buff, 0, i);
}
writer.close();
reader.close();
}
} finally {
// 6.释放资源
jdbcUtils.free(rs, ps, conn);
}
}