xml

public class ParseXML {     public static void main(String[] args) {         try {             DocumentBuilderFactory factory = DocumentBuilderFactory                     .newInstance();             DocumentBuilder builder = factory.newDocumentBuilder();             File file = new File("d:/table/AFFICHE.xml");             // 创建             Document document = builder.parse(file);             FileWriter fw = new FileWriter("d:/23.txt");                                     // 从数据库提取             // String xmlstr= "<beans><name>liu</name><pass>123</pass></beans>";             // builder.parse(new ByteArrayInputStream(str.getBytes()));             // save to mysql //            StringWriter output = new StringWriter(); //            TransformerFactory.newInstance().newTransformer().transform( //                    new DOMSource(document), new StreamResult(output));             //System.out.println(output.toString());             // 对内展现             XPathFactory factoryXpah = XPathFactory.newInstance();             XPath xpath = factoryXpah.newXPath();             XPathExpression expr = xpath.compile("//RECORD");             StringBuffer sql = new StringBuffer();             NodeList node = (NodeList)expr.evaluate(document,XPathConstants.NODESET);                       for(int i=0;i<node.getLength();i++){                        Node n = node.item(i);                        NodeList ns = n.getChildNodes();                                           sql.append("insert into ");                        sql.append(file.getName().substring(0,file.getName().lastIndexOf(".")));                        sql.append(" values(");                        for(int j =1;j<ns.getLength();j+=2){                           sql.append("'");                           String name = ns.item(j).getNodeName();                           if(name.indexOf("DATE")==-1){                               sql.append(ns.item(j).getTextContent().replaceAll("(//s+|//t+)", ""));                           }else{                               sql.append(ns.item(j).getTextContent().substring(0,ns.item(j).getTextContent().length()-7));                           }                           //sql.append(ns.item(j).getTextContent().replaceAll("(//s+|//t+)", ""));                           if(j<(ns.getLength()+1)/2)                           sql.append("',");                        }                        sql.append(")");                        sql.append(";");                    }                       fw.write(sql.toString());                       fw.close();                                                                    //System.out.println(expr.evaluate(document));             // 对jsp jstl xml             // 参考 http://www.java2s.com/Code/Java/JSP/XML.htm         } catch (Exception e) {             e.printStackTrace();         }     } }