向数据库中插入图片

  代码中Customer类的构造查看：针对单个表进行通用的查询操作_qq_46053741的博客-CSDN博客

代码中jdbcConnection类的构造查看：封装数据库的连接关闭操作_qq_46053741的博客-CSDN博客

public class BlobTest {
	@Test
	public void test(){
		String sql="insert into customers(name,email,birth,photo)values(?,?,?,?)";
		FileInputStream is=null;
		try {
			is = new FileInputStream(new File("D:\\Download\\图片\\5.jpg"));
		} catch (FileNotFoundException e) {
			e.printStackTrace();
		}finally{
            if(is!=null)
                is.close();
        }
		String str=testInsert(sql,"大雄","123@qq.com","2000-01-01",is);
		System.out.println(str);
	}
	public String testInsert(String sql,Object ...args){
		//1、获取连接
		Connection conn=null;
		//2、实例化PreparedStatement对象
		PreparedStatement ps=null;
		int flag = 0;
		try {
			conn = jdbcConnection.connection();
			ps = conn.prepareStatement(sql);
			//3、填充占位符
			for(int i=0;i<args.length;i++){
				ps.setObject(i+1,args[i]);
			}
			//4、执行
			flag=ps.executeUpdate();
		} catch (Exception e) {
			e.printStackTrace();
		}finally{
			jdbcConnection.CloseResource(conn, ps);
		}
		if(flag>0){
			return "成功插入一条数据";
		}else{
			return "数据插入失败";
		}
	}
}