public String updateByExampleSelective(Map<String, Object> parameter) {
News record = (News) parameter.get("record");
NewsExample example = (NewsExample) parameter.get("example");
BEGIN();
UPDATE("news");
if (record.getId() != null) {
SET("id = #{record.id,jdbcType=BIGINT}");
}
if (record.getHost() != null) {
SET("host = #{record.host,jdbcType=VARCHAR}");
}
if (record.getTitle() != null) {
SET("title = #{record.title,jdbcType=VARCHAR}");
}
if (record.getUrl() != null) {
SET("url = #{record.url,jdbcType=VARCHAR}");
}
applyWhere(example, true);
return SQL();
}
/**
* This method was generated by MyBatis Generator. This method corresponds to the database table
* voltage_rank_classify
*
* @mbggenerated Wed Jan 13 12:15:38 CST 2016
*/
public String updateByExample(Map<String, Object> parameter) {
BEGIN();
UPDATE("voltage_rank_classify");
SET("id = #{record.id,jdbcType=INTEGER}");
SET("name = #{record.name,jdbcType=VARCHAR}");
SET("value = #{record.value,jdbcType=INTEGER}");
SET("bigEquipment = #{record.bigequipment,jdbcType=INTEGER}");
VoltageRankClassifyExample example = (VoltageRankClassifyExample) parameter.get("example");
applyWhere(example, true);
return SQL();
}
public String updateByExample(Map<String, Object> parameter) {
BEGIN();
UPDATE("news");
SET("id = #{record.id,jdbcType=BIGINT}");
SET("host = #{record.host,jdbcType=VARCHAR}");
SET("title = #{record.title,jdbcType=VARCHAR}");
SET("url = #{record.url,jdbcType=VARCHAR}");
NewsExample example = (NewsExample) parameter.get("example");
applyWhere(example, true);
return SQL();
}
/**
* This method was generated by MyBatis Generator. This method corresponds to the database table
* voltage_rank_classify
*
* @mbggenerated Wed Jan 13 12:15:38 CST 2016
*/
public String updateByPrimaryKeySelective(VoltageRankClassify record) {
BEGIN();
UPDATE("voltage_rank_classify");
if (record.getName() != null) {
SET("name = #{name,jdbcType=VARCHAR}");
}
if (record.getValue() != null) {
SET("value = #{value,jdbcType=INTEGER}");
}
if (record.getBigequipment() != null) {
SET("bigEquipment = #{bigequipment,jdbcType=INTEGER}");
}
WHERE("id = #{id,jdbcType=INTEGER}");
return SQL();
}
/**
* This method was generated by MyBatis Generator. This method corresponds to the database table
* STAR
*
* @mbggenerated
*/
public String updateByPrimaryKeySelective(Star record) {
BEGIN();
UPDATE("STAR");
if (record.getFirstname() != null) {
SET("FIRSTNAME = #{firstname,jdbcType=VARCHAR}");
}
if (record.getLastname() != null) {
SET("LASTNAME = #{lastname,jdbcType=VARCHAR}");
}
WHERE("ID = #{id,jdbcType=INTEGER}");
return SQL();
}
/**
* 获取查询sql <功能详细描述>
*
* @return [参数说明]
* @return String [返回类型说明]
* @exception throws [异常类型] [异常说明]
* @see [类、类#方法、类#成员]
*/
public String updateSql(Object obj) {
AssertUtils.notEmpty(obj, "update obj must not empty.");
// 获取当前对象中有哪些属性
MetaObject metaObject = MetaObjectUtils.forObject(obj);
Set<String> keySet = new HashSet<String>();
for (String getterName : metaObject.getGetterNames()) {
keySet.add(getterName);
}
AssertUtils.isTrue(
keySet.contains(this.pkName),
"obj:{} must contains pk{}.",
new Object[] {obj, this.pkName});
// 构建query语句
SqlBuilder.BEGIN();
SqlBuilder.UPDATE(this.tableName);
for (String propertyName : updateAblePropertyNames) {
if (!keySet.contains(propertyName)) {
continue;
}
// Object value = metaObject.getValue(propertyName);
String columnName = getter2columnNameMapping.get(propertyName);
SqlBuilder.SET(columnName + " = ?");
}
SqlBuilder.WHERE(this.getter2columnNameMapping.get(this.pkName) + " = ? ");
String updateSql = SqlBuilder.SQL();
SqlBuilder.RESET();
return updateSql;
}
/**
* This method was generated by MyBatis Generator. This method corresponds to the database table
* voltage_rank_classify
*
* @mbggenerated Wed Jan 13 12:15:38 CST 2016
*/
public String updateByExampleSelective(Map<String, Object> parameter) {
VoltageRankClassify record = (VoltageRankClassify) parameter.get("record");
VoltageRankClassifyExample example = (VoltageRankClassifyExample) parameter.get("example");
BEGIN();
UPDATE("voltage_rank_classify");
if (record.getId() != null) {
SET("id = #{record.id,jdbcType=INTEGER}");
}
if (record.getName() != null) {
SET("name = #{record.name,jdbcType=VARCHAR}");
}
if (record.getValue() != null) {
SET("value = #{record.value,jdbcType=INTEGER}");
}
if (record.getBigequipment() != null) {
SET("bigEquipment = #{record.bigequipment,jdbcType=INTEGER}");
}
applyWhere(example, true);
return SQL();
}
public String updateByPrimaryKeySelective(News record) {
BEGIN();
UPDATE("news");
if (record.getHost() != null) {
SET("host = #{host,jdbcType=VARCHAR}");
}
if (record.getTitle() != null) {
SET("title = #{title,jdbcType=VARCHAR}");
}
if (record.getUrl() != null) {
SET("url = #{url,jdbcType=VARCHAR}");
}
WHERE("id = #{id,jdbcType=BIGINT}");
return SQL();
}
public String updateByExample(Map<String, Object> parameter) {
BEGIN();
UPDATE("student_log_assign");
SET("assign_id = #{record.assignId,jdbcType=BIGINT}");
SET("student_id = #{record.studentId,jdbcType=BIGINT}");
SET("depart_code = #{record.departCode,jdbcType=CHAR}");
SET("depart_name = #{record.departName,jdbcType=VARCHAR}");
SET("job_code = #{record.jobCode,jdbcType=CHAR}");
SET("job_name = #{record.jobName,jdbcType=VARCHAR}");
SET("job_days = #{record.jobDays,jdbcType=INTEGER}");
SET("job_deadline = #{record.jobDeadline,jdbcType=DATE}");
SET("assigned_to = #{record.assignedTo,jdbcType=VARCHAR}");
SET("create_time = #{record.createTime,jdbcType=TIMESTAMP}");
SET("create_user = #{record.createUser,jdbcType=VARCHAR}");
StudentLogAssignExample example = (StudentLogAssignExample) parameter.get("example");
applyWhere(example, true);
return SQL();
}