JDBC存取大字段代码(参考)

package wav;
import java.io.BufferedInputStream;
import java.io.File;
import java.io.FileInputStream;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.Statement;

/*
create table words(
en varchar(30) primary key,
cn varchar(100),
wav image
);

大量的字符(如小说)
create table words(
en varchar(30) primary key,
cn varchar(100),
wav clob
);

大量的二进制(如图片，word文档，电影)
create table words(
en varchar(30) primary key,
cn varchar(100),
wav blob
);

 

iamge:不是图片的意思。
 */
public class Test7 {
 public static void main(String[] args) throws Exception{
  //加载驱动(读取jar包并初始化……)
  Class.forName("net.sourceforge.jtds.jdbc.Driver");//.class
  
  String url = "jdbc:jtds:sqlserver://localhost:1433/lovo67";
  
  Connection conn = DriverManager.getConnection(url, "sa", "");
  
  //将sql嵌入到java代码中:嵌入式sql开发
  String sql = "insert into words(en,cn,wav) values(?,?,?)";
  PreparedStatement pst = conn.prepareStatement(sql);
  pst.setString(1, "a");
  pst.setString(2, "a");
  
  
  File file = new File("wav/a.wav");
       InputStream in = new BufferedInputStream(new FileInputStream(file));
         pst.setBinaryStream(3, in, (int) file.length());
        
        
         int i = pst.executeUpdate();
         in.close();

         pst.close();
  conn.close();
 }
}

 

 

 

 

 

 public static void main(String[] args) throws Exception{
  //加载驱动(读取jar包并初始化……)
  Class.forName("net.sourceforge.jtds.jdbc.Driver");//.class
  
  String url = "jdbc:jtds:sqlserver://localhost:1433/lovo67";
  
  Connection conn = DriverManager.getConnection(url, "sa", "");
  
  //将sql嵌入到java代码中:嵌入式sql开发
  
  String sql = "select * from words where en=?";
  PreparedStatement pst = conn.prepareStatement(sql);
  pst.setString(1, "a");
  
  ResultSet rs = pst.executeQuery();
  String path = null;
  while(rs.next()){
   System.out.println(rs.getString(1)+","+rs.getString(2));
   

      InputStream in = rs.getBinaryStream("wav");

      //主要面试代码
      path = "wav/"+rs.getString(1)+".wav";
      File file = new File(path);
     
            OutputStream out = new BufferedOutputStream(new FileOutputStream(file));
            byte[] buff = new byte[1024];
             for (int i = 0; (i = in.read(buff)) > 0;) {
                 out.write(buff, 0, i);
            }
              
               out.close();
               in.close();
  }
  
         pst.close();
  conn.close();
  

 }