Populating an Oracle table with a CLOB column

learnscript

Sorry, I can't type Chinese on this machine, and hopefully you can unstand my English.
I need to populate a sample Oracle table, which has at least four columns: filename, createdata, author, and content.
The table stores info for some html files, and the column content will contain the body characters of the html files.
I will do a for loop and open files one by one(up to 500 max), then do a query update. The problem is that I am not familiar
with Oracle SQL programming, especially the CLOB datatype. I am not sure what's the right way to populate a table that contains
a CLOB column. Below is the draft I have, any suggestion or observation? Thanks in advance.

1. 
   
2. import java.sql.*;
   
3. import java.io.*;
   
4. //import oracle jdbc driver
   
5. 
   
6. //create the tableString cmd = "CREATE TABLE file (filename varchar(30), createdate varchar(10), author varchar(30), content clob)";
   
7. stmt.execute (cmd); PreparedStatement pstmt = conn.prepareStatement(""insert into FILE (filename, createdate, author, content) values (?, * ?, ?, ?, ?)");
   
8. 
   
9. String fileName;
   
10. Date createDate;
    
11. String author;
    
12. pstmt.setString (1, fileName);  // Set the Bind Value
    
13. pstmt.setDATE (2, createDate);  
    
14. pstmt.setString (3, author);  
    
15. pstmt.setCLOB (4, empty_blob());   
    
16. 
    
17. //the top level dir will be command line input
    
18. File startDir = new File(args[1]);
    
19. if ( !startDir.isDirectory() )
    
20. {System.out.println("Please give me a dir!!!\n");
    
21. return;
    
22. }
    
23. File[] contents = startDir.listFiles();
    
24. for( int i=0; i<500 && i<contents.length; i++)
    
25. {
    
26. //open file only and read in data, ignor dirs
    
27. if( !contents[i].isDirectory() )
    
28. {
    
29. fileName = contents[i].getName();
    
30. createDate = new Date(contents[i].lastModified());
    
31. //author =
    
32. CLOB content;
    
33. String cmd = "SELECT * FROM file WHERE filename=fileName";
    
34. ResultSet rest = stmt.executeQuery(cmd);
    
35. CLOB clob = ((OracleResultSet)rset).getCLOB(4);
    
36. 
    
37. System.out.println("the length = " + content[i].length());
    
38. FileInputStream instream = new FileInputStream(content[i]);
    
39. OutputStream outstream = clob.getCharacterOutputStream();
    
40. int size = clob.getBufferSize();
    
41. byte[] buffer = new byte[size];
    
42. int length = -1;
    
43. while ((length = instream.read(buffer)) != -1) {
    
44. outstream.write(buffer, 0, length);
    
45. }
    
46. instream.close();
    
47. outstream.close();}}
    

复制代码