xm32sql.dad

软件开发技术与方法

<?xml version="1.0"?>
<!DOCTYPE DAD PUBLIC "dadId" "dad.dtd">
<DAD>
  <dtdid>DB2test.dtd</dtdid>
  <validation>NO</validation>
  <Xcollection>
    <SQL_stmt>
       SELECT t.EXAMID, t.DESCRIPTION, t.COMMENTS, q.QUESTIONID,
          q.QUESTTEXT, q.COMMENT, q.ALLOWMULT, c.ID,
          c.CORRECT, c.CHOICETEXT 
        FROM 
          CHOICE c, QUESTION q, TEST t 
        WHERE 
          (q.QUESTIONID = c.QUESTIONID AND t.EXAMID = q.EXAMID)
        ORDER BY t.EXAMID, q.QUESTIONID, C.ID
    </SQL_stmt>
    <prolog>?xml version="1.0" encoding="utf-8"?</prolog>
    <doctype>!DOCTYPE employees SYSTEM "exam.dtd"</doctype>
    <root_node>
      <element_node name="test">
        <attribute_node name="id">
          <column name="EXAMID"/>
        </attribute_node>
        <element_node name="decription">
          <text_node>
            <column name="DESCRIPTION"/>
          </text_node>
        </element_node>
        <element_node name="comments">
          <text_node>
            <column name="COMMENTS"/>
          </text_node>
        </element_node>
        <element_node name="testQuestions">
          <element_node name="question">
            <attribute_node name="id">
              <column name="QUESTIONID"/>
            </attribute_node>
            <element_node name="questionText">
              <text_node>
                <column name="QUESTTEXT"/>
              </text_node>
            </element_node>
            <element_node name="comment">
              <text_node>
                <column name="COMMENT"/>
              </text_node>
            </element_node>
            <element_node name="choices">
              <attribute_node name="allowmultiples">
                <column name="ALLOWMULT"/>
              </attribute_node>
              <element_node name="choice">
                <attribute_node name="id">
                  <column name="ID"/>
                </attribute_node>
                <element_node name="choiceText">
                  <text_node>
                    <column name="CHOICETEXT"/>
                  </text_node>
                </element_node>
                <element_node name="correct">
                  <text_node>
                    <column name="CORRECT"/>
                  </text_node>
                </element_node>
              </element_node>
            </element_node>
          </element_node>
        </element_node>
      </element_node>
    </root_node>
  </Xcollection>
</DAD>