Class Update

src/main/java/com/sql/parse/statement/impl/jsqlparser/Update.java:27–345

@date 2019年4月30日上午09:58:02 @desc Update语法操作类

 * @desc Update语法操作类
 */
public class Update extends com.sql.parse.statement.Update {
    private net.sf.jsqlparser.statement.update.Update update;

    public Update(net.sf.jsqlparser.statement.update.Update update) {
        this.update = update;
    }

    public Update(String tableName) {
        net.sf.jsqlparser.statement.update.Update update = new net.sf.jsqlparser.statement.update.Update();
        Table table = new Table(tableName);
        update.setTable(table);
        this.update = update;
    }

    @Override
    public String getSql(boolean safe) {
        Update myUpdate = this.clone();
        /*where条件为空时，添加1=2的条件表达式*/
        if (safe && myUpdate.getUpdate().getWhere() == null) {
            myUpdate.where("1 = 2");
        }
        return myUpdate.getUpdate().toString();
    }

    public net.sf.jsqlparser.statement.update.Update getUpdate() {
        return this.update;
    }

    /**
     * @title: addColumn
     * @desc 新增update数据
     */
    public Update addColumn(UpdateItem updateItem) {
        if (update.getColumns() == null) {
            update.setColumns(new ArrayList<>());
        }
        if (update.getExpressions() == null) {
            update.setExpressions(new ArrayList<>());
        }
        update.getColumns().add(new Column(updateItem.getColumnName()));
        try {
            Expression expression = ExpressionBuilder.parse(updateItem.getExpression());
            update.getExpressions().add(expression);
        } catch (Exception e) {
            throw BaseException.errorCode(SqlParseConstant.CODE_002);
        }
        return this;
    }

    public Update addColumn(String column, String value) {
        return addColumn(new UpdateItem(column, value));
    }

    /**
     * @title: where
     * @desc "WHERE"符号
     */
    public Update where(String expr) {