有二张表,当用户查询项目名时把下面二张表的数据封装XML格式,请问结构
create table Project//统计项目表
(
Id int(20) NOT NULL auto_increment,
ProjectName varchar(20), //项目名PRIMARY KEY (id)
)
ENGINE=InnoDB DEFAULT CHARSET=utf8;
create table ProjectItems//统计内容表
(
Id int(20) NOT NULL auto_increment,
ProjectID int(20), //统计项目id
ItemName varchar(20), //统计项名称
foreign key(ProjectID) references Project(id),
PRIMARY KEY (id)
create table Project//统计项目表
(
Id int(20) NOT NULL auto_increment,
ProjectName varchar(20), //项目名PRIMARY KEY (id)
)
ENGINE=InnoDB DEFAULT CHARSET=utf8;
create table ProjectItems//统计内容表
(
Id int(20) NOT NULL auto_increment,
ProjectID int(20), //统计项目id
ItemName varchar(20), //统计项名称
foreign key(ProjectID) references Project(id),
PRIMARY KEY (id)
<project id="1" projectName="name1">
<projectItem id="001" itemName="itemName1" />
<projectItem id="002" itemName="itemName2" />
<projectItem id="003" itemName="itemName3" />
</project>
<project id="2" projectName="name2">
<!-- xxxxxxx -->
</project>
</root>
你想要什么样的结构就生成什么样的