软件工程课程设计报告2013(5)

①查询操作

用到的sql语句：

select sno as 学生编号,sname as 学生姓名,sage as 年龄,ssex as 性别, sdept as 系 from student where sno like '学号%' and sname like '%姓名%' order by sno asc;

string SqlText = \学生编号,sname as 学生姓名,sage as 年龄,ssex as 性别, sdept as 系\

SqlText += \from student where sno like '\+ this.tbsno.Text.Trim()

+ \

SqlText += this.tbsname.Text.Trim() + \

DataAccess DA = new DataAccess(); this.dt = DA.ExeSQLdt(SqlText);

this.dataGrid1.DataSource = this.dt.DefaultView; this.cm = (CurrencyManager)BindingContext[this.dt]; if (this.dataGrid1.Rows.Count != 0) {

for (int i = 0; i < this.dataGrid1.Rows.Count; ) {

this.dataGrid1.Rows[i].DefaultCellStyle.BackColor =

System.Drawing.Color.Pink;

i += 2; } }

②添加操作

用到的sql语句：

insert into student(sno,sname,sage,ssex,sdept) values ('学号','姓名', 年龄, '性别' ,'系别');

string SqlText = \into student(sno,sname,sage,ssex,sdept) values (\ SqlText += \+ this.tbSno.Text.Trim() + \+ this.tbSname.Text.Trim() + \

SqlText += int.Parse(this.tbSage.Text.Trim()) + \+

this.tbSsex.Text.Trim() + \

SqlText += this.tbSdept.Text.Trim()+\ DataAccess DA = new DataAccess(); if (DA.ExeSQL(SqlText) == 1) {

_013student.FormStudentInfo.studentinfo.DBDataGrid();

_013student.FormStudentInfo.studentinfo.Enabled true;

MessageBox.Show(\添加成功!\ } ③修改操作

=

用到的sql语句：

update student set sname ='姓名',sage = 年龄,ssex ='性别',sdept ='系别' where sno='学号';

string SqlText = \\

SqlText += \+ int.Parse(this.tbSage.Text.Trim()) + \

SqlText += \ SqlText += \ DataAccess DA = new DataAccess(); if (DA.ExeSQL(SqlText) == 1) {

_013student.FormStudentInfo.studentinfo.DBDataGrid();

_013student.FormStudentInfo.studentinfo.Enabled true;

MessageBox.Show(\修改成功!\ } ④删除操作

=

用到的sql语句：

delete from sc where sno ='学号';//由于数据库表之间的约束先删除成绩表 delete from Student where sno ='学号';//才能删掉学生表中数据。

DialogResult result = MessageBox.Show(\是否删除此记录?\\提示!\

MessageBoxButtons.YesNo, MessageBoxIcon.Question);

if (result == DialogResult.Yes) {

string Sql = \from sc where sno='\+ this.dataGrid1[0, this.dataGrid1.CurrentCellAddress.Y].Value.ToString() + \

DataAccess DA1 = new DataAccess(); DA1.ExeSQL(Sql);

string SqlText = \from student where sno='\+ this.dataGrid1[0,

this.dataGrid1.CurrentCellAddress.Y].Value.ToString()+\

DataAccess DA = new DataAccess(); DA.ExeSQL(SqlText); this.DBDataGrid();

MessageBox.Show(\删除成功!\ }

if (result == DialogResult.No) {

return; }

3）、课程管理界面

①查询操作 用到的sql语句：

select cno as 课程号,cname as 课程名,cpno as 先行课 ,ccredit as 学分 from course where cname like '%课程名%' and cno like '课程号%';