热门标签
热门文章
- 1【建议收藏】一万字图文并茂，终于有人把GPT的玩法整理全了_学习gpt
- 2微信小程序毕业设计-车视界系统项目开发实战(附源码+文档)
- 3CSS 网页布局（详解网页的布局构造）
- 4phpmailer发邮件常见的一些问题总结及使用案例_宝塔搭建 phpmailer 邮件无法发送
- 5指针中getnext（）和setnext（）函数的区别
- 6关于TokenPocket钱包Dapp开发的一些常见问题
- 7NVMe TCG安全数据存储简介_tcg opal
- 8产品经理之如何编写需求PRD文档&（医疗HIS项目详细案例模板）_his项目描述怎么写
- 9Windows运行可视化工具tensorboard_运行tensorboard
- 10C语言实现单向链表_#ifndef list
当前位置: article > 正文
C#连接SQL Server数据库实现简易的学生成绩管理系统_vs c#学生管理系统
作者：Guff_9hys | 2024-07-23 20:59:40
赞
踩
vs c#学生管理系统
今天做了一个学生成绩管理系统，包括了成绩输入成绩输出、成绩查询、修改成绩、删除成绩信息等功能。对于有一定基础知识的同学来说，也很容易理解。
一、配置SQL数据库连接信息
1、由于这个程序连接了SQL Server数据库，所以需要配置一下相关数据，创建一个“账号登录”数据库，新建一个“登录注册表”和“学生成绩表”，并记住这个服务器名称，等下会用到，如下图所示。
登录注册表设置两个列名：username(账号)和password(密码)以及对应的数据类型(可自定义)。
学生成绩表设置5个列名：Name(学生成绩)、Number(学生学号)、Chinese(语文成绩)、Math(数学成绩)、English(英语成绩)和相应的数据类型。
2、然后打开VS2019，新建一个控制台程序，在里面设置一下App.config的SQL数据库连接信息，如下图所示。
App.config里面的代码格式：
<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<startup>
<supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.8" />
</startup>
<connectionStrings>
<add name="sqlserver" connectionString="server=SQLEXPRESS;database=账号登录;integrated security = true;"/>
//这是以windows身份验证登录连接，无需用户名和密码，SQLEXPRESS是服务器名称，“账号登录”是新建的数据库名称.
</connectionStrings>
</configuration>
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
二、相关的源代码
以下为该程序的全部源代码，创建了两个类，分别包括了账号登录程序和学生成绩管理系统两大功能。
全部源代码
using System;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.Diagnostics;
using System.Security.Cryptography;
using System.Text;
namespace CT123
{
class Account //账号登录
{
private string MD5Encrypt(string rawPass, string salt) //MD5加盐加密操作
{
MD5 md5 = MD5.Create();
byte[] bs = Encoding.UTF8.GetBytes(rawPass + salt);
byte[] hs = md5.ComputeHash(bs);
StringBuilder stb = new StringBuilder();
foreach (byte b in hs)
{
stb.Append(b.ToString("x2"));
}
return stb.ToString();
}
//#############################################################################################
private readonly string Stu = ConfigurationManager.ConnectionStrings["sqlserver"].ConnectionString; //设置数据库连接对象
private void Login() //登录功能
{
Console.WriteLine("\n--------- 1.账号登录 ---------");
SqlConnection conn = new SqlConnection(Stu);
Console.Write("请输入账号：");
string username = Console.ReadLine().Trim().Trim();
Console.Write("请输入密码：");
string password = Console.ReadLine().Trim().Trim();
while (true)
{
conn.Open();
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "select * from 登录注册表 where username='" + username + "'";
SqlDataReader sdt = cmd.ExecuteReader();
if (Equals(username, ""))
{
Console.Write("账号不得为空!\n请输入账号：");
username = Console.ReadLine().Trim().Trim();
}
else if (Equals(password, ""))
{
Console.Write("密码不得为空!\n请输入密码");
password = Console.ReadLine().Trim();
}
else if (sdt.Read()) //读取到记录
{
string result = sdt.GetString(sdt.GetOrdinal("password"));
if (MD5Encrypt(password, username).Equals(result))
{
Console.WriteLine("登录成功!");
conn.Close(); //关闭数据库连接
Grade st = new Grade();
st.GradeTable();
}
else
{
Console.WriteLine("账号密码错误!");
conn.Close();
Login();
}
}
else
{
YesOrNo();
}
conn.Close();
}
}
private void YesOrNo()
{
Console.WriteLine("\n账号不存在，是否选择注册一个新账号？\n1、是；2、否");
string num = Console.ReadLine().Trim();
switch (num)
{
case "1": Register(); break;
case "2": Main2(); break;
default:
{
Console.WriteLine("请重新选择!");
YesOrNo();
}; break;
}
}
//#############################################################################################
private void Register() //账号注册功能
{
Console.WriteLine("\n--------- 2.账号注册 ---------");
SqlConnection conn = new SqlConnection(Stu);
Console.Write("请输入注册账号：");
string newusername = Console.ReadLine().Trim();
Console.Write("请输入账号密码：");
string password = Console.ReadLine().Trim();
Console.Write("请确认账号密码：");
string repassword = Console.ReadLine().Trim();
while (true)
{
conn.Open();
string sql = "Select username from 登录注册表 where username='" + newusername + "'";
SqlCommand cmd = new SqlCommand(sql, conn); //判断账号是否已存在
cmd.CommandType = CommandType.Text;
SqlDataReader sdt = cmd.ExecuteReader();
if (Equals(newusername, ""))
{
Console.Write("注册账号不得为空!\n请输入注册账号：");
newusername = Console.ReadLine().Trim();
}
else if (Equals(password, ""))
{
Console.Write("账号密码不得为空!\n请输入账号密码：");
password = Console.ReadLine().Trim();
}
else if (repassword.Equals("") || !password.Equals(repassword))
{
Console.Write("请重新确认密码：");
repassword = Console.ReadLine().Trim();
}
/* else if (newusername.Length < 8)
{
Console.WriteLine("请输入8位以上的新用户名!");
newusername =Console.ReadLine().Trim();
}
else if (Regex.IsMatch(password.ToString(), @"^\w+_$") == false)
{
Console.Write("请输入8~16位由字母、数字和下划线组成的密码：");
password =Console.ReadLine().Trim();
}
else if (password.Length < 8 || password.Length > 16)
{
Console.WriteLine("请输入8~16位由字母、数字和下划线组成的密码!");
password =Console.ReadLine().Trim();
}*/
else
{
if (sdt.Read())
{
Console.WriteLine("该账号已注册,请重新注册账号!");
Register();
}
else
{
//插入的信息分别为账号，密文
Insert(newusername, MD5Encrypt(password, newusername));
//调用函数Insert()保存注册信息到数据库
conn.Close();
}
}
conn.Close();
}
}
private void Insert(string txt1, string txt2) //数据库插入注册成功后的账号信息
{
SqlConnection conn = new SqlConnection(Stu);
conn.Open();
try
{
string InsertStr = string.Format("insert into 登录注册表 values('{0}','{1}')", txt1, txt2);
SqlCommand comm = conn.CreateCommand();
comm.CommandText = InsertStr;
SqlCommand mycom = new SqlCommand(InsertStr, conn);
mycom.ExecuteNonQuery();
Console.WriteLine("账号注册成功!");
conn.Close();
Main2();
}
catch (Exception ex)
{
Console.WriteLine("账号注册失败!");
Console.WriteLine(ex.Message);
conn.Close();
Main2();
}
conn.Close();
}
//##############################################################################################
private void Change() //修改密码
{
Console.WriteLine("\n--------- 3.修改密码 ---------");
SqlConnection conn = new SqlConnection(Stu);
Console.Write("请输入账号：");
string username = Console.ReadLine().Trim();
Console.Write("请输入旧密码：");
string oldpassword = Console.ReadLine().Trim();
Console.Write("请输入新密码：");
string newpassword = Console.ReadLine().Trim();
while (true)
{
conn.Open();
string sql = "Select password from 登录注册表 where username='" + username + "'";
SqlCommand cmd = new SqlCommand(sql, conn); //调用登录窗体Form1参数username，判断当前账号密码是否正确
SqlDataReader reader = cmd.ExecuteReader();
if (Equals(username, ""))
{
Console.Write("账号不得为空!\n请输入账号：");
username = Console.ReadLine().Trim();
}
else if (Equals(oldpassword, ""))
{
Console.Write("密码不得为空!\n请输入旧密码：");
oldpassword = Console.ReadLine().Trim();
}
else if (Equals(newpassword, ""))
{
Console.Write("密码不得为空!\n请输入新密码：");
newpassword = Console.ReadLine().Trim();
}
else if (oldpassword.Equals(newpassword))
{
Console.Write("新旧密码相同,请重新输入密码：");
oldpassword = Console.ReadLine().Trim();
}
else if (reader.Read())
{
string result = reader["password"].ToString(); //读取到的密码
if (MD5Encrypt(oldpassword, username).Equals(result))
{
ChangeSave(username, MD5Encrypt(newpassword, username));
//调用Change()函数方法保存修改后的账号信息到数据库
conn.Close();
}
else
{
Console.WriteLine("账号密码错误!");
Change();
}
}
else
{
YesOrNo();
}
conn.Close();
}
}
private void ChangeSave(string txt1, string txt2) //数据库保存修改后的账号信息
{
SqlConnection conn = new SqlConnection(Stu);
conn.Open();
try
{
string InsertStr = string.Format("update 登录注册表 set password='{0}' WHERE username='{1}';", txt2.ToString(), txt1.ToString());
SqlCommand comm = conn.CreateCommand();
SqlCommand mycom = new SqlCommand(InsertStr, conn);
mycom.ExecuteNonQuery();
Console.WriteLine("账号密码修改成功!");
conn.Close();
Main2();
}
catch (Exception ex)
{
Console.WriteLine("账号密码修改失败!");
Console.WriteLine(ex.Message);
conn.Close();
Main2();
}
}
//###################################################################################
private void Delete() //账号注销
{
Console.WriteLine("\n--------- 4.账号注销 ---------");
SqlConnection conn = new SqlConnection(Stu);
Console.Write("请输入账号：");
string username = Console.ReadLine().Trim();
Console.Write("请输入密码：");
string password = Console.ReadLine().Trim();
while (true)
{
conn.Open();
string sql = "Select password from 登录注册表 where username='" + username + "'";
SqlCommand cmd = new SqlCommand(sql, conn); //判断当前账号密码是否正确
cmd.CommandType = CommandType.Text;
SqlDataReader reader = cmd.ExecuteReader();
if (Equals(username, ""))
{
Console.Write("账号不得为空!\n请输入账号：");
username = Console.ReadLine().Trim();
}
else if (Equals(password, ""))
{
Console.Write("账号密码不得为空!\n请输入账号密码：");
password = Console.ReadLine().Trim();
}
else if (reader.Read())
{
string result = reader.GetString(reader.GetOrdinal("password"));
if (MD5Encrypt(password, username).Equals(result))
{
Del(username); //调用方法，删除注销后的账号信息
conn.Close(); //关闭数据库对象连接
}
else
{
Console.WriteLine("账号密码错误!");
Delete();
}
}
else
{
YesOrNo();
}
conn.Close();
}
}
private void Del(string username) //数据库删除注销后的账号信息
{
SqlConnection conn = new SqlConnection(Stu);
conn.Open();
try
{
Console.WriteLine("账号注销成功!");
string sql2 = "delete from 登录注册表 where username='" + username + "'";
SqlCommand cmd1 = new SqlCommand(sql2, conn);
cmd1.ExecuteNonQuery();
conn.Close();
Main2();
}
catch (Exception ex)
{
Console.WriteLine("账号注销失败!");
Console.WriteLine(ex.Message);
Main2();
}
}
public void Main2()
{
Console.WriteLine("");
Console.WriteLine("**************************");
Console.WriteLine("******* 1.账号登录 *******");
Console.WriteLine("******* 2.账号注册 *******");
Console.WriteLine("******* 3.修改密码 *******");
Console.WriteLine("******* 4.账号注销 *******");
Console.WriteLine("******* 0.退出程序 *******");
Console.WriteLine("**************************");
Console.Write("请输入选择：");
string num = Console.ReadLine().Trim().Trim();
while (true)
{
switch (num)
{
case "1": Login(); break;
case "2": Register(); break;
case "3": Change(); break;
case "4": Delete(); break;
case "0":
{
Console.WriteLine("程序已退出!");
Console.ReadKey();
Process.GetCurrentProcess().Kill();
}; break;
default:
{
Console.Write("请重新输入选择：");
num = Console.ReadLine().Trim();
}; break;
}
}
}
}
//######################################################################################################
//######################################################################################################
//######################################################################################################
class Grade
{
static readonly string Stu = ConfigurationManager.ConnectionStrings["sqlserver"].ConnectionString; //设置数据库连接对象
public void GradeTable() //学生成绩管理系统
{
Console.WriteLine();
Console.WriteLine("******************************");
Console.WriteLine("******* 1.学生成绩输入 *******");
Console.WriteLine("******* 2.学生成绩输出 *******");
Console.WriteLine("******* 3.学生成绩查询 *******");
Console.WriteLine("******* 4.学生成绩修改 *******");
Console.WriteLine("******* 5.学生成绩删除 *******");
Console.WriteLine("******* 6.返回登录界面 *******");
Console.WriteLine("******* 0.退出当前程序 *******");
Console.WriteLine("******************************");
Console.Write("请输入选择：");
string num = Console.ReadLine().Trim();
while (true)
{
switch (num)
{
case "1": GradeInput(); break;
case "2": GradeOutput(); break;
case "3": GradeFind(); break;
case "4": GradeChange(); break;
case "5": GradeDelete(); break;
case "6":
{
Account st = new Account();
st.Main2();
}
; break;
case "0":
{
Console.WriteLine("程序已退出!");
Console.ReadKey();
Process.GetCurrentProcess().Kill();
}; break;
default:
{
Console.WriteLine("请重新输入选择!");
GradeTable();
}; break;
}
}
}
//######################################################################################################
private void GradeInput() //学生成绩输入
{
SqlConnection conn = new SqlConnection(Stu);
Console.WriteLine("\n----------- 1.学生成绩输入 -----------");
Console.Write("请输入学生姓名：");
string name = Console.ReadLine().Trim();
Console.Write("请输入学生学号：");
string number = Console.ReadLine().Trim();
Console.Write("请输入语文成绩：");
string chinese = Console.ReadLine().Trim();
Console.Write("请输入数学成绩：");
string math = Console.ReadLine().Trim();
Console.Write("请输入英语成绩：");
string english = Console.ReadLine().Trim();
while (true)
{
if (Equals(name, ""))
{
Console.Write("学生姓名不得为空!\n请输入学生姓名：");
name = Console.ReadLine().Trim();
}
else if (Equals(number, ""))
{
Console.Write("学生学号不得为空!\n请输入学生学号：");
number = Console.ReadLine().Trim();
}
else if (Equals(chinese, ""))
{
Console.Write("语文成绩不得为空!\n请输入语文成绩：");
chinese = Console.ReadLine().Trim();
}
else if (Equals(math, ""))
{
Console.Write("数学成绩不得为空!\n请输入数学成绩：");
math = Console.ReadLine().Trim();
}
else if (Equals(english, ""))
{
Console.Write("英语成绩不得为空!\n请输入英语成绩：");
english = Console.ReadLine().Trim();
}
else
{
conn.Open();
string sql = "Select Number from 学生成绩表 where Number='" + number + "'";
SqlCommand cmd = new SqlCommand(sql, conn); //判断该学生成绩信息是否已输入
cmd.CommandType = CommandType.Text;
SqlDataReader sdt = cmd.ExecuteReader();
switch (sdt.Read())
{
case true:
Console.WriteLine("该学生成绩信息已输入!");
GradeTable();
break;
default:
Input(name, number, chinese, math, english);
break;
}
conn.Close();
}
}
}
private void Input(string name, string number, string chinese, string math, string english) //保存输入的成绩到数据库
{
SqlConnection conn = new SqlConnection(Stu);
try
{
conn.Open();
string InsertStr = string.Format("insert into 学生成绩表 values('{0}','{1}','{2}','{3}','{4}')", name, number, chinese, math, english);
SqlCommand comm = conn.CreateCommand();
comm.CommandText = InsertStr;
SqlCommand mycom = new SqlCommand(InsertStr, conn);
mycom.ExecuteNonQuery();
Console.WriteLine("学生成绩输入成功!");
conn.Close();
Console.ReadKey();
GradeTable();
}
catch (Exception ex)
{
Console.WriteLine("学生成绩输入失败!");
Console.WriteLine(ex.Message);
Console.ReadKey();
GradeTable();
}
conn.Close();
}
//################################################################################################
private void GradeOutput() //学生成绩输出
{
Console.WriteLine("\n****************************** 2.学生成绩输出 ********************************");
Console.WriteLine("------------------------------------------------------------------------------");
Console.WriteLine(" 姓名 | 学号 | 语文 | 数学 | 英语 | 总分 | 平均分 ");
Console.WriteLine("------------------------------------------------------------------------------");
SqlConnection conn = new SqlConnection(Stu);
conn.Open();
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "select* from 学生成绩表 ";
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
string name = reader["Name"].ToString();
string number = reader["Number"].ToString();
double chinese = reader.GetDouble(reader.GetOrdinal("Chinese"));
double math = reader.GetDouble(reader.GetOrdinal("Math"));
double english = reader.GetDouble(reader.GetOrdinal("English"));
double sum = chinese + math + english;
double aver = sum / 3.0;
Console.WriteLine(" {0} | {1} | {2} | {3} | {4} | {5:F2} | {6:F2} ", name, number, chinese, math, english, sum, aver);
Console.WriteLine("------------------------------------------------------------------------------");
}
Console.ReadKey();
GradeTable();
}
//###################################################################################################
private void GradeFind()
{
Console.WriteLine("\n****************** 3.学生成绩查询 ********************");
Console.Write("1、按姓名查询；2、按学号查询；0、返回\n请输入选择：");
string num = Console.ReadLine().Trim();
while (true)
{
switch (num)
{
case "1":
{
Console.Write("请输入学生姓名：");
string name = Console.ReadLine().Trim();
SelectName(name);
}; break;
case "2":
{
Console.Write("请输入学生学号：");
string number = Console.ReadLine().Trim();
SelectNumber(number);
}; break;
case "0": GradeTable(); break;
default:
{
Console.Write("请重新输入选择：");
num = Console.ReadLine().Trim();
}; break;
}
}
}
private void SelectName(string Name) //按学生姓名查找成绩
{
SqlConnection conn = new SqlConnection(Stu);
conn.Open();
string sqlStr = "Select count(*) from 学生成绩表 where Name='" + Name + "'";
SqlCommand sqlcmd = new SqlCommand(sqlStr, conn);
object count = sqlcmd.ExecuteScalar();
switch ((int)count)
{
case 0:
{
Console.WriteLine("查无此人!");
Console.ReadKey();
GradeTable();
}; break;
case 1:
{
SelectNameShow(Name);
conn.Close();
}; break;
default:
{
Console.WriteLine("该学生姓名有多个，请通过学号来查询!");
GradeFind();
}; break;
}
conn.Close();
GradeTable();
}
private void SelectNameShow(string Name)
{
SqlConnection conn = new SqlConnection(Stu);
try
{
conn.Open();
Console.WriteLine("------------------------------------------------------------------------------");
Console.WriteLine(" 姓名 | 学号 | 语文 | 数学 | 英语 | 总分 | 平均分 ");
Console.WriteLine("------------------------------------------------------------------------------");
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "select * from 学生成绩表 where Name= '" + Name + "'";
SqlDataReader reader = cmd.ExecuteReader();
if (reader.Read())
{
string name = reader["Name"].ToString();
string number = reader["Number"].ToString();
double chinese = reader.GetDouble(reader.GetOrdinal("Chinese"));
double math = reader.GetDouble(reader.GetOrdinal("Math"));
double english = reader.GetDouble(reader.GetOrdinal("English"));
double sum = chinese + math + english;
double aver = sum / 3.0;
Console.WriteLine(" {0} | {1} | {2} | {3} | {4} | {5:F2} | {6:F2} ", name, number, chinese, math, english, sum, aver);
Console.WriteLine("------------------------------------------------------------------------------");
}
Console.ReadKey();
GradeTable();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
conn.Close();
GradeTable();
}
}
private void SelectNumber(string Number) //按学号查询成绩
{
SqlConnection conn = new SqlConnection(Stu);
conn.Open();
Console.WriteLine("------------------------------------------------------------------------------");
Console.WriteLine(" 姓名 | 学号 | 语文 | 数学 | 英语 | 总分 | 平均分 ");
Console.WriteLine("------------------------------------------------------------------------------");
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "select * from 学生成绩表 where Number= '" + Number + "'";
SqlDataReader reader = cmd.ExecuteReader();
if (reader.Read())
{
string name = reader["Name"].ToString();
string number = reader["Number"].ToString();
double chinese = reader.GetDouble(reader.GetOrdinal("Chinese"));
double math = reader.GetDouble(reader.GetOrdinal("Math"));
double english = reader.GetDouble(reader.GetOrdinal("English"));
double sum = chinese + math + english;
double aver = sum / 3.0;
Console.WriteLine(" {0} | {1} | {2} | {3} | {4} | {5:F2} | {6:F2} ", name, number, chinese, math, english, sum, aver);
Console.WriteLine("------------------------------------------------------------------------------");
}
else
{
Console.WriteLine("查无此人!");
Console.ReadKey();
GradeFind();
}
conn.Close();
Console.ReadKey();
GradeTable();
}
//###################################################################################################
private void GradeChange() //学生成绩修改
{
Console.WriteLine("\n----------- 4.学生成绩修改 -----------");
SqlConnection conn = new SqlConnection(Stu);
conn.Open();
Console.Write("请输入姓名：");
string name = Console.ReadLine().Trim();
Console.Write("请输入学号：");
string number = Console.ReadLine().Trim();
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "select * from 学生成绩表 where Name='" + name + "' and Number='" + number + "'";
SqlDataReader sdt = cmd.ExecuteReader();
while (true)
{
if (name.Equals(""))
{
Console.WriteLine("姓名不得为空!\n请输入学生姓名：");
name = Console.ReadLine().Trim();
}
else if (Equals(number, ""))
{
Console.Write("学号不得为空!\n请输入学生学号：");
number = Console.ReadLine().Trim();
}
else if (sdt.Read())
{
AlterGrade(number);
}
else
{
Console.WriteLine("查无此人!");
Console.ReadKey();
GradeChange();
}
}
}
private void AlterGrade(string number) //选择要修改的课程科目
{
Console.Write("\n1、语文；2、数学；3、英语；0、返回\n请选择要修改成绩的学科：");
string num = Console.ReadLine().Trim();
while (true)
{
switch (num)
{
case "1":
{
Console.Write("请输入修改后的语文成绩：");
string chinese = Console.ReadLine().Trim().Trim();
Alter(1, number, chinese);
}; break;
case "2":
{
Console.Write("请输入修改后的数学成绩：");
string math = Console.ReadLine().Trim().Trim();
Alter(2, number, math);
}; break;
case "3":
{
Console.Write("请输入修改后的英语成绩：");
string english = Console.ReadLine().Trim().Trim();
Alter(3, number, english);
}; break;
case "0": GradeTable(); break;
default:
{
Console.Write("请重新输入选择：");
num = Console.ReadLine().Trim();
}; break;
}
}
}
private void Alter(int num, string number, string item) //
{
SqlConnection conn = new SqlConnection(Stu);
conn.Open();
if (num.Equals(1))
{
try
{
string InsertStr = string.Format("update 学生成绩表 set Chinese='{0}' WHERE Number='{1}';", item, number);
SqlCommand comm = conn.CreateCommand();
SqlCommand mycom = new SqlCommand(InsertStr, conn);
mycom.ExecuteNonQuery();
conn.Close();
Console.WriteLine("语文成绩修改成功!");
Console.ReadKey();
AlterGrade(number);
}
catch (Exception ex)
{
Console.WriteLine("成绩修改失败!");
Console.WriteLine(ex.Message);
conn.Close();
}
}
else if (num.Equals(2))
{
try
{
string InsertStr = string.Format("update 学生成绩表 set Math='{0}' WHERE Number='{1}';", item, number);
SqlCommand comm = conn.CreateCommand();
SqlCommand mycom = new SqlCommand(InsertStr, conn);
mycom.ExecuteNonQuery();
conn.Close();
Console.WriteLine("数学成绩修改成功!");
Console.ReadKey();
AlterGrade(number);
}
catch (Exception ex)
{
Console.WriteLine("成绩修改失败!");
Console.WriteLine(ex.Message);
conn.Close();
}
}
else if (num.Equals(3))
{
try
{
string InsertStr = string.Format("update 学生成绩表 set English='{0}' WHERE Number='{1}';", item, number);
SqlCommand comm = conn.CreateCommand();
SqlCommand mycom = new SqlCommand(InsertStr, conn);
mycom.ExecuteNonQuery();
conn.Close();
Console.WriteLine("英语成绩修改成功!");
Console.ReadKey();
AlterGrade(number);
}
catch (Exception ex)
{
Console.WriteLine("成绩修改失败!");
Console.WriteLine(ex.Message);
conn.Close();
}
}
conn.Close();
}
//####################################################################################################
private void GradeDelete() //学生成绩删除
{
SqlConnection conn = new SqlConnection(Stu);
conn.Open();
Console.WriteLine("\n****************** 5.学生成绩删除 ********************");
Console.Write("请输入学生姓名：");
string name = Console.ReadLine().Trim();
Console.Write("请输入学生学号：");
string number = Console.ReadLine().Trim();
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "select * from 学生成绩表 where Name='" + name + "' and Number='" + number + "'";
SqlDataReader reader = cmd.ExecuteReader();
while (true)
{
if (Equals(name, ""))
{
Console.Write("姓名不得为空!\n请输入学生姓名：");
name = Console.ReadLine().Trim();
}
else if (number.Equals(""))
{
Console.Write("学号不得为空!\n请输入学生学号：");
number = Console.ReadLine().Trim();
}
else if (reader.Read())
{
DelGrade(number);
}
else
{
Console.WriteLine("查无此人!");
conn.Close();
GradeTable();
}
}
}
private void DelGrade(string number)
{
SqlConnection conn = new SqlConnection(Stu);
conn.Open();
try
{
string sql2 = "delete from 登录注册表 where username='" + number + "'";
SqlCommand cmd1 = new SqlCommand(sql2, conn);
cmd1.ExecuteNonQuery();
Console.WriteLine("成绩信息删除成功!");
conn.Close();
Console.ReadKey();
GradeTable();
}
catch (Exception ex)
{
Console.WriteLine("成绩信息删除失败!");
Console.WriteLine(ex.Message);
conn.Close();
GradeTable();
}
}
}
//######################################################################################################
//######################################################################################################
//######################################################################################################
class Program
{
static void Main()
{
Account st = new Account();
st.Main2();
}
}
}
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- 21
- 22
- 23
- 24
- 25
- 26
- 27
- 28
- 29
- 30
- 31
- 32
- 33
- 34
- 35
- 36
- 37
- 38
- 39
- 40
- 41
- 42
- 43
- 44
- 45
- 46
- 47
- 48
- 49
- 50
- 51
- 52
- 53
- 54
- 55
- 56
- 57
- 58
- 59
- 60
- 61
- 62
- 63
- 64
- 65
- 66
- 67
- 68
- 69
- 70
- 71
- 72
- 73
- 74
- 75
- 76
- 77
- 78
- 79
- 80
- 81
- 82
- 83
- 84
- 85
- 86
- 87
- 88
- 89
- 90
- 91
- 92
- 93
- 94
- 95
- 96
- 97
- 98
- 99
- 100
- 101
- 102
- 103
- 104
- 105
- 106
- 107
- 108
- 109
- 110
- 111
- 112
- 113
- 114
- 115
- 116
- 117
- 118
- 119
- 120
- 121
- 122
- 123
- 124
- 125
- 126
- 127
- 128
- 129
- 130
- 131
- 132
- 133
- 134
- 135
- 136
- 137
- 138
- 139
- 140
- 141
- 142
- 143
- 144
- 145
- 146
- 147
- 148
- 149
- 150
- 151
- 152
- 153
- 154
- 155
- 156
- 157
- 158
- 159
- 160
- 161
- 162
- 163
- 164
- 165
- 166
- 167
- 168
- 169
- 170
- 171
- 172
- 173
- 174
- 175
- 176
- 177
- 178
- 179
- 180
- 181
- 182
- 183
- 184
- 185
- 186
- 187
- 188
- 189
- 190
- 191
- 192
- 193
- 194
- 195
- 196
- 197
- 198
- 199
- 200
- 201
- 202
- 203
- 204
- 205
- 206
- 207
- 208
- 209
- 210
- 211
- 212
- 213
- 214
- 215
- 216
- 217
- 218
- 219
- 220
- 221
- 222
- 223
- 224
- 225
- 226
- 227
- 228
- 229
- 230
- 231
- 232
- 233
- 234
- 235
- 236
- 237
- 238
- 239
- 240
- 241
- 242
- 243
- 244
- 245
- 246
- 247
- 248
- 249
- 250
- 251
- 252
- 253
- 254
- 255
- 256
- 257
- 258
- 259
- 260
- 261
- 262
- 263
- 264
- 265
- 266
- 267
- 268
- 269
- 270
- 271
- 272
- 273
- 274
- 275
- 276
- 277
- 278
- 279
- 280
- 281
- 282
- 283
- 284
- 285
- 286
- 287
- 288
- 289
- 290
- 291
- 292
- 293
- 294
- 295
- 296
- 297
- 298
- 299
- 300
- 301
- 302
- 303
- 304
- 305
- 306
- 307
- 308
- 309
- 310
- 311
- 312
- 313
- 314
- 315
- 316
- 317
- 318
- 319
- 320
- 321
- 322
- 323
- 324
- 325
- 326
- 327
- 328
- 329
- 330
- 331
- 332
- 333
- 334
- 335
- 336
- 337
- 338
- 339
- 340
- 341
- 342
- 343
- 344
- 345
- 346
- 347
- 348
- 349
- 350
- 351
- 352
- 353
- 354
- 355
- 356
- 357
- 358
- 359
- 360
- 361
- 362
- 363
- 364
- 365
- 366
- 367
- 368
- 369
- 370
- 371
- 372
- 373
- 374
- 375
- 376
- 377
- 378
- 379
- 380
- 381
- 382
- 383
- 384
- 385
- 386
- 387
- 388
- 389
- 390
- 391
- 392
- 393
- 394
- 395
- 396
- 397
- 398
- 399
- 400
- 401
- 402
- 403
- 404
- 405
- 406
- 407
- 408
- 409
- 410
- 411
- 412
- 413
- 414
- 415
- 416
- 417
- 418
- 419
- 420
- 421
- 422
- 423
- 424
- 425
- 426
- 427
- 428
- 429
- 430
- 431
- 432
- 433
- 434
- 435
- 436
- 437
- 438
- 439
- 440
- 441
- 442
- 443
- 444
- 445
- 446
- 447
- 448
- 449
- 450
- 451
- 452
- 453
- 454
- 455
- 456
- 457
- 458
- 459
- 460
- 461
- 462
- 463
- 464
- 465
- 466
- 467
- 468
- 469
- 470
- 471
- 472
- 473
- 474
- 475
- 476
- 477
- 478
- 479
- 480
- 481
- 482
- 483
- 484
- 485
- 486
- 487
- 488
- 489
- 490
- 491
- 492
- 493
- 494
- 495
- 496
- 497
- 498
- 499
- 500
- 501
- 502
- 503
- 504
- 505
- 506
- 507
- 508
- 509
- 510
- 511
- 512
- 513
- 514
- 515
- 516
- 517
- 518
- 519
- 520
- 521
- 522
- 523
- 524
- 525
- 526
- 527
- 528
- 529
- 530
- 531
- 532
- 533
- 534
- 535
- 536
- 537
- 538
- 539
- 540
- 541
- 542
- 543
- 544
- 545
- 546
- 547
- 548
- 549
- 550
- 551
- 552
- 553
- 554
- 555
- 556
- 557
- 558
- 559
- 560
- 561
- 562
- 563
- 564
- 565
- 566
- 567
- 568
- 569
- 570
- 571
- 572
- 573
- 574
- 575
- 576
- 577
- 578
- 579
- 580
- 581
- 582
- 583
- 584
- 585
- 586
- 587
- 588
- 589
- 590
- 591
- 592
- 593
- 594
- 595
- 596
- 597
- 598
- 599
- 600
- 601
- 602
- 603
- 604
- 605
- 606
- 607
- 608
- 609
- 610
- 611
- 612
- 613
- 614
- 615
- 616
- 617
- 618
- 619
- 620
- 621
- 622
- 623
- 624
- 625
- 626
- 627
- 628
- 629
- 630
- 631
- 632
- 633
- 634
- 635
- 636
- 637
- 638
- 639
- 640
- 641
- 642
- 643
- 644
- 645
- 646
- 647
- 648
- 649
- 650
- 651
- 652
- 653
- 654
- 655
- 656
- 657
- 658
- 659
- 660
- 661
- 662
- 663
- 664
- 665
- 666
- 667
- 668
- 669
- 670
- 671
- 672
- 673
- 674
- 675
- 676
- 677
- 678
- 679
- 680
- 681
- 682
- 683
- 684
- 685
- 686
- 687
- 688
- 689
- 690
- 691
- 692
- 693
- 694
- 695
- 696
- 697
- 698
- 699
- 700
- 701
- 702
- 703
- 704
- 705
- 706
- 707
- 708
- 709
- 710
- 711
- 712
- 713
- 714
- 715
- 716
- 717
- 718
- 719
- 720
- 721
- 722
- 723
- 724
- 725
- 726
- 727
- 728
- 729
- 730
- 731
- 732
- 733
- 734
- 735
- 736
- 737
- 738
- 739
- 740
- 741
- 742
- 743
- 744
- 745
- 746
- 747
- 748
- 749
- 750
- 751
- 752
- 753
- 754
- 755
- 756
- 757
- 758
- 759
- 760
- 761
- 762
- 763
- 764
- 765
- 766
- 767
- 768
- 769
- 770
- 771
- 772
- 773
- 774
- 775
- 776
- 777
- 778
- 779
- 780
- 781
- 782
- 783
- 784
- 785
- 786
- 787
- 788
- 789
- 790
- 791
- 792
- 793
- 794
- 795
- 796
- 797
- 798
- 799
- 800
- 801
- 802
- 803
- 804
- 805
- 806
- 807
- 808
- 809
- 810
- 811
- 812
- 813
- 814
- 815
- 816
- 817
- 818
- 819
- 820
- 821
- 822
- 823
- 824
- 825
- 826
- 827
- 828
- 829
- 830
- 831
- 832
- 833
- 834
- 835
- 836
- 837
- 838
- 839
- 840
- 841
- 842
- 843
- 844
- 845
- 846
- 847
- 848
- 849
- 850
- 851
- 852
- 853
- 854
- 855
- 856
- 857
- 858
- 859
- 860
- 861
- 862
- 863
- 864
- 865
- 866
- 867
- 868
- 869
- 870
- 871
- 872
- 873
- 874
- 875
- 876
- 877
- 878
- 879
- 880
- 881
- 882
- 883
- 884
- 885
- 886
- 887
- 888
- 889
- 890
- 891
- 892
- 893
- 894
- 895
- 896
- 897
- 898
- 899
- 900
- 901
- 902
- 903
- 904
- 905
- 906
- 907
- 908
- 909
运行效果截图
总结
以上就是关于这个程序的全部了，感兴趣的小伙伴们可以来看看，供大家参考和学习可能还有不足之处，一些冗长的部分可以简化，也欢迎大家来批评指正。之前我还做了一个账号登录的窗体程序：C#窗体程序连接SQL Server实现账号登录、账号注册、修改密码、账号注销等功能。
声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/Guff_9hys/article/detail/871449
推荐阅读
相关标签
