《ASP NET開發(fā)與應(yīng)用實(shí)踐》課件第12章

本章教學(xué)目標(biāo)12-1系統(tǒng)概述

12-2數(shù)據(jù)庫(kù)設(shè)計(jì)12-3母版頁(yè)設(shè)計(jì)12-4應(yīng)用頁(yè)設(shè)計(jì)1思考問題？什么是母版頁(yè)?為什么要設(shè)計(jì)系統(tǒng)登錄賬戶?系統(tǒng)登錄頁(yè)設(shè)計(jì)時(shí)，要考慮什么安全問題？學(xué)生信息管理系統(tǒng)中的數(shù)據(jù)庫(kù)設(shè)計(jì)，要考慮什么問題？注冊(cè)信息的增添設(shè)計(jì)，如何實(shí)現(xiàn)？學(xué)生信息的增添設(shè)計(jì)，如何實(shí)現(xiàn)？212-1系統(tǒng)概述

學(xué)生信息管理系統(tǒng)設(shè)計(jì)，是基于SqlServer數(shù)據(jù)庫(kù)，設(shè)計(jì)的一個(gè)工作在Web環(huán)境的能對(duì)學(xué)生基本信息進(jìn)行管理的應(yīng)用系統(tǒng)。系統(tǒng)共有兩個(gè)數(shù)據(jù)庫(kù)表，6個(gè)頁(yè)面。3er12-2數(shù)據(jù)庫(kù)設(shè)計(jì)

1.用戶登錄系統(tǒng)表412-2數(shù)據(jù)庫(kù)設(shè)計(jì)

1.用戶登錄系統(tǒng)表512-2數(shù)據(jù)庫(kù)設(shè)計(jì)

2.學(xué)生信息系統(tǒng)表612-2數(shù)據(jù)庫(kù)設(shè)計(jì)

2.學(xué)生信息系統(tǒng)表712-3母版頁(yè)設(shè)計(jì)

1.母版頁(yè)的結(jié)構(gòu)812-3母版頁(yè)設(shè)計(jì)

1.母版頁(yè)的代碼

protectedvoidLinkButton1_Click(objectsender,EventArgse)

{Response.Redirect("Default2.aspx");

}protectedvoidLinkButton5_Click(objectsender,EventArgse)

{Response.Redirect("Default.aspx");

}protectedvoidLinkButton2_Click(objectsender,EventArgse)

{Response.Redirect("studentview.aspx");

}protectedvoidLinkButton4_Click(objectsender,EventArgse)

{Response.Redirect("studentinc.aspx");

}protectedvoidLinkButton3_Click(objectsender,EventArgse)

{Response.Redirect("studentdel.aspx");

}912-4應(yīng)用頁(yè)設(shè)計(jì)

1.首頁(yè)結(jié)構(gòu)設(shè)計(jì)1012-4應(yīng)用頁(yè)設(shè)計(jì)

2.首頁(yè)代碼設(shè)計(jì)protectedvoidImageButton1_Click(objectsender,ImageClickEventArgse)

{stringqq="DataSource=whc-pc\\sqlexpress;InitialCatalog=studentsys;IntegratedSecurity=SSPI";SqlConnectionConn=newSqlConnection(qq);Conn.Open();SqlCommandcmd=newSqlCommand();cmd.Connection=Conn;cmd.CommandType=CommandType.Text;stringComm="select*fromTable2wherename='"+TextBox1.Text+"'"+"andsec='"+TextBox2.Text+"'";cmd.CommandText=Comm;

if(cmd.ExecuteScalar()==null)

{Label2.Text=TextBox1.Text+"不?是?合?法ぁ?成é員±?";

}else

{Label2.Text=cmd.ExecuteScalar().ToString()+"是?合?法ぁ?成é員±！?";Response.Redirect("default2.aspx");

}

}protectedvoidImageButton2_Click(objectsender,ImageClickEventArgse)

{TextBox1.Text="";TextBox2.Text="";

}}1112-4應(yīng)用頁(yè)設(shè)計(jì)

3.用戶注冊(cè)頁(yè)設(shè)計(jì)1212-4應(yīng)用頁(yè)設(shè)計(jì)

4.用戶注冊(cè)頁(yè)代碼設(shè)計(jì)stringqq="DataSource=whc-pc\\sqlexpress;InitialCatalog=studentsys;IntegratedSecurity=SSPI";SqlConnectionConn=newSqlConnection(qq);SqlDataAdapterda=newSqlDataAdapter();stringSQL="select*fromTable2";da.SelectCommand=newSqlCommand(SQL,Conn);DataSetds=newDataSet();da.Fill(ds,"Table2");

DataRowdr=ds.Tables["Table2"].NewRow();dr["name"]=TextBox1.Text.ToString();dr["sec"]=TextBox2.Text.ToString();

ds.Tables[0].Rows.Add(dr);GridView1.DataSource=ds;GridView1.DataBind();SqlCommandBuilderread=newSqlCommandBuilder(da);da.Update(ds,"Table2");1312-4應(yīng)用頁(yè)設(shè)計(jì)

5.信息查詢頁(yè)設(shè)計(jì)1412-4應(yīng)用頁(yè)設(shè)計(jì)

6.信息查詢頁(yè)代碼設(shè)計(jì)

stringqq="DataSource=whc-pc\\sqlexpress;InitialCatalog=studentsys;IntegratedSecurity=SSPI";SqlConnectionConn=newSqlConnection(qq);SqlDataAdapterda=newSqlDataAdapter();stringSQL="select*fromTable1";da.SelectCommand=newSqlCommand(SQL,Conn);DataSetds=newDataSet();da.Fill(ds,"Table1");DataViewssc=ds.Tables["Table1"].DefaultView;stringx1=TextBox1.Text.ToString();stringx2="'"+x1+"%"+"'";ssc.RowFilter="姓名like"+x2;GridView1.DataSource=ssc;GridView1.DataBind();1512-4應(yīng)用頁(yè)設(shè)計(jì)

7.信息刪除頁(yè)設(shè)計(jì)1612-4應(yīng)用頁(yè)設(shè)計(jì)

8.信息刪除頁(yè)代碼設(shè)計(jì)stringqq="DataSource=whc-pc\\sqlexpress;InitialCatalog=studentsys;IntegratedSecurity=SSPI";SqlConnectionConn=newSqlConnection(qq);SqlDataAdapterda=newSqlDataAdapter();stringSQL="select*fromTable1where學(xué)§號(hào)?='"+TextBox1.Text+"'";da.SelectCommand=newSqlCommand(SQL,Conn);DataSetds=newDataSet();da.Fill(ds,"Table1");ds.Tables[0].Rows[0].Delete();SqlCommandBuilderread=newSqlCommandBuilder(da);da.Update(ds,"Table1");SQL="select*fromTable1";da.SelectCommand=newSqlCommand(SQL,Conn);DataSetds2=newDataSet();da.Fill(ds2,"Table1");GridView1.DataSource=ds2;GridView1.DataBind();1712-4應(yīng)用頁(yè)設(shè)計(jì)

9.信息增添頁(yè)設(shè)計(jì)1812-4應(yīng)用頁(yè)設(shè)計(jì)

10.信息增添頁(yè)代碼設(shè)計(jì)stringqq="DataSource=whc-pc\\sqlexpress;InitialCatalog=studentsys;IntegratedSecurity=SSPI";SqlConnectionConn=newSqlConnection(qq);SqlDataAdapterda=newSqlDataAdapter();stringSQL="select*fromTable1";da.SelectCommand=newSqlCommand(SQL,Conn);DataSetds=newDataSet();da.Fill(ds,"Table1");DataRowdr=ds.Tables["Table1"].NewRow();dr["ID"]=TextBox1.Text.ToString();dr["學(xué)號(hào)"]=TextBox2.Text.ToString();dr["姓名"]=TextBox3.Text.ToString();dr["性別"]=TextBox4.Text.ToString();dr["學(xué)院"]=TextBox5.Text.ToString();dr["班級(jí)"]=TextBox6.Text.ToString();dr["數(shù)學(xué)"]=Convert.ToDo