使用mybatis将数据库表导入xml文件中
public static void main(String[] args) throws Exception {
String resource="config.xml";
//读取配置文件
InputStream inputStream=Resources.getResourceAsStream(resource);
//需要SqlSessionFactoryBuilder
SqlSessionFactoryBuilder builder=new SqlSessionFactoryBuilder();
//创建SqlSessionFactory
SqlSessionFactory build = builder.build(inputStream);
//生产一个SqlSession
SqlSession openSession = build.openSession();
UserXML mapper = openSession.getMapper(UserXML.class);
List<Country> selectALLUser = mapper.selectALLUser();
Document doc = DocumentHelper.createDocument();
//增加根节点
Element country = doc.addElement("country");
//增加子元素
for (Country country1 : selectALLUser) {
Element id = country.addElement("id").addText(String.valueOf(country1.getId()));
Element countryname = id.addElement("countryname").addText(country1.getC_countryname());
Element capital = countryname.addElement("capital").addText(country1.getC_capital());
}
FileWriter out = new FileWriter("foo.xml");
doc.write(out);
out.close();
}
不知道怎么把导出的xml中的数据都改为utf-8类的,导致老是会出乱码