mysql文件写入和读出数据库

1. //写入文件到数据库 
2.     static void insert()throws Exception 
3.     { 
4.         String sql ="insert into news (info) values (?)"; 
5.         Connection conn=JdbcUtilSingle.getConnection(); 
6.          
7.         PreparedStatement pst=conn.prepareStatement(sql); 
8.          
9.         File file = new File("src/jdbc/test/day01/Jdbc01.java"); 
10.         //这里不能用字节流，需要用字符流 
11.         //InputStream inputstream = new BufferedInputStream(new FileInputStream(file)); 
12.         Reader reader = new BufferedReader(new FileReader(file)); 
13.          
14.         //这里也不能再用setBinaryStream了 
15.         //setBinaryStream(1, inputstream,(long)file.length()); 
16.         pst.setCharacterStream(1, reader, (int)file.length()); 
17.          
18.         int i = pst.executeUpdate(); 
19.          
20.         System.out.println(i); 
21.          
22.         JdbcUtilSingle.free(null, pst, conn); 
23.     } 
24.     //读出数据库信息写入文件 
25.     static void write()throws Exception 
26.     { 
27.         String sql="select * from news "; 
28.         Connection conn=JdbcUtilSingle.getConnection(); 
29.         PreparedStatement pst=conn.prepareStatement(sql); 
30.         ResultSet rs=pst.executeQuery(); 
31.          
32.         File file = new File("output.java"); 
33.          
34.         while(rs.next()) 
35.         { 
36.             //Blob blob = rs.getBlob(1); 
37.             //InputStream in = blob.getBinaryStream(); 
38.             //上面兩行的作用和下面這行相同 
39.             //InputStream in = rs.getBinaryStream(1); 
40.             Reader reader = rs.getCharacterStream(1); 
41.             //OutputStream out = new BufferedOutputStream(new FileOutputStream(file)); 
42.             Writer writer = new BufferedWriter(new FileWriter(file)); 
43.              
44.             //这里也要换成字符数组 
45.             //byte buff[]= new byte[1024]; 
46.             char buff[]=newchar[1034]; 
47.              
48.             //寫入文件 
49.             for(int i=0;(i=reader.read(buff))>0;) 
50.             { 
51.                 writer.write(buff, 0, i); 
52.             } 
53.         } 
54.          
55.         JdbcUtilSingle.free(rs, pst, conn); 
56.          
57.          

58.     }  

http://jason521-wang-163-com.iteye.com/blog/1542295