BuilderUpdateTest.java

package com.alibaba.druid.bvt.sql.builder;

import junit.framework.TestCase;

import org.junit.Assert;

import com.alibaba.druid.sql.builder.SQLBuilderFactory;
import com.alibaba.druid.sql.builder.SQLUpdateBuilder;
import com.alibaba.druid.util.JdbcConstants;

public class BuilderUpdateTest extends TestCase {

    public void test_0() throws Exception {
        SQLUpdateBuilder builder = SQLBuilderFactory.createUpdateBuilder(JdbcConstants.MYSQL);

        builder //
        .from("mytable") //
        .whereAnd("f1 > 0") //
        .set("f1 = f1 + 1", "f2 = ?");

        String sql = builder.toString();
        System.out.println(sql);
        Assert.assertEquals("UPDATE mytable" //
                            + "\nSET f1 = f1 + 1, f2 = ?" //
                            + "\nWHERE f1 > 0", sql);
    }
}