package mydbms;
import org.w3c.dom.*; 
import javax.xml.parsers.*; 
import javax.xml.transform.*; 
import javax.xml.transform.dom.DOMSource; 
import javax.xml.transform.stream.StreamResult; 
import java.io.*; 
import java.util.*;
import javax.swing.tree.*;
import javax.swing.tree.DefaultMutableTreeNode;
/*
 * ParseXml.java
 *
 * Created on 2006年5月12日, 下午9:25
 *
 * To change this template, choose Tools | Template Manager
 * and open the template in the editor.
 */
public class ParseXml { 
    Document document;
    Element root;
    TransformerFactory tf;
    Transformer transformer;
    DOMSource source;
    PrintWriter pw;
    StreamResult result;
    String filepath;
    public ParseXml(String filepath)
    {
        DocumentBuilderFactory dbf = DocumentBuilderFactory.newInstance();
        this.filepath=filepath;
        try
        {
            DocumentBuilder db = dbf.newDocumentBuilder();
            document = db.parse(filepath);
            root =(Element)document.getFirstChild(); 
        }
        catch(Exception e){
        }
    }
    public void toSave(){
        try{ 
                tf=TransformerFactory.newInstance(); 
		transformer=tf.newTransformer(); 
		source=new DOMSource(document); 
		transformer.setOutputProperty(OutputKeys.ENCODING,"GB2312"); 
		transformer.setOutputProperty(OutputKeys.INDENT,"yes"); 
		pw=new PrintWriter(new FileOutputStream(filepath)); 
		result=new StreamResult(pw); 
		transformer.transform(source,result); 
            } 
            catch(TransformerException mye){ 
		mye.printStackTrace(); 
            } 
            catch(IOException exp){ 
		exp.printStackTrace(); 
            } 
    }
    //創建數據庫中的表
    public void insertTable(String tbname)
    {
        Element dn = document.createElement("table"); 
        dn.setAttribute("name",tbname);
	root.appendChild(dn); 
    } 
    
    //將新創建的數據庫寫入xml文件
    public void insertDbArray(String dbname)
    {
        Element dn = document.createElement("dbname"); 
	dn.appendChild(document.createTextNode(String.valueOf(dbname))); 
	root.appendChild(dn); 
    } 
   //刪除數據庫中的結點
    public void delDbTable(String tbname)
        {
            NodeList codes = document.getElementsByTagName("dbname"); 
            Node child=null;
            Node parent = null;
            int num=0;
            while(codes.item(num)!=null)
            {
                child = codes.item(num);
		if(child.getTextContent().equals(tbname))
                {
			parent = child.getParentNode();                        
			parent.removeChild(child);
		}                
                num++;
            }
        } 
    //修改數據庫名稱
    public void modDbTable(String newname,String oldname)
        {
            NodeList codes = document.getElementsByTagName("dbname");
            Node child=null;
            Node parent = null;
            int num=0;
            while(codes.item(num)!=null)
            {
                child = codes.item(num);
		if(child.getTextContent().equals(oldname))
                {
			child.setTextContent(newname);
                        int i=MainFrame.root.getIndex(MainFrame.sn);
                        MainFrame.treeModel.removeNodeFromParent(MainFrame.sn);                       
                        MainFrame.sn=new DefaultMutableTreeNode(newname);
                        MainFrame.treeModel.insertNodeInto(MainFrame.sn,MainFrame.root,i);
                        System.out.print(oldname+"+"+i);
		}                
                num++;
            }
        } 
    //獲取xml中所有數據庫的名稱
    public ArrayList getDbArray()
    {
        ArrayList dbname = new ArrayList();
        try{
        NodeList nodes = document.getElementsByTagName("dbname");
        if(nodes!=null){
           for(int i=0;i<nodes.getLength();i=i+1)
           {                    
                    dbname.add(nodes.item(i).getFirstChild().getNodeValue());                      
            }
        }
        }
        catch(Exception e){}
         return dbname;
    }
    //從數據庫中找到需要的數據
    public ArrayList getElement(String name,String tablename)
    {
        ArrayList dbname = new ArrayList();
       try{
       NodeList nodes = document.getElementsByTagName(name);
       if(nodes!=null){
           for(int i=0;i<nodes.getLength();i=i+1)
           {                    
                    Element e=(Element)nodes.item(i);
                    Element dd=(Element)e.getParentNode().getParentNode();
                   // System.out.print(dd.getAttribute("name"));
                    if(dd.getAttribute("name").equals(tablename))
                    {
                        dbname.add(nodes.item(i).getFirstChild().getNodeValue());                      
                    }
            }
        }
        }
        catch(Exception e){}
         return dbname;
    }
    //下列是關于數據庫中表的操作
    public void addTable(String dbname,String tbname)
    {
        //先找到數據庫文件
        DocumentBuilderFactory dbf1 = DocumentBuilderFactory.newInstance();
        try
        {            
            DocumentBuilder db1 = dbf1.newDocumentBuilder();
            Document dmt=db1.parse("f://DataBase/"+dbname+".xml");
            //在該數據庫文件中創建一個表格
            Element dn1 = dmt.createElement("dbname"); 
            dn1.appendChild(dmt.createTextNode(String.valueOf(dbname))); 
            Element rt=(Element)dmt.getFirstChild();           
            rt.appendChild(dn1);
        }catch(Exception e)
        {
                System.out.print("aaa");
        }
        
    }
}