Delete.java

/* ================================================================
 * JSQLParser : java based sql parser 
 * ================================================================
 *
 * Project Info:  http://jsqlparser.sourceforge.net
 * Project Lead:  Leonardo Francalanci (leoonardoo@yahoo.it);
 *
 * (C) Copyright 2004, by Leonardo Francalanci
 *
 * This library is free software; you can redistribute it and/or modify it under the terms
 * of the GNU Lesser General Public License as published by the Free Software Foundation;
 * either version 2.1 of the License, or (at your option) any later version.
 *
 * This library is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY;
 * without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
 * See the GNU Lesser General Public License for more details.
 *
 * You should have received a copy of the GNU Lesser General Public License along with this
 * library; if not, write to the Free Software Foundation, Inc., 59 Temple Place, Suite 330,
 * Boston, MA 02111-1307, USA.
 */
package net.sf.jsqlparser.statement.delete;

import net.sf.jsqlparser.expression.Expression;
import net.sf.jsqlparser.schema.Table;
import net.sf.jsqlparser.statement.Statement;
import net.sf.jsqlparser.statement.StatementVisitor;

public class Delete implements Statement {

    private Table table;
    private Expression where;
    private String comment;
    private String endComment = new String();
    private String fromComment;
    private String whereComment;

    @Override
    public void accept(StatementVisitor statementVisitor) {
        statementVisitor.visit(this);
    }

    public Table getTable() {
        return table;
    }

    public Expression getWhere() {
        return where;
    }

    public void setTable(Table name) {
        table = name;
    }

    public void setWhere(Expression expression) {
        where = expression;
    }

    public String toString() {
        String sql;
        sql = getComment() != null ? getComment() + " " : "";
        sql += "DELETE " + (getFromComment() != null ? getFromComment() + " " : "");
        sql += "FROM " + table + ((where != null) ? ((getWhereComment() != null ? " " + getWhereComment() : "") + " WHERE " + where) : "");
        sql += !"".equals(getEndComment()) ? " " + getEndComment() : "";
        return sql;
    }

    /**
     * @return the comment
     */
    public String getComment() {
        return comment;
    }

    /**
     * @param comment the comment to set
     */
    public void setComment(String comment) {
        this.comment = comment;
    }

    @Override
    public void setEndComment(String endComment) {
        this.endComment = endComment;
    }

    @Override
    public String getEndComment() {
        return endComment;
    }

    /**
     * @return the fromComment
     */
    public String getFromComment() {
        return fromComment;
    }

    /**
     * @param fromComment the fromComment to set
     */
    public void setFromComment(String fromComment) {
        this.fromComment = fromComment;
    }

    /**
     * @return the whereComment
     */
    public String getWhereComment() {
        return whereComment;
    }

    /**
     * @param whereComment the whereComment to set
     */
    public void setWhereComment(String whereComment) {
        this.whereComment = whereComment;
    }
}