处理大数据对象clob数据和blob数据

直接上下代码：

package com.learn.jdbc.chap06;

import java.io.File;
import java.io.FileInputStream;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.PreparedStatement;

import com.learn.jdbc.model.Album;
import com.learn.jdbc.util.DbUtil;

/**
 * 处理大数据对象clob数据和blob数据--插入
 * @author Administrator
 *
 */
public class Demo1 {
    private static DbUtil dbUtil=new DbUtil();
    
    private static int addAlbum(Album ab) throws Exception{
        Connection con = dbUtil.getCon();
        String sql="insert into sp_album_test values (null,?,?,?,?,?)";
        PreparedStatement pstmt = con.prepareStatement(sql);
        pstmt.setString(1, ab.getName());
        pstmt.setInt(2, ab.getUid());
        pstmt.setLong(3, ab.getTime());
        
        // 大字符数据(clob数据)插入数据库--文本文件
        File content = ab.getContent();
        InputStream inputStream = new FileInputStream(content);
        pstmt.setAsciiStream(4, inputStream, content.length());
        
        // 二进制数据(blob数据)插入数据库--图片,电影,音乐
        File pic = ab.getPic();
        InputStream inputStream2 = new FileInputStream(pic);
        pstmt.setBinaryStream(5, inputStream2, pic.length());
        
        int result = pstmt.executeUpdate();
        dbUtil.close(pstmt, con);
        return result;
    }
    
    public static void main(String[] args) throws Exception {
        File content = new File("e:/code.txt");
        File pic     = new File("e:/Koala111.png");
        Album ab = new Album("张三", 1, System.currentTimeMillis(), content, pic);
        int result = addAlbum(ab);
        if(result>0){
            System.out.println("数据插入成功");
        }else{
            System.out.println("数据插入失败");
        }
    }
}

package com.learn.jdbc.chap06;

import java.io.File;
import java.io.FileOutputStream;
import java.io.OutputStream;
import java.sql.Blob;
import java.sql.Clob;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

import com.learn.jdbc.util.DbUtil;


/**
 * 处理大数据对象clob数据和blob数据--查询
 * @author Administrator
 *
 */
public class Demo2 {
    private static DbUtil dbUtil=new DbUtil();
    
    private static void listAlbum(int id) throws Exception{
        Connection con = dbUtil.getCon();
        String sql="select * from sp_album_test where id=?";
        PreparedStatement pstmt = con.prepareStatement(sql);
        pstmt.setInt(1, id);
        ResultSet rs = pstmt.executeQuery();
        
        if(rs.next()){
            String name = rs.getString("name");
            int uid = rs.getInt("uid");
            long time = rs.getLong("add_time");
            // 读取大字符数据--clob数据
            Clob clob =rs.getClob("content");
            String content = clob.getSubString(1,(int) clob.length());
            
            // 读取二进制数据--blob数据
            Blob blob = rs.getBlob("pic");
            OutputStream out = new FileOutputStream(new File("e:/kaola.png"));
            out.write(blob.getBytes(1, (int) blob.length()));
            out.close();
            
            System.out.println("名字："+name);
            System.out.println("uid: "+uid);
            System.out.println("时间: "+time);
            System.out.println("内容: "+content);
            
            
        }
        
    }
    
    
    public static void main(String[] args) throws Exception {
        listAlbum(1);
    }
}