com.google.protobuf.Descriptors.FieldDescriptor#getOptions ( )源码实例Demo

/**
 * 插入对象到给定的表中。注意，这里并不自动生成ID。
 * 
 * @param message
 * @param tableName
 * @return
 */
public long insert(M message, String tableName) {
	StringBuilder insertSql = new StringBuilder("insert into ");
	insertSql.append(tableName).append("(");
	StringBuilder fields = new StringBuilder("");
	StringBuilder values = new StringBuilder("");
	List<Object> args = new ArrayList<Object>();
	Map<FieldDescriptor, Object> fieldMap = message.getAllFields();

	for (Entry<FieldDescriptor, Object> entry : fieldMap.entrySet()) {
		FieldDescriptor fieldDescriptor = entry.getKey();
		FieldOptions fieldOptions = fieldDescriptor.getOptions();
		ColumnFieldOption columnFieldOption = fieldOptions
				.getExtension(Taglib.columnOption);
		String fieldName = fieldDescriptor.getName();
		Object value = entry.getValue();

		if (columnFieldOption.getColumnType() == ColumnType.DATETIME
				|| columnFieldOption.getColumnType() == ColumnType.TIMESTAMP) {// datetime类型
			if (value != null && (long) value > 0) {
				fields.append('`').append(fieldName).append("`,");
				values.append("?, ");
				args.add(new Timestamp((long) value));
			}
		} else {
			fields.append('`').append(fieldName).append("`,");
			values.append("?, ");
			args.add(value);
		}
	}
	int tmpIndex = fields.lastIndexOf(",");
	insertSql.append(fields.substring(0, tmpIndex)).append(") values(");
	tmpIndex = values.lastIndexOf(",");
	insertSql.append(values.substring(0, tmpIndex)).append(")");
	String sql = insertSql.toString();
	return update(sql, args);
}
 

/**
 * 
 * @param message
 * @param conditionFields
 * @param conditionParams
 * @param tableName
 * @return
 */
protected int updateMessageByCondition(M message, String[] conditionFields,
		Object[] conditionParams, String tableName) {
	StringBuilder updateSql = new StringBuilder("update ");
	updateSql.append(tableName).append(" set ");
	StringBuilder options = new StringBuilder("");
	List<Object> args = new ArrayList<Object>();
	Map<FieldDescriptor, Object> fieldMap = message.getAllFields();

	for (Entry<FieldDescriptor, Object> entry : fieldMap.entrySet()) {
		FieldDescriptor fieldDescriptor = entry.getKey();
		if (!Arrays.asList(conditionFields).contains(
				fieldDescriptor.getName())) {
			FieldOptions fieldOptions = fieldDescriptor.getOptions();
			ColumnFieldOption columnFieldOption = fieldOptions
					.getExtension(Taglib.columnOption);
			String fieldName = fieldDescriptor.getName();
			Object value = entry.getValue();
			if (columnFieldOption.getColumnType() == ColumnType.DATETIME
					|| columnFieldOption.getColumnType() == ColumnType.TIMESTAMP) {// datetime类型
				if (value != null && (long) value > 0) {
					options.append(fieldName).append("=?, ");
					args.add(new Timestamp((long) value));
				}
			} else {
				options.append(fieldName).append("=?, ");
				args.add(value);
			}
		}
	}
	int tmpIndex = options.lastIndexOf(",");
	updateSql.append(options.substring(0, tmpIndex)).append(" where 1=1 ");
	StringBuilder condition = new StringBuilder();
	if (conditionFields.length != conditionParams.length) {
		throw new IllegalArgumentException("condition error");
	} else {
		for (int i = 0; i < conditionFields.length; i++) {
			condition.append("AND ").append(conditionFields[i])
					.append("=? ");
			args.add(conditionParams[i]);
		}
		updateSql.append(condition);
		String sql = updateSql.toString();
		logger.debug(sql);
		return update(sql, args);
	}
}