Linq to XML 增删改查

转自：http://de.cel.blog.163.com/blog/static/5145123620119983945167/

public class DataBaseInfo

        {

            public string ID { get; set; }

            public string Company { get; set; }

            public string Server { get; set; }

            public string DataBase { get; set; }

            public string UserName { get; set; }

            public string Password { get; set; }

 

            private static XDocument doc = new XDocument();

            public static string filePath = ".DataBaseInfo.xml";

 

            public DataBaseInfo() {

                doc = XDocument.Load(filePath);

            }

            public DataBaseInfo(string filepath):this()

            {

                filePath = filepath;

            }

 

            /// <summary>

            /// 增

            /// </summary>

            /// <returns></returns>

            public  bool Add()

            {

                XElement db = new XElement("DataBase",new XAttribute("id",ID),new XElement("company",new XAttribute("value",Company)),new XElement("server",Server)),new XElement("database",DataBase)),new XElement("username",UserName)),new XElement("password",Password))

                   );

                try

                {

                    //用XElement的Add方法

                    //XElement doc = XElement.Load(filePath);

                    //doc.Add(db);

 

                    //用XDocument的Add方法

                    doc.Element("DataBases").Add(db);

                    doc.Save(filePath);

                    return true;

                }

                catch

                {

                    return false;

                }

            }

            /// <summary>

            /// 删

            /// </summary>

            /// <param name="id"></param>

            /// <returns></returns>

            public static bool Remove(string id)

            {

                XElement xe = (from db in doc.Element("DataBases").Elements("DataBase") where db.Attribute("id").Value == id select db).Single() as XElement;

                try

                {

                    xe.Remove();

                    doc.Save(filePath);

                    return true;

                }

                catch

                {

                    return false;

 

                }

 

            }

            /// <summary>

            /// 改

            /// </summary>

            /// <returns></returns>

            public bool Modify()

            {

                XElement xe = (from db in doc.Element("DataBases").Elements("DataBase") where db.Attribute("id").Value.ToString() == ID select db).Single();

                try

                {

                    xe.Element("company").Attribute("value").Value = Company;

                    xe.Element("server").Attribute("value").Value = Server;

                    xe.Element("database").Attribute("value").Value = DataBase;

                    xe.Element("username").Attribute("value").Value = UserName;

                    xe.Element("password").Attribute("value").Value = Password;

                    doc.Save(filePath);

                    return true;

                }

                catch

                {

                    return false;

                }

 

            }

            /// <summary>

            /// 查

            /// </summary>

            /// <returns></returns>

            public List<DataBaseInfo> GetAll()

            {

 

                List<DataBaseInfo> dbs = (from db in doc.Element("DataBases").Elements("DataBase")

                                          select new DataBaseInfo

                                          {

                                              ID = db.Attribute("id").Value.ToString(),Company = db.Element("company").Attribute("value").Value.ToString(),Server = db.Element("server").Attribute("value").Value.ToString(),DataBase = db.Element("database").Attribute("value").Value.ToString(),UserName = db.Element("username").Attribute("value").Value.ToString(),Password = db.Element("password").Attribute("value").Value.ToString()

 

                                          }).ToList();

                return dbs;

            }

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!