学生成绩管理系统Web程序设计课程设计报告

public partial class Student_StudentReg : System.Web.UI.Page {

private static string strUser = \

SQLHelper sqlhelper = new SQLHelper(); Common common = new Common();

protected void Page_Load(object sender, EventArgs e) {

if (!Page.IsPostBack) {

common.BindDropDownList(ref ddl_major, \ common.BindDropDownList(ref ddl_dept, \ } }

protected void Button1_Click(object sender, EventArgs e) {

if (this.tbx_sn.Text != \ {

strUser = sqlhelper.RunSqlReturn(\sn from Student where sn='\+ this.tbx_sn.Text + \and sname='\+ this.tbx_name.Text + \pwd='\+ this.tbx_pwd1.Text + \执行SQL语句，并返回第一行第一列结果,即学号 if (strUser.Equals(this.tbx_sn.Text)) {

Page.ClientScript.RegisterStartupScript(GetType(), \\该学生的信息已经有了！') ;\ }

else {

SqlParameter[] prams ={

sqlhelper.CreateInParam(\

sqlhelper.CreateInParam(\

sqlhelper.CreateInParam(\

sqlhelper.CreateInParam(\arChar,50,this.ddl_major.SelectedItem.Text),

sqlhelper.CreateInParam(\ };

sqlhelper.RunProc(\

Page.ClientScript.RegisterStartupScript(GetType(), \\保存成功');window.close();\ } } }

protected void btn_file_Click(object sender, EventArgs e) {

Response.Clear();

Response.Buffer = false;

Response.Charset = \

Response.AppendHeader(\ Response.ContentEncoding = System.Text.Encoding.GetEncoding(\ Response.ContentType = \ Response.Write(\http-equiv=Content-Type content=\\\charset=GB2312\\\

this.EnableViewState = false;

System.IO.StringWriter oStringWriter = new System.IO.StringWriter(); HtmlTextWriter oHtmlTextWriter = new HtmlTextWriter(oStringWriter); GridView1.RenderControl(oHtmlTextWriter); Response.Write(oStringWriter.ToString()); Response.End(); }

public partial class Teacher_TeacherLogin : System.Web.UI.Page {

SQLHelper sqlhelper = new SQLHelper();

protected void Page_Load(object sender, EventArgs e) {

}

protected void ImageButton1_Click(object sender, ImageClickEventArgs e) {

if (this.tbx_name.Text.IndexOf(\ {

this.Label_Msg.Text = \用户名中有非法字符\ return; }

Login lgn = new Login();

if (lgn.TeacherLogin(tbx_name.Text, tbx_pwd1.Text) != null) {

Session[\ Session[\

Response.Redirect(\ } else {

Page.ClientScript.RegisterStartupScript(GetType(), \\用户名或密码错误！') ;\ } }

protected void ImageButton2_Click(object sender, ImageClickEventArgs e) {

this.tbx_name.Text = \ this.tbx_pwd1.Text = \ this.tbx_pwd2.Text = \ }