Java Operations Database CLOB type large field

Java Operations database Clob type large fields, the processing tool class is as follows:

Package Org.shefron.utils;import Java.io.stringreader;import Java.sql.clob;import java.sql.PreparedStatement; Import Java.sql.sqlexception;public class Clobutils {public final static String Getvaluefromclob (Clob Clob) throws Sqlexc eption {String value = null;if (CLOB! = null) {int size = (int) clob.length (); value = clob.getsubstring (1, size);} return value;}  Public final static void Setclobparameter (PreparedStatement ps, int i,string parameter) throws SQLException {StringReader reader = new StringReader (parameter);p s.setcharacterstream (i, Reader, parameter.length ());}}

Java Operations database Clob type large fields, processing tool classes.

Java Operations Database CLOB type large field