数据库实验成绩管理系统.docx
- 文档编号:23143376
- 上传时间:2023-05-08
- 格式:DOCX
- 页数:14
- 大小:195.05KB
数据库实验成绩管理系统.docx
《数据库实验成绩管理系统.docx》由会员分享,可在线阅读,更多相关《数据库实验成绩管理系统.docx(14页珍藏版)》请在冰豆网上搜索。
数据库实验成绩管理系统
页面总体布局
usingSystem;
usingSystem.Collections.Generic;
usingSystem.ComponentModel;
usingSystem.Data;
usingSystem.Drawing;
usingSystem.Linq;
usingSystem.Text;
usingSystem.Windows.Forms;
usingSystem.Data.SqlClient;
namespaceWindowsFormsApplication1
{
publicpartialclass成绩管理:
Form
{
public成绩管理()
{
InitializeComponent();
查询.Visible=false;
增加.Visible=false;
删除.Visible=false;
修改.Visible=false;
}
登入部分
privatevoid登入_Click(objectsender,EventArgse)
{
if(textBox5.Text=="张礼富"&&textBox6.Text=="123456")
{
查询.Visible=true;
增加.Visible=true;
删除.Visible=true;
修改.Visible=true;
MessageBox.Show("恭喜你!
登入成功!
","提示");
}
else
{
查询.Visible=false;
增加.Visible=false;
删除.Visible=false;
修改.Visible=false;
}
}
查询记录数及相关代码
privatevoid查询记录数ToolStripMenuItem_Click(objectsender,EventArgse)
{
stringstr=@"DataSource=PC-201205121510;InitialCatalog=zhang;UserID=sa";
SqlConnectionconn=newSqlConnection();
conn.ConnectionString=str;
try
{
conn.Open();
if(conn.State==ConnectionState.Open)
{
SqlCommandcmd=newSqlCommand();
cmd.CommandText=@"selectcount(*)from学生成绩表";
cmd.Connection=conn;
intmycount=(int)cmd.ExecuteScalar();
toolStripStatusLabel1.Text="学生人数是:
"+mycount;
}
}
catch(Exceptionex)
{
toolStripStatusLabel1.Text=ex.Message.ToString();
}
finally
{
conn.Close();
}
}
精确查询及相关代码
privatevoid精确查询ToolStripMenuItem_Click(objectsender,EventArgse)
{
stringstr=@"DataSource=PC-201205121510;InitialCatalog=zhang;UserID=sa";
SqlConnectionconn=newSqlConnection();
conn.ConnectionString=str;
stringsql=@"select*from学生成绩表where学号="+textBox1.Text+"and课程='"+textBox3.Text+"'";
SqlDataAdapterda=newSqlDataAdapter(sql,conn);
DataSetds=newDataSet();
try
{
if(textBox1.Text!
=""&&textBox3.Text!
="")
{
conn.Open();
da.Fill(ds);
dataGridView1.DataSource=ds.Tables[0];
}
elseMessageBox.Show("查询值为空,请输入要查询的值....","提示");
}
catch(Exceptionex)
{
toolStripStatusLabel1.Text=ex.Message.ToString();
MessageBox.Show("对不起!
查找失败!
","提示");
}
finally
{
conn.Close();
}
}
鼠标点击获取及代码演示
privatevoiddataGridView1_CellMouseDown(objectsender,DataGridViewCellMouseEventArgse)
{
inti;
i=Convert.ToInt16(e.RowIndex);
textBox1.Text=Convert.ToString(dataGridView1.Rows[i].Cells[0].Value);
textBox2.Text=Convert.ToString(dataGridView1.Rows[i].Cells[1].Value);
textBox3.Text=Convert.ToString(dataGridView1.Rows[i].Cells[2].Value);
textBox4.Text=Convert.ToString(dataGridView1.Rows[i].Cells[3].Value);
}
模糊查询
privatevoid模糊查询ToolStripMenuItem_Click(objectsender,EventArgse)
{
stringstr=@"DataSource=PC-201205121510;InitialCatalog=zhang;UserID=sa";
SqlConnectionconn=newSqlConnection();
conn.ConnectionString=str;
stringsql=@"select*from学生成绩表where姓名like'"+textBox2.Text+"'+'%'";
SqlDataAdapterda=newSqlDataAdapter(sql,conn);
DataSetds=newDataSet();
try
{
if(textBox2.Text!
="")
{
conn.Open();
da.Fill(ds);
dataGridView1.DataSource=ds.Tables[0];
}
elseMessageBox.Show("查询值为空,请输入要查询的值....","提示");
}
catch(Exceptionex)
{
toolStripStatusLabel1.Text=ex.Message.ToString();
MessageBox.Show("对不起!
查找失败!
","提示");
}
finally
{
conn.Close();
}
}
删除
privatevoid删除ToolStripMenuItem_Click(objectsender,EventArgse)
{
stringstr=@"DataSource=PC-201205121510;InitialCatalog=zhang;UserID=sa";
SqlConnectionconn=newSqlConnection();
conn.ConnectionString=str;
stringsql=@"deletefrom学生成绩表where学号="+textBox1.Text+"and课程='"+textBox3.Text+"'";
SqlCommandcmd=newSqlCommand(sql,conn);
//cmd.CommandText=sql;
//cmd.Connection=conn;
try
{
conn.Open();
cmd.ExecuteNonQuery();
}
catch(Exceptionex)
{
toolStripStatusLabel1.Text=ex.Message.ToString();
MessageBox.Show("对不起!
修改数据失败!
","提示");
}
finally
{
conn.Close();
}
}
增加
privatevoid增加ToolStripMenuItem_Click(objectsender,EventArgse)
{
stringstr=@"DataSource=PC-201205121510;InitialCatalog=zhang;UserID=sa";
SqlConnectionconn=newSqlConnection();
conn.ConnectionString=str;
stringsql=@"insertinto学生成绩表(学号,姓名,课程,成绩)values("+textBox1.Text+",'"+textBox2.Text+"','"+textBox3.Text+"',"+textBox4.Text+")";
SqlCommandcmd=newSqlCommand(sql,conn);
//cmd.CommandText=sql;
//cmd.Connection=conn;
try
{
conn.Open();
cmd.ExecuteNonQuery();
}
catch(Exceptionex)
{
toolStripStatusLabel1.Text=ex.Message.ToString();
MessageBox.Show("对不起!
修改数据失败!
","提示");
}
finally
{
conn.Close();
}
}
修改
privatevoid修改ToolStripMenuItem_Click(objectsender,EventArgse)
{
stringstr=@"DataSource=PC-201205121510;InitialCatalog=zhang;UserID=sa";
SqlConnectionconn=newSqlConnection();
conn.ConnectionString=str;
stringsql=@"update学生成绩表set学号="+textBox1.Text+",姓名='"+textBox2.Text+"',课程='"+textBox3.Text+"',成绩="+textBox4.Text+"where学号="+textBox1.Text+"and课程='"+textBox3.Text+"'";
SqlCommandcmd=newSqlCommand(sql,conn);
try
{
conn.Open();
cmd.ExecuteNonQuery();
}
catch(Exceptionex)
{
toolStripStatusLabel1.Text=ex.Message.ToString();
MessageBox.Show("对不起!
修改数据失败!
","提示");
}
finally
{
conn.Close();
}
}
其他功能:
privatevoid查看全部ToolStripMenuItem_Click(objectsender,EventArgse)
{
stringstr=@"DataSource=PC-201205121510;InitialCatalog=zhang;UserID=sa";
SqlConnectionconn=newSqlConnection();
conn.ConnectionString=str;
stringsql=@"select*from学生成绩表";
SqlDataAdapterda=newSqlDataAdapter(sql,conn);
DataSetds=newDataSet();
try
{
conn.Open();
da.Fill(ds);
dataGridView1.DataSource=ds.Tables[0];
}
catch(Exceptionex)
{
toolStripStatusLabel1.Text=ex.Message.ToString();
MessageBox.Show("对不起!
查找失败!
","提示");
}
finally
{
conn.Close();
}
}
privatevoid退出_Click(objectsender,EventArgse)
{
if(MessageBox.Show("确定要退出?
!
","提示!
",MessageBoxButtons.OKCancel,MessageBoxIcon.Information)==DialogResult.OK)
this.Close();
}
}
}
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- 数据库 实验 成绩管理系统
![提示](https://static.bdocx.com/images/bang_tan.gif)