参考文章 http://www.blogjava.net/chenlb/archive/2007/09/06/143040.html
生成的xml老是乱码
//树框xml
public void createxml() throws IOException, SQLException{
TestDao test=new TestDao();
List list=new ArrayList();
List list1=new ArrayList();
XMLWriter Wxml=null;
OutputFormat format = OutputFormat.createPrettyPrint();
//format.setEncoding("UTF-8");
File file=new File("./flex_src/xml/tree.xml");
FileOutputStream fos = new FileOutputStream(file);
Document _document=DocumentHelper.createDocument();
//Wxml=new XMLWriter(new FileWriter(file),format);
Wxml = new XMLWriter(fos, format);
Element root=_document.addElement("西藏");
String sqlarea="select distinct(area) from t_site"; //从站点表获得所有地区名
ResultSet rs=test.selectSql(sqlarea);
while(rs.next()){ //将地区名赋值给数组
String name =rs.getString("area");
list.add(name);
}
rs.close(); //地区结果集释放
for(int i=0;i<list.size();i++){ //通过地区名获得其站点名及其站点id
String area=list.get(i).toString();
// System.out.println(area);
Element _area=root.addElement(area);
String sqlsite="select siteId,siteName from t_site where area='"+area+"' ";
rs=test.selectSql(sqlsite);
while(rs.next()){ //将此地区的所有站点名及站点id赋值给数组
int id=rs.getInt("siteId");
String name=rs.getString("siteName");
list1.add(id);
list1.add(name);
}
rs.close(); //站点结果集释放
for(int j=0;j<list1.size();j+=2){ //通过站点id从设备表获得此站点的所有设备
Object id1 = list1.get(j); //int值获取得怪异方式
String site=list1.get(j+1).toString();
Element _site=_area.addElement(site);
String sqldevice="select deviceName from t_device where siteId='"+id1+"'";
rs=test.selectSql(sqldevice);
while(rs.next()){
String name=rs.getString("deviceName");
Element _device=_site.addElement(name);
}
}
}
rs.close();
Wxml.write(_document);
Wxml.close();
System.out.println("创建完毕");
}
红色为修改内容。可以正常显示了 。