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:com.baifendian.swordfish.dao.mapper.MasterServerMapperProvider.java

License:Apache License

/**
 * ? table /* w w w.  j a v a 2s  .c o  m*/
 *
 * @param parameter
 * @return
 */
public String insert(Map<String, Object> parameter) {
    return new SQL() {
        {
            INSERT_INTO(TABLE_NAME);

            VALUES("host", "#{masterServer.host}");
            VALUES("port", "#{masterServer.port}");
            VALUES("create_time", "#{masterServer.createTime}");
            VALUES("modify_time", "#{masterServer.modifyTime}");
        }
    }.toString();
}

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

License:Apache License

/**
 * ?/*from   www .  jav a 2 s . c om*/
 *
 * @param parameter
 * @return
 */
public String update(Map<String, Object> parameter) {
    return new SQL() {
        {
            UPDATE(TABLE_NAME);

            SET("modify_time = #{masterServer.modifyTime}");

            WHERE("host = #{masterServer.host}");
            WHERE("port = #{masterServer.port}");
        }
    }.toString();
}

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

License:Apache License

/**
 * 
 *
 * @return
 */
public String delete() {
    return new SQL() {
        {
            DELETE_FROM(TABLE_NAME);
        }
    }.toString();
}

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

License:Apache License

/**
 *  host, port ?/*from w  ww  .  j av a 2s. c  om*/
 *
 * @param parameter
 * @return
 */
public String deleteByHostPort(Map<String, Object> parameter) {
    return new SQL() {
        {
            DELETE_FROM(TABLE_NAME);

            WHERE("host = #{host}");
            WHERE("port = #{port}");
        }
    }.toString();
}

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

License:Apache License

/**
 * ? <p>//from  ww  w . ja  v a  2 s.  c  o  m
 *
 * @param parameter
 * @return sql ?
 */
public String insert(Map<String, Object> parameter) {
    return new SQL() {
        {
            INSERT_INTO(TABLE_NAME);

            VALUES("`name`", "#{flow.name}");
            VALUES("`desc`", "#{flow.desc}");
            VALUES("`project_id`", "#{flow.projectId}");
            VALUES("`modify_time`", "#{flow.modifyTime}");
            VALUES("`create_time`", "#{flow.createTime}");
            VALUES("`owner`", "#{flow.ownerId}");
            VALUES("`proxy_user`", "#{flow.proxyUser}");
            VALUES("`user_defined_params`", "#{flow.userDefinedParams}");
            VALUES("`extras`", "#{flow.extras}");
            VALUES("`queue`", "#{flow.queue}");
        }
    }.toString();
}

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

License:Apache License

/**
 *  id  <p>//from   w w  w .  j  ava  2 s  .  c o  m
 *
 * @param parameter
 * @return sql ?
 */
public String updateById(Map<String, Object> parameter) {
    return new SQL() {
        {
            UPDATE(TABLE_NAME);

            SET("`desc`=#{flow.desc}");
            SET("`modify_time`=#{flow.modifyTime}");
            SET("`create_time`=#{flow.createTime}");
            SET("`owner`=#{flow.ownerId}");
            SET("`proxy_user`=#{flow.proxyUser}");
            SET("`user_defined_params`=#{flow.userDefinedParams}");
            SET("`extras`=#{flow.extras}");
            SET("`queue`=#{flow.queue}");

            WHERE("id = #{flow.id}");
            WHERE("flag is null");
        }
    }.toString();
}

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

License:Apache License

/**
 * ??//from   www . j a va 2  s. c  om
 *
 * @param parameter
 * @return
 */
public String queryByName(Map<String, Object> parameter) {
    return new SQL() {
        {
            SELECT("p_f.owner as owner_id");
            SELECT("p.name as project_name");
            SELECT("u.name as owner_name");
            SELECT("p_f.*");

            FROM(TABLE_NAME + " p_f");

            JOIN("project p on p_f.project_id = p.id");
            JOIN("user u on p_f.owner = u.id");

            WHERE("p_f.project_id = #{projectId}");
            WHERE("p_f.name = #{name}");
        }
    }.toString();
}

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

License:Apache License

/**
 * ??//  w w w  . ja  va2  s. c  o m
 *
 * @param parameter
 * @return
 */
public String queryById(Map<String, Object> parameter) {
    return new SQL() {
        {
            SELECT("p_f.owner as owner_id");
            SELECT("p.name as project_name");
            SELECT("u.name as owner_name");
            SELECT("p_f.*");

            FROM(TABLE_NAME + " p_f");

            JOIN("project p on p_f.project_id = p.id");
            JOIN("user u on p_f.owner = u.id");

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

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

License:Apache License

/**
 * ??//from  www  . j  ava  2  s.c o  m
 *
 * @param parameter
 * @return
 */
public String findByProjectNameAndName(Map<String, Object> parameter) {
    return new SQL() {
        {
            SELECT("p_f.owner as owner_id");
            SELECT("p.name as project_name");
            SELECT("u.name as owner_name");
            SELECT("p_f.*");

            FROM(TABLE_NAME + " p_f");

            JOIN("project p on p_f.project_id = p.id");
            JOIN("user u on p_f.owner = u.id");

            WHERE("p.name = #{projectName}");
            WHERE("p_f.name = #{name}");
        }
    }.toString();
}

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

License:Apache License

/**
 * ??//from   ww  w.  java2  s . co  m
 *
 * @param parameter
 * @return
 */
public String findByProject(Map<String, Object> parameter) {
    return new SQL() {
        {
            SELECT("*");

            FROM(TABLE_NAME);

            WHERE("project_id = #{projectId}");
        }
    }.toString();
}