hibernate oracle boolean 数据类型,用hibernate向oracle读取blob数据类型为并下载到本地...

向Oracle读取16进制byte[]数据

这种方法只能处理总大小小于6M的数据(在默认的java虚拟机设置下)。

①持久化类：

public class Mail implements Serializable {

/**

* 主键

*/

private int id;

/**

* 即将传入数据库中的文件

*/

private byte[] filedata;

/*此处省略get、set*/

}

②持久化类与hibernate的映射文件：持久化类.hbm.xml

③HibernateUtil.java文件(这个不用去理解复制下来就可以)

import org.hibernate.SessionFactory;

import org.hibernate.cfg.Configuration;

public class HibernateUtil {

private static final SessionFactory sessionFactory;

static {

try {

// Create the SessionFactory from hibernate.cfg.xml

sessionFactory = new Configuration().configure().buildSessionFactory();

} catch (Throwable ex) {

// Make sure you log the exception, as it might be swallowed

System.err.println("Initial SessionFactory creation failed." + ex);

throw new ExceptionInInitializerError(ex);

}

}

public static SessionFactory getSessionFactory() {

return sessionFactory;

}

}

④用hibernate来读取并下载到本地：

public class TheMain {

/**

* @param args

*/

public static void main(String[] args) {

//例行公事的两句，不要忘了任何hibernate操作都要用到的

Session session = HibernateUtil.getSessionFactory().openSession();

Transaction tran = session.beginTransaction();

File forDownFile = new File("D:/被下载的数据.jpg");

//从数据库请求数据

Mail mail = (Mail) session.load(Mail.class, 4);

//如果不要求下载那么写到这里已经足够

FileOutputStream fos = null;

try {

//载入文件路径

fos = new FileOutputStream(forDownFile);

//写入文件数据

fos.write(mail.getFiledata());

} catch (FileNotFoundException e) {

e.printStackTrace();

} catch (IOException e) {

e.printStackTrace();

} finally {

try {

//一定不要忘了释放资源

fos.close();

} catch (IOException e) {

e.printStackTrace();

}

}

}

}