学生学籍管理系统的设计与实现

if(rbtnMan.Checked) {

Sex=\男\ }

if(rbtnWomen.Checked) {

Sex=\女\ }

SqlConnection con = dataOperate.createConnection(); con.Open();

//根据班级名称查询班级编号 string classID=\ string

sql=\

classID

from

T_Class

className='\

SqlDataReader sdr=dataOperate.getRow(sql); if(sdr.Read()) {

classID=sdr[\

where

} sql

=

\

into

T_Student

values('\Address.Text+\

bool flag= dataOperate.execSQL(sql); if (flag) {

MessageBox.Show(\成功添加信息!\ ////往学生成绩表中添加学生信息 //sql =

\

into

values('\

//dataOperate.execSQL(sql); AddUser au = new AddUser(); au.Show(); this.Visible = false; } else {

31 / 55

T_Grade(Num)

MessageBox.Show(\添加信息失败!\ return; } }

private void btnReset_Click(object sender, EventArgs e) {

Reset(); }

public void Reset() {

txtBirthday.Text = \ txtAddress.Text = \ }

(六) 学生信息查询界面设计

其窗口界面如下:

窗体加载时,通过查询数据库中系部信息,将系部信息填充到系部;当系部的值发生改变时,将通过系部值查找专业信息,并填充到专业;当专业的值发生改变时,将通过专业的值查找班级信息,并填充到班级;最后通过班级值查找该班级中所有学生的信息。

实现代码如下:

private void AdminTeacherSelectInfo_Load(object sender, EventArgs e) {

string sql = \ DataSet ds = dataOperate.getDataSet(sql, \ cbDepartment.DataSource = ds.Tables[\

33 / 55

cbDepartment.DisplayMember = \ }

private void cbDepartment_SelectedIndexChanged(object sender, EventArgs e)

{

string sql = \as

m

where

departmentName='\

+

cbDepartment.Text

+

\

and

d.departmentID=m.departmentID\

DataSet ds = dataOperate.getDataSet(sql, \ cbMajor.DataSource = ds.Tables[\ cbMajor.DisplayMember = \ }

private void cbMajor_SelectedIndexChanged(object sender, EventArgs e)

{

string sql = \className from T_Major as m,T_Class as c where majorName='\

联系客服:779662525#qq.com(#替换为@) 苏ICP备20003344号-4