private int addData(String mac,String sn,String content) {
int flag=0;
Connection conn = null;
PreparedStatement ps = null;
ResultSet rs = null;
conn = ConnectionUtil.getConnection();
try {
String sql = "insert into ecs_sfis_testlog(log_id,log_mac,log_sn,log_content,log_create_time) values(ECS_SFIS_TESTLOG_ID.nextval,'"+mac+"','"
+ sn + "',EMPTY_CLOB(),sysdate)";
conn.setAutoCommit(false);
ps = conn.prepareStatement(sql);
flag = ps.executeUpdate();
sql = "select log_content from ecs_sfis_testlog where log_mac ='" + mac
+ "' for update";
ResultSet rs2 = ps.executeQuery(sql);
if (rs2.next()) {
Clob clob = rs2.getClob(1);
BufferedWriter bw = new BufferedWriter(clob
.setCharacterStream(clob.length()));
bw.write(content);
bw.close();
}
conn.commit();
conn.setAutoCommit(true);
ConnectionUtil.closeResultSet(rs);
ConnectionUtil.closePreparedStatement(ps);
ConnectionUtil.closeConnection(conn);
} catch (SQLException e) {
e.printStackTrace();
log.WriteException(new Date() + "/n" + e.getMessage());
} catch (IOException e) {
e.printStackTrace();
log.WriteException(new Date() + "/n" + e.getMessage());
}
return flag;
}
java中使用大对象CLOB
最新推荐文章于 2021-04-03 11:27:33 发布