如何用jsp把数据库内容生成xml文件?
表 select_ employees
EMP_ID 名称 JOB_TITLE HIRE_DATE 存储
10 Allan Baker Manager 2000-01-01 1
11 Carol Dan Manager 2000-01-01 2
20 Eric Frank Sales 2000-01-02 1
21 Garry Hans Asst 2000-02-01 1
22 Ivan James Sales 2000-02-01 2
12 Karen Law Manager 2000-06-05 3
23 Mike Nis Sales 2000-06-06 3
把我得mysql数据库select_ employees表通过jsp生成
如下select_employees.xml文件
<?xml version="1.0" encoding="UTF-8"?>
<SQLResult>
...
<EMPLOYEES>
<EMP_ID>21</EMP_ID>
<NAME>Garry Hans</NAME>
<JOB_TITLE>Asst Sales
Rep</JOB_TITLE>
<HIRE_DATE>2000-02-01</HIRE_DATE>
<STORE>1</STORE>
</EMPLOYEES>
<EMPLOYEES>
<EMP_ID>22</EMP_ID>
<NAME>Ivan James</NAME>
<JOB_TITLE>Sales Rep</JOB_TITLE>
<HIRE_DATE>2000-02-01</HIRE_DATE>
<STORE>2</STORE>
</EMPLOYEES>
...
</SQLResult>
请给出代码或相关实例,小弟初学,在线急等,谢谢