/** * Return the SQL for a prepared statement delete on this row. */ private String getDeleteSQL(DBDictionary dict) { StringBuilder buf = new StringBuilder(); buf.append("DELETE FROM "). append(dict.getFullName(getTable(), false)); appendWhere(buf, dict); return buf.toString(); }
/** * Return the SQL for a prepared statement delete on this row. */ private String getDeleteSQL(DBDictionary dict) { StringBuilder buf = new StringBuilder(); buf.append("DELETE FROM "). append(dict.getFullName(getTable(), false)); appendWhere(buf, dict); return buf.toString(); }
/** * Return the SQL for a prepared statement delete on this row. */ private String getDeleteSQL(DBDictionary dict) { StringBuilder buf = new StringBuilder(); buf.append("DELETE FROM "). append(dict.getFullName(getTable(), false)); appendWhere(buf, dict); return buf.toString(); }
/** * Return the SQL for a prepared statement delete on this row. */ private String getDeleteSQL(DBDictionary dict) { StringBuilder buf = new StringBuilder(); buf.append("DELETE FROM "). append(dict.getFullName(getTable(), false)); appendWhere(buf, dict); return buf.toString(); }
/** * Return the SQL for a prepared statement delete on this row. */ private String getDeleteSQL(DBDictionary dict) { StringBuffer buf = new StringBuffer(); buf.append("DELETE FROM "). append(dict.getFullName(getTable(), false)); appendWhere(buf, dict); return buf.toString(); }
/** * Return the SQL for a prepared statement update on this row. */ private String getUpdateSQL(DBDictionary dict) { StringBuffer buf = new StringBuffer(); buf.append("UPDATE ").append(dict.getFullName(getTable(), false)). append(" SET "); boolean hasVal = false; for (int i = 0; i < _cols.length; i++) { if (_vals[i] == null) continue; if (hasVal) buf.append(", "); buf.append(_cols[i]); if (_types[i] == RAW) buf.append(" = ").append(_vals[i]); else buf.append(" = ?"); hasVal = true; } appendWhere(buf, dict); return buf.toString(); }
/** * Return the SQL for a prepared statement update on this row. */ private String getUpdateSQL(DBDictionary dict) { StringBuilder buf = new StringBuilder(); buf.append("UPDATE ").append(dict.getFullName(getTable(), false)). append(" SET "); boolean hasVal = false; for (int i = 0; i < _cols.length; i++) { if (_vals[i] == null) continue; if (hasVal) buf.append(", "); buf.append(dict.getColumnDBName(_cols[i])); if (_types[i] == RAW) buf.append(" = ").append(_vals[i]); else { buf.append(" = "); buf.append(dict.getMarkerForInsertUpdate(_cols[i], _vals[i])); } hasVal = true; } appendWhere(buf, dict); return buf.toString(); }
/** * Return the SQL for a prepared statement update on this row. */ private String getUpdateSQL(DBDictionary dict) { StringBuilder buf = new StringBuilder(); buf.append("UPDATE ").append(dict.getFullName(getTable(), false)). append(" SET "); boolean hasVal = false; for (int i = 0; i < _cols.length; i++) { if (_vals[i] == null) continue; if (hasVal) buf.append(", "); buf.append(dict.getColumnDBName(_cols[i])); if (_types[i] == RAW) buf.append(" = ").append(_vals[i]); else { buf.append(" = "); buf.append(dict.getMarkerForInsertUpdate(_cols[i], _vals[i])); } hasVal = true; } appendWhere(buf, dict); return buf.toString(); }
/** * Return the SQL for a prepared statement update on this row. */ private String getUpdateSQL(DBDictionary dict) { StringBuilder buf = new StringBuilder(); buf.append("UPDATE ").append(dict.getFullName(getTable(), false)). append(" SET "); boolean hasVal = false; for (int i = 0; i < _cols.length; i++) { if (_vals[i] == null) continue; if (hasVal) buf.append(", "); buf.append(dict.getColumnDBName(_cols[i])); if (_types[i] == RAW) buf.append(" = ").append(_vals[i]); else { buf.append(" = "); buf.append(dict.getMarkerForInsertUpdate(_cols[i], _vals[i])); } hasVal = true; } appendWhere(buf, dict); return buf.toString(); }
/** * Return the SQL for a prepared statement update on this row. */ private String getUpdateSQL(DBDictionary dict) { StringBuilder buf = new StringBuilder(); buf.append("UPDATE ").append(dict.getFullName(getTable(), false)). append(" SET "); boolean hasVal = false; for (int i = 0; i < _cols.length; i++) { if (_vals[i] == null) continue; if (hasVal) buf.append(", "); buf.append(dict.getColumnDBName(_cols[i])); if (_types[i] == RAW) buf.append(" = ").append(_vals[i]); else { buf.append(" = "); buf.append(dict.getMarkerForInsertUpdate(_cols[i], _vals[i])); } hasVal = true; } appendWhere(buf, dict); return buf.toString(); }