Dom4j²Ù×÷XMLÎļþ дÎļþ
package com.beckham.dom;
import java.io.File;
import java.io.FileWriter;
import org.dom4j.Document;
import org.dom4j.DocumentHelper;
import org.dom4j.Element;
import org.dom4j.io.OutputFormat;
import org.dom4j.io.XMLWriter;
/**
* @author ×÷Õß<Beckham>
* Email:gaowm0207@gmail.com
* Jan 28, 2010 10:03:12 AM
* DOM4jдXMLÎļþ
*/
public class CreateXMLFile {
public static void main(String[] args)throws Exception {
createFile("src/com/beckham/dom/application.xml") ;
}
public static void createFile(String fileName) throws Exception{
Document document = DocumentHelper.createDocument() ;
//¸ù½Úµã
Element root = document.addElement("beans") ;
//¸ù½Úµã×¢ÊÍ
root.addComment("ÕâÊǸù½Úµã") ;
//µÚÒ»¸ö×Ó½Úµã
Element elementBean1 = root.addElement("bean") ;
elementBean1.addAttribute("id", "boy") ;
elementBean1.addAttribute("class", "com.beckham.spring.Boy") ;
Element elementProp = elementBean1.addElement("property") ;
elementProp.addAttribute("name", "user") ;
elementProp.addAttribute("ref", "com.beckham.User") ;
//µÚ¶þ¸ö×Ó½Úµã
Element elementBean2 = root.addElement("bean") ;
elementBean2.addAttribute("id", "girl") ;
elementBean2.addAttribute("class", "com.beckham.spring.Girl") ;
Element elementProp2 = elementBean2.addElement("property") ;
elementProp2.addAttribute("name", "user") ;
elementProp2.addAttribute("ref", "com.beckham.User") ;
//ǰһ¸ö²ÎÊý±íʾËõ½ø4¸ö¿Õ¸ñ
OutputFormat format = new OutputFormat(" ",true) ;
format.setEncoding("GBK") ;
XMLWriter w = new XMLWriter(new FileWriter(new File(fileName)),format ) ;
w.write(document) ;
w.close() ;
}
}
<?xml version="1.0&qu
Ïà¹ØÎĵµ£º
ÀûÓÃsqlhelperÖеÄExcuteXmlReader·½·¨£¬¶ÁÈ¡Êý¾Ý²¢±£´æÎªxmlÎļþ
string strConn = Properties.Settings.Default.Connections;
SqlConnection connection = new SqlConnection(strConn);
& ......
SQL Server¸ù¾Ý²éѯ½á¹û,Éú³ÉXMLÎļþ
À´Ô´£º²»Ïê ×÷ÕߣºØýÃû ʱ¼ä£º2009-3-6 22:15:58 ·¢²¼£ººÚ¿ÍÈí¼þÔ°
/*
'bcp' ²»ÊÇÄÚ²¿»òÍⲿÃüÁҲ²»ÊÇ¿ÉÔËÐеijÌÐò£¿
¿´¿´ÔÚC:\Program Files\Microsoft SQL Server\80\Tools\BinnÀïÃæÓÐûÓÐbcp.exeÕâ¸öÎļþ
È»ºó¿´¿´pathÀïÃæ¼ÓC:\Program Files\Microso ......
Javaͨ¹ýXML SchemaУÑéXML
XMLµÄУÑéÔÚXML´¦ÀíÖзdz£³£¼û£¬Èç¹ûûÓÐÓÐЧµÄ°ì·¨À´Ð£ÑéXMLµÄºÏ·¨ÐÔ£¬ÍùÍù»áµ¼ÖºܶàÎÊÌâ¡£
XMLµÄУÑéÊÇͨ¹ýXML Schema£¨XSD£© »òDTDÎļþµÄÓï·¨¹æ·¶À´Ð£ÑéµÄ¡£DTDÏÖÔÚÔ½À´Ô½²»ÊÜ»¶ÓÁË£¬ÔÚ´ËÑ¡ÓÃXSDÀ´Ð£Ñé¡£
JavaУÑéXMLÊǼþºÍ³¶µµÄÊÂÇ飬ÒòΪSunµÄXMLÏà¹ØÈí¼þ°ü» ......
xmlΪ£º
<friendShares>
<totalCount>352</totalCount>
<friendShare>
<code>XXXXXXX</code>
<date>2010-01-15T00:00:00+08:00</date>
<friendId>499</friendId>
<movie>
<code>XXXXXX</code>
<contentId>89718</content ......
public string WriteXML(string[] values, int flag)
{
//Èç¹ûflag==0ÔòΪµÚÒ»´ÎÔËÐÐÐèÒª³õʼ»¯XMLÎļþ
if (flag == 0)
{
//ÉúÔÚËæ»úÎļþÃû
string dateName = System.DateTime.Now.ToString("yyyyMMddHHmmss");
......