JSP从数据库中导出数据并输出生成XML文件

JSP从数据库教程中导出数据并输出生成XML文件
/*
数据库结构

create table userTable01(
    user_id int(4) NOT NULL primary key auto_increment,
    user_name varchar(40),
    user_password varchar(40),
    user_true_name varchar(40),
    user_age int, user_易做图 varchar(2),
    user_address varchar(80),
    user_telphone varchar(20),
    add_time datetime
);
insert into usertable01 (
        user_name,
        user_password,
        user_true_name,
        user_age,
        user_易做图,
        user_address,
        user_telphone,
        add_time)
       values ('wgy','123123','gavin.wang','23','M','sdfg','321321',now());

//xml文档结构

<?xml version="1.0" encoding="gb2312" ?>
- <users>
- <user>
<id>1</id>
<name>wgy</name>
<password>123123</password>
<true_name>www.zzzyk.com</true_name>
<age>23</age>
<易做图>M</易做图>
<address>sdfg</address>
<telphone>321321</telphone>
<add_time>2010-01-06</add_time>
</user>
</users>

<%@ page contentType = "text/xml;charset =gb2312" %>
<%@ page import = "java.sql.*" %>
<?xml version = "1.0" encoding = "gb2312" ?>
<users>
<%
    Connection con = null;
    Statement sql = null;
    ResultSet rs = null;

    try
    {
        String url = "jdbc:mysql教程://localhost:3306/test"; ;
        String username = "root";
        String password = "password";
        Class.forName("com.mysql.jdbc.Driver");
        con = DriverManager.getConnection(url, username, password );
        sql = con.createStatement();
        rs = sql.executeQuery("select * from userTable01");
        while(rs.next())
        {
%>
     <user>
         <id><%=rs.getLong("user_id") %></id>
         <name><%=rs.getString("user_name") %></name>
         <password><%=rs.getString("user_password") %></password>
         <true_name><%=rs.getString("user_true_name") %></true_name>
         <age><%=rs.getInt("user_age") %></age>
         <易做图><%=rs.getString("user_易做图") %></易做图>
         <address><%=rs.getString("user_address") %></address>
         <telphone><%=rs.getString("user_telphone") %></telphone>
         <add_time><%=rs.getDate("add_time") %></add_time>
     </user>
<%         }
    }catch(Exception e)
    {
        out.print("程序出现异常"+" "+e);
        //out.print(e);
    }
%>
</users>

补充：Jsp教程,Java与XML