1,readXML
package com.bn.util;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Iterator;
import java.util.Properties;
import org.dom4j.Document;
import org.dom4j.DocumentException;
import org.dom4j.Element;
import org.dom4j.io.SAXReader;
public class DB {
private static String dbServer;
private static String dbName;
private static String dbUser;
private static String dbPwd;
//java项目www.fhadmin.org
public void readXML(){
SAXReader sr = new SAXReader();//获取读取xml的对象。
Document doc = null;
String path1 = String.valueOf(Thread.currentThread().getContextClassLoader().getResource(""));
//System.out.println(path1);
path1 = path1 + "../DB.xml";
//System.out.println(path1);
try {
doc = sr.read(path1);
} catch (DocumentException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}//得到xml所在位置。然后开始读取。并将数据放入doc中
Element el_root = doc.getRootElement();//向外取数据,获取xml的根节点。
Iterator it = el_root.elementIterator();//从根节点下依次遍历,获取根节点下所有子节点
while(it.hasNext()){//遍历该子节点
Object o = it.next();//再获取该子节点下的子节点
Element el_row = (Element)o;
String s = el_row.getText();
Iterator it_row = el_row.elementIterator();
int i =1;
while(it_row.hasNext()){//遍历节点
Element el_ename = (Element)it