MVC試題及答案

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

2、碼 B.電話號碼 C.一組數字 D.QQ號7、不是正則表達是的語法規(guī)則的是？(D)A.字符匹配 B.重復匹配 C.字符定位 D.字符刪除8、下列能夠實現接收表單提交過來是數據的是？(B)A.Seeion B.FormCollection C.ViewData D.Cookie還有另一種獲取數據的方式為：Request.Form9、下列代碼執(zhí)行后產生的是超鏈接的是？( A)A. HTML.ActionLink(“txt”)B. HTML.TextBox(“txt”)C. HTML.TextArea(“txt”)C. HTML.ListBox(“txt”)10、能夠引用外部用戶控件的方法是？(C)

3、A. HTML.ActionLink(“txt”)B. HTML.TextBox(“txt”)C. HTML.RenderPartial(“txt”)C. HTML.ListBox(“txt”)編程題1、下列程序實現了分頁技術，每頁5條數據，請?zhí)顚懴聞澗€的內容： public ActionResult Index(int page)/page頁碼 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、下列程序實現了獲取文章信息列表，請?zhí)顚懴聞澗€的內容：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、下列程序實現了更新文章的功能，請?zhí)顚懴聞澗€的內容： _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、下列程序實現了通過數據操作

8、來添加文章的功能，請?zhí)顚懴聞澗€的內容： 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(); 自己編寫代碼完成下面各題一、編寫代碼完成簡單的MVC文件上傳的功能：1、視圖頁面代碼(Up.aspx)<form enctype="multipart/form-data"><input type='file' id="upfile1"><input type='submit' value='sub'></form>2、控制器頁面代碼(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); 二、編程前提：項目名為：ECa

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

12、ntroller中編寫代碼完成文章修改功能。 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、編寫Model層ArtOp類的UpdateArt方法，完成修改文章的業(yè)務邏輯。(通過存儲過程和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、編寫存儲過程UpdateArt完成數據庫中的修改功能。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;>文章對象</param> / <returns>執(zhí)行結果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("