1、数量5、把压缩包内三篇短文放置在目录Books下。二、试题1、面向对象题(20分)。周三下午1:30 6/312 创建一个抽象类:书类(Book),包含书号BookID、书名BookName,价格Price,包含一个抽象方法int FindWord(string word);创建一个教材类(TeachingMaterial)继承于书类,包含内容Content属性信息;实现FindWord ()方法,要求根据输入参数word在Content中查找出现的次数。2、控件应用题(30分)新建模板页MasterPage.master,模板页含有站点地图信息;并新建一个内容页TestControl.asp
2、x,如下图构建注册页面,使用相对应的验证控件进行输入数据的有效性验证。点击取消按钮清除文本框内已填写数据,点击确定按钮进行提交。3、数据库题(50分)主页面MainPage.aspx主要由一个GridView构成,页面打开时GridView显示Book表中的信息,并允许选择删除一条Book信息(注意如删除书本信息,必须同时考虑删除订单信息)-using System;using System.Collections.Generic;using System.Linq;using System.Web;/ / Student 的摘要说明/summarypublic class Student:H
3、uman /. public Student() / / TODO: 在此处添加构造函数逻辑 public override void Work() / public void getInfo(params int numbers) foreach (int num in numbers) /if num is Prime ouput num; private bool isPrime(int num) return true;public abstract class Human public int Height get; set; public float Weight get; pri
4、vate string _name; public string Name get return _name; set _name = value; public abstract void Work();!DOCTYPE htmlhtml xmlns=http:/www.w3.org/1999/xhtmlhead runat=servermeta http-equiv=Content-Type content=text/html; charset=utf-8/ /title/headbodyform id=form1 runat=div /divasp:DropDownList ID=Dro
5、pDownList1 AutoPostBack=True DataSourceID=SqlDataSource1 DataTextField=Scholl DataValueField=SchoolId/asp:DropDownListLabel ID=Label1 Text=LabelLabelGridView ID=GridView1 AutoGenerateColumns=False DataKeyNames=StuIdSqlDataSource2ColumnsBoundField DataField= HeaderText=学号 ReadOnly= SortExpression= /S
6、tuName姓名学院/ColumnsGridViewDropDownList2SqlDataSource ID= ConnectionString=%$ ConnectionStrings:ConnectionString % SelectCommand=SELECT Student.StuId, Student.StuName, School.Scholl FROM Student INNER JOIN School ON Student.SchoolId = School.SchoolId WHERE (Student.SchoolId = SchoolID)SelectParameter
7、sControlParameter ControlID= Name=SchoolID PropertyName=SelectedValue/SelectParametersSqlDataSourceButton ID=Button1 OnClick=Button1_ClickButtonSELECT * FROM School/form/body/html-using System.Web.UI;using System.Web.UI.WebControls;using System.Data.SqlClient;using System.Configuration;public partia
8、l class _Default : System.Web.UI.Page protected void Page_Load(object sender, EventArgs e) protected void Button1_Click(object sender, EventArgs e) SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStringsConnectionString.ConnectionString); con.Open(); SqlCommand cmd = con.CreateC
9、ommand(); cmd.CommandText = update student set schoolId=+DropDownList2.SelectedValue+ where schoolId=+DropDownList1.SelectedValue; cmd.ExecuteNonQuery();select Count(*) from student where SchoolId=+DropDownList2.SelectedValue; Label1.Text = cmd.ExecuteScalar().ToString(); con.Close();-Default.aspx.c
10、supdate stuInfo set schoolID=where schoolID =select count(*) from stuInfo where schoolID=-DOCTYPE html PUBLIC -/W3C/DTD XHTML 1.0 Transitional/EN /www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd DeleteCommand=DELETE FROM Student WHERE StuID = StuID InsertCommand=INSERT INTO Student (StuID, StuName,
11、 SchoolID) VALUES (StuID, StuName, SchoolID)SELECT * FROM Student UpdateCommand=UPDATE Student SET StuName = StuName, SchoolID = SchoolID WHERE StuID = StuIDDeleteParametersParameter Name=StuID Type=String/DeleteParametersInsertParameters/InsertParametersUpdateParameters/UpdateParametersbr / 原先的学院ID为: 学院学生数量:Label2Labe2 选择要更新的学院:ListItem Selected=计算机学院软件工程学院 0) Response.Write(更新成功! GridView1.DataBind(); /获取连接字符串 conn.Open(
copyright@ 2008-2022 冰豆网网站版权所有
经营许可证编号:鄂ICP备2022015515号-1