Speicherung der Textdaten in Datenbank CLOB-Feld

Quellecode

 1 Connection conn = DBUtil.getConnection();
 2 conn.setAutoCommit(false);
 3 Statement stmt = conn.createStatement();
 4 
 5 // Initialisierung der CLOB-Felder. sonst folgt NullPointerException
 6 String initSql = "UPDATE ATTACHMENT SET MYCLOB=EMPTY_CLOB() WHERE ID=1";
 7 
 8 // Zugriff auf CLOB-Felder
 9 String updateSql = "SELECT MYCLOB FROM ATTACHMENT WHERE ID=1";
10 stmt.executeUpdate(initSql);
11 
12 ResultSet rs = stmt.executeQuery(updateSql);
13 if (rs.next()) {
14     // Abholung und Konvertierung der Inhalte von CLOB zu oracle.sql.CLOB
15     CLOB clob = (CLOB) rs.getClob(1);
16     // Definition CLOB's OutputStream
17     Writer os = clob.getCharacterOutputStream();
18     // Lesen der Text
19     BufferedReader br = new BufferedReader(new FileReader(new File("D:/Test.java")));
20     String line = br.readLine();
21     StringBuffer buffer = new StringBuffer();
22     while (line != null) {
23         buffer.append(line);  
24         line = br.readLine();
25     }
26     os.write(buffer.toString());
27     os.flush();
28     br.close();
29     os.close();
30     conn.commit();
31     conn.close();
32 }

gelagert.

转载于:https://www.cnblogs.com/wissen/archive/2012/02/01/2335002.html