MVC试题及答案

1、1、下列不是MVC的组成部分的是？ （D）A.Model B.Controller C.View D.Bll2、下列不是MVC的优点的是？ （ D）A.结构清晰 B.易于维护 C.有利于软件工程化管理 D.占用资源少3、正则表达式的命名控件隶属于？（B）4、下列不是MVC的缺点的是？（D）A.增加了系统结构的复杂性 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、不是正则表达是的语法规则的是？(D)A.字符匹配 B.重复匹配 C.字符定位 D.字符删除8、下列能够实现接收表单提交过来是数据的是？(B)A.Seeion B.FormCollection C.ViewData D.Cookie还有另一种获取数据的方式为：Request.Form9、下列代码执行后产生的是超链接的是？( 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条数据，请填写下划线的内容： 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、下列程序实现了获取文章信息列表，请填写下划线的内容：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、下列程序实现了更新文章的功能，请填写下划线的内容： _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、来添加文章的功能，请填写下划线的内容： 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类，用来实现修改文章的业务逻辑。公共类：DB.cs用过来实现数据库的操作。公共类中有功能如下：连接字符串：ConStr 字符串类型执行存储过程：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方法，完成修改文章的业务逻辑。(通过存储过程和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>执行结果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("