今天的项目模块中用到根据数据库里的资料生成xml文件,主要步骤如下:
(1) 连接数据库,取出数据;
(2) 创建结点,添加子项;
(3) 写入文件“test.xml”中;
具体代码如下:
import java.io.FileOutputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import org.jdom.Document;
import org.jdom.Element;
import org.jdom.output.XMLOutputter;
public class CreateXml {
/**
* @param args
* @throws ClassNotFoundException
* @throws SQLException
*/
public static void main(String[] args) throws ClassNotFoundException,SQLException {
Class.forName("com.mysql.jdbc.Driver");
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/lalayi?user=root&password=root");
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("select * from store");
try {
Element root = new Element("店面类");
Document Doc = new Document(root);
int i = 0;
while (rs.next()) {
Element elements = new Element("店面");
elements.addAttribute("id","" + i);
elements.addContent(new Element("店面ID").setText(rs.getString(1)));
elements.addContent(new Element("名称").setText(rs.getString(2)));
elements.addContent(new Element("密码").setText(rs.getString(3)));
elements.addContent(new Element("邮箱").setText(rs.getString(4)));
elements.addContent(new Element("日期").setText(rs.getString(5)));
elements.addContent(new Element("手机").setText(rs.getString(6)));
elements.addContent(new Element("手机2").setText(rs.getString(7)));
elements.addContent(new Element("手机3").setText(rs.getString(8)));
elements.addContent(new Element("即时通讯工具").setText(rs.getString(9)));
elements.addContent(new Element("描述").setText(rs.getString(10)));
root.addContent(elements);
i++;
}
XMLOutputter XMLOut = new XMLOutputter();
XMLOut.output(Doc, new FileOutputStream("D:/test.xml"));
} catch (Exception e) {
e.printStackTrace();
}
}
}