XML操作多行数据(即DataTable)的类(可直接使用)
来源:互联网 发布:eclipse的js插件 编辑:程序博客网 时间:2024/05/16 13:04
using System;
using System.Collections.Generic;
using System.Text;
using System.Xml;
using System.Windows.Forms;
namespace ParseXML
{
/// <summary>
/// XML文件操作类
/// </summary>
class XMLFunc
{
/// <summary>
/// 创建XML文档
/// </summary>
/// <param name="path"></param>
public static void CreateXML(string path, Student stu)
{
XmlTextWriter xw = new XmlTextWriter(path, Encoding.UTF8);
xw.WriteStartDocument();
xw.Formatting = Formatting.Indented;
xw.WriteStartElement("Students");
xw.WriteStartElement("Student");
xw.WriteStartElement("SID");
xw.WriteStartAttribute("id");
xw.WriteValue(stu.SID.ToString());
xw.WriteEndAttribute();
xw.WriteValue(stu.SID.ToString());
xw.WriteEndElement();
xw.WriteStartElement("Name");
xw.WriteValue(stu.Name);
xw.WriteEndElement();
xw.WriteStartElement("Age");
xw.WriteValue(stu.Age.ToString());
xw.WriteEndElement();
xw.WriteStartElement("Sex");
xw.WriteValue(stu.Sex);
xw.WriteEndElement();
xw.WriteStartElement("Address");
xw.WriteValue(stu.Address);
xw.WriteEndElement();
xw.WriteEndElement();
xw.WriteEndElement();
xw.Flush();
xw.Close();
MessageBox.Show(path + " 创建成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
/// <summary>
/// 追加
/// </summary>
/// <param name="path">XML文件路径</param>
/// <param name="stu">学员</param>
public static void Append(string path, Student stu)
{
XmlDocument xmlDoc = new XmlDocument();
xmlDoc.Load(path);
XmlNode xnl = xmlDoc.DocumentElement;
for (int j = 0; j < xnl.ChildNodes.Count; j++)
{
if (xnl.ChildNodes[j].ChildNodes[0].Attributes["id"].Value == stu.SID.ToString())
{
MessageBox.Show("已经包含了一个学号为:" + stu.SID + " 的学员!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
}
XmlNode node = xmlDoc.SelectSingleNode("Students");
XmlElement xes = xmlDoc.CreateElement("Student");
XmlElement xeid = xmlDoc.CreateElement("SID");
xeid.SetAttribute("id", stu.SID.ToString());
xeid.InnerText = stu.SID.ToString();
XmlElement xename = xmlDoc.CreateElement("Name");
xename.InnerText = stu.Name;
XmlElement xeage = xmlDoc.CreateElement("Age");
xeage.InnerText = stu.Age.ToString();
XmlElement xesex = xmlDoc.CreateElement("Sex");
xesex.InnerText = stu.Sex;
XmlElement xeadd = xmlDoc.CreateElement("Address");
xeadd.InnerText = stu.Address;
xes.AppendChild(xeid);
xes.AppendChild(xename);
xes.AppendChild(xeage);
xes.AppendChild(xesex);
xes.AppendChild(xeadd);
node.AppendChild(xes);
xmlDoc.Save(path);
MessageBox.Show("追加成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
/// <summary>
/// 修改
/// </summary>
/// <param name="path">XML文件路径</param>
/// <param name="id">学号</param>
/// <param name="stu">学员对象</param>
public static void Edit(string path, string id, Student stu)
{
XmlDocument xmlDoc = new XmlDocument();
xmlDoc.Load(path);
XmlNode xnl = xmlDoc.DocumentElement;
XmlNode node = null;
for (int j = 0; j < xnl.ChildNodes.Count; j++)
{
if (xnl.ChildNodes[j].ChildNodes[0].Attributes["id"].Value == id)
{
node = xnl.ChildNodes[j];
}
}
if (node == null)
return;
node.ChildNodes[1].InnerText = stu.Name;
node.ChildNodes[2].InnerText = stu.Age.ToString();
node.ChildNodes[3].InnerText = stu.Sex;
node.ChildNodes[4].InnerText = stu.Address;
xmlDoc.Save(path);
MessageBox.Show("修改成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
/// <summary>
/// 删除操作
/// </summary>
/// <param name="path">XML路径</param>
/// <param name="id">删除的ID</param>
public static void Delete(string path, string id)
{
XmlDocument xmlDoc = new XmlDocument();
xmlDoc.Load(path);
XmlNode xnl = xmlDoc.DocumentElement;
XmlNode node = null;
for (int j = 0; j < xnl.ChildNodes.Count; j++)
{
if (xnl.ChildNodes[j].ChildNodes[0].Attributes["id"].Value == id)
{
node = xnl.ChildNodes[j];
}
}
if (node == null)
return;
node.ParentNode.RemoveChild(node);
xmlDoc.Save(path);
MessageBox.Show("删除成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
/// <summary>
/// 加载信息
/// </summary>
/// <param name="path"></param>
/// <returns></returns>
public static IList<Student> LoadXML(string path)
{
IList<Student> stuList = new List<Student>();
XmlDocument xmlDoc = new XmlDocument();
xmlDoc.Load(path);
XmlNode node = xmlDoc.DocumentElement;
for (int i = 0; i < node.ChildNodes.Count; i++)
{
XmlNode xnl = node.ChildNodes[i];
Student stu = new Student();
stu.SID = Convert.ToInt32(xnl["SID"].InnerText);
stu.Name = xnl["Name"].InnerText;
stu.Age = Convert.ToInt32(xnl["Age"].InnerText);
stu.Sex = xnl["Sex"].InnerText;
stu.Address = xnl["Address"].InnerText;
stuList.Add(stu);
}
return stuList;
}
}
}
using System.Collections.Generic;
using System.Text;
using System.Xml;
using System.Windows.Forms;
namespace ParseXML
{
/// <summary>
/// XML文件操作类
/// </summary>
class XMLFunc
{
/// <summary>
/// 创建XML文档
/// </summary>
/// <param name="path"></param>
public static void CreateXML(string path, Student stu)
{
XmlTextWriter xw = new XmlTextWriter(path, Encoding.UTF8);
xw.WriteStartDocument();
xw.Formatting = Formatting.Indented;
xw.WriteStartElement("Students");
xw.WriteStartElement("Student");
xw.WriteStartElement("SID");
xw.WriteStartAttribute("id");
xw.WriteValue(stu.SID.ToString());
xw.WriteEndAttribute();
xw.WriteValue(stu.SID.ToString());
xw.WriteEndElement();
xw.WriteStartElement("Name");
xw.WriteValue(stu.Name);
xw.WriteEndElement();
xw.WriteStartElement("Age");
xw.WriteValue(stu.Age.ToString());
xw.WriteEndElement();
xw.WriteStartElement("Sex");
xw.WriteValue(stu.Sex);
xw.WriteEndElement();
xw.WriteStartElement("Address");
xw.WriteValue(stu.Address);
xw.WriteEndElement();
xw.WriteEndElement();
xw.WriteEndElement();
xw.Flush();
xw.Close();
MessageBox.Show(path + " 创建成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
/// <summary>
/// 追加
/// </summary>
/// <param name="path">XML文件路径</param>
/// <param name="stu">学员</param>
public static void Append(string path, Student stu)
{
XmlDocument xmlDoc = new XmlDocument();
xmlDoc.Load(path);
XmlNode xnl = xmlDoc.DocumentElement;
for (int j = 0; j < xnl.ChildNodes.Count; j++)
{
if (xnl.ChildNodes[j].ChildNodes[0].Attributes["id"].Value == stu.SID.ToString())
{
MessageBox.Show("已经包含了一个学号为:" + stu.SID + " 的学员!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
}
XmlNode node = xmlDoc.SelectSingleNode("Students");
XmlElement xes = xmlDoc.CreateElement("Student");
XmlElement xeid = xmlDoc.CreateElement("SID");
xeid.SetAttribute("id", stu.SID.ToString());
xeid.InnerText = stu.SID.ToString();
XmlElement xename = xmlDoc.CreateElement("Name");
xename.InnerText = stu.Name;
XmlElement xeage = xmlDoc.CreateElement("Age");
xeage.InnerText = stu.Age.ToString();
XmlElement xesex = xmlDoc.CreateElement("Sex");
xesex.InnerText = stu.Sex;
XmlElement xeadd = xmlDoc.CreateElement("Address");
xeadd.InnerText = stu.Address;
xes.AppendChild(xeid);
xes.AppendChild(xename);
xes.AppendChild(xeage);
xes.AppendChild(xesex);
xes.AppendChild(xeadd);
node.AppendChild(xes);
xmlDoc.Save(path);
MessageBox.Show("追加成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
/// <summary>
/// 修改
/// </summary>
/// <param name="path">XML文件路径</param>
/// <param name="id">学号</param>
/// <param name="stu">学员对象</param>
public static void Edit(string path, string id, Student stu)
{
XmlDocument xmlDoc = new XmlDocument();
xmlDoc.Load(path);
XmlNode xnl = xmlDoc.DocumentElement;
XmlNode node = null;
for (int j = 0; j < xnl.ChildNodes.Count; j++)
{
if (xnl.ChildNodes[j].ChildNodes[0].Attributes["id"].Value == id)
{
node = xnl.ChildNodes[j];
}
}
if (node == null)
return;
node.ChildNodes[1].InnerText = stu.Name;
node.ChildNodes[2].InnerText = stu.Age.ToString();
node.ChildNodes[3].InnerText = stu.Sex;
node.ChildNodes[4].InnerText = stu.Address;
xmlDoc.Save(path);
MessageBox.Show("修改成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
/// <summary>
/// 删除操作
/// </summary>
/// <param name="path">XML路径</param>
/// <param name="id">删除的ID</param>
public static void Delete(string path, string id)
{
XmlDocument xmlDoc = new XmlDocument();
xmlDoc.Load(path);
XmlNode xnl = xmlDoc.DocumentElement;
XmlNode node = null;
for (int j = 0; j < xnl.ChildNodes.Count; j++)
{
if (xnl.ChildNodes[j].ChildNodes[0].Attributes["id"].Value == id)
{
node = xnl.ChildNodes[j];
}
}
if (node == null)
return;
node.ParentNode.RemoveChild(node);
xmlDoc.Save(path);
MessageBox.Show("删除成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
/// <summary>
/// 加载信息
/// </summary>
/// <param name="path"></param>
/// <returns></returns>
public static IList<Student> LoadXML(string path)
{
IList<Student> stuList = new List<Student>();
XmlDocument xmlDoc = new XmlDocument();
xmlDoc.Load(path);
XmlNode node = xmlDoc.DocumentElement;
for (int i = 0; i < node.ChildNodes.Count; i++)
{
XmlNode xnl = node.ChildNodes[i];
Student stu = new Student();
stu.SID = Convert.ToInt32(xnl["SID"].InnerText);
stu.Name = xnl["Name"].InnerText;
stu.Age = Convert.ToInt32(xnl["Age"].InnerText);
stu.Sex = xnl["Sex"].InnerText;
stu.Address = xnl["Address"].InnerText;
stuList.Add(stu);
}
return stuList;
}
}
}
- XML操作多行数据(即DataTable)的类(可直接使用)
- XML简单操作类、只可操作单行数据(可直接使用)
- Datatable 操作行数据
- 利用JQGrid动态删除多行数据,行号(即删除/增加数据)变化的问题
- Oracle 执行计划(2)-基数 cardinality【即估算一个操作返回的行数】
- 模板类多线程(可直接使用)
- C#开发之DataTable多行数据的合并
- Xml与DataTable等使用的类
- JAXB序列化和反序列化XML源码(可直接使用)
- Vue 工具类整理 完整案例(可直接使用)
- Android中使用列表画表格(可动态添加行数据)
- 使用反射机制将DataTable某行数据赋给一个类
- 直接复制datagrid的行数据
- PB里协调多数据窗口数据操纵的一种方法(即多Tab标签可同时保存)
- SqlServer实现oracle10g的 wmsys.wm_concat()/使用自连接、for xml path('')和stuff合并显示多行数据到一行中
- CTE+操作性语句(删除无主键的相同的多行数据)+CTE操作技巧
- dataTable交换两行数据
- 从gridview选中拖拽的多行数据并放在一个datatable中执行DataTable中的查询返回新的DataTable
- 委差的含义
- 复合服务 Composite Services
- Android 对话框(Dialog)大全 建立你自己的对话框
- IOCP原理
- navigationbar,tabbar,toolbar添加背景
- XML操作多行数据(即DataTable)的类(可直接使用)
- 编程技术面试的五大要点
- 再谈登录服的实现
- IT全能王
- gcc编译报错:程序中有游离的‘\357’‘\273’‘\277’等 解决方法
- 苹果标志乔布斯重生
- include,viewStub标签的使用
- Log Shipping VS Database Mirroring
- jquery常用方法