Java SmTbProductBean.isPrdIdInitialized示例

  // 63
  public int deleteUsingTemplate(SmTbProductBean pObject) throws SQLException {
    if (pObject.isPrdIdInitialized()) return deleteByPrimaryKey(pObject.getPrdId());

    Connection c = null;
    PreparedStatement ps = null;
    StringBuffer sql = null;

    try {
      sql = new StringBuffer("DELETE FROM sm_tb_product WHERE ");
      int _dirtyAnd = 0;
      if (pObject.isPrdIdInitialized()) {
        if (_dirtyAnd > 0) sql.append(" AND ");
        sql.append("prd_id").append("=?");
        _dirtyAnd++;
      }

      if (pObject.isPrdTypeIdInitialized()) {
        if (_dirtyAnd > 0) sql.append(" AND ");
        sql.append("prd_type_id").append("=?");
        _dirtyAnd++;
      }

      if (pObject.isNameInitialized()) {
        if (_dirtyAnd > 0) sql.append(" AND ");
        sql.append("name").append("=?");
        _dirtyAnd++;
      }

      if (pObject.isPriceInitialized()) {
        if (_dirtyAnd > 0) sql.append(" AND ");
        sql.append("price").append("=?");
        _dirtyAnd++;
      }

      if (pObject.isPriceVipInitialized()) {
        if (_dirtyAnd > 0) sql.append(" AND ");
        sql.append("price_vip").append("=?");
        _dirtyAnd++;
      }

      if (pObject.isSuplyStatusInitialized()) {
        if (_dirtyAnd > 0) sql.append(" AND ");
        sql.append("suply_status").append("=?");
        _dirtyAnd++;
      }

      if (pObject.isFormatDescInitialized()) {
        if (_dirtyAnd > 0) sql.append(" AND ");
        sql.append("format_desc").append("=?");
        _dirtyAnd++;
      }

      if (pObject.isDetailDescInitialized()) {
        if (_dirtyAnd > 0) sql.append(" AND ");
        sql.append("detail_desc").append("=?");
        _dirtyAnd++;
      }

      if (pObject.isSendAreaInitialized()) {
        if (_dirtyAnd > 0) sql.append(" AND ");
        sql.append("send_area").append("=?");
        _dirtyAnd++;
      }

      if (pObject.isSendDescInitialized()) {
        if (_dirtyAnd > 0) sql.append(" AND ");
        sql.append("send_desc").append("=?");
        _dirtyAnd++;
      }

      if (pObject.isPrdPicFileInitialized()) {
        if (_dirtyAnd > 0) sql.append(" AND ");
        sql.append("prd_pic_file").append("=?");
        _dirtyAnd++;
      }

      if (pObject.isOwnerInitialized()) {
        if (_dirtyAnd > 0) sql.append(" AND ");
        sql.append("owner").append("=?");
        _dirtyAnd++;
      }

      c = getConnection();
      ps =
          c.prepareStatement(
              sql.toString(), ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
      int _dirtyCount = 0;

      if (pObject.isPrdIdInitialized()) {
        Manager.setLong(ps, ++_dirtyCount, pObject.getPrdId());
      }

      if (pObject.isPrdTypeIdInitialized()) {
        Manager.setLong(ps, ++_dirtyCount, pObject.getPrdTypeId());
      }

      if (pObject.isNameInitialized()) {
        ps.setString(++_dirtyCount, pObject.getName());
      }

      if (pObject.isPriceInitialized()) {
        Manager.setLong(ps, ++_dirtyCount, pObject.getPrice());
      }

      if (pObject.isPriceVipInitialized()) {
        Manager.setLong(ps, ++_dirtyCount, pObject.getPriceVip());
      }

      if (pObject.isSuplyStatusInitialized()) {
        ps.setString(++_dirtyCount, pObject.getSuplyStatus());
      }

      if (pObject.isFormatDescInitialized()) {
        ps.setString(++_dirtyCount, pObject.getFormatDesc());
      }

      if (pObject.isDetailDescInitialized()) {
        ps.setString(++_dirtyCount, pObject.getDetailDesc());
      }

      if (pObject.isSendAreaInitialized()) {
        ps.setString(++_dirtyCount, pObject.getSendArea());
      }

      if (pObject.isSendDescInitialized()) {
        ps.setString(++_dirtyCount, pObject.getSendDesc());
      }

      if (pObject.isPrdPicFileInitialized()) {
        ps.setString(++_dirtyCount, pObject.getPrdPicFile());
      }

      if (pObject.isOwnerInitialized()) {
        Manager.setLong(ps, ++_dirtyCount, pObject.getOwner());
      }

      int _rows = ps.executeUpdate();
      return _rows;
    } finally {
      getManager().close(ps);
      freeConnection(c);
    }
  }