Ò»¸öÓÃDom4j½âÎöxmlµÄÀý×Ó
Ò»¡¢²âÊÔÓõÄem.xml
<?xml version="1.0" encoding="GB2312"?>
<EW cmd="login" mod="Login" version="6.0">
<Source uns="" type="user"/>
<Username>zhangzhiyun@hp</Username>
<Password>111111</Password>
<Version>6.01.06.00</Version>
</EW>
¶þ¡¢Dom4jTest.java
import java.io.BufferedReader;
import java.io.BufferedWriter;
import java.io.File;
import java.io.FileReader;
import java.io.FileWriter;
import java.io.IOException;
import org.apache.log4j.Logger;
import org.dom4j.Attribute;
import org.dom4j.DocumentException;
import org.dom4j.DocumentHelper;
import org.dom4j.Element;
/**
* @author julysea
*
* Ò»¸öÓÃDom4j½âÎöxmlµÄÀý×Ó
*
*/
public class Dom4jTest {
private static final Logger logger = Logger.getLogger(Dom4jTest.class);
public static void main(String[] args) throws IOException,
DocumentException {
BufferedReader reader=new BufferedReader(new FileReader("ew.xml"));
String tempStr;
String ewXml="";
while((tempStr=reader.readLine())!=null) {
ewXml=ewXml+tempStr;
logger.debug(tempStr);
}
Element root = null;
root = DocumentHelper.parseText(ewXml).getRootElement();
Attribute rootCmd=root.attribute("cmd");
Attribute rootVersion=root.attribute("version");
logger.debug("rootNmae = "+root.getName());
logger.debug("EW'cmd = "+rootCmd.getValue());
logger.debug("EW'version = "+rootVersion.getValue());
Element usrName=root.element("Username");
logger.debug("EW.Username value = "+usrName.getTextTrim());
Element source=root.element("Source");
Attribute sourceUns=source.attribute("uns");
logger.debug("EW.Source'uns£½"+sourceUns.getValue());
Attribute sourceType=source.attribute("type");
Ïà¹ØÎĵµ£º
1. <?xml version="1.0" encoding="GB2312" standalone="yes" ?>
1.1 ÕâÊÇxmlµÄÎĵµÉùÃ÷£¬Ò»°ãλÓÚxmlÎļþµÄÊ×ÐС£
1.2 Êéд¹æ·¶£º<?xmlΪһÌå Ö®¼ä²»ÄÜÓпոñ¡£
1.3 encodingÊôÐÔ£¬Èç¹ ......
/*--´æÎªXML
½«±í/²éѯ´æ´¢Îª±ê×¼µÄXMLÎļþ
--*/
/*--µ÷ÓÃʾÀý
--ÓÃSQLÓÃwinowsÉí·ÝÑéÖ¤µÄÇé¿ö
exec p_savexml @sql='µØÇø×ÊÁÏ',@fname='c:\µØÇø×ÊÁÏ.xml'
--ÓÃÖ¸¶¨µÄÓû§
exec p_savexml @sql='µØÇø×ÊÁÏ',@fname='c:\µØÇø×ÊÁÏ.xml',@userid='sa'
--*/
if exists (select * from db ......
ºÜ¶àÈ˶ÔXpath¿ÉÄܱȽÏÊìϤ£¬µ«²»ÖªµÀÓÐûÓÐÖ±½Ó²Ù×÷¹ýÊý¾Ý¿â£¬ÎÒÃǶ¼ÖªµÀ ÔÚSql2005À﹫֧³ÖµÄ¼¸ÖÖ²éѯÓÐRaw£¬Auto£¬PathģʽµÈ£¬Èç¹ûÔÚ2000ÀïʹÓùý PathģʽµÄÅóÓÑÓ¦¸ÃÖªµÀ£¬ÊDz»ÈÝÒ×´¦Àí²éѯ½á¹ûµÄ£¬ÄÇôÔÚ2005Àï¶ÔÕâÒ»¿é×öÁ˺ܺõÄÌáÉý
ÎÒÏÈÀ´½éÉÜÒ»ÏÂʲôÊÇSql¡¡F ......
¡¡¡¡±¾ÎÄÌÖÂÛSQL Server 2005µÄй¦ÄÜ£¬ËüÔÊÐíÄ㽫XMLÊý¾Ý·Ö½âµ½¹ØÏµ¸ñʽÖУ¬¶ø²»±ØºÄÓÃÌ«¶àÄÚ´æ¡£
¡¡¡¡±¾ÎÄÌÖÂÛSQL Server 2005µÄй¦ÄÜ£¬ËüÔÊÐíÄ㽫XMLÊý¾Ý·Ö½âµ½¹ØÏµ¸ñʽÖУ¬¶ø²»±ØºÄÓÃÌ«¶àÄÚ´æ¡£
¡¡¡¡ÔÚ¾ÙÀý˵Ã÷ÈçºÎ·Ö½âÉÏһƪÎÄÕÂÖеÄÊý¾Ýʱ£¬ÎÒÃÇÊ×ÏÈÁ˽âÒ»ÏÂXQueryºÍËüÔÚSQL Server 2005ÖÐΪ¿ª·¢ÕßÌṩµÄ¹¦ÄÜ¡£
¡ ......
1.Òª½âÎöµÄXMLÎļþÈçÏ£º
<?xml version="1.0" encoding="GB2312"?>
<?xml-stylesheet href="student.xsl" type="text/xsl"?>
<StudentInfo>
<student>
<name>´ïÄÚ</name>
<sex>ÄÐ</sex>
<lesson>
  ......