本文整理汇总了Java中org.apache.ibatis.jdbc.SQL类的典型用法代码示例。如果您正苦于以下问题:Java SQL类的具体用法?Java SQL怎么用?Java SQL使用的例子?那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。
SQL类属于org.apache.ibatis.jdbc包,在下文中一共展示了SQL类的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的Java代码示例。
示例1: findByPage
import org.apache.ibatis.jdbc.SQL; //导入依赖的package包/类
/**
* 查询所有记录(分页)
*
* @param parameter
* @return
*/
public String findByPage(final Map<String, Object> parameter) {
return new SQL() {
{
Class<?> clazz = (Class<?>) parameter.get(CLASS_KEY);
SELECT("*");
FROM(EntityUtil.getTableName(clazz));
if (parameter.containsKey(WHERE_KEY)) {
WHERE((String) parameter.get(WHERE_KEY));
}
if (parameter.containsKey(ORDER_KEY)) {
ORDER_BY((String) parameter.get(ORDER_KEY));
}
if (parameter.containsKey(GROUP_KEY)) {
GROUP_BY((String) parameter.get(GROUP_KEY));
}
}
}.toString();
}
示例2: update
import org.apache.ibatis.jdbc.SQL; //导入依赖的package包/类
public String update(String[] fields, String conditions) {
SQL sql = new SQL().UPDATE(metadata.getTableName() + " AS _this");
for (ColumnProperty property : metadata.getUpdateProperties()) {
String propertyName = property.getName();
// 不包含字段
if (fields.length > 0 && !ArrayUtils.contains(fields, propertyName)) {
continue;
}
Path path = root.getPath(property);
sql.SET(path.getColumn() + "=#{" + path.getPropertyName() + "}");
}
if (conditions != null && conditions.length() > 0) {
sql.WHERE(conditions);
}
return sql.toString();
}
示例3: insert
import org.apache.ibatis.jdbc.SQL; //导入依赖的package包/类
public String insert(T record) {
SQL sql = new SQL().INSERT_INTO(this.getTableName());
getAllDeclaredFields(entityClass).stream()
.filter(field -> !field.isAnnotationPresent(Ignore.class))
.forEach(field -> {
String fieldName = field.getName();
Object value = valueOfField(record, fieldName);
if (null != value) {
if (field.isAnnotationPresent(Column.class)) {
Column annotation = field.getAnnotation(Column.class);
sql.VALUES(annotation.column().trim(), fieldExpression(fieldName, annotation));
} else {
sql.VALUES(columnName(fieldName), fieldExpression(fieldName, null));
}
}
});
if (logger.isDebugEnabled()) {
logger.debug(sql.toString());
}
return sql.toString();
}
示例4: insertSql
import org.apache.ibatis.jdbc.SQL; //导入依赖的package包/类
public String insertSql(final MemAccount memAccount) {
return new SQL(){{
INSERT_INTO(TABLE_NAME);
VALUES("uid", "#{uid}");
VALUES("name", "#{name}");
VALUES("figure", "#{figure}");
VALUES("account", "#{account}");
VALUES("psw", "#{psw}");
VALUES("email", "#{email}");
VALUES("phone", "#{phone}");
VALUES("channel", "#{channel}");
VALUES("platform", "#{platform}");
VALUES("timeCreate", "#{timeCreate}");
VALUES("timeLastLogin", "#{timeLastLogin}");
VALUES("ipCreate", "#{ipCreate}");
VALUES("ipLastLogin", "#{ipLastLogin}");
VALUES("vipLevel", "#{vipLevel}");
VALUES("vipExp", "#{vipExp}");
VALUES("rmb", "#{rmb}");
}}.toString();
}
示例5: updateSql
import org.apache.ibatis.jdbc.SQL; //导入依赖的package包/类
public String updateSql() {
return new SQL(){{
UPDATE(TABLE_NAME);
SET("uid=#{uid}");
SET("name=#{name}");
SET("figure=#{figure}");
SET("account=#{account}");
SET("psw=#{psw}");
SET("email=#{email}");
SET("phone=#{phone}");
SET("channel=#{channel}");
SET("platform=#{platform}");
SET("timeLastLogin=#{timeLastLogin}");
SET("ipLastLogin=#{ipLastLogin}");
SET("vipLevel=#{vipLevel}");
SET("vipExp=#{vipExp}");
SET("rmb=#{rmb}");
WHERE("uid=#{uid}");
}}.toString();
}
示例6: insertSelective
import org.apache.ibatis.jdbc.SQL; //导入依赖的package包/类
/**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table user
*
* @mbg.generated
*/
public String insertSelective(User record) {
SQL sql = new SQL();
sql.INSERT_INTO("user");
if (record.getId() != null) {
sql.VALUES("id", "#{id,jdbcType=INTEGER}");
}
if (record.getUsername() != null) {
sql.VALUES("username", "#{username,jdbcType=VARCHAR}");
}
if (record.getPsw() != null) {
sql.VALUES("psw", "#{psw,jdbcType=VARCHAR}");
}
return sql.toString();
}
示例7: selectByExample
import org.apache.ibatis.jdbc.SQL; //导入依赖的package包/类
/**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table user
*
* @mbg.generated
*/
public String selectByExample(UserCriteria example) {
SQL sql = new SQL();
if (example != null && example.isDistinct()) {
sql.SELECT_DISTINCT("id");
} else {
sql.SELECT("id");
}
sql.SELECT("username");
sql.SELECT("psw");
sql.FROM("user");
applyWhere(sql, example, false);
if (example != null && example.getOrderByClause() != null) {
sql.ORDER_BY(example.getOrderByClause());
}
return sql.toString();
}
示例8: updateByExampleSelective
import org.apache.ibatis.jdbc.SQL; //导入依赖的package包/类
/**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table user
*
* @mbg.generated
*/
public String updateByExampleSelective(Map<String, Object> parameter) {
User record = (User) parameter.get("record");
UserCriteria example = (UserCriteria) parameter.get("example");
SQL sql = new SQL();
sql.UPDATE("user");
if (record.getId() != null) {
sql.SET("id = #{record.id,jdbcType=INTEGER}");
}
if (record.getUsername() != null) {
sql.SET("username = #{record.username,jdbcType=VARCHAR}");
}
if (record.getPsw() != null) {
sql.SET("psw = #{record.psw,jdbcType=VARCHAR}");
}
applyWhere(sql, example, true);
return sql.toString();
}
示例9: updateByPrimaryKeySelective
import org.apache.ibatis.jdbc.SQL; //导入依赖的package包/类
/**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table user
*
* @mbg.generated
*/
public String updateByPrimaryKeySelective(User record) {
SQL sql = new SQL();
sql.UPDATE("user");
if (record.getUsername() != null) {
sql.SET("username = #{username,jdbcType=VARCHAR}");
}
if (record.getPsw() != null) {
sql.SET("psw = #{psw,jdbcType=VARCHAR}");
}
sql.WHERE("id = #{id,jdbcType=INTEGER}");
return sql.toString();
}
示例10: select
import org.apache.ibatis.jdbc.SQL; //导入依赖的package包/类
public String select(Map<String, Object> params) {
Object condition = params.get("condition");
EntityTable entityTable = getEntityTable(condition.getClass());
Pageable pageable = null;
if (params.containsKey("pageable")) {
pageable = (Pageable) params.get("pageable");
}
SQL sql = new SQL();
sql.SELECT(entityTable.getSelectColumns());
sql.FROM(entityTable.getName());
entityTable.getInnerJoins().forEach(sql::INNER_JOIN);
applyWhere(sql, entityTable, condition);
if (pageable == null) {
entityTable.getOrderBys().forEach(sql::ORDER_BY);
return sql.toString();
} else {
return applyPageable(sql, pageable);
}
}
示例11: update
import org.apache.ibatis.jdbc.SQL; //导入依赖的package包/类
/**
* 更新操作
*
* @param obj
* @return String
*/
public String update(Object obj) {
Class<?> clazz = obj.getClass();
PersistMeta meta = EntityUtil.getMeta(clazz);
StringBuilder setting = new StringBuilder(32);
int i = 0;
for (Map.Entry<String, Field> kv : meta.getColumns().entrySet()) {
if (isNull(kv.getValue(), obj)) {
continue;
}
if (i++ != 0) {
setting.append(',');
}
setting.append('`').append(kv.getKey()).append('`').append("=#{").append(kv.getValue().getName()).append('}');
}
return new SQL().UPDATE(getTableName(meta, obj)).SET(setting.toString()).WHERE("id=#{id}").toString();
}
示例12: insert
import org.apache.ibatis.jdbc.SQL; //导入依赖的package包/类
/**
* 新增操作
*
* @param obj
* @return String
*/
public String insert(Object obj) {
PersistMeta meta = EntityUtil.getMeta(obj.getClass());
StringBuilder names = new StringBuilder(), values = new StringBuilder();
int i = 0;
for (Map.Entry<String, Field> kv : meta.getColumns().entrySet()) {
if (isNull(kv.getValue(), obj)) {
continue;
}
if (i++ != 0) {
names.append(',');
values.append(',');
}
names.append('`').append(kv.getKey()).append('`');
values.append("#{").append(kv.getValue().getName()).append('}');
}
return new SQL().INSERT_INTO(getTableName(meta, obj)).VALUES(names.toString(), values.toString()).toString();
}
示例13: query
import org.apache.ibatis.jdbc.SQL; //导入依赖的package包/类
public String query(DefaultPageAndSortEntity defaultPageAndSortEntity) {
try {
final Map<String, Object> entityData = getParam(defaultPageAndSortEntity);
return new SQL() {
{
SELECT("*");
FROM(TABLE_NAME);
for(String column : entityData.keySet()) {
WHERE(column + "=#{" + entityData.get(column) + "}");
}
}
}.toString();
} catch(Exception e) {
throw new MybatisHelperException("query sql error", e);
}
}
示例14: count
import org.apache.ibatis.jdbc.SQL; //导入依赖的package包/类
public String count(DefaultPageAndSortEntity defaultPageAndSortEntity) {
try {
final Map<String, Object> entityData = getParam(defaultPageAndSortEntity);
return new SQL() {
{
SELECT("count(*)");
FROM(TABLE_NAME);
for(String column : entityData.keySet()) {
WHERE(column + "=#{" + entityData.get(column) + "}");
}
}
}.toString();
} catch(Exception e) {
throw new MybatisHelperException("count sql error", e);
}
}
示例15: update
import org.apache.ibatis.jdbc.SQL; //导入依赖的package包/类
public String update(Entity model) {
try {
final Map<String, Object> entityData = getParam(model);
entityData.remove("id");
return new SQL() {
{
UPDATE(TABLE_NAME);
for(String column : entityData.keySet()) {
SET(column + "=#{" + entityData.get(column) + "}");
}
WHERE("id = #{id}");
}
}.toString();
} catch(Exception e) {
throw new MybatisHelperException("construct update sql error", e);
}
}