Read CLOBs data from database
import java.io.File; import java.io.FileWriter; import java.io.Reader; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; publicclass Main { privatestatic String url = "jdbc:oracle:thin:@localhost:1521:javaDemo"; privatestatic String username = "java"; privatestatic String password = "welcome"; publicstaticvoid main(String[] args) throws Exception { Class.forName("oracle.jdbc.driver.OracleDriver"); Connection conn = DriverManager.getConnection(url, username, password); PreparedStatement stmt = conn.prepareStatement("SELECT name, description, data FROM documents "); ResultSet resultSet = stmt.executeQuery(); while (resultSet.next()) { String name = resultSet.getString(1); String description = resultSet.getString(2); File data = newFile("C:\\a.txt"); Reader reader = resultSet.getCharacterStream(3); FileWriter writer = new FileWriter(data); char[] buffer = newchar[1]; while (reader.read(buffer) > 0) { writer.write(buffer); } writer.close(); } conn.close(); } } Related examples in the same category
