学生管理web程序代码

《学生管理web程序代码》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、个人收集整理勿做商业用途房屋销售管理系统一、HouseManagerDAL数据访问层中设计三个类：CustomerService.cs和DBhelper.cs和houseserver.cs(1)在CustomerService.cs中usingSystem;usingSystem.Collections.Generic;usingSystem.Text;usingSystem.Data;usingSystem.Data.SqlClient;usingHouseManager.Models;namespaceHouseManage

2、r.DAL{publicstaticclassCustomerService{///根据提供地登录账号查询用户信息publicstaticCustomerGetCustomerByLoginName(stringname)资料个人收集整理，勿做商业用途{stringsql=string.Format("select*fromCustomerswhereLoginName='{0}'",name);资料个人收集整理，勿做商业用途returnGetCustomerBySQL(sql);}///根据用户ID查询用户信息publicst

3、aticCustomerGetCustomerById(intid){stringsql=string.Format("select*fromCustomerswhereCustomerId={0}",id);资料个人收集整理，勿做商业用途returnGetCustomerBySQL(sql);}///私有方法，提供公共方法查询用户信息使用privatestaticCustomerGetCustomerBySQL(stringsql)资料个人收集整理，勿做商业用途{using(SqlConnectionconn=newSqlCo

4、nnection(DBHelper.connectString))资料个人收集整理，勿做商业用途{Customerc=null;try{conn.Open();SqlCommandcmd=newSqlCommand(sql,conn);SqlDataReadersdr=cmd.ExecuteReader();if(sdr.Read()){c=newCustomer();c.Id=(int)sdr["CustomerId"];c.LoginName=sdr["LoginName"].ToString();c.Password=sd

5、r["Password"].ToString();21/21个人收集整理勿做商业用途}}catch(Exceptionex){Console.WriteLine(ex.Message);}finally{conn.Close();}returnc;}}}}(2)在DBHelper中usingSystem;usingSystem.Collections.Generic;usingSystem.Text;namespaceHouseManager.DAL{publicstaticclassDBHelper{publicstaticr

6、eadonlystringconnectString="server=.;database=HouseDB;uid=sa;pwd=123456";资料个人收集整理，勿做商业用途}}(3)在HouseService中usingSystem;usingSystem.Collections.Generic;usingSystem.Text;usingSystem.Data;usingSystem.Data.SqlClient;usingHouseManager.Models;namespaceHouseManager.DAL{publ

7、icstaticclassHouseService{///获取所有发布地房屋信息publicstaticIListGetAllHouse(){Listhouses=newList();using(SqlConnectionconn=newSqlConnection(DBHelper.connectString))资料个人收集整理，勿做商业用途21/21个人收集整理勿做商业用途{try{conn.Open();SqlCommandcmd=newSqlCommand("select*from

8、Houses",conn);资料个人收集整理，勿做商业用途SqlDataReadersdr=cmd.ExecuteReader();while(sdr.Read()){Househ=newHouse();h.Id=(int)sdr["HouseId"];h.Ty