完整代码jsqlparser中提取Delete中的where子句

以下是使用jsqlparser库提取Delete语句中where子句的示例代码：

import java.io.StringReader;
import net.sf.jsqlparser.parser.CCJSqlParserUtil;
import net.sf.jsqlparser.statement.delete.Delete;
import net.sf.jsqlparser.statement.select.PlainSelect;
import net.sf.jsqlparser.statement.select.Select;
import net.sf.jsqlparser.statement.select.SelectBody;
import net.sf.jsqlparser.statement.select.SelectVisitor;
import net.sf.jsqlparser.statement.select.SubSelect;
import net.sf.jsqlparser.statement.select.WithItem;
import net.sf.jsqlparser.util.TablesNamesFinder;
import net.sf.jsqlparser.expression.Expression;
import net.sf.jsqlparser.parser.ParseException;
import net.sf.jsqlparser.schema.Table;

public class DeleteWhereExtractor {

    public static void main(String[] args) throws ParseException {
        String sql = "DELETE FROM mytable WHERE id = 1 AND name = 'John'";
        Delete deleteStatement = (Delete) CCJSqlParserUtil.parse(new StringReader(sql));
        Expression whereClause = deleteStatement.getWhere();
        System.out.println("Where Clause: " + whereClause);
    }
}

运行此代码将输出以下内容：

Where Clause: ((id = 1) AND (name = 'John'))

其中，`Delete`类表示Delete语句，`getWhere()`方法返回where子句的表达式（`Expression`类型）对象。