DBContorller3

private boolean insertExceptionLog(EsbRequest request) {
// esb_business_exception(oid,err_code,err_type,err_info)
if (!isWriteLog(true))
return false;

PreparedStatement stmt = null;
int result = 0;

try {
log.info(insert_ex_log.toString());
stmt = this.conn.prepareStatement(insert_ex_log.toString());

int i = 1;
// oid,businessid,transactionid,moduleid,servernumber,operator,
// areaid,starttime,endtime,is_long_flow,esb_version,status,err_type
stmt.setLong(i++, Long.parseLong(request.getOid()));
stmt.setString(i++, request.getErrCode());
stmt.setString(i++, request.getErrType());
stmt.setBytes(i++, request.getErrInfo().getBytes());

result = stmt.executeUpdate();

} catch (SQLException e) {
// TODO Auto-generated catch block
// e.printStackTrace();
log.error("SQL Err(insertExceptionLog):" + e);
throw new BaseException(e);
} finally {
DBTools.close(stmt);
}

return (result == 1) ? true : false;
}

private void insertMsgLog(String oid, java.util.List<MsgBO> list)
throws IOException {
if (list == null)
return;

if (!isWriteLog(false))
return;

PreparedStatement stmt = null;

try {
log.info(insert_msg_log.toString());
stmt = this.conn.prepareStatement(insert_msg_log.toString());

for (Object element : list) {

MsgBO bo = (MsgBO) element;

int i = 1;
stmt.setLong(i++, Long.parseLong(oid));
stmt.setString(i++, bo.getSender());
stmt.setString(i++, bo.getRecevier());
stmt.setShort(i++, Short.parseShort(bo.getMsgType()));

stmt.setString(i++, bo.getMsg());

stmt.executeUpdate();
}
} catch (SQLException e) {
// TODO Auto-generated catch block
// e.printStackTrace();
log.error("SQL Err(insertMsgLog):" + e);
throw new BaseException(e);
} finally {
DBTools.close(stmt);
}

}

/**
* @return
*/
private boolean isWriteLog(boolean exFlag) {
String dbFlag = Configuration.getProperty("WRITEDB");

if ("0".equals(dbFlag)) {
return false;
} else if ("1".equals(dbFlag)) {
return true;
} else if ("2".equals(dbFlag)) {
return exFlag;
}

return false;
}

protected StringBuffer insert_esb_log = new StringBuffer(
"insert into esb_business_log")
.append("(oid,businessid,transactionid,moduleid,servicenumber,operator,areaid,departmentid,remotehost,starttime,endtime,is_long_flow,esb_version,status,err_type)")
.append(" values(?,?,?,?,?,?,?,?,?,to_date(?,'yyyy-mm-dd hh24:mi:ss'),to_date(?,'yyyy-mm-dd hh24:mi:ss'),?,?,?,?)");

protected StringBuffer insert_ex_log = new StringBuffer(
"insert into esb_business_exception").append(
"(oid,err_code,err_type,err_info)").append(" values(?,?,?,?)");

protected StringBuffer insert_msg_log = new StringBuffer(
"insert into esb_business_msg").append(
" (oid,sender,recevier,msgtype,message)").append(
" values(?,?,?,?,?)");



}