public class ZealotKhalaTest {

    /**
     * 测试使用ZealotKhala书写的sql.
     */
    @Test
    public void testSql() {
        String userName = "zhang";
        String startBirthday = "1990-03-25";
        String endBirthday = "2010-08-28";
        Integer[] sexs = new Integer[]{0, 1};

        SqlInfo sqlInfo = ZealotKhala.start()
                .select("u.id, u.name, u.email, d.birthday, d.address")
                .from("user AS u")
                .leftJoin("user_detail AS d").on("u.id = d.user_id")
                .where("u.id != ''")
                .andLike("u.name", userName)
                // 该doAnything方法可以在拼接期间做任何代码插入和注入，如果是Java8的话，可以转为Lamda表达式
                .doAnything(true, new ICustomAction() {
                    @Override
                    public void execute(final StringBuilder join, final List<Object> params) {
                        join.append("abc111");
                        params.add(5);
                        log.info("执行了自定义操作，可任意拼接字符串和有序参数...");
                    }
                })
                .andMoreThan("u.age", 21)
                .andLessThan("u.age", 13)
                .andMoreEqual("d.birthday", startBirthday)
                .andLessEqual("d.birthday", endBirthday)
                .andBetween("d.birthday", startBirthday, endBirthday)
                .andIn("u.sex", sexs)
                .andIsNotNull("u.state")
                .orderBy("d.birthday").desc()
                .end();
        String sql = sqlInfo.getSql();
        Object[] arr = sqlInfo.getParamsArr();

        // 断言并输出sql信息
        assertEquals("SELECT u.id, u.name, u.email, d.birthday, d.address FROM user AS u "
                + "LEFT JOIN user_detail AS d ON u.id = d.user_id WHERE u.id != '' AND u.name LIKE ? "
                + "abc111 AND u.age > ? AND u.age < ? AND d.birthday >= ? AND d.birthday <= ? "
                + "AND d.birthday BETWEEN ? AND ? AND u.sex IN (?, ?) AND u.state IS NOT NULL "
                + "ORDER BY d.birthday DESC", sql);
        assertArrayEquals(new Object[]{"%zhang%", 5, 21, 13, "1990-03-25", "2010-08-28",
                "1990-03-25", "2010-08-28", 0, 1} ,arr);
        log.info("-- testSql()方法生成的sql信息:\n" + sql + "\n-- 参数为:\n" + Arrays.toString(arr));
    }

}

// 在你的启动类或方法中加入该语句，来初始化加载zealot xml目录中的xml命名空间和其对应的位置
// 如果参数 xmlLocations 值为空的话，则默认扫描你项目资源目录(及子目录)`zealot`下的所有Zealot XML SQL文件.
ZealotConfigManager.getInstance().initLoadXmlLocations("myzealots/xml");

/**
 * 测试从扫描的zealot xml文件中生成sql.
 */
@Test
public void testQueryTeacherSql() {
    SqlInfo sqlInfo = Zealot.getSqlInfo("myTeacher", "queryTeacherById",
            ParamWrapper.newInstance("id", "123").toMap());
    String expectedSql = "SELECT * FROM t_teacher AS t WHERE t.c_id = ?";

    assertEquals(expectedSql, sqlInfo.getSql());
    assertArrayEquals(new Object[]{"123"}, sqlInfo.getParamsArr());
}

// 在你的启动类或方法中加入该语句，来初始化加载zealot handler目录中的注解和标签处理器
// 参数 handlerLocations 值不能为空，如果为空，也不会报错，不过不会产生任何作用而已.
ZealotConfigManager.getInstance()
        .initLoadXmlLocations("myzealots/xml, xml/zealots, abc/zealot-user.xml")
        .initLoadHandlerLocations("com.blinkfox.zealot.test.handler, com.blinkfox.myProject.zealot.Hello.java");

import com.blinkfox.zealot.bean.BuildSource;
import com.blinkfox.zealot.bean.SqlInfo;
import com.blinkfox.zealot.config.annotation.Tagger;
import com.blinkfox.zealot.core.IConditHandler;

/**
 * 测试Tagger注解的Handler.
 *
 * @author blinkfox on 2018/4/28.
 */
@Tagger(value = "helloTagger", prefix = "Hello", symbol = "Tagger")
public class TaggerTestHandler implements IConditHandler {

    /**
     * 由于只是用来测试注解，所以这里只做简单的拼接.
     * @param source 构建所需的资源对象
     * @return sqlInfo
     */
    @Override
    public SqlInfo buildSqlInfo(BuildSource source) {
        source.getSqlInfo().getJoin().append(source.getPrefix())
                .append(" ").append(source.getSuffix());
        return source.getSqlInfo();
    }

}

import com.blinkfox.zealot.bean.BuildSource;
import com.blinkfox.zealot.bean.SqlInfo;
import com.blinkfox.zealot.config.annotation.Tagger;
import com.blinkfox.zealot.config.annotation.Taggers;
import com.blinkfox.zealot.core.IConditHandler;

/**
 * 测试'Taggers'注解的Handler.
 * @see com.blinkfox.zealot.config.annotation.Taggers
 *
 * @author blinkfox on 2018/4/28.
 */
@Taggers({
        @Tagger(value = "hello", prefix = "hello", symbol = "blinkfox"),
        @Tagger(value = "hi", prefix = "hi", symbol = "blinkfox"),
        @Tagger(value = "hw", prefix = "hello", symbol = "world")
})
public class TaggersTestHandler implements IConditHandler {

    /**
     * 由于这个类只是用来测试注解，所以这里只做简单的字符串拼接.
     * @param source 构建所需的资源对象
     * @return sqlInfo
     */
    @Override
    public SqlInfo buildSqlInfo(BuildSource source) {
        source.getSqlInfo().getJoin().append(source.getPrefix())
                .append(" ").append(source.getSuffix());
        return source.getSqlInfo();
    }

}

NormalConfig.getInstance() // 获取普通配置的唯一实例
        .setDebug(false)  // 设置是否开启debug模式，这样每次调用都会实时从最新的xml文件中获取sql，默认值为false.
        .setPrintBanner(true) // 设置是否打印zealot的启动banner，默认为true.
        .setPrintSqlInfo(true); // 设置是否打印zealot的sql日志，默认为true.

// 直接指定类的class
ZealotConfigManager.getInstance().initLoad(MyZealotConfig.class);

// 或者类的class全名
ZealotConfigManager.getInstance().initLoad("com.blinkfox.config.MyZealotConfig");

// 或者类的实例,这个实例就可以直接从Spring等容器中获取了，不一定是new出来的
ZealotConfigManager.getInstance().initLoad(new MyZealotConfig());

ZealotConfigManager.getInstance().initLoad(MyZealotConfig.class, "zealot/xml", "com.blinkfox.zealot.test.handler");

// 或者
ZealotConfigManager.getInstance().initLoad("com.blinkfox.config.MyZealotConfig", "zealot/xml", "com.blinkfox.zealot.test.handler");

// 或者
ZealotConfigManager.getInstance().initLoad(new MyZealotConfig(), "zealot/xml", "com.blinkfox.zealot.test.handler");

package com.blinkfox.config;

import XmlContext;
import AbstractZealotConfig;

/**
 * 我继承的zealotConfig配置类
 * Created by blinkfox on 2018/05/01.
 */
public class MyZealotConfig extends AbstractZealotConfig {

    /**
     * 1.3.0版本之后，该方法可以不必再覆盖了，按需覆盖。
     */
    @Override
    public void configNormal(NormalConfig normalConfig) {
        // 1.1.5版本新增的方法
    }

    /**
     * 1.3.0版本之后，该方法可以不必再覆盖了，按需覆盖。
     */
    @Override
    public void configXml(XmlContext ctx) {

    }

    /**
     * 1.3.0版本之后，该方法可以不必再覆盖了，按需覆盖。
     */
    @Override
    public void configTagHandler() {

    }

}

ZealotConfigManager.getInstance().initLoad(MyZealotConfig.class);

package com.blinkfox.config;

import XmlContext;
import AbstractZealotConfig;

/**
 * 我继承的zealotConfig配置类
 * Created by blinkfox on 2016/11/4.
 */
public class MyZealotConfig extends AbstractZealotConfig {

    public static final String USER_ZEALOT = "user_zealot";

    @Override
    public void configNormal(NormalConfig normalConfig) {
        normalConfig.setDebug(true) // 是否开启debug模式，默认为false
                .setPrintBanner(true) // 加载配置信息完毕后是否打印Banner，默认为true
                .setPrintSqlInfo(true); // 是否打印Sql信息，默认为true，注意日志级别为info时才打印，如果是warn、error则不打印
    }

    @Override
    public void configXml(XmlContext ctx) {
        // 注：如果在zealots根节点中指定了命名空间nameSpace属性的值，那么就可以不用在此方法中配置了，只需指定扫描XML的位置即可.
        ctx.add(USER_ZEALOT, "/zealotxml/zealot-user.xml");
    }

    @Override
    public void configTagHandler() {

    }

}

/**
 * 用户信息相关的控制器
 * Created by blinkfox on 16/7/24.
 */
public class UserController extends Controller {

    public void queryUserById() {
        Map<String, Object> paramMap = new HashMap<String, Object>();
        paramMap.put("id", "2");

        SqlInfo sqlInfo = Zealot.getSqlInfo(MyZealotConfig.USER_ZEALOT, "queryUserById", paramMap);
        String sql = sqlInfo.getSql();
        Object[] params = sqlInfo.getParamsArr();

        List<User> users = User.userDao.find(sql, params);
        renderJson(users);
    }

    public void userZealot() {
        // 构造测试需要的动态查询的参数
        Map<String, Object> paramMap = new HashMap<String, Object>();
        paramMap.put("nickName", "张");
        paramMap.put("email", "san");
        paramMap.put("startAge", 23);
        paramMap.put("endAge", 28);
        paramMap.put("startBirthday", "1990-01-01 00:00:00");
        paramMap.put("endBirthday", "1991-01-01 23:59:59");
        paramMap.put("sexs", new Integer[]{0, 1});

        // 执行Zealot方法，得到完整的SQL和对应的有序参数
        SqlInfo sqlInfo = Zealot.getSqlInfo(MyZealotConfig.USER_ZEALOT, "queryUserInfo", paramMap);
        String sql = sqlInfo.getSql();
        Object[] params = sqlInfo.getParamsArr();

        // 执行SQL查询并返回结果
        List<User> users = User.userDao.find(sql, params);
        renderJson(users);
    }

}

package com.blinkfox.handler;

import BuildSource;
import SqlInfo;
import ZealotConst;
import IConditHandler;
import ParseHelper;
import StringHelper;
import XmlNodeHelper;
import org.dom4j.Node;
import java.util.List;

/**
 * 自定义的ID和Email条件查询的SQL处理器
 * Created by blinkfox on 2016/11/11.
 */
public class UserIdEmailHandler implements IConditHandler {

    @Override
    public SqlInfo buildSqlInfo(BuildSource source) {
        /* 获取拼接的参数和Zealot节点 */
        SqlInfo sqlInfo = source.getSqlInfo();
        Node node = source.getNode();

        // 获取配置的属性值,getAndCheckNodeText()方法会检测属性值是否为空，如果为空，会抛出运行时异常
        String idField = XmlNodeHelper.getAndCheckNodeText(node, "attribute::idField");
        String emailField = XmlNodeHelper.getAndCheckNodeText(node, "attribute::emailField");
        // getAndCheckNodeText()方法仅仅只获取属性的值，即使未配置或书写值，也会返回空字符串
        String idValue = XmlNodeHelper.getNodeAttrText(node, "attribute::idValue");
        String emailValue = XmlNodeHelper.getNodeAttrText(node, "attribute::emailValue");

        /* 获取match属性值,如果匹配中 字符值没有，则认为是必然生成项 */
        String matchText = XmlNodeHelper.getNodeAttrText(node, ZealotConst.ATTR_MATCH);
        if (StringHelper.isBlank(matchText)) {
            sqlInfo = buildIdEmailSqlInfo(source, idField, emailField, idValue, emailValue);
        } else {
            /* 如果match匹配成功，则生成数据库sql条件和参数 */
            Boolean isTrue = (Boolean) ParseHelper.parseWithMvel(matchText, source.getParamObj());
            if (isTrue) {
                sqlInfo = buildIdEmailSqlInfo(source, idField, emailField, idValue, emailValue);
            }
        }

        return sqlInfo;
    }

    /**
     * 构建自定义的SqlInfo信息，区分是根据id做等值查询，还是根据email做模糊查询的情况
     * @param source source
     * @param idField idField
     * @param emailField emailField
     * @param idValue idValue
     * @param emailValue emailValue
     */
    private SqlInfo buildIdEmailSqlInfo(BuildSource source, String idField, String emailField,
            String idValue, String emailValue) {
        SqlInfo sqlInfo = source.getSqlInfo();
        StringBuilder join = sqlInfo.getJoin();
        List<Object> params = sqlInfo.getParams();

        // 如果userId不为空，则根据id来做等值查询
        Integer idText = (Integer) ParseHelper.parseWithMvel(idValue, source.getParamObj());
        if (idText != null) {
            // prefix是前缀，如"and","or"之类，没有则默认为空字符串""
            join.append(source.getPrefix()).append(idField).append(ZealotConst.EQUAL_SUFFIX);
            params.add(idText);
            return sqlInfo.setJoin(join).setParams(params);
        }

        // 获取userEmail的值,如果userEmail不为空，则根据email来做模糊查询
        String emailText = (String) ParseHelper.parseWithMvel(emailValue, source.getParamObj());
        if (StringHelper.isNotBlank(emailText)) {
            // prefix是前缀，如"and","or"之类，没有则默认为空字符串""
            join.append(source.getPrefix()).append(emailField).append(ZealotConst.LIEK_SUFFIX);
            params.add("%" + emailText + "%");
            return sqlInfo.setJoin(join).setParams(params);
        }

        return sqlInfo;
    }

}

/**
 * 我继承的zealotConfig配置类
 * Created by blinkfox on 2016/11/4.
 */
public class MyZealotConfig extends AbstractZealotConfig {

    public static final String USER_ZEALOT = "user_zealot";

    @Override
    public void configXml(XmlContext ctx) {
        ctx.add(USER_ZEALOT, "/zealot/zealot-user.xml");
    }

    @Override
    public void configTagHandler() {
        // 自定义userIdEmail标签和处理器
        add("userIdEmail", UserIdEmailHandler.class);
        // 有and前缀的自定义标签
        add("andUserIdEmail", " and " ,UserIdEmailHandler.class);
    }

}

public void queryUserIdEmail() {
    Map<String, Object> user = new HashMap<String, Object>();
    user.put("userId", 3);
    user.put("userEmail", "san");

    SqlInfo sqlInfo = Zealot.getSqlInfo(MyZealotConfig.USER_ZEALOT, "queryUserWithIdEmail", user);
    String sql = sqlInfo.getSql();
    Object[] params = sqlInfo.getParamsArr();
    System.out.println("----生成sql的为:" + sql);
    System.out.println("----生成sql的参数为:" + Arrays.toString(params));

    List<User> users = User.userDao.find(sql, params);
    renderJson(users);
}

Hello, my name is @{person.name}

@code{age = 23; name = 'John Doe'}
@{name} is @{age} years old

@if{foo != bar}
   Foo not a bar!
@else{bar != cat}
   Bar is not a cat!
@else{}
   Foo may be a Bar or a Cat!
@end{}

@foreach{item : products}
 - @{item.serialNumber}
@end{}

Map<String, Object> paramMap = new HashMap<String, Object>();
paramMap.put("sex", "1")
paramMap.put("stuId", "123")
paramMap.put("state", false)

SqlInfo sqlInfo = Zealot.getSqlInfo(MyZealotConfig.STUDENT_ZEALOT, "queryByChoose", paramMap);

SqlInfo sqlInfo = Zealot.getSqlInfo(MyZealotConfig.STUDENT_ZEALOT, "queryByChoose",
        ParamWrapper.newInstance("sex", "1").put("stuId", "123").put("state", false).toMap());

@Test
public void testParseWithMvel() {
    // 构造上下文参数
    Map<String, Object> context = new HashMap<String, Object>();
    context.put("foo", "Hello");
    context.put("bar", "World");

    String result = (String) ParseHelper.parseExpressWithException("foo + bar", context);
    assertEquals("HelloWorld", result); // 解析得到`HelloWorld`字符串，断言为:true。
}

@Test
public void testParseStr2() {
    Boolean result = (Boolean) ParseHelper.parseExpress("sex == 1", ParamWrapper.newInstance("sex", "1").toMap());
    assertEquals(true, result); // 断言为:true。
}

@Test
public void testParseTemplate2() {
    String result = ParseHelper.parseTemplate("@if{?foo != empty}@{foo} World!@end{}", ParamWrapper.newInstance("foo", "Hello").toMap());
    assertEquals("Hello World!", result);// 解析得到`Hello World!`字符串，断言为:true。
}

sqlInfo.removeIfExist(" 1 = 1 AND");

// 或者
sqlInfo.removeIfExist(" 1 <> 1");