The invention discloses a
database table and
XML message mapping
processing method and
system. The method comprises the steps that a
field mapping table of
database fields and
XML message node fields is preset; a
target database is acquired; the preset number of target data tables are extracted from the
target database; whether a master-sub table relation exists among the target data tables or not is judged; if yes, at least one group of master-sub table relations are determined;
XML message templates of which the group number corresponds to that of the master-sub table relations are generated according to the
field mapping table and the master-sub table relations, wherein the XML message templates contain hierarchical nested relations between the main tables and the sub tables; corresponding XML messages are generated according to the XML message templates and the corresponding target data tables. According to the
database table and XML message mapping
processing method and
system, mutual conversion between the data tables and the XML messages can be achieved, the input cost of project development, measurement and management is reduced, the message
parsing efficiency is improved, and management and maintenance are convenient.