施用java插入oracle中数据类型为clob的字段
使用java插入oracle中数据类型为clob的字段
表结构:
SQL> desc liuxiaowen.hadoop_job_sql; Name Type Nullable Default Comments --------- ------------- -------- ------- -------- DATA_DESC VARCHAR2(20) Y JOBID VARCHAR2(100) Y SQL CLOB Y
insert 代码:
public static void writeToRac (String jobId,StringBuffer sql) { PreparedStatement st = null; try{ st=con.prepareStatement("insert into liuxiaowen.hadoop_job_sql(data_desc,jobid,sql) values(?,?,?)"); st.setString(1,today); st.setString(2,jobId); st.setString(3,sql.toString()); st.execute(); st.close(); }catch (SQLException e){ e.printStackTrace(); System.out.println("########### insert error! jobId:" + jobId + " \nsql: " + sql); } }
1 楼
suns3739
2012-07-18
解救了我 不错不错