.Net 2005 partial class 的用途2008-03-28 11:01:35 来源:中国编程网 作者:未知
一般来说,我习惯把数据库操作部分和相应的类放在一起,比如,一个 BookCollection 类就应该自己包含操作 Book 表: 一般来说,我习惯把数据库操作部分和相应的类放在一起,比如,一个 BookCollection 类就应该自己包含操作 Book 表:
public class Book
{ public string BookName; } public class BookCollection : CollectionBase { public void Add(Book b) { List.Add(b); BookAccess.SaveToDatabase(b); } } public class BookAccess { public static void SaveToDatabase(Book b) { string sql = string.Format( "Insert Into [Books] ([BookName]) Values (’{0}’)", b.BookName.Replace("’", "’’")); SqlConnection.CreateCommand(sql).ExecuteNonQuery(); } } using System;using System.Collections;public class Book{public string BookName;}public class BookCollection : CollectionBase{public void Add(Book b){List.Add(b);BookAccess.SaveToDatabase(b);}}public class BookAccess{public static void SaveToDatabase(Book b){string sql = string.Format("Insert Into [Books] ([BookName]) Values (’{0}’)",b.BookName.Replace("’", "’’"));SqlConnection.CreateCommand(sql).ExecuteNonQuery();}} 相关文章: |