杭电aspnet期末样卷文档格式.docx
《杭电aspnet期末样卷文档格式.docx》由会员分享,可在线阅读,更多相关《杭电aspnet期末样卷文档格式.docx(21页珍藏版)》请在冰豆网上搜索。
![杭电aspnet期末样卷文档格式.docx](https://file1.bdocx.com/fileroot1/2023-1/10/9724a7dc-8bd9-494b-a7d0-6f9773061a3a/9724a7dc-8bd9-494b-a7d0-6f9773061a3a1.gif)
数量
5、把压缩包内三篇短文放置在目录Books下。
二、试题
1、面向对象题(20分)。
周三下午1:
306/312
创建一个抽象类:
书类(Book),包含书号BookID、书名BookName,价格Price,包含一个抽象方法intFindWord(stringword);
创建一个教材类(TeachingMaterial)继承于书类,包含内容Content属性信息;
实现FindWord()方法,要求根据输入参数word在Content中查找出现的次数。
2、控件应用题(30分)
新建模板页MasterPage.master,模板页含有站点地图信息;
并新建一个内容页TestControl.aspx,如下图构建注册页面,使用相对应的验证控件进行输入数据的有效性验证。
点击取消按钮清除文本框内已填写数据,点击确定按钮进行提交。
3、数据库题(50分)
主页面MainPage.aspx主要由一个GridView构成,页面打开时GridView显示Book表中的信息,并允许选择删除一条Book信息(注意如删除书本信息,必须同时考虑删除订单信息)
---------------------------------------------------------------------
usingSystem;
usingSystem.Collections.Generic;
usingSystem.Linq;
usingSystem.Web;
///<
summary>
///Student的摘要说明
/summary>
publicclassStudent:
Human
{
//....
publicStudent()
{
//
//TODO:
在此处添加构造函数逻辑
}
publicoverridevoidWork()
//
publicvoidgetInfo(paramsint[]numbers)
foreach(intnuminnumbers)
{
//ifnumisPrimeouputnum;
privateboolisPrime(intnum)
returntrue;
}
publicabstractclassHuman
publicintHeight{get;
set;
publicfloatWeight{get;
privatestring_name;
publicstringName
get{return_name;
set{_name=value;
publicabstractvoidWork();
<
%@PageLanguage="
C#"
AutoEventWireup="
true"
CodeFile="
Default.aspx.cs"
Inherits="
_Default"
%>
!
DOCTYPEhtml>
htmlxmlns="
http:
//www.w3.org/1999/xhtml"
>
headrunat="
server"
metahttp-equiv="
Content-Type"
content="
text/html;
charset=utf-8"
/>
<
title>
/title>
/head>
body>
formid="
form1"
runat="
div>
/div>
asp:
DropDownListID="
DropDownList1"
AutoPostBack="
True"
DataSourceID="
SqlDataSource1"
DataTextField="
Scholl"
DataValueField="
SchoolId"
/asp:
DropDownList>
LabelID="
Label1"
Text="
Label"
Label>
GridViewID="
GridView1"
AutoGenerateColumns="
False"
DataKeyNames="
StuId"
SqlDataSource2"
Columns>
BoundFieldDataField="
HeaderText="
学号"
ReadOnly="
SortExpression="
/>
StuName"
姓名"
学院"
/Columns>
GridView>
DropDownList2"
SqlDataSourceID="
ConnectionString="
%$ConnectionStrings:
ConnectionString%>
"
SelectCommand="
SELECTStudent.StuId,Student.StuName,School.SchollFROMStudentINNERJOINSchoolONStudent.SchoolId=School.SchoolIdWHERE(Student.SchoolId=@SchoolID)"
SelectParameters>
ControlParameterControlID="
Name="
SchoolID"
PropertyName="
SelectedValue"
/SelectParameters>
SqlDataSource>
ButtonID="
Button1"
OnClick="
Button1_Click"
Button"
SELECT*FROM[School]"
/form>
/body>
/html>
--------------------------------
usingSystem.Web.UI;
usingSystem.Web.UI.WebControls;
usingSystem.Data.SqlClient;
usingSystem.Configuration;
publicpartialclass_Default:
System.Web.UI.Page
protectedvoidPage_Load(objectsender,EventArgse)
protectedvoidButton1_Click(objectsender,EventArgse)
SqlConnectioncon=newSqlConnection(ConfigurationManager.ConnectionStrings["
ConnectionString"
].ConnectionString);
con.Open();
SqlCommandcmd=con.CreateCommand();
cmd.CommandText="
updatestudentsetschoolId="
+DropDownList2.SelectedValue+"
whereschoolId="
+DropDownList1.SelectedValue;
cmd.ExecuteNonQuery();
selectCount(*)fromstudentwhereSchoolId="
+DropDownList2.SelectedValue;
Label1.Text=cmd.ExecuteScalar().ToString();
con.Close();
}--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Default.aspx.cs
updatestuInfosetschoolID="
whereschoolID="
selectcount(*)fromstuInfowhereschoolID="
-----------------------------------------------------------------------------------------
DOCTYPEhtmlPUBLIC"
-//W3C//DTDXHTML1.0Transitional//EN"
"
//www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"
DeleteCommand="
DELETEFROM[Student]WHERE[StuID]=@StuID"
InsertCommand="
INSERTINTO[Student]([StuID],[StuName],[SchoolID])VALUES(@StuID,@StuName,@SchoolID)"
SELECT*FROM[Student]"
UpdateCommand="
UPDATE[Student]SET[StuName]=@StuName,[SchoolID]=@SchoolIDWHERE[StuID]=@StuID"
DeleteParameters>
ParameterName="
StuID"
Type="
String"
/DeleteParameters>
InsertParameters>
/InsertParameters>
UpdateParameters>
/UpdateParameters>
br/>
原先的学院ID为:
&
nbsp;
学院学生数量:
Label2"
Labe2"
选择要更新的学院:
ListItemSelected="
计算机学院<
ListItem>
软件工程学院<
ListItemValue="
电气学院"
确定更新"
onclick="
usingSystem.Data;
//建立数据库连接
stringstr=ConfigurationManager.ConnectionStrings["
].ConnectionString.ToString();
SqlConnectionconn;
conn=newSqlConnection(str);
//打开数据库
conn.Open();
//获取原先学院信息
stringsql=string.Format("
selectSchoolIDfromStudent"
);
//创建查询器
SqlDataAdaptersad=newSqlDataAdapter(sql,conn);
//创建结果集
DataSetdataSet=newDataSet();
//将结果集填入
sad.Fill(dataSet);
Label1.Text=dataSet.Tables[0].Rows[0]["
].ToString();
Label2.Text=dataSet.Tables[0].Rows.Count.ToString();
conn.Close();
//更新数据库
//建立数据库命令
SqlCommandsqlcommd2=newSqlCommand("
updateStudentsetSchoolID="
+(DropDownList2.SelectedIndex+1)+"
whereSchoolID="
+Label1.Text.ToString(),conn);
//判断是否命令执行成功
if(sqlcommd2.ExecuteNonQuery()>
0)
Response.Write("
更新成功!
GridView1.DataBind();
//获取连接字符串
conn.Open(