ÔںܶàÇé¿öÏÂ, ÎÒÃÇ»áÓõ½XML,±ÈÈç˵ÅäÖÃÎļþµÈ.C#ÌṩÁËXMLÀà.
ÕâÀïÎÒÖ»ÊǼòµ¥µÄдһÏÂXMLÎļþµÄÉú³É,½âÎö¾Í²»¶à˵ÁË.
µÚÒ»ÖÖ·½·¨
DataBase db = DataBaseFactory.CreateDataBase(DataBaseType.MySql, strMysql);
DbCommand command = db.GetSqlStringCommand(strSql);
DataTable dt = db.ExecuteDataSet(command).Tables[0];
//string strFileName = Application.StartupPath + "\\" + "test.xml";
DirectoryInfo file = new DirectoryInfo(strPath);
if (!file.Exists)
{
file.Create();
&nb ......
ÕâƪÎÄÕ±»×ªÔصĴÎÊý×î¶à£¬Æäʵ´úÂë¼òªµÃÎÒ×Ô¼º¶¼¿´²»ÏÂÈ¥¡£Ö»²»¹ý·¢±íÕâƪÎÄÕÂʱºÜ¶àÈËÐèÒªÕâ¸ö¹¦ÄÜ¡£
Õ⼸Ììд¸öÊý¾Ý¿â²éѯ·ÖÎöÆ÷£¬ÒªÓõ½XML¼Ç¼Óû§×¢²áµÄÊý¾Ý¿âÁ¬½ÓµØÖ·¡¢¶Ë¿ÚµÈÐÅÏ¢£¬×ʼÏëÓÃjavaµÄpropertieÀàÀ´Íê³É¡£µ«propertie²»Ö§³Ö[С½áÃû--¼üÖµÃû--¼üÖµ]ÕâÖֽṹ£¬Èç¹ûÒª¼Ç¼Óû§×¢²áµÄ¶à¸öÊý¾Ý¿âÐÅÏ¢µÄ»°£¬propertieÖоͱØÐëÓÃ[С½áÃû.¼üÖµÃû=¼üÖµ]ÕâÖÖ¸ñʽ½øÐмǼ£¬ºóÀ´Óõ½xml£¬Íê³ÉÁËÀàËÆiniÎļþ¶ÁÈ¡ºÍ±£´æµÄ¹¦ÄÜ£¬É¾³ý¹¦ÄÜÄ¿Ç°»¹Ã»×ö£¬ÒªÊµÏֺܼòµ¥£¬ËùÒÔ¾Íû°üº¬ÔÚ´úÂëÀïÃæÁË¡£
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<SERVER>
<CRM>
<IP>162.105.167.4</IP>
<PORT>5000</PORT>
<CHARSET>cp850</CHARSET>
<DBTYPE>Sybase</DBTYPE>
<DBNAME>BB_CRM</DBNAME>
</CRM>
<JYGS>
<IP>162.105.16 ......
ÕâƪÎÄÕ±»×ªÔصĴÎÊý×î¶à£¬Æäʵ´úÂë¼òªµÃÎÒ×Ô¼º¶¼¿´²»ÏÂÈ¥¡£Ö»²»¹ý·¢±íÕâƪÎÄÕÂʱºÜ¶àÈËÐèÒªÕâ¸ö¹¦ÄÜ¡£
Õ⼸Ììд¸öÊý¾Ý¿â²éѯ·ÖÎöÆ÷£¬ÒªÓõ½XML¼Ç¼Óû§×¢²áµÄÊý¾Ý¿âÁ¬½ÓµØÖ·¡¢¶Ë¿ÚµÈÐÅÏ¢£¬×ʼÏëÓÃjavaµÄpropertieÀàÀ´Íê³É¡£µ«propertie²»Ö§³Ö[С½áÃû--¼üÖµÃû--¼üÖµ]ÕâÖֽṹ£¬Èç¹ûÒª¼Ç¼Óû§×¢²áµÄ¶à¸öÊý¾Ý¿âÐÅÏ¢µÄ»°£¬propertieÖоͱØÐëÓÃ[С½áÃû.¼üÖµÃû=¼üÖµ]ÕâÖÖ¸ñʽ½øÐмǼ£¬ºóÀ´Óõ½xml£¬Íê³ÉÁËÀàËÆiniÎļþ¶ÁÈ¡ºÍ±£´æµÄ¹¦ÄÜ£¬É¾³ý¹¦ÄÜÄ¿Ç°»¹Ã»×ö£¬ÒªÊµÏֺܼòµ¥£¬ËùÒÔ¾Íû°üº¬ÔÚ´úÂëÀïÃæÁË¡£
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<SERVER>
<CRM>
<IP>162.105.167.4</IP>
<PORT>5000</PORT>
<CHARSET>cp850</CHARSET>
<DBTYPE>Sybase</DBTYPE>
<DBNAME>BB_CRM</DBNAME>
</CRM>
<JYGS>
<IP>162.105.16 ......
using System;
using System.Data;
using System.Drawing;
using System.Globalization;
using System.IO;
using System.Windows.Forms;
using Excel = Microsoft.Office.Interop.Excel;
// Ìí¼ÓÒýÓÃ -> .NET -> Microsoft.Office.Interop.Excel(2003->11.0, 2007->12.0)
namespace WinFormTable
{
public partial class FormTable : Form
{
#region
private DataTable table;
private ChineseLunisolarCalendar lunarCalendar;
#endregion
public FormTable()
{
#region
InitializeComponent();
lunarCalen ......
using System;
using System.Data;
using System.Drawing;
using System.Globalization;
using System.IO;
using System.Windows.Forms;
using Excel = Microsoft.Office.Interop.Excel;
// Ìí¼ÓÒýÓÃ -> .NET -> Microsoft.Office.Interop.Excel(2003->11.0, 2007->12.0)
namespace WinFormTable
{
public partial class FormTable : Form
{
#region
private DataTable table;
private ChineseLunisolarCalendar lunarCalendar;
#endregion
public FormTable()
{
#region
InitializeComponent();
lunarCalen ......
Ê×ÏÈÎÒÃǸø³öÒ»¶ÎʾÀý³ÌÐò£º
import
java.io.File;
import
java.io.FileWriter;
import
java.util.Iterator;
import
org.dom4j.Document;
import
org.dom4j.DocumentHelper;
import
org.dom4j.Element;
import
org.dom4j.io.OutputFormat;
import
org.dom4j.io.SAXReader;
import
org.dom4j.io.XMLWriter;
public
class
DOM4JTest
{
/** */
/**
*/
/** */
/**
*/
/** */
/**
*/
/** */
/**
* DOM4J¶ÁдXMLʾÀý
*
*
@param
args
*
@throws
Exception
*/
public
static
void
main(String[] args)
{
  ......
¶ÔÓÚСÐÍÊý¾Ý´æ´¢ºÜ·½±ã¡£
µ«¶àÁ˾ÍÒªÓöµ½IOÆ¿¾±¡£
ÁíÍ⣬XML¸ñʽ±È½ÏͨÓá£
Ò»°ãÀ´Ëµ£¬¸´ÔÓÐ͵ÄÊý¾Ý´æ´¢»¹ÊÇÓÃÊý¾Ý¿âºÃЩ¡£´¦Àí·½±ã¡£¶øÇÒЧÂʸߡ£
ͨÓÃÐÔÇ¿£¬¿ÉÒÔÔÚÈκÎƽ̨ÉÏʹÓá£Ð¡Ð͵ÄÊý¾Ý¶¼¿ÉÒÔʹÓÃXML¡£
ȱµã¾ÍÊÇÓÐÒ»¸ö»º´æµÄÎÊÌâ
1£©XML¿ÉÒÔÓÃÓÚ±¾µØ¼ÆËãµÄÊý¾Ý¡£´«µÝµ½×ÀÃæµÄÊý¾Ý¿ÉÒÔ½øÐб¾µØ¼ÆËã¡£XML½âÎöÆ÷¿ÉÒÔ¶ÁÈ¡Êý¾Ý£¬²¢½«ËüµÝ½»¸ø±¾µØÓ¦ÓóÌÐò£¨ÀýÈçä¯ÀÀÆ÷£©½øÒ»²½²é¿´»ò´¦Àí¡£Êý¾ÝÒ²¿ÉÒÔÓÉʹÓÃXML¶ÔÏóÄ£Ð͵Ľű¾»òÆäËü±à³ÌÓïÑÔÀ´´¦Àí¡£ 2£©¿ÉÒÔΪÓû§ÌṩÕýÈ·µÄ½á¹¹»¯Êý¾ÝÊÓͼ¡£´«µÝµ½×ÀÃæµÄÊý¾Ý¿ÉÒÔÒÔ¶àÖÖ·½Ê½±íʾ¡£±¾µØÊý¾Ý¼¯£¬¿ÉÒÔ¸ù¾ÝÓû§Ï²ºÃºÍÅäÖõÈÒòËØ£¬ÒÔÊʵ±µÄÐÎʽÔÚÊÓͼÖж¯Ì¬±íÏÖ¸øÓû§¡£ 3£©ÔÊÐí¼¯³É²»Í¬À´Ô´µÄ½á¹¹»¯Êý¾Ý¡£Ê¹ÓôúÀí¿ÉÔÚÖмä²ã·þÎñÆ÷Éϼ¯³ÉÀ´×Ôºó¶ËÊý¾Ý¿âºÍÆäËüÓ¦ÓóÌÐòµÄÊý¾Ý£¬Ê¹¸ÃÊý¾ÝÄܹ»´«µÝ¸ø×ÀÃæ»òÕßÆäËü·þÎñÆ÷£¬×ö½øÒ»²½´¦Àí¡£ 4£©ÃèÊöÀ´×Ô¶àÖÖÓ¦ÓóÌÐòµÄÊý¾Ý¡£ÓÉÓÚ XML ÊÇ¿ÉÀ©Õ¹µÄ£¬Òò´ËËü¿ÉÒÔÓÃÓÚÃèÊöÀ´×Ô¶àÖÖÓ¦ÓóÌÐòµÄÊý¾Ý£¬¼´Ê¹Ã»ÓÐÊý¾ÝµÄÄÚÖÃÃèÊö£¬Ò²Äܹ»½ÓÊպʹ¦ÀíÊý¾Ý¡£ 5£©Í¨¹ýÁ£¶È¸üÐÂÀ´Ìá¸ßÐÔÄÜ¡£XML ÔÊÐíÁ£¶È¸üС£¿ª·¢ÈËÔ±²»±ØÔÚÿ´Î¸Ä¶¯Ê±¶¼·¢ËÍÕû¸ö½á¹¹»¯Êý¾Ý¼¯¡£ÓÐÁËÁ£¶È¸üкó£¬Ö»ÓиıäµÄÔ ......
private
NodeList root(
final
String url ,
final
String str){
NodeList root =
null
;
try
{
InputSource is=
new
InputSource(
new
InputStreamReader(
new
URL(url).openStream()));
DocumentBuilderFactory factory = DocumentBuilderFactory.newInstance
();
DocumentBuilder dom = factory.newDocumentBuilder();
Document doc = dom.parse(is);
root = doc.getElementsByTagName(str);
}
catch
(Exception e){
  ......