教务管理系统 毕业论文

教务管理系统

4.4 学生模块组成：

实现本模块的主要代码如下所示:

string sql;

string ngender;

if (RadioButton1.Checked) {

ngender = \男\ } else {

ngender = \女\ }

sql = \

xuesheng(xuehao,mima,xingming,banji,jiaoshi,xingbie,jiguan,dianhua,QQ,youxiang,beizhu) values('\+ \jiaoshi.SelectedItem.ToString().Trim() + \

24 20

教务管理系统

jiguan.Text.ToString().Trim() + \QQ.Text.ToString().Trim() + \beizhu.Text.ToString().Trim() + \

int result;

result = new Class1().hsgexucute(sql); if (result == 1) {

Response.Write(\添加成功');\ } else {

Response.Write(\系统错误，请检查数据库的连?);\

}

4.5 成绩模块组成：

该模块是让教师添加学生成绩的模块,每个教师只能添加自己学生的成绩,实现本模块的主要代码如下所示:

protected void Page_Load(object sender, EventArgs e) {

if (!IsPostBack)

{

25 21

教务管理系统

xuehao.Items.Add(\请选择\

string sql; sql

=

\

xuehao

from

xuesheng

where

jiaoshi='\ DataSet result = new DataSet(); result = new Class1().hsggetdata(sql); if (result != null) {

if (result.Tables[0].Rows.Count > 0) {

int k = 0;

for (k = 0; k < result.Tables[0].Rows.Count; k++)

{ xuehao.Items.Add(result.Tables[0].Rows[k][\ } } } } }

protected void Button1_Click(object sender, EventArgs e) {

string sql; sql=\

xueshengchengji(xuehao,xingming,banji,jiaoshi,kecheng,chengji)

values('\m()+\eng.Text.ToString().Trim()+\ int result;

result = new Class1().hsgexucute(sql); if (result == 1)

26 22

into

教务管理系统

{

Response.Write(\添加成功');\ } else {

Response.Write(\系统错误，请检查数据库的连?);\ } }

protected void xuehao_SelectedIndexChanged(object sender, EventArgs e) {

string sql; sql

=

\

xingming,banji,jiaoshi

from

xuesheng

where

xuehao='\ DataSet result = new DataSet(); result = new Class1().hsggetdata(sql); if (result != null) {

if (result.Tables[0].Rows.Count > 0) {

xingming.Text

result.Tables[0].Rows[0][\

banji.Text = result.Tables[0].Rows[0][\ jiaoshi.Text

result.Tables[0].Rows[0][\ } } }

27 23

=

=