package com.example.xml.dom4h;

 import java.io.File;

 import java.sql.Connection;

 import java.sql.DriverManager;

 import java.sql.Statement;

 import java.util.Iterator;

 import java.util.List;

 import javax.xml.parsers.DocumentBuilder;

 import javax.xml.parsers.DocumentBuilderFactory;

 import org.dom4j.Document;

 import org.dom4j.Element;

 import org.dom4j.io.DOMReader;

 import org.dom4j.io.SAXReader;

 /**

 * dom4j框架学习： 读取并解析xml

 *

 *

 */

 public class Dom4j_parse {

 public static void main(String[] args) throws Exception {

 SAXReader saxReader = new SAXReader();

 Document document = saxReader.read(new File("snapshot-Automatic-2016-02-09-15-53-00-1.xml"));

 String bsrName = "";

 String bsrId = "";

 String region = "";

 String city = "";

 String address ="";

 String classification = "";

 // 获取根元素

 Element root = document.getRootElement();

 System.out.println("Root: " + root.getName());

 // 获取所有子元素

 List<Element> childList = root.elements();

 System.out.println("total child count: " + childList.size());

 // 获取特定名称的子元素

 Element femtoCluster = root.element("FemtoCluster");

 List<Element> childList2 = femtoCluster.elements("Femto");

 System.out.println("locationname child: " + childList2.size());

 //对每一个femto的locationName解析

 for(int i=0; i < childList2.size(); i++){

 Element femtoElement = childList2.get(i);

 String femtoId= femtoElement.attributeValue("id");

 Element attributeElement = femtoElement.element("attributes");

 //step1 对bsc的名称和id先处理

 Element bsrNameElement = attributeElement.element("bSRName");

 Element bsridElement = attributeElement.element("bsrId");

 bsrName = bsrNameElement.getTextTrim();

 bsrId = bsridElement.getTextTrim();

 System.out.println( " bstname :"+bsrNameElement.getTextTrim()+ " ,bsrid :"+bsridElement.getTextTrim());

 //step2 对locatin的处理

 //用下划线把值分割成三部分，第一部分是region，第二部分是address,第三部分是city

 Element locationElement =    attributeElement.element("locationName");

 String allString = locationElement.getTextTrim();

 //如果有值，安装上面的三部分解析，如果没值，给region，city为空。

 if(!allString.isEmpty() && allString !=null && allString !="" ){

 //allString有值的时候

 String[] allStringArray = allString.split("_");

 region = allStringArray[0];

 city = allStringArray[2];

 address = allStringArray[1];

 if(city.isEmpty() ){

 classification = "RR";

 }else{

 classification = "U_SB";

 }

 System.out.println( " region :"+ region + " , city :"+city +" , address:"+ address);

 }else{

 //allString没有值得时候

 region = "";

 city = "";

 address = "";

 classification = "RR";

 System.out.println( " region :"+ region + " , city :"+city +" , address:"+ address);

 }//end if

 //对这些数据插入到数据库中

 /*

 * update pm4h_db.mo_moentity t set (region,city,address,classification) = (region,city,address,classification)

 * where t.moentityid = bsrId

 *

 * */

 }// end one element

 // 获取名字为指定名称的第一个子元素

 //    Element firstWorldElement = root.element("world");

 //    // 输出其属性

 //    System.out.println("first World Attr: "

 //    + firstWorldElement.attribute(0).getName() + "="

 //    + firstWorldElement.attributeValue("name"));

 //

 //    System.out.println("迭代输出-----------------------");

 //    // 迭代输出

 //    for (Iterator iter = root.elementIterator(); iter.hasNext();) {

 //    Element e = (Element) iter.next();

 //    System.out.println(e.attributeValue("name"));

 //

 //    }

 // System.out.println("用DOMReader-----------------------");

 //    DocumentBuilderFactory dbf = DocumentBuilderFactory.newInstance();

 //    DocumentBuilder db = dbf.newDocumentBuilder();

 //    // 注意要用完整类名

 //    org.w3c.dom.Document document2 = db.parse(new File("students.xml "));

 //

 //    DOMReader domReader = new DOMReader();

 //

 //    // 将JAXP的Document转换为dom4j的Document

 //    Document document3 = domReader.read(document2);

 //

 //    Element rootElement = document3.getRootElement();

 //

 //    System.out.println("Root: " + rootElement.getName());

 //连接数据库，并执行更新sql的方法

 }

 public void updateFemtoData(String region1,String city1,String address1,String classification1,String bsrid1) {

 try{

 //0 拼sql语句

 //modify

 String sql= " update pm4h_db.mo_moentity t set t.region =" + region1

 +" ,city = "+ city1

 +" , classification= "+ classification1

 +" ,address = "+ address1

 + " where t.moentityid = " +bsrid1

 ;

 //1.加载驱动

 Class.forName("oracle.jdbc.driver.OracleDriver");

 //2 建立连接

 //modify ip and

 Connection ct = DriverManager.getConnection("jdbc:oracle:thin:@10.218.6.165:1521:mos5200","oracle","oracle");

 Statement st = ct.createStatement() ;

 int rs = st.executeUpdate(sql);

 }catch(Exception e){

 e.printStackTrace();

 }finally{

 if(true){

 //    st.close();

 //    ct.close();

 }

 }