MVC試題及答案

1、1、下列不是MVC的組成部分的是？ （D）A.Model B.Controller C.View D.Bll2、下列不是MVC的優(yōu)點(diǎn)的是？ （ D）A.結(jié)構(gòu)清晰 B.易于維護(hù) C.有利于軟件工程化管理 D.占用資源少3、正則表達(dá)式的命名控件隸屬于？（B）4、下列不是MVC的缺點(diǎn)的是？（D）A.增加了系統(tǒng)結(jié)構(gòu)的復(fù)雜性 B.視圖與控制器間的過(guò)于緊密的連接 C.視圖對(duì)模型數(shù)據(jù)的低效率訪問(wèn) D.不能滿足用戶(hù)的需求變化5、下列不是常用URL模型的結(jié)構(gòu)參數(shù)的是？（D）A.Controller B.Id C.Action D.Model6、正則表達(dá)式“d3,4-?d6,8”代表的可能意思是？(B)A.手機(jī)號(hào)

2、碼 B.電話號(hào)碼 C.一組數(shù)字 D.QQ號(hào)7、不是正則表達(dá)是的語(yǔ)法規(guī)則的是？(D)A.字符匹配 B.重復(fù)匹配 C.字符定位 D.字符刪除8、下列能夠?qū)崿F(xiàn)接收表單提交過(guò)來(lái)是數(shù)據(jù)的是？(B)A.Seeion B.FormCollection C.ViewData D.Cookie還有另一種獲取數(shù)據(jù)的方式為：Request.Form9、下列代碼執(zhí)行后產(chǎn)生的是超鏈接的是？( A)A. HTML.ActionLink(“txt”)B. HTML.TextBox(“txt”)C. HTML.TextArea(“txt”)C. HTML.ListBox(“txt”)10、能夠引用外部用戶(hù)控件的方法是？(C)

3、A. HTML.ActionLink(“txt”)B. HTML.TextBox(“txt”)C. HTML.RenderPartial(“txt”)C. HTML.ListBox(“txt”)編程題1、下列程序?qū)崿F(xiàn)了分頁(yè)技術(shù)，每頁(yè)5條數(shù)據(jù)，請(qǐng)?zhí)顚?xiě)下劃線的內(nèi)容： public ActionResult Index(int page)/page頁(yè)碼 ECard.Models.ArtPage pg= new ECard.Models.ArtPage(); var model = ECard.Models.ArtOp.GetList()._Skip(page*5).Take(5)_; pg.Arts

4、 = model; pg.NextPage = page + 1; pg.PrevtPage = page - 1; return View(pg); 2、下列程序?qū)崿F(xiàn)了獲取文章信息列表，請(qǐng)?zhí)顚?xiě)下劃線的內(nèi)容：public static List<Art> GetList() List<Art> retArts = new List<Art>(); SqlDataReader dr = DB.ExecuteReader(CommandType.StoredProcedure, "GetArt", null); while (dr.Read(

5、) Art myart = new Art(); myart.Id = Convert.ToInt32(dr"Id"); myart.Title = dr"Title".ToString(); myart.Key = dr"Key".ToString(); myart.Source = dr"Source".ToString(); myart.Content = dr"Content".ToString(); myart.Point = Convert.ToInt32(dr"Point

6、"); myart.Mid = Convert.ToInt32(dr"Mid"); _retArts.Add(myart)_; return retArts; 3、下列程序?qū)崿F(xiàn)了更新文章的功能，請(qǐng)?zhí)顚?xiě)下劃線的內(nèi)容： _SqlParameter Params =new sqlparameter_ new SqlParameter("Id",myart.Id), new SqlParameter("Title",myart.Title), new SqlParameter("Key",myart.Key),

7、new SqlParameter("Source",myart.Source), new SqlParameter("Content",myart.Content), new SqlParameter("Point",myart.Point), new SqlParameter("Mid",myart.Mid), ; ret = DB.ExecuteNonQuery(CommandType.StoredProcedure, "UpdateArt", Params);4、下列程序?qū)崿F(xiàn)了通過(guò)數(shù)據(jù)操作

8、來(lái)添加文章的功能，請(qǐng)?zhí)顚?xiě)下劃線的內(nèi)容： AcceptVerbs(_HTTPVerbs.POST_) public ActionResult HAdd(_formco_ form) ECard.Models.Art myart = new ECard.Models.Art(); myart.Id = 0; myart.Title = form"txtTitle" myart.Key = form"txtKey" myart.Content = form"txtContent" ECard.Models.ArtOp.AddToArt(_m

9、yart_); return View(); 自己編寫(xiě)代碼完成下面各題一、編寫(xiě)代碼完成簡(jiǎn)單的MVC文件上傳的功能：1、視圖頁(yè)面代碼(Up.aspx)<form enctype="multipart/form-data"><input type='file' id="upfile1"><input type='submit' value='sub'></form>2、控制器頁(yè)面代碼(fileController.Up) if (Request.Files.Cou

10、nt != 0) upload.UploadFilePath = string.Format("0:yyyyMMddHHmmssffff.rm", DateTime.Now); var file = Request.Files0; if (file != null && file.ContentLength > 0) string savePath = Server.MapPath("/Uploads/" + upload.UploadFilePath); file.SaveAs(savePath); 二、編程前提：項(xiàng)目名為：ECa

11、rd文章表：Art<ID,Title,Author,Content,Point,AddTime> ID主，AddTime自動(dòng)獲取視圖：View文件夾的Art文件夾下的Add.aspx視圖頁(yè)面，有實(shí)現(xiàn)添加的HTML代碼?？刂破鳎篊ontroller文件夾的ArtController.cs文件中有Update方法。模型：Model文件夾下有ArtOp類(lèi)，用來(lái)實(shí)現(xiàn)修改文章的業(yè)務(wù)邏輯。公共類(lèi)：DB.cs用過(guò)來(lái)實(shí)現(xiàn)數(shù)據(jù)庫(kù)的操作。公共類(lèi)中有功能如下：連接字符串：ConStr 字符串類(lèi)型執(zhí)行存儲(chǔ)過(guò)程：ExecuteNonQuery(CommandType,存儲(chǔ)過(guò)程名,參數(shù))1、在控制器ArtCo

12、ntroller中編寫(xiě)代碼完成文章修改功能。 public ActionResult Update (FormCollection forms) int id = Convert.ToInt32(forms"Hide"); Art article=Ecard.Models.ArtOp.GetList().First(c=>c.ID=id); article.ID = id; article.Title=forms“txtTile” article.Author=forms“txtAuthor”;article.Content=form“txtContent”;arti

13、cl.AddTime=DateTime.Now; int val=Ecard.Models.ArtOp.UpdateArt(article); if (val > 0) return RedirectToAction("List?page=0"); else return View("Erro.html"); 2、編寫(xiě)Model層ArtOp類(lèi)的UpdateArt方法，完成修改文章的業(yè)務(wù)邏輯。(通過(guò)存儲(chǔ)過(guò)程和SqlParameter完成)public static int UpdateArt(Art myart) int ret = 0; SqlPa

14、rameter Params = new SqlParameter new SqlParameter("Id",myart.Id), new SqlParameter("Title",myart.Title), new SqlParameter("Content",myart.Content), new SqlParameter("Point",myart.Point), new SqlParameter("AddTime",myart.AddTime), ; ret = DB.ExecuteN

15、onQuery(CommandType.StoredProcedure, "UpdateArt", Params); return ret; 3、編寫(xiě)存儲(chǔ)過(guò)程UpdateArt完成數(shù)據(jù)庫(kù)中的修改功能。create proc dbo.UpdateArtId int,Title varchar(100),Author varchar(100),Content text ,Point int ,AddTime datetimeasupdate dbo.Art set Title=Title,Author=Author,Content=Content,Point=Point,Add

16、Time=AddTimewhere Id=id注視下面為一些常用的代碼：下面為增刪改查的代碼：using System;using System.Collections.Generic;using System.Linq;using System.Web;using System.Data;using System.Data.SqlClient;namespace ECard.Models public class Art public int Id get; set; public string Title get; set; public string Key get; set; publ

17、ic string Source get; set; public string Content get; set; public int Point get; set; public int Mid get; set; public DateTime AddTime get; set; public class ArtOp public static List<Art> GetList() List<Art> retArts = new List<Art>(); SqlDataReader dr = DB.ExecuteReader(CommandType

18、.StoredProcedure, "GetArt", null); while (dr.Read() Art myart = new Art(); myart.Id = Convert.ToInt32(dr"Id"); myart.Title = dr"Title".ToString(); myart.Key = dr"Key".ToString(); myart.Source = dr"Source".ToString(); myart.Content = dr"Content&q

19、uot;.ToString(); myart.Point = Convert.ToInt32(dr"Point"); myart.Mid = Convert.ToInt32(dr"Mid"); retArts.Add(myart); return retArts; / <summary> / 顯示文章 / </summary> / <param name="id"></param> / <returns></returns> public static Art a

20、rtShow(int id) Art myart = new Art(); SqlDataReader dr = DB.ExecuteReader(CommandType.StoredProcedure, "getshow", new SqlParameter("id", id); while (dr.Read() myart.Id = Convert.ToInt32(dr"Id"); myart.Title = dr"Title".ToString(); myart.Key = dr"Key"

21、.ToString(); myart.Source = dr"Source".ToString(); myart.Content = dr"Content".ToString(); myart.Point = Convert.ToInt32(dr"Point"); myart.Mid = Convert.ToInt32(dr"Mid"); return myart; / <summary> / 添加文章 / </summary> / <param name="myart&qu

22、ot;>文章對(duì)象</param> / <returns>執(zhí)行結(jié)果0 成功 1失敗</returns> public static int AddToArt(Art myart) int ret = 0; SqlParameter Params = new SqlParameter new SqlParameter("Id",myart.Id), new SqlParameter("Title",myart.Title), new SqlParameter("Key",myart.Key), n

23、ew SqlParameter("Source",myart.Source), new SqlParameter("Content",myart.Content), new SqlParameter("Point",myart.Point), new SqlParameter("Mid",myart.Mid), ; ret = DB.ExecuteNonQuery(CommandType.StoredProcedure, "AddArt", Params); return ret; / <summary> / 更新文章 / </summary> / <param name="myart"></param> / <returns></returns> public static int UpdateArt(Art myart) int ret = 0; SqlParameter Params = new SqlParameter new SqlParameter("