Exemple #1
0
 /* 开始记录日志 */
 public void executeCommon_BEGINDBTRACE(Object obj) throws CallDbException {
   Dbtrace dbtrace = (Dbtrace) obj;
   SqlParameterExt spx = new SqlParameterExt();
   spx.add(new StringValue(dbtrace.getDbtrace_id()));
   spx.add(new LongValue(dbtrace.getUserid()));
   spx.add(new StringValue(dbtrace.getIp()));
   spx.add(new StringValue(dbtrace.getModule_name()));
   spx.add(new StringValue(dbtrace.getWebservice_method()));
   // spx.add(new StringValue(dbtrace.getMethod_name()));
   spx.add(new TimeValue(dbtrace.getStart_time()));
   String sql =
       "insert into t_wa_sys_dbtrace(dbtrace_id,userid,ip,module_name,webservice_method,start_time) values(?,?,?,?,?,?)";
   bo.setSqlParameterExt(spx);
   try {
     bo.execute(sql);
     bo.clearParameters();
   } catch (Exception err) {
     xlog.error("开始数据跟踪不成功:" + err.getMessage());
     throw new CallDbException("开始数据跟踪不成功!");
   }
 }
Exemple #2
0
 /* 结束日志记录 */
 public void executeCommon_ENDDBTRACE(Object obj) throws CallDbException {
   Dbtrace dbtrace = (Dbtrace) obj;
   SqlParameterExt spx = new SqlParameterExt();
   spx.add(new TimeValue(dbtrace.getEnd_time()));
   spx.add(new DoubleValue(dbtrace.getDuration()));
   spx.add(new IntValue(dbtrace.getRet_count()));
   spx.add(new StringValue(dbtrace.getMethod_name()));
   spx.add(new StringValue(dbtrace.getDbtrace_id()));
   String sql =
       "update t_wa_sys_dbtrace set end_time=?, duration=?, ret_count=?,sql_code=? where dbtrace_id=?";
   bo.setSqlParameterExt(spx);
   try {
     bo.execute(sql);
     bo.clearParameters();
   } catch (Exception err) {
     xlog.error("结束数据跟踪不成功:" + err.getMessage());
     throw new CallDbException("结束数据跟踪不成功!");
   }
 }