XML½âÎöµÄÉè¼ÆÄ£Ê½µÄÎÊÌâ
¿´ÁËÒ»¸ö´úÂ룬µ«ÊDz»ÖªµÀÓõÄÊÇʲôÉè¼ÆÄ£Ê½£¬Ò»¶Î¹ØÓÚ½âÎöXMLµÄ´úÂ룬ÏÂÃæµÄÁ½¸öÀ࣬ÔÚVSXµÄÕâÁ½ÐÐ
SAXParser saxParser = factory.newSAXParser( );
saxParser.parse( new File(filename), handler);
ÆäÖУ¬µÚÒ»ÐÐÊÇÒ»¸ö¹¤³§Ä£Ê½£¬Éú³ÉÒ»¸ö SAXParser µÄ½âÎöÆ÷
ÆäÖУ¬µÚ¶þÐÐ saxParser.parse( new File(filename), handler) Õâ¸öÓõÄÊÇʲôÉè¼ÆÄ£Ê½ÄØ£¿
Java code:
public class VSX {
public TreeModel parse(String filename) {
SAXParserFactory factory = SAXParserFactory.newInstance( );
XMLTreeHandler handler = new XMLTreeHandler( );
try {
// Parse the input.
SAXParser saxParser = factory.newSAXParser( );
saxParser.parse( new File(filename), handler);
}
catch (Exception e) {
System.err.println("File Read Error: " + e);
e.printStackTrace( );
return new DefaultTreeModel(new DefaultMutableTreeNode("error"));
}
return new DefaultTreeModel(handler.getRoot( ));
}
}
public class XMLTreeHandler extends DefaultHandler {
private DefaultMutableTreeNode root, currentNode;
public DefaultMutableTreeNode getRoot( ) {
return root;
}
// SAX parser handler methods
Ïà¹ØÎÊ´ð£º
Êý¾Ý¿â±íÖÐÓÐÒ»ÁУ¨TranXml£©ÀàÐÍÊÇxml£¬´æ´¢µÄÊÇÀàËÆ
<fathernode>
<a>aaa
</a>
<b>bbb
</b>
</fathernode>
µÄÐÅÏ¢£¬²¢ÇÒͨ¹ý²éѯ·½· ......
´ÓÊý¾Ý¿âÖвéѯһÕűíµÄÊý¾Ý
select ²¿ÃÅ,ÐÕÃû from tb
ÈçºÎ²ÅÄÜÉú³ÉÏÂÃæµÄxml¸ñʽ
XML code:
<folder state="unchecked" label="È«²¿">
¡¡¡¡ <folder state="unchecked&qu ......
ÎÒÏÖÔÚ×ö½Ó¿Úµ¼³ö£¬.NETƽ̨£¬¿ª·¢ÓïÑÔC#£¬Ïëµ¼³öXMLµÄÎı¾¸ñʽ¡£
ÏëµÃµ½ <?xml version="1.0" encoding="GBK"?>
µÄ±àÂë¸ñʽ£¡ÔõôÉèÖã¿Ð»Ð»£¡¼±£¡
¶¥
Ö»Òª±£´æÎªxml¸ñʽ£¬ ......
ÒýÓõÄÎļþ°üº¬´íÎó£¨XXXXX.xsd£©¡£Óйظü¶àÐÅÏ¢£¬ÓÒ¼üµ¥»÷ÏûÏ¢²¢Ñ¡Ôñ¡°ÏÔʾÏêϸÐÅÏ¢...¡±
ÇëÎÊÕâÊÇÄijö´íÁË£¿£¿£¿ÎÒÔÚelipseÀïû´í Äõ½myelipseÀïxmlÈ«ÊÇÕâ¸ö´íÎ󡣡£¡£¡£
ÊDz»ÊÇÉÙ°ü°¡£¿
°ü¶¼ÔÚÄØÑ½¡£¡£¡£ ......
ÏÖÔÚÓиöxmlÎļþÊÇ<?xml version="1.0"?>
<?mso-application progid="Excel.Sheet"?>
<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"
xm ......