Blob:
public static void blobOperate() throws IOException, InterruptedException, SQLException { Session sess = new Configuration().configure("main.xml") .buildSessionFactory().getCurrentSession(); sess.beginTransaction(); InputStream in=new FileInputStream(new File("F:\\a.jpg")); BufferedInputStream bf=new BufferedInputStream(in); Blobtype ct = new Blobtype(1,Hibernate.createBlob(bf)); in.close(); sess.save(ct); Blobtype by=(Blobtype)sess.get(Blobtype.class, 1); OutputStream out=new FileOutputStream(new File("F:\\b.jpg")); out.write(by.getContent().getBytes(1, (int)by.getContent().length())); out.close(); sess.getTransaction().commit(); }
Clob:
public static void clobOperate() throws IOException, SQLException { Session sess = new Configuration().configure("main.xml") .buildSessionFactory().getCurrentSession(); sess.beginTransaction(); BufferedReader bf = new BufferedReader(new InputStreamReader( new FileInputStream("F:\\a.txt"), Charset.defaultCharset())); String text = null; StringBuffer sb = new StringBuffer(); while ((text = bf.readLine()) != null) { sb.append(text); } Clobtype ct = new Clobtype(1, Hibernate.createClob(sb.toString())); bf.close(); sess.update(ct); Clobtype c = (Clobtype) sess.get(Clobtype.class, 1); Clob cl = c.getContent(); String str = ""; if (cl != null) { try { str = cl.getSubString(new Long(1), (int) cl.length()); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } System.out.println(str); sess.getTransaction().commit(); }