<rt id="bn8ez"></rt>
<label id="bn8ez"></label>

  • <span id="bn8ez"></span>

    <label id="bn8ez"><meter id="bn8ez"></meter></label>

    隨筆-7  評論-15  文章-0  trackbacks-0

    一、使用eclipse新建一個java project
    二、把saxon的jar包放入classpath(我用的jar包是saxon9ee.jar)
    三、新建package,然后新建一個xml文件(cd_catalog.xml),其內容如下:
    <?xml version="1.0" encoding="ISO-8859-1"?>
        <CATALOG>
             <CD>
                  <TITLE>Empire Burlesque</TITLE>
                  <ARTIST>Bob Dylan</ARTIST>
                  <COUNTRY>USA</COUNTRY>
                   <COMPANY>Columbia</COMPANY>
                  <PRICE>10.90</PRICE>
                  <YEAR>1985</YEAR>
             </CD>
             <CD>
                  <TITLE>Hide your heart</TITLE>
                  <ARTIST>Bonnie Tyler</ARTIST>
                  <COUNTRY>UK</COUNTRY>
                  <COMPANY>CBS Records</COMPANY>
                  <PRICE>9.90</PRICE>
                  <YEAR>1988</YEAR>
             </CD>
             <CD>
                  <TITLE>Greatest Hits</TITLE>
                  <ARTIST>Dolly Parton</ARTIST>
                  <COUNTRY>USA</COUNTRY>
                  <COMPANY>RCA</COMPANY>
                  <PRICE>9.90</PRICE>
                  <YEAR>1982</YEAR>
             </CD>
             <CD>
                  <TITLE>Still got the blues</TITLE>
                  <ARTIST>Gary Moore</ARTIST>
                  <COUNTRY>UK</COUNTRY>
                  <COMPANY>Virgin records</COMPANY>
                  <PRICE>10.20</PRICE>
                  <YEAR>1990</YEAR>
             </CD>
             <CD>
                  <TITLE>Eros</TITLE>
                  <ARTIST>Eros Ramazzotti</ARTIST>
                  <COUNTRY>EU</COUNTRY>
                  <COMPANY>BMG</COMPANY>
                  <PRICE>9.90</PRICE>
                  <YEAR>1997</YEAR>
             </CD>
             <CD>
                  <TITLE>One night only</TITLE>
                  <ARTIST>Bee Gees</ARTIST>
                  <COUNTRY>UK</COUNTRY>
                  <COMPANY>Polydor</COMPANY>
                  <PRICE>10.90</PRICE>
                  <YEAR>1998</YEAR>
             </CD>
             <CD>
                  <TITLE>Sylvias Mother</TITLE>
                  <ARTIST>Dr.Hook</ARTIST>
                  <COUNTRY>UK</COUNTRY>
                  <COMPANY>CBS</COMPANY>
                  <PRICE>8.10</PRICE>
                  <YEAR>1973</YEAR>
             </CD>
             <CD>
                    <TITLE>Maggie May</TITLE>
                  <ARTIST>Rod Stewart</ARTIST>
                  <COUNTRY>UK</COUNTRY>
                  <COMPANY>Pickwick</COMPANY>
                  <PRICE>8.50</PRICE>
                  <YEAR>1990</YEAR>
             </CD>
             <CD>
                   <TITLE>Romanza</TITLE>
                  <ARTIST>Andrea Bocelli</ARTIST>
                  <COUNTRY>EU</COUNTRY>
                  <COMPANY>Polydor</COMPANY>
                  <PRICE>10.80</PRICE>
                  <YEAR>1996</YEAR>
           </CD>
             <CD>
                  <TITLE>When a man loves a woman</TITLE>
                  <ARTIST>Percy Sledge</ARTIST>
                  <COUNTRY>USA</COUNTRY>
                  <COMPANY>Atlantic</COMPANY>
                  <PRICE>8.70</PRICE>
                  <YEAR>1987</YEAR>
             </CD>
       </CATALOG>
            
    四、新建一個java class(XqueryTest.java)

    import java.io.IOException;
    import java.util.Properties;

    import javax.xml.parsers.DocumentBuilder;
    import javax.xml.parsers.DocumentBuilderFactory;
    import javax.xml.parsers.ParserConfigurationException;
    import javax.xml.transform.OutputKeys;
    import javax.xml.transform.Transformer;
    import javax.xml.transform.TransformerConfigurationException;
    import javax.xml.transform.TransformerException;
    import javax.xml.transform.TransformerFactory;
    import javax.xml.transform.dom.DOMSource;
    import javax.xml.transform.stream.StreamResult;

    import org.w3c.dom.Document;
    import org.xml.sax.SAXException;

    import net.sf.saxon.Configuration;
    import net.sf.saxon.dom.*;
    import net.sf.saxon.query.DynamicQueryContext;
    import net.sf.saxon.query.StaticQueryContext;
    import net.sf.saxon.query.XQueryExpression;
    import net.sf.saxon.trans.XPathException;

    public class XqueryTest {
     /**
      * 執行查詢
      */
     public static void select(){
      //文件
      String fileString = "src/study/xquery/cd_catalog.xml";
      //查詢語句
      String query = " for $s in //CD/TITLE "
        + " return $s";
      //生產文檔對象
      Document document = getDocument(fileString);
      Configuration configuration = new Configuration();
      StaticQueryContext context = new StaticQueryContext(configuration, false);
      //查詢表達式對象
      XQueryExpression expression = null;
      try {
       expression = context.compileQuery(query);
       DynamicQueryContext context2 = new DynamicQueryContext(configuration);
       context2.setContextItem(new DocumentWrapper(document,null,configuration));
       
       final Properties props = new Properties();
                props.setProperty(OutputKeys.METHOD, "xml");
                props.setProperty(OutputKeys.INDENT, "yes");
                //執行查詢,并輸出查詢結果
                expression.run(context2, new StreamResult(System.out), props);
      } catch (XPathException e) {
       // TODO Auto-generated catch block
       e.printStackTrace();
      }
      
     }
     /**
      * 生產文檔對象
      *
      * @param xml   文件名
      * @return
      */
     public static Document getDocument(String xml){
      DocumentBuilderFactory builderFactory = DocumentBuilderFactory.newInstance();
      DocumentBuilder builder;
      Document document = null;
      try {
       builder = builderFactory.newDocumentBuilder();
       document = builder.parse(xml);
      } catch (ParserConfigurationException e) {
       // TODO Auto-generated catch block
       e.printStackTrace();
      } catch (SAXException e) {
       // TODO Auto-generated catch block
       e.printStackTrace();
      } catch (IOException e) {
       // TODO Auto-generated catch block
       e.printStackTrace();
      }
      document.normalize();
      return document;
     }
     /**
      * 輸入生成的文檔內容
      *
      * @param doc
      */
     public static void output(Document doc){
      TransformerFactory factory = TransformerFactory.newInstance();
      Transformer transformer = null;
      try {
       transformer = factory.newTransformer();
       Properties properties = transformer.getOutputProperties();
       properties.setProperty(OutputKeys.INDENT, "yes");
                properties.setProperty(OutputKeys.ENCODING, "GB2312");
                properties.setProperty(OutputKeys.METHOD, "xml");
                properties.setProperty(OutputKeys.VERSION, "1.0");
                transformer.setOutputProperties(properties);
               
                DOMSource source = new DOMSource(doc);
                StreamResult result = new StreamResult(System.out);
                transformer.transform(source, result);
       
      } catch (TransformerConfigurationException e) {
       // TODO Auto-generated catch block
       e.printStackTrace();
      } catch (TransformerException e) {
       // TODO Auto-generated catch block
       e.printStackTrace();
      }
     }
     public static void main(String[] args) {
      select();
     }
    }


    五、運行結果
    <?xml version="1.0" encoding="UTF-8"?>
    <TITLE>Empire Burlesque</TITLE>
    <TITLE>Hide your heart</TITLE>
    <TITLE>Greatest Hits</TITLE>
    <TITLE>Still got the blues</TITLE>
    <TITLE>Eros</TITLE>
    <TITLE>One night only</TITLE>
    <TITLE>Sylvias Mother</TITLE>
    <TITLE>Maggie May</TITLE>
    <TITLE>Romanza</TITLE>
    <TITLE>When a man loves a woman</TITLE>
    posted on 2009-10-07 17:14 腳踏實地 閱讀(1183) 評論(0)  編輯  收藏 所屬分類: start XQuery
    主站蜘蛛池模板: 免费无码AV电影在线观看| 84pao强力永久免费高清 | 免费人成网站在线观看不卡| 亚洲黄片毛片在线观看| 亚洲欧美日韩中文字幕在线一区| 100000免费啪啪18免进| 亚洲av无码一区二区三区观看| 99精品免费观看| 亚洲精品电影天堂网| 免费观看的毛片大全| 丁香婷婷亚洲六月综合色| 免费高清在线爱做视频| 免费观看亚洲人成网站| 国产亚洲精aa成人网站| AAAAA级少妇高潮大片免费看| 亚洲一区爱区精品无码| 日本在线看片免费人成视频1000| 亚洲视频网站在线观看| 最近2019中文字幕mv免费看| 美女隐私免费视频看| 亚洲区小说区激情区图片区| 全免费a级毛片免费看| 亚洲伊人久久大香线蕉啊| 日本免费网站观看| 好湿好大好紧好爽免费视频| 亚洲精品视频在线| 在线a毛片免费视频观看| 欧洲精品码一区二区三区免费看| 久久亚洲精品视频| 免费av欧美国产在钱| 一级毛片正片免费视频手机看| 亚洲国产精品高清久久久| 久久精品a一国产成人免费网站 | 亚洲欧洲日产韩国在线| 日韩一级视频免费观看| 野花香在线视频免费观看大全| 亚洲www在线观看| 亚洲毛片αv无线播放一区 | 四虎精品视频在线永久免费观看| 亚洲a∨无码精品色午夜| 亚洲a在线视频视频|