JDBC学习（七）：操作Blob类型数据

package demo04;
import java.io.File;
import java.io.FileInputStream;
import java.sql.Connection;
import java.sql.PreparedStatement;
import org.junit.jupiter.api.Test;
import utils.JDBCUtils;
public class BlobTest {
  @Test
  public void test(){
    Connection conn = null;
    PreparedStatement ps = null;
    try {
      conn = JDBCUtils.getConnection();
      String sql = "insert into beauty(name,sex,phone,photo)values(?,?,?,?)";
      ps = conn.prepareStatement(sql);
      ps.setObject(1, "刘亦菲");
      ps.setObject(2, "女");
      ps.setObject(3, "18209179577");
      FileInputStream fis = new FileInputStream(new File("liu.png"));
      ps.setBlob(4, fis);
      ps.execute();
    }catch (Exception e) {
      // TODO 自动生成的 catch 块
      e.printStackTrace();
    }finally {
      JDBCUtils.closeResourse(conn, ps);
    }
  }
}