在POJO字符串可以声明为一个大型对象java.lang.String要么java.sql.Clob种类。

当程序从数据库加载Clob数据的类型。负荷只有一个Clob数据的逻辑指针类型。我们需要通过使用Clob.getCaracterStream()方法Clob型的数据输入流之后才干获取大对象数据。

看以下详细代码

package dao;

import java.io.BufferedReader;

import java.io.IOException;

import java.io.Reader;

import java.math.BigDecimal;

import java.sql.Clob;

import java.sql.SQLException;

import org.hibernate.LobHelper;

import org.hibernate.Query;

import org.hibernate.Session;

import org.hibernate.Transaction;

import entity.Clobtable;

import Factory.HibernateSessionFactory;

public class ClobDao {

	private Session session = null;

	private Transaction tran = null;

	public ClobDao() {

		session = HibernateSessionFactory.getSession();

	}

	public void saveClob(BigDecimal id,String content){

		Clobtable ct = new Clobtable();

		ct.setId(id);

		LobHelper lh = session.getLobHelper();

		ct.setContent(lh.createClob(content));

		tran = session.beginTransaction();

		try{

			session.save(ct);

			tran.commit();

			System.out.println("插入成功！

");

		}catch(Exception e){

			tran.rollback();

			System.out.println("插入失败");

		}

	}

	public void getClob(BigDecimal id){

		String hql = "from Clobtable where id = ?

";

		Query query = session.createQuery(hql);

		query.setBigDecimal(0, id);

		Clobtable ct = (Clobtable) query.uniqueResult();

		Clob clob = ct.getContent();

		try {

			Reader reader = clob.getCharacterStream();

			BufferedReader br = new BufferedReader(reader);

			String content = br.readLine();

			System.out.println(content);

		} catch (SQLException e) {

			e.printStackTrace();

			System.out.println("读取失败！");

		} catch (IOException e) {

			System.out.println("读取失败。");

		}

	}

}