usingSqystem.Data;usingSystem.Data.SqlClient;usingSystem.Configuration;//引用一个库Ststem.configuration//修改根目录的web.config文件<configuration>//最外层节点......<connectionStrings><addname="connString"connectionString="Sqerver=.;DataBase=StudentManage;Uid=sa;Pwd=scale2018@"></connectionStrings>......</configuration>//数据库通用访问类classSQLHelper{//数据库连接字符串privatestaticstringconnString=ConfigurationManager.ConnectionStrings["connString"].ToString();//写入日志文件publicvoidWriteLog(stringmsg){FileStreamfs=FileStream("1.log",fileMode.Append);StreamWritersw=newStreamWriter(fs);sw.writeLine(DateTime.Now.ToString()+""+msg);sw.Close();fs.Close();}//数据库更新publicstaticintUpdate(stringsql){SqlConnectionconn=newSqlConnection(connString);SqlConnectioncmd=newSqlCommand(sql,conn);try{conn.Open();returncmd.ExecuteNoQuery();}catch(Exceptionex){WriteLog("执行更新时发生异常"+ex.Message);throwex;}finally{conn.Close();}}publicstaticobjectGetSingleResult(stringsql){Sqlconnectionconn=newSqlConnection(connString);SqlCommandcmd=newSqlCommand(sql,conn);try{conn.Open();returncmd.ExecuteScalar();}catch(Exceptionex){WriteLog("执行单一结果查询"+ex.message);throwex;}finally{conn.Close();}}//返回结果集publicstaticSqlDataReaderGetReader(stringsql){SqlConnectionconn=newSqlConnection(connString);SqlCommandcmd=newSqlCommand(sql,conn);try{conn.Open();retruncmd.ExecuteReader(CommandBehavior.CloseConnection);//不能在此关闭连接}catch(Exceptionex){WriteLog("读取结果集发生异常"+ex.message);throwex;}}//带参数的存储过程publicstaticintUpdate(stringsqlOrProcedureName,SqlParameter[]param,boolisProcedure){SqlConnectionconn=newSqlConnection(connString);SqlConnectioncmd=newSqlCommand(sqlOrProcedureName,conn);if(isProcedure){cmd.CommandType=CommmandType.StoredProcedure;}try{conn.Open();cmd.Parameters.AddRang(param);returncmd.ExecuteNoQuery();}catch(Exceptionex){WriteLog("执行更新时发生异常"+ex.Message);throwex;}finally{conn.Close();}}}

//DAL调用数据访问模块

classAdminService{publicUseInfoLogin(UseInfoobjUser){stringsql="selectUserNamefromUserTablewhereloginid=@LoginIdandLoginPwn=@LoginPwn";SqlParameter[]param=newSqlParameter[];{newSqlPrameter("@LoginId",UseInfo.LoginId),newSqlParameter("@LoginPwd",UseInfo.LoginPwd)};try{SqlDataReaderobjReader=SQLHelper.GetReader(sql,param,false);if(objReader.Read()){objUser.UserName=objReader["UserName"].ToString();}else{objUser=null;}objReader.Close();}catch(Exceptionex){thrownewException("用户登录异常"+ex.message);}returnobjUser;}}