学生管理系统界面+源代码优选.docx
- 文档编号:25409625
- 上传时间:2023-06-08
- 格式:DOCX
- 页数:21
- 大小:837.29KB
学生管理系统界面+源代码优选.docx
《学生管理系统界面+源代码优选.docx》由会员分享,可在线阅读,更多相关《学生管理系统界面+源代码优选.docx(21页珍藏版)》请在冰豆网上搜索。
学生管理系统界面+源代码优选
内蒙古信息工程系
学实训报告
系部:
信息技术系
课程名称:
网站网页制作
专业班级:
14计算机网络技术一班
姓名:
xxx
任课老师:
xxx
实验实训
项目名称
网站制作
实验
类型
验证型
实验室
思科网络实验室
实验
时间
[实验方案设计(步骤)]
实验目的:
1.熟练掌握SQL语句的编写。
2.掌握使用VS2010对网页的设计。
实验步骤:
1.登录页面
主要代码:
protectedvoidButton1_Click(objectsender,EventArgse)
{
stringusername=TextBox1.Text;
stringpassword=TextBox2.Text;
stringconnStr="server=(local);uid=sa;pwd=123456;database=StudentManager";
SqlConnectionconn=newSqlConnection(connStr);
SqlCommandcmd=newSqlCommand("select*fromUserInfowhereusername='"+username+"'andpassword='"+password+"'",conn);
conn.Open();
SqlDataReaderreader=cmd.ExecuteReader();//记?
录?
集ˉ
if(reader.Read())
{
Response.Redirect("main.aspx");
}
else
{
Label1.Text="用?
户§名?
或ò者?
密ü码?
错洙?
误ó!
?
!
?
";
}
conn.Close();
}
2.主页面+用户信息管理页面
左侧主要运用了TreeView控件,然后用户信息运用了GridView控件,链接数据源,在页面中展示用户信息,主要代码:
GridViewID="GridView1"runat="server"AllowPaging="True" AllowSorting="True"AutoGenerateColumns="False"DataKeyNames="Userid" DataSourceID="SqlDataSource1" style="font-family: 楷? 体? ;font-size: medium"Width="550px" BackColor="#DEBA84"BorderColor="#DEBA84"BorderStyle="None"BorderWidth="1px" CellPadding="3"CellSpacing="2"> BoundFieldDataField="Userid"HeaderText="序ò号? "ReadOnly="True" SortExpression="Userid"/> BoundFieldDataField="UserName"HeaderText="用? 户§名? " SortExpression="UserName"/> BoundFieldDataField="Password"HeaderText="密ü码? " SortExpression="Password"/> BoundFieldDataField="Email"HeaderText="电? 子哩? 邮? 件t"SortExpression="Email"/> CommandFieldShowDeleteButton="True"ShowEditButton="True"/> GridView> SqlDataSourceID="SqlDataSource1"runat="server" ConnectionString="<%$ConnectionStrings: StudentManagerConnectionString%>" DeleteCommand="DELETEFROM[UserInfo]WHERE[Userid]=@Userid" InsertCommand="INSERTINTO[UserInfo]([Userid],[UserName],[Password],[Email])VALUES(@Userid,@UserName,@Password,@Email)" SelectCommand="SELECT*FROM[UserInfo]" UpdateCommand="UPDATE[UserInfo]SET[UserName]=@UserName,[Password]=@Password,[Email]=@EmailWHERE[Userid]=@Userid"> 3.学籍信息添加页面 主要代码: protectedvoidButton1_Click(objectsender,EventArgse) { stringconnStr="server=(local);uid=sa;pwd=123456;database=StudentManager"; SqlConnectionconn=newSqlConnection(connStr); SqlCommandcmd=newSqlCommand("insertintoStudentXj(Sno,Sname,Ssex,Sbrithday,DepartNo,ClassNo,Tel,Srxtime,xuezhi,xueli,address,youbian,zzmm,pingjia)values('"+this.TextBox1.Text+"','"+this.TextBox2.Text+"','"+RadioButtonList1.Text+"','"+this.TextBox3.Text+"','"+this.TextBox12.Text+"','"+this.TextBox4.Text+"','"+this.TextBox5.Text+"','"+this.TextBox6.Text+"','"+this.TextBox7.Text+"','"+this.TextBox8.Text+"','"+this.TextBox9.Text+"','"+this.TextBox10.Text+"','"+DropDownList1.Text+"','"+this.TextBox11.Text+"')",conn); conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); } 4.学籍信息修改 本页面也是用GridView控件,与数据库连接,展示出学籍信息,然后生成“修改”,单击“修改”方可进行修改,主要代码: GridViewID="GridView1"runat="server"AllowPaging="True" AllowSorting="True"AutoGenerateColumns="False"BackColor="#DEBA84" BorderColor="#DEBA84"BorderStyle="None"BorderWidth="1px"CellPadding="3" CellSpacing="2"DataKeyNames="Sno"DataSourceID="SqlDataSource1" style="text-align: center;font-family: 楷? 体? ;font-size: large;margin-top: 0px;" Width="1471px"> BoundFieldDataField="Sno"HeaderText="Sno"ReadOnly="True" SortExpression="Sno"/> BoundFieldDataField="Sname"HeaderText="Sname"SortExpression="Sname"/> BoundFieldDataField="Ssex"HeaderText="Ssex"SortExpression="Ssex"/> BoundFieldDataField="Sbrithday"HeaderText="Sbrithday" SortExpression="Sbrithday"/> BoundFieldDataField="DepartNo"HeaderText="DepartNo" SortExpression="DepartNo"/> BoundFieldDataField="ClassNo"HeaderText="ClassNo" SortExpression="ClassNo"/> BoundFieldDataField="Tel"HeaderText="Tel"SortExpression="Tel"/> BoundFieldDataField="Srxtime"HeaderText="Srxtime" SortExpression="Srxtime"/> BoundFieldDataField="xuezhi"HeaderText="xuezhi" SortExpression="xuezhi"/> BoundFieldDataField="xueli"HeaderText="xueli"SortExpression="xueli"/> BoundFieldDataField="address"HeaderText="address" SortExpression="address"/> BoundFieldDataField="youbian"HeaderText="youbian" SortExpression="youbian"/> BoundFieldDataField="zzmm"HeaderText="zzmm"SortExpression="zzmm"/> BoundFieldDataField="pingjia"HeaderText="pingjia" SortExpression="pingjia"/> CommandFieldEditText="修T改? "ShowEditButton="True"/> GridView> SqlDataSourceID="SqlDataSource1"runat="server" ConnectionString="<%$ConnectionStrings: StudentManagerConnectionString2%>" DeleteCommand="DELETEFROM[StudentXj]WHERE[Sno]=@Sno" InsertCommand="INSERTINTO[StudentXj]([Sno],[Sname],[Ssex],[Sbrithday],[DepartNo],[ClassNo],[Tel],[Srxtime],[xuezhi],[xueli],[address],[youbian],[zzmm],[pingjia])VALUES(@Sno,@Sname,@Ssex,@Sbrithday,@DepartNo,@ClassNo,@Tel,@Srxtime,@xuezhi,@xueli,@address,@youbian,@zzmm,@pingjia)" SelectCommand="SELECT*FROM[StudentXj]" UpdateCommand="UPDATE[StudentXj]SET[Sname]=@Sname,[Ssex]=@Ssex,[Sbrithday]=@Sbrithday,[DepartNo]=@DepartNo,[ClassNo]=@ClassNo,[Tel]=@Tel,[Srxtime]=@Srxtime,[xuezhi]=@xuezhi,[xueli]=@xueli,[address]=@address,[youbian]=@youbian,[zzmm]=@zzmm,[pingjia]=@pingjiaWHERE[Sno]=@Sno"> 5.学籍信息查询 本页面运用GridView控件展示出学生信息,设置三种条件查询,按学号、姓名、系别方可查询出学生信息,主要代码: protectedvoidPage_Load(objectsender,EventArgse) { stringconnStr="server=(local);uid=sa;pwd=123456;database=StudentManager"; SqlConnectionconn=newSqlConnection(connStr); SqlDataAdapterda=newSqlDataAdapter("select*fromStudentXj",conn); DataSetds=newDataSet(); da.Fill(ds); GridView1.DataSource=ds; GridView1.DataBind(); } protectedvoidButton1_Click(objectsender,EventArgse) { stringconnStr="server=(local);uid=sa;pwd=123456;database=StudentManager"; SqlConnectionconn=newSqlConnection(connStr); SqlDataAdapterda=newSqlDataAdapter("select*fromStudentXjwhereSno='"+this.TextBox1.Text+"'orSname='"+this.TextBox2.Text+"'orDepartNo='"+this.TextBox3.Text+"'",conn); DataSetds=newDataSet(); da.Fill(ds); GridView1.DataSource=ds; GridView1.DataBind(); } 6.课程信息添加 主要代码: protectedvoidButton1_Click(objectsender,EventArgse) { stringconnStr="server=(local);uid=sa;pwd=123456;database=StudentManager"; SqlConnectionconn=newSqlConnection(connStr); SqlCommandcmd=newSqlCommand("insertintoCourse(Courseid,CourseName,Credit,Datetime)values('"+this.TextBox1.Text+"','"+this.TextBox2.Text+"','"+this.TextBox3.Text+"','"+this.TextBox4.Text+"')",conn); conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); Label1.Text="添? 加ó成é功|! ? ! ? ! ? "; } 7.课程信息修改 本页面运用了GridView控件,并启用了“修改”,单击修改方可实现修改功能,主要代码: GridViewID="GridView1"runat="server"AutoGenerateColumns="False" BackColor="#DEBA84"BorderColor="#DEBA84"BorderStyle="None"BorderWidth="1px" CellPadding="3"CellSpacing="2"DataKeyNames="Courseid" DataSourceID="SqlDataSource1" style="text-align: center;font-family: 楷? 体? ;font-size: large;"Width="630px"> BoundFieldDataField="Courseid"HeaderText="课? 程ì编括? 号? "ReadOnly="True" SortExpression="Courseid"/> BoundFieldDataField="CourseName"HeaderText="课? 程ì名? 称? " SortExpression="CourseName"/> BoundFieldDataField="Credit"HeaderText="学§分? "SortExpression="Credit"/> BoundFieldDataField="Datetime"HeaderText="日? 期ú" SortExpression="Datetime"/> CommandFieldEditText="修T改? "HeaderText="修T改? "ShowEditButton="True"/> GridView> SqlDataSourceID="SqlDataSource1"runat="server" ConnectionString="<%$ConnectionStrings: StudentManagerConnectionString4%>" DeleteCommand="DELETEFROM[Course]WHERE[Courseid]=@Courseid" InsertCommand="INSERTINTO[Course
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- 学生 管理 系统 界面 源代码 优选