本文整理汇总了Java中org.apache.ibatis.jdbc.SQL.UPDATE属性的典型用法代码示例。如果您正苦于以下问题:Java SQL.UPDATE属性的具体用法?Java SQL.UPDATE怎么用?Java SQL.UPDATE使用的例子?那么恭喜您, 这里精选的属性代码示例或许可以为您提供帮助。您也可以进一步了解该属性所在类org.apache.ibatis.jdbc.SQL
的用法示例。
在下文中一共展示了SQL.UPDATE属性的6个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的Java代码示例。
示例1: updateByPrimaryKeySelective
/**
* 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();
}
示例2: updateByExampleSelective
/**
* 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();
}
示例3: update
public int update(UpdateContext context){
int count = -1;
SQL sql = new SQL();
sql.UPDATE(getTableName(context));
HashMap<String, Object> paramter = new HashMap<>();
Table table = TableMap.getInstance().getTableMap(clazz);
for (int i = 0;i<fields.length;i++) {
String fieldName = table.getDataBaseField(fields[i]);
sql = sql.SET(fieldName+ " = #{" + fields[i] + i + "}");
paramter.put(fields[i] + i, values[i]);
}
paramter.put(Constant.SQL_SYMBOL, sql.toString()+context.getCondation().toSql(clazz, paramter));
count = context.getDaoMapper().update(paramter);
return count;
}
示例4: update
public int update(UpdateContext context){
int count = -1;
Object target = context.getTarget();
Class<?> targetType = Toolkit.isCglibProxy(target) ? target.getClass().getSuperclass() : target.getClass();
Table table = TableMap.getInstance().getTableMap(targetType);
SQL sql = new SQL();
sql.UPDATE(getTableName(context));
HashMap<String, Object> paramter = new HashMap<>();
for (String fieldStr : table.getDataBaseFieldMap().values()) {
Field field = table.getField(fieldStr);
if (field == table.getId().getField())
continue;
Object value = ReflectionUtils.getValue(target, field);
if (value == null)
continue;
sql = sql.SET(fieldStr+ " = #{" + field.getName() + "}");
paramter.put(field.getName(), value);
}
paramter.put(Constant.SQL_SYMBOL, sql.toString()+context.getCondation().toSql(targetType, paramter));
count = context.getDaoMapper().update(paramter);
return count;
}
示例5: updateSql
@SuppressWarnings("rawtypes")
public String updateSql(Object obj) throws Exception {
String tableName = getTableName(obj);
Map oMap = getBeanMap(obj);
SQL uSql = new SQL();
uSql.UPDATE(tableName);
for (Object key : oMap.keySet()) {
// 属性为null,统一不做修改
if (null != oMap.get(key) && !key.toString().equals("id")) {
uSql.SET(key.toString() + " = #{" + key.toString() + "}");
}
}
uSql.WHERE("id = #{id}");
return uSql.toString();
}
示例6: updateByExample
/**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table user
*
* @mbg.generated
*/
public String updateByExample(Map<String, Object> parameter) {
SQL sql = new SQL();
sql.UPDATE("user");
sql.SET("id = #{record.id,jdbcType=INTEGER}");
sql.SET("username = #{record.username,jdbcType=VARCHAR}");
sql.SET("psw = #{record.psw,jdbcType=VARCHAR}");
UserCriteria example = (UserCriteria) parameter.get("example");
applyWhere(sql, example, true);
return sql.toString();
}