mybatis動的SQL実装ロジックコード詳細

<?xml version = "1.0" ? >
<!DOCTYPE script SYSTEM "script-1.0.dtd">
<script namespace="user">
    <common id="commonOrder">
        order by id desc
    </common>
    <sql id="queryUser">
        select * from user
        <where>
            <if test='id ! = null '>
                id = #{id}
            </if>
            <if test="names ! = null and names.size() >0">
                and name in
                <foreach collection="names" item="item" separator="," open="(" close=")">
                    ${item}
                </foreach>
            </if>
        </where>
        <ref id="commonOrder"/>
    </sql>

    <sql id="updateUser">
        update user set name = ${name}
        <where>
            <if test='id ! = null '>
                id = #{id}
            </if>
        </where>
    </sql>

 
</script>

<!ELEMENT script (#PCDATA | sql | common)*>
<!ATTLIST script
namespace CDATA #REQUIRED
>
<!ELEMENT sql (#PCDATA | trim | where | set | foreach | choose | if | ref)*>
<!ATTLIST sql
id CDATA #REQUIRED
>
<!ELEMENT common (#PCDATA | trim | where | set | foreach | choose | if)*>
<!ATTLIST common
id CDATA #REQUIRED
>
<!ELEMENT ref (#PCDATA)*>
<!ATTLIST ref
id CDATA #REQUIRED
>
<!ELEMENT trim (#PCDATA | trim | where | set | foreach | choose | if)*>
<!ATTLIST trim
prefixCDATA #IMPLIED
prefixOverrides CDATA #IMPLIED
suffix CDATA #IMPLIED
suffixOverrides CDATA #IMPLIED
>
<!ELEMENT where (#PCDATA | trim | where | set | foreach | choose | if | ref)*>
<!ELEMENT set (#PCDATA | trim | where | set | foreach | choose | if)*>

<!ELEMENT foreach (#PCDATA | trim | where | set | foreach | choose | if)*>
<!ATTLIST foreach
collection CDATA #REQUIRED
item CDATA #IMPLIED
index CDATA #IMPLIED
open CDATA #IMPLIED
close CDATA #IMPLIED
separator CDATA #IMPLIED
>

<!ELEMENT choose (when* , otherwise?)>
<!ELEMENT when (#PCDATA | trim | where | set | foreach | choose | if)*>
<!ATTLIST when
test CDATA #REQUIRED
>
<!ELEMENT otherwise (#PCDATA | trim | where | set | foreach | choose | if)*>

<!ELEMENT if (#PCDATA | trim | where | set | foreach | choose | if)*>
<!ATTLIST if
test CDATA #REQUIRED
>

private Document buildXml(InputStream scriptFile)
				throws ParserConfigurationException, SAXException, IOException {
			DocumentBuilderFactory factory = DocumentBuilderFactory
					.newInstance();
			// By default, the parser does not validate documents. Set this parameter to true to turn on validation.
			factory.setValidating(true);
			//whether to set namespace
			factory.setNamespaceAware(false);
			// Determine if comments in the file should be ignored. The default value is false.
			factory.setIgnoringComments(true);
			// Determines whether to ignore whitespace in element content (similar to the way browsers treat HTML). The default value is false.
			factory.setIgnoringElementContentWhitespace(false);
			// Determines whether the parser should convert CDATA nodes to text, and whether it should merge them with surrounding text nodes (if applicable). The default value is false.
			factory.setCoalescing(false);
			// Determine if external entity references should be expanded. If true, external data will be inserted into the document. Its default value is true
			factory.setExpandEntityReferences(true);

			DocumentBuilder builder = factory.newDocumentBuilder();
			// set the validation rules file dtd file
			builder.setEntityResolver(new EntityResolver() {
				@Override
				public InputSource resolveEntity(String publicId,
						String systemId) throws SAXException, IOException {
					return new InputSource(new ClassPathResource("script-1.0.dtd").getInputStream());
				}
			});
			// Set the error parser
			builder.setErrorHandler(new ErrorHandler() {
				@Override
				public void error(SAXParseException exception)
						throws SAXException {
					throw exception;
				}

				@Override
				public void fatalError(SAXParseException exception)
						throws SAXException {
					throw exception;
				}

				@Override
				public void warning(SAXParseException exception)
						throws SAXException {
				}
			});
			return builder.parse(scriptFile);
		}