Example usage for org.apache.ibatis.jdbc SQL SQL

Introduction

In this page you can find the example usage for org.apache.ibatis.jdbc SQL SQL.

Prototype

SQL

Source Link

Usage

From source file:cn.songxinqiang.study.mybatis.sqlprovider.OrderSQLProvider.java

License:Apache License

public String getSql(Map<String, Object> parameters) {
    Integer uid = (Integer) parameters.get("id");
    SQL sql = new SQL().SELECT("order_id, order_no, order_price").FROM(TABLE_NAME);
    if (uid != null) {
        sql = sql.WHERE("order_id = #{id}");
    }//from   www  .  j  a  v  a 2s .co m
    return sql.toString();
}

From source file:cn.songxinqiang.study.mybatis.sqlprovider.OrderSQLProvider.java

License:Apache License

public String getAllSql() {
    SQL sql = new SQL().SELECT("order_id, order_no, order_price").FROM(TABLE_NAME);
    return sql.toString();
}

From source file:com.baifendian.swordfish.dao.mapper.AdHocMapperProvider.java

License:Apache License

/**
 * ???//w ww . j a  va 2 s  .com
 *
 * @return sql?
 */
public String insert(Map<String, Object> parameter) {
    return new SQL() {
        {
            INSERT_INTO(TABLE_NAME);
            VALUES("`name`", "#{adHoc.name}");
            VALUES("`project_id`", "#{adHoc.projectId}");
            VALUES("`owner`", "#{adHoc.owner}");
            VALUES("`parameter`", "#{adHoc.parameter}");
            VALUES("`proxy_user`", "#{adHoc.proxyUser}");
            VALUES("`type`", EnumFieldUtil.genFieldStr("adHoc.type", SqlEngineType.class));
            VALUES("`queue`", "#{adHoc.queue}");
            VALUES("`status`", EnumFieldUtil.genFieldStr("adHoc.status", FlowStatus.class));
            VALUES("`job_id`", "#{adHoc.jobId}");
            VALUES("`timeout`", "#{adHoc.timeout}");
            VALUES("`create_time`", "#{adHoc.createTime}");
            VALUES("`start_time`", "#{adHoc.startTime}");
            VALUES("`end_time`", "#{adHoc.endTime}");

        }
    }.toString();
}

From source file:com.baifendian.swordfish.dao.mapper.AdHocMapperProvider.java

License:Apache License

/**
 * ??/*from w  w  w. j av  a 2  s .co  m*/
 *
 * @param parameter
 * @return
 */
public String selectProjectByExecId(Map<String, Object> parameter) {
    String sql = new SQL() {
        {
            SELECT("p.*");

            FROM(TABLE_NAME + " as a");

            JOIN("project p on a.project_id = p.id");

            WHERE("a.id = #{execId}");
        }
    }.toString();

    return sql;
}

From source file:com.baifendian.swordfish.dao.mapper.AdHocMapperProvider.java

License:Apache License

/**
 * ?? <p>/*  w  w w.j  a va2  s .c  o m*/
 *
 * @return sql?
 */
public String update(Map<String, Object> parameter) {
    return new SQL() {
        {
            UPDATE(TABLE_NAME);

            SET("`start_time` = #{adHoc.startTime}");
            SET("`end_time` = #{adHoc.endTime}");
            SET("`job_id` = #{adHoc.jobId}");
            SET("`status` = " + EnumFieldUtil.genFieldStr("adHoc.status", FlowStatus.class));

            WHERE("`id` = #{adHoc.id}");
        }
    }.toString();
}

From source file:com.baifendian.swordfish.dao.mapper.AdHocMapperProvider.java

License:Apache License

/**
 * @param parameter//from   w  w  w  . j  a v a2  s.  co m
 * @return
 */
public String updateStatus(Map<String, Object> parameter) {
    return new SQL() {
        {
            UPDATE(TABLE_NAME);

            SET("`status` = " + EnumFieldUtil.genFieldStr("adHoc.status", FlowStatus.class));

            WHERE("`id` = #{adHoc.id}");
        }
    }.toString();
}

From source file:com.baifendian.swordfish.dao.mapper.AdHocMapperProvider.java

License:Apache License

/**
 * , ? id /*  w w  w  .  jav a 2 s .  c o  m*/
 *
 * @param parameter
 * @return
 */
public String selectById(Map<String, Object> parameter) {
    return new SQL() {
        {
            SELECT("*");

            FROM(TABLE_NAME);

            WHERE("`id` = #{id}");
        }
    }.toString();
}

From source file:com.baifendian.swordfish.dao.mapper.AdHocMapperProvider.java

License:Apache License

/**
 *  sql//from   w  w w .  j a  v a  2  s.c om
 *
 * @param parameter
 * @return
 */
public String selectResultById(Map<String, Object> parameter) {
    return new SQL() {
        {
            SELECT("*");

            FROM(RESULT_TABLE_NAME);

            WHERE("`exec_id` = #{execId}");
        }
    }.toString();
}

From source file:com.baifendian.swordfish.dao.mapper.AdHocMapperProvider.java

License:Apache License

/**
 * query result by exec id and index//from  ww w  .j  a v  a  2s . c  o  m
 *
 * @param parameter
 * @return
 */
public String selectResultByIdAndIndex(Map<String, Object> parameter) {
    return new SQL() {
        {
            SELECT("ahr.*");
            SELECT("ah.name as name");

            FROM(RESULT_TABLE_NAME + " as ahr");
            JOIN(TABLE_NAME + " as ah on ahr.exec_id = ah.id");

            WHERE("ahr.exec_id = #{execId}");
            WHERE("ahr.index = #{index}");
        }
    }.toString();
}

From source file:com.baifendian.swordfish.dao.mapper.AdHocMapperProvider.java

License:Apache License

/**
 * adhoc, ? name /*from ww w  .  j a  v a  2s. c  o m*/
 *
 * @param parameter
 * @return
 */
public String selectAdhocByName(Map<String, Object> parameter) {
    return new SQL() {
        {
            SELECT("*");

            FROM(TABLE_NAME);
            WHERE("`project_id` = #{projectId}");
            WHERE("`name` = #{name}");
            ORDER_BY("`create_time` desc");
        }
    }.toString();
}