public String forModelDeleteById(TableInfo tInfo) {
String primaryKey = tInfo.getPrimaryKey();
StringBuilder sql = new StringBuilder(45);
sql.append("delete from \"");
sql.append(tInfo.getTableName());
sql.append("\" where \"").append(primaryKey).append("\" = ?");
return sql.toString();
}
public String forModelFindById(TableInfo tInfo, String columns) {
StringBuilder sql = new StringBuilder("select ");
if (columns.trim().equals("*")) {
sql.append(columns);
} else {
String[] columnsArray = columns.split(",");
for (int i = 0; i < columnsArray.length; i++) {
if (i > 0) sql.append(", ");
sql.append("\"").append(columnsArray[i].trim()).append("\"");
}
}
sql.append(" from \"");
sql.append(tInfo.getTableName());
sql.append("\" where \"").append(tInfo.getPrimaryKey()).append("\" = ?");
return sql.toString();
}
public void forModelSave(
TableInfo tableInfo, Map<String, Object> attrs, StringBuilder sql, List<Object> paras) {
sql.append("insert into \"").append(tableInfo.getTableName()).append("\"(");
StringBuilder temp = new StringBuilder(") values(");
for (Entry<String, Object> e : attrs.entrySet()) {
String colName = e.getKey();
if (tableInfo.hasColumnLabel(colName)) {
if (paras.size() > 0) {
sql.append(", ");
temp.append(", ");
}
sql.append("\"").append(colName).append("\"");
temp.append("?");
paras.add(e.getValue());
}
}
sql.append(temp.toString()).append(")");
}
public void forModelUpdate(
TableInfo tableInfo,
Map<String, Object> attrs,
Set<String> modifyFlag,
String primaryKey,
Object id,
StringBuilder sql,
List<Object> paras) {
sql.append("update \"").append(tableInfo.getTableName()).append("\" set ");
for (Entry<String, Object> e : attrs.entrySet()) {
String colName = e.getKey();
if (!primaryKey.equalsIgnoreCase(colName)
&& modifyFlag.contains(colName)
&& tableInfo.hasColumnLabel(colName)) {
if (paras.size() > 0) sql.append(", ");
sql.append("\"").append(colName).append("\" = ? ");
paras.add(e.getValue());
}
}
sql.append(" where \"").append(primaryKey).append("\" = ?");
paras.add(id);
}
