读XML并且写入到Oracal库中

读XML并且写入到Oracal库中

/**/ /*
 *创建日期：2006-8-4  17:57:21
 *创建作者：李长有
 */
package  lcy.jdom;

import  java.io.FileInputStream;
import  java.sql.Connection;
import  java.sql.DriverManager;
import  java.sql.Statement;
import  java.util.List;

import  org.jdom.Document;
import  org.jdom.Element;
import  org.jdom.input.SAXBuilder;
/** */ /**
 * 
 * 插入数据库之前，最好先删除记录，以免重复插入
 *
 */
public   class  XmlInfor  ... {
    // Xml的节点信息from_view_id，nacase_from_outcome，nacase_to_view_id
    private String from_view_id;

    private String nacase_from_outcome;

    private String nacase_to_view_id;

    public String getNacase_from_outcome() ...{
        return nacase_from_outcome;
    }

    public void setNacase_from_outcome(String nacase_from_outcome) ...{
        this.nacase_from_outcome = nacase_from_outcome;
    }

    public String getNacase_to_view_id() ...{
        return nacase_to_view_id;
    }

    public void setNacase_to_view_id(String nacase_to_view_id) ...{
        this.nacase_to_view_id = nacase_to_view_id;
    }

    public String getFrom_view_id() ...{
        return from_view_id;
    }

    public void setFrom_view_id(String from_view_id) ...{
        this.from_view_id = from_view_id;
    }

    // 循环读入读XML信息
    public void LoadXML(String path) throws Exception ...{

        // 准备插入Oracle数据库中
        String driver = "oracle.jdbc.driver.OracleDriver";
        Class.forName(driver);
        String url = "jdbc:oracle:thin:@172.16.10.200:1521:test2";// ????
        Connection con = DriverManager.getConnection(url, "system", "abc");// 2
        // 开始读制定路径的XML文件
        FileInputStream fi = null;
        try ...{

            fi = new FileInputStream(path);
            // 利用SAX方式读
            SAXBuilder sb = new SAXBuilder();
            Document doc = sb.build(fi);
            // 得到根元素
            Element root = doc.getRootElement();

            // 得到根元素所有子元素的集合
            List navigation_rules = root.getChildren();

            Element navigation_rule = null;
            Element navigation_case = null;
            XmlInfor xml = null;

            for (int i = 0; i < navigation_rules.size(); i++) ...{
                // 每循环读入一条记录，就插入到数据库中
                xml = new XmlInfor();

                navigation_rule = (Element) navigation_rules.get(i);
                xml.setFrom_view_id(navigation_rule.getChild("from-view-id")
                        .getText());

                List navigation_cases = navigation_rule
                        .getChildren("navigation-case");

                for (int j = 0; j < navigation_cases.size(); j++) ...{

                    navigation_case = (Element) navigation_cases.get(j);

                    xml.setNacase_from_outcome(navigation_case.getChild(
                            "from-outcome").getText());

                    xml.setNacase_to_view_id(navigation_case.getChild(
                            "to-view-id").getText());

                    String qry = "INSERT INTO LIUCHENG1(wjlx,bz,xm,tj)"
                            + " VALUES" + " ('" + "fangjia" + "'" + " , '"
                            + xml.getFrom_view_id().substring(1, 2) + "', "
                            + " '" + xml.getNacase_from_outcome() + "'" + ", "
                            + "'" + xml.getNacase_to_view_id().substring(1, 2)
                            + "')";

                    Statement stmt = con.createStatement();
                    stmt.executeUpdate(qry);

                    stmt.close();
                    System.out.println("一条信息插入数据库成功");
                }

            }
        } catch (Exception e) ...{
            System.err.println(e + "error");
        } finally ...{
            try ...{
                fi.close();
                con.close();
            } catch (Exception e) ...{
                e.printStackTrace();
            }
        }

    }

    public static void main(String[] ars) ...{

        try ...{
            String path = "D:/faces-config1.xml";
            XmlInfor xml = new XmlInfor();
            xml.LoadXML(path);

        } catch (Exception ea) ...{
            ea.printStackTrace();
        }
    }

}

 

需要提供jDom.jar包，Oracal的jdbc包