MARS'S SPACE

这两天开始学习jsp，下面贴一段jsp连接mysql生成xml的代码，希望能对一些人有帮助。代码如下:

<%@ page contentType="text/html; charset=GBK" language="java" import="java.io.FileOutputStream,java.sql.Connection,java.sql.DriverManager,java.sql.ResultSet,java.sql.SQLException,java.sql.Statement,org.dom4j.Document,org.dom4j.DocumentHelper,org.dom4j.Element,org.dom4j.io.XMLWriter,org.dom4j.io.OutputFormat"%>

<%
ResultSet rs = null; //执行查询
Statement stmt = null;
Connection conn = null; //连接数据库
//创建一个Xml文件
Element root = null;
Document doc = null;
try {
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
String url = "jdbc:mysql://localhost/数据库名?useUnicode=true&characterEncoding=GBK";
//载入jdbc odbc的驱动程序
String user = "root";
String password = "";
conn = DriverManager.getConnection(url, user, password);
stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_UPDATABLE);
//创建一个statement
String sql = "select * from 数据库表名"; //定义查询的SQL语句
rs = stmt.executeQuery(sql);
doc = DocumentHelper.createDocument();
root = doc.addElement("root");
root.addAttribute("type", "book");
while (rs.next()) { //将查询结果取出
String userName= rs.getString("userName");//数据库表字段
String userID= rs.getString("userID");
root.addElement("标题").setText(userName);
root.addElement("作者").setText(userID);

}
String path = config.getServletContext().getRealPath("");
            //out.println(path);
XMLWriter xmlWriter = new XMLWriter(new FileOutputStream(path+"/my.xml"));
xmlWriter.write(doc);
xmlWriter.close();
            
response.sendRedirect("my.xml");
            //out.println(text);
            //OutputFormat format = OutputFormat.createPrettyPrint();
            //format.setEncoding("GBK");
//XMLWriter writer = new XMLWriter(out,format);
//writer.write(doc);
//writer.close();
} catch (SQLException e) {
e.printStackTrace();

} catch (Exception e) {
e.printStackTrace();
} finally {
try {
rs.close(); //关闭结果集
stmt.close(); //关闭statement
conn.close();
} catch (SQLException e1) {
e1.printStackTrace();
}
}
%>