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.blazarquant.bfp.database.providers.UserSQLProvider.java

License:Apache License

public String buildUpdateConfirmationKey() {
    return new SQL() {
        {/*  ww  w  .  j a va  2s  . co m*/
            UPDATE(Tables.USERS_TABLE);
            SET("user_confirmationkey = #{confirmationKey}");
            WHERE("ID = #{userId.id}");
        }
    }.toString();
}

---

From source file:com.blazarquant.bfp.database.providers.UserSQLProvider.java

License:Apache License

public String buildUpdateUserLastLogin() {
    return new SQL() {
        {/*from   ww w .java 2  s .  co  m*/
            UPDATE(Tables.USERS_TABLE);
            SET("user_lastlogin = #{lastLogin, typeHandler=com.blazarquant.bfp.database.typehandlers.InstantTypeHandler}");
            WHERE("ID = #{userId.id}");
        }
    }.toString();
}

---

From source file:com.blazarquant.bfp.database.providers.UserSQLProvider.java

License:Apache License

public String buildUpdateUserStatus() {
    return new SQL() {
        {// w  w w . j  av  a  2  s.  c om
            UPDATE(Tables.USERS_TABLE);
            SET("user_status=#{userStatus, typeHandler=com.blazarquant.bfp.database.typehandlers.user.ActiveUserTypeHandler}");
            WHERE("ID = #{userId.id}");
        }
    }.toString();
}

---

From source file:com.blazarquant.bfp.database.providers.UserSQLProvider.java

License:Apache License

public String buildFindParameters() {
    return new SQL() {
        {//from   w ww . j a va  2s .c o m
            SELECT("user_setting, setting_value");
            FROM(Tables.USER_PARAMETERS);
            WHERE("user_id = #{userId.id}");
        }
    }.toString();
}

---

From source file:com.github.abel533.entity.CommonProvider.java

License:Open Source License

/**
 * ??Entity.classnew Entity()/*from   www .  j  a  v  a2s  . com*/
 *
 * @param params
 * @return
 */
public String selectOne(final Map<String, Object> params) {
    return new SQL() {
        {
            Object entity = getEntity(params);
            Class<?> entityClass = getEntityClass(params);
            EntityHelper.EntityTable entityTable = EntityHelper.getEntityTable(entityClass);
            SELECT(EntityHelper.getAllColumns(entityClass));
            FROM(entityTable.getName());
            if (entity != null) {
                final MetaObject metaObject = MapperTemplate.forObject(entity);
                for (EntityHelper.EntityColumn column : entityTable.getEntityClassColumns()) {
                    Object value = metaObject.getValue(column.getProperty());
                    if (value == null) {
                        continue;
                    } else if (column.getJavaType().equals(String.class)) {
                        if (isNotEmpty((String) value)) {
                            WHERE(column.getColumn() + "=#{record." + column.getProperty() + "}");
                        }
                    } else {
                        WHERE(column.getColumn() + "=#{record." + column.getProperty() + "}");
                    }
                }
            }
        }
    }.toString();
}

---

From source file:com.github.abel533.entity.CommonProvider.java

License:Open Source License

/**
 * ??Entity.classnew Entity()/* w ww . ja v  a 2  s . c  o m*/
 *
 * @param params
 * @return
 */
public String select(final Map<String, Object> params) {
    return new SQL() {
        {
            Object entity = getEntity(params);
            Class<?> entityClass = getEntityClass(params);
            EntityHelper.EntityTable entityTable = EntityHelper.getEntityTable(entityClass);
            SELECT(EntityHelper.getAllColumns(entityClass));
            FROM(entityTable.getName());
            if (entity != null) {
                final MetaObject metaObject = MapperTemplate.forObject(entity);
                for (EntityHelper.EntityColumn column : entityTable.getEntityClassColumns()) {
                    Object value = metaObject.getValue(column.getProperty());
                    if (value == null) {
                        continue;
                    } else if (column.getJavaType().equals(String.class)) {
                        if (isNotEmpty((String) value)) {
                            WHERE(column.getColumn() + "=#{record." + column.getProperty() + "}");
                        }
                    } else {
                        WHERE(column.getColumn() + "=#{record." + column.getProperty() + "}");
                    }
                }
            }
            StringBuilder orderByClause = EntityHelper.getOrderByClause(entityClass);
            if (orderByClause.length() > 0) {
                ORDER_BY(orderByClause.toString());
            }
        }
    }.toString();
}

---

From source file:com.github.abel533.entity.CommonProvider.java

License:Open Source License

/**
 * ??Entity.classnew Entity()//  ww w  . j  a v  a2  s . co m
 *
 * @param params
 * @return
 */
public String count(final Map<String, Object> params) {
    return new SQL() {
        {
            Object entity = getEntity(params);
            Class<?> entityClass;
            if (entity instanceof Class<?>) {
                entityClass = (Class<?>) entity;
                entity = null;
            } else {
                entityClass = getEntityClass(params);
            }
            EntityHelper.EntityTable entityTable = EntityHelper.getEntityTable(entityClass);
            SELECT("count(*)");
            FROM(entityTable.getName());
            if (entity != null) {
                MetaObject metaObject = MapperTemplate.forObject(entity);
                for (EntityHelper.EntityColumn column : entityTable.getEntityClassColumns()) {
                    Object value = metaObject.getValue(column.getProperty());
                    if (value == null) {
                        continue;
                    } else if (column.getJavaType().equals(String.class)) {
                        if (isNotEmpty((String) value)) {
                            WHERE(column.getColumn() + "=#{record." + column.getProperty() + "}");
                        }
                    } else {
                        WHERE(column.getColumn() + "=#{record." + column.getProperty() + "}");
                    }
                }
            }
        }
    }.toString();
}

---

From source file:com.github.abel533.entity.CommonProvider.java

License:Open Source License

/**
 * ?/* w ww.  ja v  a  2 s .  c  o m*/
 *
 * @param params
 * @return
 */
public String selectByPrimaryKey(final Map<String, Object> params) {
    return new SQL() {
        {
            Object entity = getEntity(params);
            Class<?> entityClass = getEntityClass(params);
            EntityHelper.EntityTable entityTable = EntityHelper.getEntityTable(entityClass);
            SELECT(EntityHelper.getAllColumns(entityClass));
            FROM(entityTable.getName());
            if (entityTable.getEntityClassPKColumns().size() == 1) {
                EntityHelper.EntityColumn column = entityTable.getEntityClassPKColumns().iterator().next();
                notNullKeyProperty(column.getProperty(), entity);
                WHERE(column.getColumn() + "=#{key}");
            } else {
                applyWherePk(this, MapperTemplate.forObject(entity), entityTable.getEntityClassPKColumns(),
                        "key");
            }
        }
    }.toString();
}

---

From source file:com.github.abel533.entity.CommonProvider.java

License:Open Source License

/**
 * /*from   ww  w.j  a va 2 s  .  c  o m*/
 *
 * @param params
 * @return
 */
public String insert(final Map<String, Object> params) {
    return new SQL() {
        {
            Class<?> entityClass = getEntityClass(params);
            EntityHelper.EntityTable entityTable = EntityHelper.getEntityTable(entityClass);
            INSERT_INTO(entityTable.getName());
            for (EntityHelper.EntityColumn column : entityTable.getEntityClassColumns()) {
                VALUES(column.getColumn(), "#{record." + column.getProperty() + "}");
            }
        }
    }.toString();
}

---

From source file:com.github.abel533.entity.CommonProvider.java

License:Open Source License

/**
 * ??/* w  w w.j  a  v  a2 s .c om*/
 *
 * @param params
 * @return
 */
public String insertSelective(final Map<String, Object> params) {
    return new SQL() {
        {
            Object entity = getEntity(params);
            Class<?> entityClass = getEntityClass(params);
            EntityHelper.EntityTable entityTable = EntityHelper.getEntityTable(entityClass);
            MetaObject metaObject = MapperTemplate.forObject(entity);
            INSERT_INTO(entityTable.getName());
            for (EntityHelper.EntityColumn column : entityTable.getEntityClassColumns()) {
                Object value = metaObject.getValue(column.getProperty());
                if (column.isId() || value != null) {
                    VALUES(column.getColumn(), "#{record." + column.getProperty() + "}");
                }
            }
        }
    }.toString();
}

---

• «
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• 12
• 13
• 14
• 15
• 16
• 17
• 18
• 19
• 20
• 21
• 22
• »