PreparedStatement操作Blob类型的数据

JDBC
使用PreparedStatement操作Blob类型的数据

/**
 * 	
* @Description 测试使用PreparedStatement操作Blob类型的数据
* @author muYang  Email:786885864@qq.com  
* @version   
* @date 2020年11月11日下午5:29:31  
*
 */
public class BlobTest {
	
	@Test
	public void testInsert() throws Exception {
		
		Connection conn = JDBCUtil.getConnection();
		String sql = "insert into customers(name,email,birth,photo)values(?,?,?,?)";
		
		PreparedStatement ps = conn.prepareStatement(sql);
		
		ps.setObject(1, "yang");
		ps.setObject(2, "yang@qq.com");
		ps.setObject(3, "1999-01-13");
		
		FileInputStream is = new FileInputStream(new File("cai.jpg"));
		ps.setBlob(4, is);
		
		ps.execute();
		
		JDBCUtil.closeResourse(conn, ps);
	}
	
	
	
	//查询数据表customers中Blob类型的字段
	@Test
	public void testQuery() throws Exception {
		
		Connection conn = null;
		PreparedStatement ps = null;
		ResultSet rs = null;
		InputStream bs = null;
		FileOutputStream fos = null;
		try {
			conn = JDBCUtil.getConnection();
			
			String sql = "select  id,name,email,birth,photo from customer where id = ?";
			ps = conn.prepareStatement(sql );
			
			rs = ps.executeQuery();
			if(rs.next()) {
				int id = rs.getInt("id");
				String name = rs.getString("name");
				String email = rs.getString("email");
				Date birth = rs.getDate("birth");
				
				
				//将blob类型的字段下载下类，并以文件的格式保存在本地
				Blob blob = rs.getBlob("photo");
				
				bs = blob.getBinaryStream();
				fos = new FileOutputStream("yang");
				byte[] buffer = new byte[1024];
				int len;
				if((len = bs.read(buffer)) != -1) {
					fos.write(buffer,0,len);
				}
			}
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		
		bs.close();
		fos.close();
		
		JDBCUtil.closeResourse(conn, ps,rs);
		
	}
	
	
}