数据库实验成绩管理系统.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();
}
}
}