基于net平臺的分層架構(gòu)實(shí)戰(zhàn)-資料下載頁
2025-06-24 03:51本頁面
【正文】 eters參數(shù)集合/param65///returns/returns66publicstaticOleDbDataReaderExecuteSQLDataReader(stringSQLCommand,OleDbParameter[]parameters)67{68OleDbConnectionconnection=newOleDbConnection(GetConnectionString())。69OleDbCommandmand=newOleDbCommand(SQLCommand,connection)。7071for(inti=0。ii++)72{73(parameters[i])。74}7576()。77OleDbDataReaderdataReader=()。78//()。7980returndataReader。81}82}83}因?yàn)榍懊嬉呀?jīng)定義了數(shù)據(jù)訪問層接口，所以實(shí)現(xiàn)數(shù)據(jù)訪問操作類就是很機(jī)械的工作了。下面僅以Admin的數(shù)據(jù)訪問操作類為例：AdminDAL:1usingSystem。2using3using4using5using6using7using89namespace10{11publicclassAdminDAL:IAdminDAL12{13///summary14///插入管理員15////summary16///paramname=admin管理員實(shí)體類/param17///returns是否成功/returns18publicboolInsert(AdminInfoadmin)19{20stringSQLCommand=insertinto[TAdmin]([Name],[Password])values(@name,@password)。21OleDbParameter[]parameters={22newOleDbParameter(name,),23newOleDbParameter(password,)24}。2526try27{28(SQLCommand,parameters)。29returntrue。30}31catch32{33returnfalse。34}35}3637///summary38///刪除管理員39////summary40///paramname=id欲刪除的管理員的ID/param41///returns是否成功/returns42publicboolDelete(intid)43{44stringSQLCommand=deletefrom[TAdmin]where[ID]=@id。45OleDbParameter[]parameters={46newOleDbParameter(id,id)47}。4849try50{51(SQLCommand,parameters)。52returntrue。53}54catch55{56returnfalse。57}58}5960///summary61///更新管理員信息62////summary63///paramname=admin管理員實(shí)體類/param64///returns是否成功/returns65publicboolUpdate(AdminInfoadmin)66{67stringSQLCommand=update[TAdmin]set[Name]=@name,[Password]=@passwordwhere[ID]=@id。68OleDbParameter[]parameters={69newOleDbParameter(id,),70newOleDbParameter(name,),71newOleDbParameter(password,)72}。7374try75{76(SQLCommand,parameters)。77returntrue。78}79catch80{81returnfalse。82}83}8485///summary86///按ID取得管理員信息87////summary88///paramname=id管理員ID/param89///returns管理員實(shí)體類/returns90publicAdminInfoGetByID(intid)91{92stringSQLCommand=select*from[TAdmin]where[ID]=@id。93OleDbParameter[]parameters={94newOleDbParameter(id,id)95}。9697try98{99OleDbDataReaderdataReader=(SQLCommand,parameters)。100if(!)101{102thrownewException()。103}104105AdminInfoadmin=newAdminInfo()。106()。107=(int)dataReader[ID]。108=(string)dataReader[Name]。109=(string)dataReader[Password]。110111returnadmin。112}113catch114{115returnnull。116}117}118119///summary120///按用戶名及密碼取得管理員信息121////summary122///paramname=name用戶名/param123///paramname=password密碼/param124///returns管理員實(shí)體類，不存在時(shí)返回null/returns125publicAdminInfoGetByNameAndPassword(stringname,stringpassword)126{127stringSQLCommand=select*from[TAdmin]where[Name]=@nameand[Password]=@password。128OleDbParameter[]parameters={129newOleDbParameter(name,name),130newOleDbParameter(password,password),131}。132133try134{135OleDbDataReaderdataReader=(SQLCommand,parameters)。136if
環(huán)評公示相關(guān)推薦
鄂ICP備17016276號-1