Clob和Blob

Clob:
.

/

package Ajdbc1;

import jdk.jfr.events.FileReadEvent;

import java.io.FileReader;
import java.io.Reader;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

public class Test5 {
    public static void main(String[] args) {
        //添加
        //addClob();
        //查询（读取）
        queryClob();
    }
    //添加
    public static void addClob(){
        Connection conn=null;
        PreparedStatement stm=null;
        try {
            conn=DBUtil.getConn();
            String sql="insert tclob(title,context) values(?,?)";
            stm=conn.prepareStatement(sql);
            stm.setString(1,"这是标题");
            Reader r=new FileReader("H://aa.txt");//io
           stm.setCharacterStream(2,r);
           int rs=stm.executeUpdate();
            System.out.println(rs);

        }catch (Exception e){
            e.printStackTrace();
        }finally {
            DBUtil.close(null,stm,conn);
        }
    }

    //查询
    public static void queryClob(){
        Connection conn=null;
        ResultSet rs=null;
        PreparedStatement stm=null;
        try {
            conn=DBUtil.getConn();
            String sql="select * from tclob where id=?";
            stm=conn.prepareStatement(sql);
            stm.setInt(1,1);
            rs=stm.executeQuery();
            if (rs.next()){
                System.out.println(rs.getString("title"));
                Reader r = rs.getCharacterStream("context");
                char[] ch=new char[1024];
                int len=0;
                while ((len=r.read(ch))!=-1){
                    System.out.println(new String(ch,0,len));
                }
                r.close();
            }
        }catch (Exception e){
            e.printStackTrace();
        }finally {
            DBUtil.close(rs,stm,conn);
        }
    }
}

/
/
/
blob:
/

package Ajdbc1;

import java.io.*;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

public class Test6 {
        public static void main(String[] args) {
            //添加
            addBlob();
            //查询（读取）
            //queryClob();
        }
        //添加
        public static void addBlob(){
            Connection conn=null;
            PreparedStatement stm=null;
            try {
                conn=DBUtil.getConn();
                String sql="insert tclob(title,context) values(?,?)";
                stm=conn.prepareStatement(sql);
                stm.setString(1,"这是标题");
                InputStream in = new FileInputStream("H://aa.jpg");
                stm.setBinaryStream(2,in);
                int rs=stm.executeUpdate();
                System.out.println(rs);

            }catch (Exception e){
                e.printStackTrace();
            }finally {
                DBUtil.close(null,stm,conn);
            }
        }

        //查询
        public static void queryBlob(){
            Connection conn=null;
            ResultSet rs=null;
            PreparedStatement stm=null;
            try {
                conn=DBUtil.getConn();
                String sql="select * from tclob where id=?";
                stm=conn.prepareStatement(sql);
                stm.setInt(1,1);
                rs=stm.executeQuery();
                if (rs.next()){
                    System.out.println(rs.getString("title"));
                    InputStream in=rs.getBinaryStream("context");
                    OutputStream out=new FileOutputStream("H://aa.jpg");
                    byte[] buff=new byte[1024];
                    int len=0;
                    while ((len=in.read(buff))!=-1){
                        out.write(buff,0,len);
                    }
                    in.close();
                    out.close();
                }
            }catch (Exception e){
                e.printStackTrace();
            }finally {
                DBUtil.close(rs,stm,conn);
            }
        }
    }

/

/

/
/
/
/一般用varchar:

.

.
c://temp/img/用户1头像.jpg是存放的位置