C#对XML、JSON等格式的解析

C#对XML、JSON等格式的解析

一、C#对XML格式数据的解析

1、用XMLDocument来解析

1
2
3
4
5
6
7
8
9
10
11
12
XmlDocument xmlDocument =  new  XmlDocument();
xmlDocument.Load( "test.xml" );
                                            
//创建新节点 
XmlElement nn = xmlDocument.CreateElement( "image" );
nn.SetAttribute( "imageUrl" "6.jpg" );
                                            
XmlNode node = xmlDocument.SelectSingleNode( "content/section/page/gall/folder" ); //定位到folder节点
node.AppendChild(nn); //附加新节点
                                            
//保存
xmlDocument.Save( "test.xml" );

2、用Linq to XML来解析

可以通过遍历,来获得你想要的节点的内容或属性

1
2
3
4
5
6
XElement root = XElement.Load( "test.xml" );
foreach  (XAttribute att  in  root.Attributes())
{
     root.Add( new  XElement(att.Name, ( string )att));
}
Console.WriteLine(root);

3、附一个详细点的例子

比如要解析如下的xml文件,将其转化为Ilist对象。

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
<? xml  version = "1.0"  encoding = "utf-8" ?>
< Car >
   < carcost >
     < ID >20130821133126</ ID >
     < uptime >60</ uptime >
     < downtime >30</ downtime >
     < price >0.4</ price >
   </ carcost >
   < carcost >
     < ID >20130821014316</ ID >
     < uptime >120</ uptime >
     < downtime >60</ downtime >
     < price >0.3</ price >
   </ carcost >
   < carcost >
     < ID >20130822043127</ ID >
     < uptime >30</ uptime >
     < downtime >0</ downtime >
     < price >0.5</ price >
   </ carcost >
   < carcost >
     < ID >20130822043341</ ID >
     < uptime >120以上!</ uptime >
     < downtime >120</ downtime >
     < price >0.2</ price >
   </ carcost >
</ Car >

在控制台应用程序中输入如下代码即可。

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
class  Program
{
     static  void  Main( string [] args)
     {
         IList<CarCost> resultList =  new  List<CarCost>();
                               
         XmlDocument xmlDocument =  new  XmlDocument();
         xmlDocument.Load( "test.xml" );
                               
         XmlNodeList xmlNodeList = xmlDocument.SelectSingleNode( "Car" ).ChildNodes;
         foreach  (XmlNode list  in  xmlNodeList)
         {
             CarCost carcost =  new  CarCost
             (
                 list.SelectSingleNode( "ID" ).InnerText,
                 list.SelectSingleNode( "uptime" ).InnerText,
                 list.SelectSingleNode( "downtime" ).InnerText,
                 float .Parse(list.SelectSingleNode( "price" ).InnerText)
             );
             resultList.Add(carcost);
         }
                               
         IEnumerator enumerator = resultList.GetEnumerator();
         while  (enumerator.MoveNext())
         {
             CarCost carCost = enumerator.Current  as  CarCost;
             Console.WriteLine(carCost.ID +  " "  + carCost.UpTime +  " "  + carCost.DownTime +  " "  + carCost.Price);
         }
     }
}
                               
public  class  CarCost
{
     public  CarCost( string  id,  string  uptime,  string  downtime,  float  price)
     {
         this .ID = id;
         this .UpTime = uptime;
         this .DownTime = downtime;
         this .Price = price;
     }
     public  string  ID {  get set ; }
     public  string  UpTime {  get set ; }
     public  string  DownTime {  get set ; }
     public  float  Price {  get set ; }
}

二、C#对JSON格式数据的解析

引用Newtonsoft.Json.dll文件,来解析。

比如:有个要解析的JSON字符串

[{"TaskRoleSpaces":"","TaskRoles":"","ProxyUserID":"5d9ad5dc1c5e494db1d1b4d8d79b60a7","UserID":"5d9ad5dc1c5e494db1d1b4d8d79b60a7","UserName":"姓名","UserSystemName":"2234","OperationName":"送合同负责人","OperationValue":"同意","OperationValueText":"","SignDate":"2013-06-19 10:31:26","Comment":"同意","FormDataHashCode":"","SignatureDivID":""},{"TaskRoleSpaces":"","TaskRoles":"","ProxyUserID":"2c96c3943826ea93013826eafe6d0089","UserID":"2c96c3943826ea93013826eafe6d0089","UserName":"姓名2","UserSystemName":"1234","OperationName":"送合同负责人","OperationValue":"同意","OperationValueText":"","SignDate":"2013-06-20 09:37:11","Comment":"同意","FormDataHashCode":"","SignatureDivID":""}]

首先定义个实体类:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
public  class  JobInfo
{
     public  string  TaskRoleSpaces {  get set ; }
     public  string  TaskRoles {  get set ; }
     public  string  ProxyUserID {  get set ; }
     public  string  UserID {  get set ; }
     public  string  UserName {  get set ; }
     public  string  UserSystemName {  get set ; }
     public  string  OperationName {  get set ; }
     public  string  OperationValue {  get set ; }
     public  string  OperationValueText {  get set ; }
     public  DateTime SignDate {  get set ; }
     public  string  Comment {  get set ; }
     public  string  FormDataHashCode {  get set ; }
     public  string  SignatureDivID {  get set ; }
}

然后在控制台Main函数内部输入如下代码:

1
2
3
4
5
6
7
8
9
string  json =  @"[{'TaskRoleSpaces':'','TaskRoles':'','ProxyUserID':'5d9ad5dc1c5e494db1d1b4d8d79b60a7','UserID':'5d9ad5dc1c5e494db1d1b4d8d79b60a7','UserName':'姓名','UserSystemName':'2234','OperationName':'送合同负责人','OperationValue':'同意','OperationValueText':'','SignDate':'2013-06-19 10:31:26','Comment':'同意','FormDataHashCode':'','SignatureDivID':''},{'TaskRoleSpaces':'','TaskRoles':'','ProxyUserID':'2c96c3943826ea93013826eafe6d0089','UserID':'2c96c3943826ea93013826eafe6d0089','UserName':'姓名2','UserSystemName':'1234','OperationName':'送合同负责人','OperationValue':'同意','OperationValueText':'','SignDate':'2013-06-20 09:37:11','Comment':'同意','FormDataHashCode':'','SignatureDivID':''}]
" ;
                       
             List<JobInfo> jobInfoList = JsonConvert.DeserializeObject<List<JobInfo>>(json);
                       
             foreach  (JobInfo jobInfo  in  jobInfoList)
             {
                 Console.WriteLine( "UserName:"  + jobInfo.UserName +  "UserID:"  + jobInfo.UserID);
             }

这样就可以正常输出内容了。

我想肯定有人会问,如果有多层关系的json字符串该如何处理呢?没关系,一样的处理。

比如如何解析这个json字符串:[{'phantom':true,'id':'20130717001','data':{'MID':1019,'Name':'aaccccc','Des':'cc','Disable':'启用','Remark':'cccc'}}]  ?

首先还是定义实体类:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
public  class  Info
{
     public  string  phantom {  get set ; }
     public  string  id {  get set ; }
     public  data data {  get set ; }
}
                  
public  class  data
{
     public  int  MID {  get set ; }
     public  string  Name {  get set ; }
     public  string  Des {  get set ; }
     public  string  Disable {  get set ; }
     public  string  Remark {  get set ; }
}

然后在main方法里面,键入:

1
2
3
4
5
6
7
string  json =  @"[{'phantom':true,'id':'20130717001','data':{'MID':1019,'Name':'aaccccc','Des':'cc','Disable':'启用','Remark':'cccc'}}]" ;
List<Info> infoList = JsonConvert.DeserializeObject<List<Info>>(json);
             
foreach  (Info info  in  infoList)
{
     Console.WriteLine( "id:"  + info.data.MID);
}

   按照我们的预期,应该能够得到1019的结果。


截图为证:

Center

另外,对于有些json格式不是标准的,可以使用通用的方法进行解析。

1
2
3
4
5
6
string  jsonText =  @" {'Count':1543,'Items':[{'UnitID':6119,'UnitName':'C'}]}" ;
JsonReader reader =  new  JsonTextReader( new  StringReader(jsonText));
while  (reader.Read())
{
     Console.WriteLine(reader.TokenType +  "\t\t"  + reader.ValueType +  "\t\t"  + reader.Value);
}

附Newtonsoft.Json.dll下载地址:下载吧



本文转自 guwei4037  51CTO博客,原文链接:http://blog.51cto.com/csharper/1344190

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值