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

License:Apache License

/**
 * ? sql ?, ???//ww  w  .  j  a v  a2 s  .c  o  m
 *
 * @return
 */
private SQL constructCommonSimpleSQL() {
    return new SQL() {
        {
            SELECT("submit_user as submit_user_id");
            SELECT("s.owner as owner_id");
            SELECT("s.project_id");
            SELECT("s.name");
            SELECT("s.`desc`");
            SELECT("s.create_time");
            SELECT("s.modify_time");
            SELECT("s.notify_type");
            SELECT("s.notify_mails");
            SELECT("s.type");
            SELECT("p.name as project_name");
            SELECT("r.*");

            FROM(TABLE_NAME + " as r");

            JOIN("streaming_job s on r.streaming_id = s.id");
            JOIN("project p on s.project_id = p.id");
        }
    };
}

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

License:Apache License

/**
 *  sql, ???//from w w w  .  j  a  v a 2 s . c  o  m
 *
 * @return
 */
private SQL constructCommonDetailSQL() {
    return new SQL() {
        {
            SELECT("r.submit_user as submit_user_id");
            SELECT("s.owner as owner_id");
            SELECT("s.project_id");
            SELECT("s.name");
            SELECT("s.`desc`");
            SELECT("s.create_time");
            SELECT("s.modify_time");
            SELECT("s.type");
            SELECT("s.notify_type");
            SELECT("s.notify_mails");
            SELECT("u2.name as submit_user_name");
            SELECT("u1.name as owner_name");
            SELECT("p.name as project_name");
            SELECT("r.*");

            FROM(TABLE_NAME + " as r");

            JOIN("streaming_job s on r.streaming_id = s.id");
            JOIN("project p on s.project_id = p.id");
            JOIN("user u1 on s.owner = u1.id");
            JOIN("user u2 on r.submit_user = u2.id");
        }
    };
}

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

License:Apache License

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

            FROM(TABLE_NAME);

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

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

License:Apache License

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

            FROM(TABLE_NAME);

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

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

License:Apache License

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

            FROM(TABLE_NAME);

            if (parameter.get("name") != null) {
                WHERE("`name` = #{name}");
            }
            if (parameter.get("email") != null) {
                WHERE("`email` = #{email}");
            }

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

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

License:Apache License

/**
 * ? id  sql//  ww  w  .  j  a v a2  s  . c  o m
 *
 * @param parameter
 * @return
 */
public String queryById(Map<String, Object> parameter) {
    return new SQL() {
        {
            SELECT("*");

            FROM(TABLE_NAME);

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

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

License:Apache License

/**
 * ??/*from  www  .j a v a 2  s . com*/
 *
 * @param parameter
 * @return
 */
public String insert(Map<String, Object> parameter) {
    return new SQL() {
        {
            INSERT_INTO(TABLE_NAME);

            VALUES("`name`", "#{user.name,jdbcType=VARCHAR}");
            VALUES("`email`", "#{user.email}");
            VALUES("`desc`", "#{user.desc}");
            VALUES("`phone`", "#{user.phone}");
            VALUES("`password`", "#{user.password}");
            VALUES("`role`", EnumFieldUtil.genFieldStr("user.role", UserRoleType.class));
            VALUES("`proxy_users`", "#{user.proxyUsers}");
            VALUES("`create_time`", "#{user.createTime}");
            VALUES("`modify_time`", "#{user.modifyTime}");
        }
    }.toString();
}

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

License:Apache License

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

            SET("`email`=#{user.email}");
            SET("`desc`=#{user.desc}");
            SET("`phone`=#{user.phone}");
            SET("`password`=#{user.password}");
            //        if (user.getRole() != null) {
            //          SET("`role`=" + EnumFieldUtil.genFieldStr("user.role", UserRoleType.class));
            //        }
            SET("`proxy_users`=#{user.proxyUsers}");
            SET("`modify_time`=#{user.modifyTime}");

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

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

License:Apache License

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

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

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

License:Apache License

/**
 * ?/*from   ww  w. ja v  a 2 s  .c  o  m*/
 *
 * @return
 */
public String queryAllUsers() {
    return new SQL() {
        {
            SELECT("*");

            FROM(TABLE_NAME);
        }
    }.toString();
}