package blob;
import java.io.FileInputStream;
import java.io.InputStream;
import java.nio.file.Files;
import java.nio.file.Paths;
import java.sql.Blob;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import org.junit.Test;
import pers.mjn.util.JdbcUtil;
public class BlobTest {
// 把c盘的outman.png图片的数据保存到t_image表中
@Test
public void test1() throws Exception {
String sql = "INSERT INTO t_image (img) VALUES (?)";
Connection conn = JdbcUtil.getConn();
PreparedStatement ps = conn.prepareStatement(sql);
ps.setBlob(1, new FileInputStream("C:/1.png"));
ps.executeUpdate();
JdbcUtil.close(conn, ps, null);
}
// t_image表中的图片数据保存到磁盘中
@Test
public void test2() thr