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.ScheduleMapperProvider.java

License:Apache License

public String selectByFlowName(Map<String, Object> parameter) {
    return new SQL() {
        {/*from www  .  j  av  a 2  s.co m*/
            SELECT("p_f.name as project_flow_name");
            SELECT("p.name as project_name");
            SELECT("u.name as owner_name");
            SELECT("s.*");

            FROM(DB_NAME + " as s");

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

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

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

License:Apache License

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

            FROM(TABLE_NAME);

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

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

License:Apache License

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

            FROM(TABLE_NAME);

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

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

License:Apache License

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

            FROM(TABLE_NAME);

            WHERE("`user_id` = #{userId}");
            WHERE("`ip` = #{ip}");
        }
    }.toString();
}

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

License:Apache License

/**
 * @param parameter/*from www  .ja  v a2  s .c o  m*/
 * @return
 */
public String insert(Map<String, Object> parameter) {
    return new SQL() {
        {
            INSERT_INTO(TABLE_NAME);

            VALUES("`id`", "#{session.id}");
            VALUES("`user_id`", "#{session.userId}");
            VALUES("`ip`", "#{session.ip}");
            VALUES("`last_login_time`", "#{session.lastLoginTime}");
        }
    }.toString();
}

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

License:Apache License

/**
 * @param parameter//from   ww  w .  jav  a 2s  .c  om
 * @return
 */
public String deleteById(Map<String, Object> parameter) {
    return new SQL() {
        {
            DELETE_FROM(TABLE_NAME);

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

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

License:Apache License

/**
 * @param parameter//from  w  w w .j av a 2  s .  co m
 * @return
 */
public String deleteByExpireTime(Map<String, Object> parameter) {
    return new SQL() {
        {
            DELETE_FROM(TABLE_NAME);

            WHERE("`last_login_time` <= #{expireTime}");
        }
    }.toString();
}

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

License:Apache License

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

            SET("`last_login_time`=#{loginTime}");

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

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

License:Apache License

/**
 * ?????//w w w.java2s.co m
 *
 * @param parameter
 * @return
 */
public String insert(Map<String, Object> parameter) {
    return new SQL() {
        {
            INSERT_INTO(TABLE_NAME);

            VALUES("`name`", "#{job.name}");
            VALUES("`desc`", "#{job.desc}");
            VALUES("`project_id`", "#{job.projectId}");
            VALUES("`create_time`", "#{job.createTime}");
            VALUES("`modify_time`", "#{job.modifyTime}");
            VALUES("`owner`", "#{job.ownerId}");
            VALUES("`type`", "#{job.type}");
            VALUES("`parameter`", "#{job.parameter}");
            VALUES("`user_defined_params`", "#{job.userDefinedParams}");
            VALUES("`notify_type`", EnumFieldUtil.genFieldStr("job.notifyType", NotifyType.class));
            VALUES("`notify_mails`", "#{job.notifyMails}");
        }
    }.toString();
}

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

License:Apache License

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

            FROM(TABLE_NAME + " s");

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

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