读取和写入大字段(Oracle,JDBC)

最新推荐文章于 2019-08-03 23:44:39 发布

iteye_17267

最新推荐文章于 2019-08-03 23:44:39 发布

阅读量96

点赞数

文章标签： java 数据库

本文介绍了一个使用Java进行数据库CLOB字段读写的示例程序。该程序通过连接Oracle数据库，演示了如何将文件内容写入CLOB字段，并从数据库中读取CLOB字段的内容并打印。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

package test; import java.io.BufferedReader; import java.io.File; import java.io.FileInputStream; import java.io.FileNotFoundException; import java.io.IOException; import java.io.InputStreamReader; import java.io.Reader; import java.sql.Clob; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; //向数据库中写入大字段 public class CLOB_Test { static { try { Class.forName("oracle.jdbc.driver.OracleDriver"); } catch (ClassNotFoundException e) { e.printStackTrace(); } } public static void main(String[] args) { // insertCLOB(); readCLOB(); } // 插入大文本 private static void insertCLOB() { String url = "jdbc:oracle:thin:@127.0.0.1:1521:oracle"; String user = "chenl"; String password = "chenl"; String sql = "insert into c_lob_blob(C) values(?)"; Connection conn = null; PreparedStatement pstmt = null; FileInputStream input = null; try { conn = DriverManager.getConnection(url, user, password); pstmt = conn.prepareStatement(sql); File file = new File("src/com/优快云Swing.java"); input = new FileInputStream(file); Reader reader = new InputStreamReader(input); pstmt.setCharacterStream(1, reader, (int) file.length()); pstmt.executeUpdate(); conn.commit(); System.out.println("writer ok!"); } catch (FileNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } finally { if (pstmt != null) { try { pstmt.close(); } catch (SQLException e) { e.printStackTrace(); } } if (conn != null) { try { conn.close(); } catch (SQLException e) { e.printStackTrace(); } } } } private static void readCLOB() { String url = "jdbc:oracle:thin:@127.0.0.1:1521:oracle"; String user = "chenl"; String password = "chenl"; Connection conn = null; PreparedStatement pstmt = null; ResultSet rs = null; try { conn = DriverManager.getConnection(url, user, password); String sql = "select c from c_lob_blob"; pstmt = conn.prepareStatement(sql); rs = pstmt.executeQuery(); System.out.println(rs); while (rs.next()) { Clob clob = rs.getClob(1); Reader reader = clob.getCharacterStream(); BufferedReader buff = new BufferedReader(reader); System.out.println(buff); String temp = ""; while((temp = buff.readLine()) != null){ System.out.println(temp); } } } catch (SQLException e) { e.printStackTrace(); } catch (IOException e) { e.printStackTrace(); } } }