首页 诗词 字典 板报 句子 名言 友答 励志 学校 网站地图
当前位置: 首页 > 教程频道 > 数据库 > 其他数据库 >

字符变换CLOB插入数据库

2012-07-28 
字符转换CLOB插入数据库public static CLOB oracleStr2Clob(String str, CLOB lob) throws Exception {Met

字符转换CLOB插入数据库

public static CLOB oracleStr2Clob(String str, CLOB lob) throws Exception {         Method methodToInvoke = lob.getClass().getMethod("getCharacterOutputStream", (Class[]) null);         Writer writer = (Writer) methodToInvoke.invoke(lob, (Object[]) null);         writer.write(str);         writer.close();         return lob;     } public static Object createOracleLob(Connection conn, String lobClassName)     throws Exception { Class lobClass = conn.getClass().getClassLoader().loadClass(         lobClassName); final Integer DURATION_SESSION = new Integer(lobClass.getField("DURATION_SESSION").getInt(null)); final Integer MODE_READWRITE = new Integer(lobClass.getField("MODE_READWRITE").getInt(null)); Method createTemporary = lobClass.getMethod("createTemporary",new Class[] { Connection.class, boolean.class, int.class }); Object lob = createTemporary.invoke(null, new Object[] { conn, false,DURATION_SESSION }); Method open = lobClass.getMethod("open", new Class[] { int.class }); open.invoke(lob, new Object[] { MODE_READWRITE }); return lob; }
?

?

热点排行