示例#1
0
  /**
   * 根据orderid删除发送失败后存储到表or_order_sms和or_orderextinfo中的记录
   *
   * @param orderid
   */
  public void delOrderSMS(long orderid) {
    String sql1 = "delete from or_order_sms m where m.orderid=" + orderid;
    String sql2 = "delete from or_orderextinfo f where f.orderid=" + orderid + " and f.type='03' ";
    log.info("清空or_order_sms对应的数据,orderid=" + orderid);
    super.getSession().createSQLQuery(sql1).executeUpdate();

    log.info("清空or_orderextinfo对应的数据,orderid=" + orderid);
    super.getSession().createSQLQuery(sql2).executeUpdate();
  }
示例#2
0
 /** 插入表extinfo随机码 */
 public void addCheckcodeToExtInfoBySql(String checkcode, long orderid) {
   String sql =
       "insert into or_orderextinfo(id,orderid,type,context) values(seq_order_extinfo.nextval,"
           + orderid
           + ",'03','"
           + checkcode
           + "') ";
   super.getSession().createSQLQuery(sql).executeUpdate();
 }