在mysql中 Blob Clob 分别为blob text 数据类型,二在java中需要导入的则是import java.sql, Blob;import java.sql.Clob,存入时Java代码为:
Session session=DButil.getConnection();
Transaction tran= session.beginTransaction();
User user=new User();
Clob clob=Hibernate.createClob("钟山风雨起苍黄,百万雄师过大江。虎踞龙盘今胜昔,天翻地覆慨而慷。宜将剩勇追穷寇,不可沽名学霸王。天若有情天亦老,人间正道是沧桑。");
InputStream in=new FileInputStream("D:\\pic.jpg");
Blob blob=Hibernate.createBlob(in);
user.setId(1);
user.setInfo(clob);
user.setPic(blob);
session.save(user);
tran.commit();
} catch (Exception e) {
e.printStackTrace();
}
读取时代码为:
Session session=DButil.getConnection();
User user=(User) session.get(User.class, 12);
Clob clob=user.getInfo();
Blob blob=user.getPic();
OutputStream out=new FileOutputStream("D:\\hbm.jpg");
byte[] buff=blob.getBytes(1, (int)blob.length());
out.write(buff);
out.close();
String temp = clob.getSubString(1, (int)clob.length());
System.out.println(temp);
} catch (Exception e) {
e.printStackTrace();
}