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

License:Apache License

/**
 * ?/*from w w  w  . j  ava2s . c o  m*/
 *
 * @param parameter
 * @return
 */
public String query(Map<String, Object> parameter) {
    return new SQL() {
        {
            SELECT("*");
            SELECT("u.name as user_name, p.name as project_name");

            FROM(TABLE_NAME + " p_u");

            JOIN("user u on p_u.user_id = u.id");
            JOIN("project p on p_u.project_id = p.id");

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

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

License:Apache License

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

            VALUES("`project_id`", "#{projectUser.projectId}");
            VALUES("`user_id`", "#{projectUser.userId}");
            VALUES("`perm`", "#{projectUser.perm}");
            VALUES("`create_time`", "#{projectUser.createTime}");
            VALUES("`modify_time`", "#{projectUser.modifyTime}");
        }
    }.toString();
}

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

License:Apache License

/**
 * /*w w  w  . jav a 2s . c o m*/
 *
 * @param parameter
 * @return
 */
public String queryByProject(Map<String, Object> parameter) {
    String sql = new SQL() {
        {
            SELECT("p_u.*");
            SELECT("u.name as user_name, p.name as project_name, p.owner as owner_id");

            FROM(TABLE_NAME + " p_u");

            JOIN("user u on p_u.user_id = u.id");
            JOIN("project p on p_u.project_id = p.id");

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

    return new SQL() {
        {
            SELECT("t.*");
            SELECT("u.name as owner_name");

            FROM("(" + sql + ") t");

            JOIN("user u on t.owner_id = u.id");
        }
    }.toString();
}

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

License:Apache License

/**
 * ?/* ww w  .j  a va2s  .  com*/
 *
 * @param parameter
 * @return
 */
public String update(Map<String, Object> parameter) {
    return new SQL() {
        {
            UPDATE(TABLE_NAME);

            SET("`perm`=#{projectUser.perm}");
            SET("`modify_time`=#{projectUser.modifyTime}");

            WHERE("`project_id` = #{projectUser.projectId}");
            WHERE("`user_id` = #{projectUser.userId}");
        }
    }.toString();
}

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

License:Apache License

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

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

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

License:Apache License

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

            FROM(TABLE_NAME + " p_u");

            JOIN("user u on p_u.user_id = u.id");

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

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

License:Apache License

/**
 * ???/*w w w  . jav  a 2  s .co m*/
 *
 * @param parameter
 * @return
 */
public String queryByUser(Map<String, Object> parameter) {
    return new SQL() {
        {
            SELECT("*");
            SELECT("u.name as user_name, p.name as project_name");

            FROM(TABLE_NAME + " p_u");

            JOIN("user u on p_u.user_id = u.id");
            JOIN("project p on p_u.project_id = p.id");

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

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

License:Apache License

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

            VALUES("`name`", "#{resource.name,jdbcType=VARCHAR}");
            VALUES("`origin_filename`", "#{resource.originFilename}");
            VALUES("`desc`", "#{resource.desc}");
            VALUES("`owner`", "#{resource.ownerId}");
            VALUES("`project_id`", "#{resource.projectId}");
            VALUES("`create_time`", "#{resource.createTime}");
            VALUES("`modify_time`", "#{resource.modifyTime}");
        }
    }.toString();
}

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

License:Apache License

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

            FROM(TABLE_NAME + " r");

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

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

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

License:Apache License

/**
 * ?//from  www  .j a v  a 2s.co  m
 *
 * @param parameter
 * @return
 */
public String queryResource(Map<String, Object> parameter) {
    return new SQL() {
        {
            SELECT("r.*");
            SELECT("u.name as owner_name");
            SELECT("p.name as project_name");
            FROM(TABLE_NAME + " as r");
            JOIN("user as u on r.owner = u.id");
            JOIN("project as p on r.project_id = p.id");
            WHERE("r.project_id = #{projectId}");
            WHERE("r.name = #{name}");
        }
    }.toString();
}