查询数据表customers中Blob类型的字段
@Test
public void testQuery() {
Connection conn = null;
PreparedStatement ps = null;
InputStream is= null;
FileOutputStream fos= null;
ResultSet rs = null;
try {
conn = JDBCUtil.getConnection();
String sql="select id,name,email,birth,photo from customers where id=?";
ps = conn.prepareStatement(sql);
ps.setObject(1, 21);
is = null;
fos = null;
rs = ps.executeQuery();
if (rs.next()){
int id = (int) rs.getObject(1);
String name = rs.getString(2);
String email = rs.getString(3);
Date birth = rs.getDate(4);
Customer cust = new Customer(id, name, email, birth);
System.out.println(cust);
Blob photo = rs.getBlob(5);
is = photo.getBinaryStream();
fos = new FileOutputStream("cxy.jpg");
byte[] buffer = new byte[1024];
int len;
while ((len=is.read(buffer))!=-1){
fos.write(buffer, 0, len);
}
}
} catch (Exception e) {
e.printStackTrace();
} finally {
JDBCUtil.closeResource(conn, ps,rs);
try {
if (is !=null)
is.close();
} catch (IOException e) {
e.printStackTrace();
}
try {
if (fos !=null)
fos.close();
} catch (IOException e) {
e.printStackTrace();
}
}
}
向数据表customers中插入Blob类型的字段
@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, "cxy");
ps.setObject(2, "cxy@qq.com");
ps.setObject(3, "1998-08-18");
FileInputStream is = new FileInputStream(new File("C:\\Users\\63096\\Desktop\\相关性分析热力图.png"));
ps.setBlob(4, is);
ps.execute();
JDBCUtil.closeResource(conn, ps);
}