org.mybatis.generator.api.dom.xml.XmlElement#addElement

Source File: HsqldbUpsertPlugin.java From dolphin with Apache License 2.0

6 votes

@Override
protected void generateSqlMapContentSelective(IntrospectedTable introspectedTable, XmlElement parent) {
  generateTextBlockAppendTableName("merge into ", introspectedTable, parent);
  generateTextBlock(" using (values ", parent);
  generateParametersSeparateByComma(PROPERTY_PREFIX, true, introspectedTable.getAllColumns(), parent);
  generateTextBlock(" ) temp ", parent);
  generateActualColumnNamesWithParenthesis(PROPERTY_PREFIX, true, introspectedTable.getAllColumns(), parent);
  generateTextBlock(" on ( ", parent);

  XmlElement include = new XmlElement("include");
  include.addAttribute(new Attribute("refid", IDENTIFIERS_ARRAY_CONDITIONS));
  parent.addElement(include);

  generateTextBlock(" ) ", parent);

  generateTextBlock(" when matched then update set ", parent);
  generateCopyForSetByPrefix(PROPERTY_PREFIX,
      introspectedTable.getAliasedFullyQualifiedTableNameAtRuntime() + ".", "temp.", true, introspectedTable, parent);

  generateTextBlock(" when not matched then insert ", parent);
  generateActualColumnNamesWithParenthesis(PROPERTY_PREFIX, true, introspectedTable.getAllColumns(), parent);
  generateTextBlock(" values ", parent);
  generateActualColumnNamesWithParenthesis(PROPERTY_PREFIX, "temp.", true, introspectedTable.getAllColumns(), parent);
}

Source File: OracleSupport.java From mybatis-generator-plus with Apache License 2.0

6 votes

/**
 * 在单条插入动态sql中增加查询序列，以实现oracle主键自增
 *
 * @author 吴帅
 * @parameter @param element
 * @parameter @param introspectedTable
 * @createDate 2015年9月29日 下午12:00:37
 */
@Override
public void adaptInsertSelective(XmlElement element, IntrospectedTable introspectedTable) {
    TableConfiguration tableConfiguration = introspectedTable.getTableConfiguration();
    Properties properties = tableConfiguration.getProperties();
    String incrementFieldName = properties.getProperty("incrementField");
    if (incrementFieldName != null) {// 有自增字段的配置
        List<Element> elements = element.getElements();
        XmlElement selectKey = new XmlElement("selectKey");
        selectKey.addAttribute(new Attribute("keyProperty", incrementFieldName));
        selectKey.addAttribute(new Attribute("resultType", "java.lang.Long"));
        selectKey.addAttribute(new Attribute("order", "BEFORE"));
        selectKey.addElement(new TextElement("select "));
        XmlElement includeSeq = new XmlElement("include");
        includeSeq.addAttribute(new Attribute("refid", "TABLE_SEQUENCE"));
        selectKey.addElement(includeSeq);
        selectKey.addElement(new TextElement(" from dual"));
        elements.add(0, selectKey);
    }
}

Source File: DeleteByExampleElementGenerator.java From mapper-generator-javafx with Apache License 2.0

6 votes

@Override
public void addElements(XmlElement parentElement) {
    XmlElement answer = new XmlElement("delete");

    String fqjt = introspectedTable.getExampleType();

    answer.addAttribute(new Attribute(
            "id", introspectedTable.getDeleteByExampleStatementId()));
    answer.addAttribute(new Attribute("parameterType", fqjt));

    context.getCommentGenerator().addComment(answer);

    StringBuilder sb = new StringBuilder();
    sb.append("delete from ");
    sb.append(introspectedTable
            .getAliasedFullyQualifiedTableNameAtRuntime());
    answer.addElement(new TextElement(sb.toString()));
    answer.addElement(getExampleIncludeElement());

    if (context.getPlugins().sqlMapDeleteByExampleElementGenerated(
            answer, introspectedTable)) {
        parentElement.addElement(answer);
    }
}

Source File: GenPlugin.java From scaffold-cloud with MIT License

6 votes

/**
 * 查询
 *
 * @param id
 * @param tableName
 * @param pkColumn
 * @return
 */
private XmlElement createSelect(String id, String tableName, IntrospectedColumn pkColumn) {
    XmlElement select = new XmlElement("select");
    select.addAttribute(new Attribute("id", id));
    select.addAttribute(new Attribute("resultMap", "BaseResultMap"));

    StringBuilder selectStr = new StringBuilder("select <include refid=\"sql_columns\" /> from ").append(tableName);
    if (null != pkColumn) {
        selectStr.append(" where ").append(pkColumn.getActualColumnName()).append(" = #{").append(pkColumn.getJavaProperty()).append("}");
    } else {
        if (!"selectMap".equals(id)) {
            selectStr.append(" <include refid=\"sql_where\" />");
        } else {
            selectStr.append(" <include refid=\"sql_map_where\" />");
        }
    }
    if ("selectPage".equals(id)) {
        selectStr.append(" limit #{page.startRow}, #{page.pageSize}");
    }
    if ("selectLockById".equals(id)) {
        selectStr.append(" for update");
    }
    select.addElement(new TextElement(selectStr.toString()));
    return select;
}

Source File: XmlElementGeneratorTools.java From mybatis-generator-plugin with Apache License 2.0

6 votes

/**
 * 生成 xxxByPrimaryKey 的where 语句
 * @param element
 * @param primaryKeyColumns
 * @param prefix
 * @return
 */
public static void generateWhereByPrimaryKeyTo(XmlElement element, List<IntrospectedColumn> primaryKeyColumns, String prefix) {
    StringBuilder sb = new StringBuilder();
    boolean and = false;
    for (IntrospectedColumn introspectedColumn : primaryKeyColumns) {
        sb.setLength(0);
        if (and) {
            sb.append("  and ");
        } else {
            sb.append("where ");
            and = true;
        }

        sb.append(MyBatis3FormattingUtilities.getEscapedColumnName(introspectedColumn));
        sb.append(" = ");
        sb.append(MyBatis3FormattingUtilities.getParameterClause(introspectedColumn, prefix));
        element.addElement(new TextElement(sb.toString()));
    }
}

Source File: HsqldbUpsertPlugin.java From dolphin with Apache License 2.0

6 votes

@Override
protected void generateSqlMapContent(IntrospectedTable introspectedTable, XmlElement parent) {
  generateTextBlockAppendTableName("merge into ", introspectedTable, parent);
  generateTextBlock(" using (values ", parent);
  generateParametersSeparateByComma(PROPERTY_PREFIX,introspectedTable.getAllColumns(), parent);
  generateTextBlock(" ) temp ", parent);
  generateActualColumnNamesWithParenthesis(introspectedTable.getAllColumns(), parent);
  generateTextBlock(" on ( ", parent);

  XmlElement include = new XmlElement("include");
  include.addAttribute(new Attribute("refid", IDENTIFIERS_ARRAY_CONDITIONS));
  parent.addElement(include);

  generateTextBlock(" ) ", parent);

  generateTextBlock(" when matched then update set ", parent);
  generateCopyForSetByPrefix(introspectedTable.getAliasedFullyQualifiedTableNameAtRuntime() + ".", "temp.", introspectedTable, parent);

  generateTextBlock(" when not matched then insert ", parent);
  generateActualColumnNamesWithParenthesis(introspectedTable.getAllColumns(), parent);
  generateTextBlock(" values ", parent);
  generateActualColumnNamesWithParenthesis(PROPERTY_PREFIX, "temp.", false, introspectedTable.getAllColumns(), parent);
}

Source File: DeleteByExampleElementGenerator.java From mybatis-generator-plus with Apache License 2.0

5 votes

@Override
public void addElements(XmlElement parentElement) {
    XmlElement answer = new XmlElement("delete"); //$NON-NLS-1$

    answer.addAttribute(new Attribute(
            "id", introspectedTable.getDeleteByExampleStatementId())); //$NON-NLS-1$
    answer.addAttribute(new Attribute(
            "parameterClass", introspectedTable.getExampleType())); //$NON-NLS-1$

    context.getCommentGenerator().addComment(answer);

    StringBuilder sb = new StringBuilder();
    sb.append("delete from "); //$NON-NLS-1$
    sb.append(introspectedTable
            .getAliasedFullyQualifiedTableNameAtRuntime());
    answer.addElement(new TextElement(sb.toString()));

    XmlElement includeElement = new XmlElement("include"); //$NON-NLS-1$
    sb.setLength(0);
    sb.append(introspectedTable.getIbatis2SqlMapNamespace());
    sb.append('.');
    sb.append(introspectedTable.getExampleWhereClauseId());
    includeElement.addAttribute(new Attribute("refid", //$NON-NLS-1$
            sb.toString()));

    answer.addElement(includeElement);

    if (context.getPlugins().sqlMapDeleteByExampleElementGenerated(
            answer, introspectedTable)) {
        parentElement.addElement(answer);
    }
}

Source File: HsqldbPaginationPlugin.java From dolphin with Apache License 2.0

5 votes

@Override
public boolean sqlMapSelectByExampleWithoutBLOBsElementGenerated(XmlElement element, IntrospectedTable introspectedTable) {
  XmlElement isNotNullElement = new XmlElement("if");
  isNotNullElement.addAttribute(new Attribute("test", "limit != null and limit>=0 and offset != null"));
  isNotNullElement.addElement(new TextElement("limit #{limit} offset #{offset}"));
  element.addElement(isNotNullElement);
  return true;
}

Source File: ResultMapWithBLOBsElementGenerator.java From mybatis-generator-core-fix with Apache License 2.0

5 votes

@Override
public void addElements(XmlElement parentElement) {
    XmlElement answer = new XmlElement("resultMap"); //$NON-NLS-1$

    answer.addAttribute(new Attribute("id", //$NON-NLS-1$
            introspectedTable.getResultMapWithBLOBsId()));

    String returnType;
    if (introspectedTable.getRules().generateRecordWithBLOBsClass()) {
        returnType = introspectedTable.getRecordWithBLOBsType();
    } else {
        // table has BLOBs, but no BLOB class - BLOB fields must be
        // in the base class
        returnType = introspectedTable.getBaseRecordType();
    }

    answer.addAttribute(new Attribute("type", //$NON-NLS-1$
            returnType));

    if (!introspectedTable.isConstructorBased()) {
        answer.addAttribute(new Attribute("extends", //$NON-NLS-1$
            introspectedTable.getBaseResultMapId()));
    }

    context.getCommentGenerator().addComment(answer);

    if (introspectedTable.isConstructorBased()) {
        addResultMapConstructorElements(answer);
    } else {
        addResultMapElements(answer);
    }

    if (context.getPlugins()
            .sqlMapResultMapWithBLOBsElementGenerated(answer,
                    introspectedTable)) {
        parentElement.addElement(answer);
    }
}

Source File: MapperCommentGenerator.java From tk-mybatis with MIT License

5 votes

/**
 * xml中的注释
 *
 * @param xmlElement
 */
public void addComment(XmlElement xmlElement) {
    xmlElement.addElement(new TextElement("<!--"));
    StringBuilder sb = new StringBuilder();
    sb.append("  WARNING - ");
    sb.append(MergeConstants.NEW_ELEMENT_TAG);
    xmlElement.addElement(new TextElement(sb.toString()));
    xmlElement.addElement(new TextElement("-->"));
}

Source File: SQLServerUpsertPlugin.java From dolphin with Apache License 2.0

5 votes

@Override protected void generateSqlMapContentSelective(IntrospectedTable introspectedTable, XmlElement parent) {
  generateTextBlockAppendTableName("update ", introspectedTable,parent);
  generateTextBlock(" set ",parent);
  generateParameterForSet(PROPERTY_PREFIX,true, introspectedTable.getAllColumns(), parent);
  parent.addElement(checkArrayWhere(introspectedTable));
  generateTextBlock(" if @@ROWCOUNT = 0 ",parent);
  generateTextBlockAppendTableName(" insert into ", introspectedTable,parent);
  generateActualColumnNamesWithParenthesis(PROPERTY_PREFIX,true,introspectedTable.getAllColumns(), parent);
  generateTextBlock(" values ", parent);
  generateParametersSeparateByCommaWithParenthesis(PROPERTY_PREFIX,true, introspectedTable.getAllColumns(), parent);
}

Source File: BaseColumnListElementGenerator.java From mybatis-generator-core-fix with Apache License 2.0

5 votes

@Override
public void addElements(XmlElement parentElement) {
    XmlElement answer = new XmlElement("sql"); //$NON-NLS-1$

    answer.addAttribute(new Attribute("id", //$NON-NLS-1$
            introspectedTable.getBaseColumnListId()));

    context.getCommentGenerator().addComment(answer);

    StringBuilder sb = new StringBuilder();
    Iterator<IntrospectedColumn> iter = introspectedTable
            .getNonBLOBColumns().iterator();
    while (iter.hasNext()) {
        sb.append(MyBatis3FormattingUtilities.getSelectListPhrase(iter
                .next()));

        if (iter.hasNext()) {
            sb.append(", "); //$NON-NLS-1$
        }

        if (sb.length() > 80) {
            answer.addElement(new TextElement(sb.toString()));
            sb.setLength(0);
        }
    }

    if (sb.length() > 0) {
        answer.addElement((new TextElement(sb.toString())));
    }

    if (context.getPlugins().sqlMapBaseColumnListElementGenerated(
            answer, introspectedTable)) {
        parentElement.addElement(answer);
    }
}

Source File: BlobColumnListElementGenerator.java From mybatis-generator-core-fix with Apache License 2.0

5 votes

@Override
public void addElements(XmlElement parentElement) {
    XmlElement answer = new XmlElement("sql"); //$NON-NLS-1$

    answer.addAttribute(new Attribute("id", //$NON-NLS-1$
            introspectedTable.getBlobColumnListId()));

    context.getCommentGenerator().addComment(answer);

    StringBuilder sb = new StringBuilder();

    Iterator<IntrospectedColumn> iter = introspectedTable.getBLOBColumns()
            .iterator();
    while (iter.hasNext()) {
        sb.append(Ibatis2FormattingUtilities.getSelectListPhrase(iter
                .next()));

        if (iter.hasNext()) {
            sb.append(", "); //$NON-NLS-1$
        }

        if (sb.length() > 80) {
            answer.addElement(new TextElement(sb.toString()));
            sb.setLength(0);
        }
    }

    if (sb.length() > 0) {
        answer.addElement((new TextElement(sb.toString())));
    }

    if (context.getPlugins().sqlMapBlobColumnListElementGenerated(
            answer, introspectedTable)) {
        parentElement.addElement(answer);
    }
}

Source File: SelectPageKeyPlugin.java From hui-mybatis-generator-plugins with Apache License 2.0

5 votes

@Override
    public boolean sqlMapDocumentGenerated(Document document, IntrospectedTable introspectedTable) {
//        if (isGeneratePagination(introspectedTable)) {
        XmlElement select = new XmlElement("select");
        select.addAttribute(new Attribute("id", "selectByPage"));
        select.addAttribute(new Attribute("resultMap", "BaseResultMap"));
        select.addElement(new TextElement("SELECT <include refid=\"Base_Column_List\" /> FROM " + introspectedTable.getFullyQualifiedTableNameAtRuntime() + " LIMIT #{offset},#{limit}"));
        XmlElement parentElement = document.getRootElement();
        parentElement.addElement(select);
        return super.sqlMapDocumentGenerated(document, introspectedTable);
//        }

//        return super.sqlMapDocumentGenerated(document, introspectedTable);
    }

Source File: BaseColumnListElementGenerator.java From mapper-generator-javafx with Apache License 2.0

5 votes

@Override
public void addElements(XmlElement parentElement) {
    XmlElement answer = new XmlElement("sql");

    answer.addAttribute(new Attribute("id",
            introspectedTable.getBaseColumnListId()));

    context.getCommentGenerator().addComment(answer);

    StringBuilder sb = new StringBuilder();
    Iterator<IntrospectedColumn> iter = introspectedTable
            .getNonBLOBColumns().iterator();
    while (iter.hasNext()) {
        sb.append(MyBatis3FormattingUtilities.getSelectListPhrase(iter
                .next()));

        if (iter.hasNext()) {
            sb.append(", ");
        }

        if (sb.length() > 80) {
            answer.addElement(new TextElement(sb.toString()));
            sb.setLength(0);
        }
    }

    if (sb.length() > 0) {
        answer.addElement(new TextElement(sb.toString()));
    }

    if (context.getPlugins().sqlMapBaseColumnListElementGenerated(
            answer, introspectedTable)) {
        parentElement.addElement(answer);
    }
}

Source File: PropertyHolder.java From mapper-generator-javafx with Apache License 2.0

5 votes

protected void addPropertyXmlElements(XmlElement xmlElement) {
    Enumeration<?> enumeration = properties.propertyNames();
    while (enumeration.hasMoreElements()) {
        String propertyName = (String) enumeration.nextElement();

        XmlElement propertyElement = new XmlElement("property");
        propertyElement.addAttribute(new Attribute("name", propertyName));
        propertyElement.addAttribute(new Attribute(
                "value", properties.getProperty(propertyName)));
        xmlElement.addElement(propertyElement);
    }
}

Source File: ExampleWhereClauseElementGenerator.java From mapper-generator-javafx with Apache License 2.0

4 votes

@Override
public void addElements(XmlElement parentElement) {
    XmlElement answer = new XmlElement("sql");

    if (isForUpdateByExample) {
        answer
                .addAttribute(new Attribute(
                        "id", introspectedTable.getMyBatis3UpdateByExampleWhereClauseId()));
    } else {
        answer.addAttribute(new Attribute(
                "id", introspectedTable.getExampleWhereClauseId()));
    }

    context.getCommentGenerator().addComment(answer);

    XmlElement whereElement = new XmlElement("where");
    answer.addElement(whereElement);

    XmlElement outerForEachElement = new XmlElement("foreach");
    if (isForUpdateByExample) {
        outerForEachElement.addAttribute(new Attribute(
                "collection", "example.oredCriteria")); //$NON-NLS-2$
    } else {
        outerForEachElement.addAttribute(new Attribute(
                "collection", "oredCriteria")); //$NON-NLS-2$
    }
    outerForEachElement.addAttribute(new Attribute("item", "criteria")); //$NON-NLS-2$
    outerForEachElement.addAttribute(new Attribute("separator", "or")); //$NON-NLS-2$
    whereElement.addElement(outerForEachElement);

    XmlElement ifElement = new XmlElement("if");
    ifElement.addAttribute(new Attribute("test", "criteria.valid")); //$NON-NLS-2$
    outerForEachElement.addElement(ifElement);

    XmlElement trimElement = new XmlElement("trim");
    trimElement.addAttribute(new Attribute("prefix", "(")); //$NON-NLS-2$
    trimElement.addAttribute(new Attribute("suffix", ")")); //$NON-NLS-2$
    trimElement.addAttribute(new Attribute("prefixOverrides", "and")); //$NON-NLS-2$

    ifElement.addElement(trimElement);

    trimElement.addElement(getMiddleForEachElement(null));

    for (IntrospectedColumn introspectedColumn : introspectedTable
            .getNonBLOBColumns()) {
        if (stringHasValue(introspectedColumn
                .getTypeHandler())) {
            trimElement
                    .addElement(getMiddleForEachElement(introspectedColumn));
        }
    }

    if (context.getPlugins()
            .sqlMapExampleWhereClauseElementGenerated(answer,
                    introspectedTable)) {
        parentElement.addElement(answer);
    }
}

Source File: ResultMapWithBLOBsElementGenerator.java From mybatis-generator-core-fix with Apache License 2.0

4 votes

@Override
public void addElements(XmlElement parentElement) {
    boolean useColumnIndex = isTrue(introspectedTable
                    .getTableConfigurationProperty(PropertyRegistry.TABLE_USE_COLUMN_INDEXES));

    XmlElement answer = new XmlElement("resultMap"); //$NON-NLS-1$

    answer.addAttribute(new Attribute("id", //$NON-NLS-1$
            introspectedTable.getResultMapWithBLOBsId()));

    String returnType;
    if (introspectedTable.getRules().generateRecordWithBLOBsClass()) {
        returnType = introspectedTable.getRecordWithBLOBsType();
    } else {
        // table has BLOBs, but no BLOB class - BLOB fields must be
        // in the base class
        returnType = introspectedTable.getBaseRecordType();
    }

    answer.addAttribute(new Attribute("class", //$NON-NLS-1$
            returnType));

    StringBuilder sb = new StringBuilder();
    sb.append(introspectedTable.getIbatis2SqlMapNamespace());
    sb.append('.');
    sb.append(introspectedTable.getBaseResultMapId());
    answer.addAttribute(new Attribute("extends", sb.toString())); //$NON-NLS-1$

    context.getCommentGenerator().addComment(answer);

    int i = introspectedTable.getNonBLOBColumnCount() + 1;
    if (stringHasValue(introspectedTable
            .getSelectByPrimaryKeyQueryId())
            || stringHasValue(introspectedTable
                    .getSelectByExampleQueryId())) {
        i++;
    }

    for (IntrospectedColumn introspectedColumn : introspectedTable
            .getBLOBColumns()) {
        XmlElement resultElement = new XmlElement("result"); //$NON-NLS-1$

        if (useColumnIndex) {
            resultElement.addAttribute(new Attribute(
                    "columnIndex", Integer.toString(i++))); //$NON-NLS-1$
        } else {
            resultElement
                    .addAttribute(new Attribute(
                            "column", Ibatis2FormattingUtilities.getRenamedColumnNameForResultMap(introspectedColumn))); //$NON-NLS-1$
        }
        resultElement.addAttribute(new Attribute(
                "property", introspectedColumn.getJavaProperty())); //$NON-NLS-1$
        resultElement.addAttribute(new Attribute(
                "jdbcType", introspectedColumn.getJdbcTypeName())); //$NON-NLS-1$

        if (stringHasValue(introspectedColumn
                .getTypeHandler())) {
            resultElement.addAttribute(new Attribute(
                    "typeHandler", introspectedColumn.getTypeHandler())); //$NON-NLS-1$
        }

        answer.addElement(resultElement);
    }

    if (context.getPlugins()
            .sqlMapResultMapWithBLOBsElementGenerated(answer,
                    introspectedTable)) {
        parentElement.addElement(answer);
    }
}

Source File: DeleteByPrimaryKeyElementGenerator.java From mybatis-generator-plus with Apache License 2.0

4 votes

@Override
public void addElements(XmlElement parentElement) {
    XmlElement answer = new XmlElement("delete"); //$NON-NLS-1$

    answer.addAttribute(new Attribute(
            "id", introspectedTable.getDeleteByPrimaryKeyStatementId())); //$NON-NLS-1$
    String parameterClass;
    if (introspectedTable.getRules().generatePrimaryKeyClass()) {
        parameterClass = introspectedTable.getPrimaryKeyType();
    } else {
        parameterClass = introspectedTable.getBaseRecordType();
    }
    answer.addAttribute(new Attribute("parameterClass", //$NON-NLS-1$
            parameterClass));

    context.getCommentGenerator().addComment(answer);

    StringBuilder sb = new StringBuilder();
    sb.append("delete from "); //$NON-NLS-1$
    sb.append(introspectedTable.getFullyQualifiedTableNameAtRuntime());
    answer.addElement(new TextElement(sb.toString()));

    boolean and = false;
    for (IntrospectedColumn introspectedColumn : introspectedTable
            .getPrimaryKeyColumns()) {
        sb.setLength(0);
        if (and) {
            sb.append("  and "); //$NON-NLS-1$
        } else {
            sb.append("where "); //$NON-NLS-1$
            and = true;
        }

        sb.append(Ibatis2FormattingUtilities
                .getEscapedColumnName(introspectedColumn));
        sb.append(" = "); //$NON-NLS-1$
        sb.append(Ibatis2FormattingUtilities
                .getParameterClause(introspectedColumn));
        answer.addElement(new TextElement(sb.toString()));
    }

    if (context.getPlugins()
            .sqlMapDeleteByPrimaryKeyElementGenerated(answer,
                    introspectedTable)) {
        parentElement.addElement(answer);
    }
}

Source File: SelectByPrimaryKeyElementGenerator.java From mybatis-generator-core-fix with Apache License 2.0

4 votes

@Override
public void addElements(XmlElement parentElement) {
    XmlElement answer = new XmlElement("select"); //$NON-NLS-1$

    answer.addAttribute(new Attribute(
            "id", introspectedTable.getSelectByPrimaryKeyStatementId())); //$NON-NLS-1$
    if (introspectedTable.getRules().generateResultMapWithBLOBs()) {
        answer.addAttribute(new Attribute("resultMap", //$NON-NLS-1$
                introspectedTable.getResultMapWithBLOBsId()));
    } else {
        answer.addAttribute(new Attribute("resultMap", //$NON-NLS-1$
                introspectedTable.getBaseResultMapId()));
    }

    String parameterType;
    if (introspectedTable.getRules().generatePrimaryKeyClass()) {
        parameterType = introspectedTable.getPrimaryKeyType();
    } else {
        // select by primary key, but no primary key class. Fields
        // must be in the base record
        parameterType = introspectedTable.getBaseRecordType();
    }

    answer.addAttribute(new Attribute("parameterClass", //$NON-NLS-1$
            parameterType));

    context.getCommentGenerator().addComment(answer);

    StringBuilder sb = new StringBuilder();
    sb.append("select "); //$NON-NLS-1$

    if (stringHasValue(introspectedTable
            .getSelectByPrimaryKeyQueryId())) {
        sb.append('\'');
        sb.append(introspectedTable.getSelectByPrimaryKeyQueryId());
        sb.append("' as QUERYID,"); //$NON-NLS-1$
    }
    answer.addElement(new TextElement(sb.toString()));
    answer.addElement(getBaseColumnListElement());
    if (introspectedTable.hasBLOBColumns()) {
        answer.addElement(new TextElement(",")); //$NON-NLS-1$
        answer.addElement(getBlobColumnListElement());
    }

    sb.setLength(0);
    sb.append("from "); //$NON-NLS-1$
    sb.append(introspectedTable
            .getAliasedFullyQualifiedTableNameAtRuntime());
    answer.addElement(new TextElement(sb.toString()));

    boolean and = false;
    for (IntrospectedColumn introspectedColumn : introspectedTable
            .getPrimaryKeyColumns()) {
        sb.setLength(0);
        if (and) {
            sb.append("  and "); //$NON-NLS-1$
        } else {
            sb.append("where "); //$NON-NLS-1$
            and = true;
        }

        sb.append(Ibatis2FormattingUtilities
                .getAliasedEscapedColumnName(introspectedColumn));
        sb.append(" = "); //$NON-NLS-1$
        sb.append(Ibatis2FormattingUtilities
                .getParameterClause(introspectedColumn));
        answer.addElement(new TextElement(sb.toString()));
    }

    if (context.getPlugins()
            .sqlMapSelectByPrimaryKeyElementGenerated(answer,
                    introspectedTable)) {
        parentElement.addElement(answer);
    }
}

Java Code Examples for org.mybatis.generator.api.dom.xml.XmlElement#addElement()