数据库大作业，代码展示

最新推荐文章于 2023-12-21 19:50:01 发布
最新推荐文章于 2023-12-21 19:50:01 发布
阅读量526 收藏 9
点赞数 1
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/ker_viner/article/details/106874529
版权

在这里插入图片描述
登录界面代码：

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Linq;
using System.Security.Cryptography;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;

namespace test518
{
public partial class Form1 : Form
{
    public class Class1
    {
        public static string UserID;
    }
    public Form1()
    {
        InitializeComponent();
    }

    private void button1_Click(object sender, EventArgs e)
    {
        string username = textBox1.Text.Trim();
        string password = textBox2.Text.Trim();
        string myConnString = "Data Source=.;Initial Catalog=STUDENT;User ID=sa;Password=woaini123";

        SqlConnection sqlConnection = new SqlConnection(myConnString);
        sqlConnection.Open();

        string sql = "select 用户名称,密码 from UserTable where 用户名称 ='" + username + "' and 密码 ='" + password + "'";

        SqlCommand sqlcommand = new SqlCommand(sql, sqlConnection);

        SqlDataReader sqlDataReader = sqlcommand.ExecuteReader();
        if (sqlDataReader.HasRows&&textBox3.Text==label5.Text)
        {
            if(username=="admin")
            {
                Class1.UserID = username;
                MessageBox.Show("欢迎使用！");
                Manager manager = new Manager();
                manager.Show();
                this.Hide();
            }
            else
            {
                Class1.UserID = username;
                MessageBox.Show("欢迎使用！");
                Form2 form2 = new Form2();
                form2.Show();
                this.Hide();

            }

        }
        else
        {
            MessageBox.Show("登录失败，输入密码或验证码错误！");
            textBox1.Text = "";
            textBox2.Text = "";
            textBox3.Text = "";
            return;
        }
        sqlDataReader.Close();
        sqlConnection.Close();

    }

    private void button2_Click(object sender, EventArgs e)
    {
        Application.Exit();
    }
    public static string EncryptWithMD5(string source)
    {
        byte[] sor = Encoding.UTF8.GetBytes(source);
        MD5 md5 = MD5.Create();
        byte[] result = md5.ComputeHash(sor);
        StringBuilder strbul = new StringBuilder(40);
        for (int i = 0; i < result.Length; i++)
        {
            strbul.Append(result[i].ToString("x2"));
        }
        return strbul.ToString();
    }
    public string code;
    private void Form1_Load(object sender, EventArgs e)
    {
        Random ran = new Random();
        int number;
        char code1;
        for (int i = 0; i < 5; i++)
        {
            number = ran.Next();
            if (number % 2 == 0)
                code1 = (char)('0' + (char)(number % 10));
            else
                code1 = (char)('A' + (char)(number % 26));

            this.code += code1.ToString();
        }

        label5.Text = code;
    }
    private void label5_Click(object sender, EventArgs e)
    {
        
    }

    private void linkLabel1_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
    {
        register register = new register();
        register.ShowDialog();
    }

    private void linkLabel2_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
    {
        Form3 form3 = new Form3();
        form3.Show();
        this.Hide();
    }
}
}

在这里插入图片描述

注册窗口代码：

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.IO;
using System.Linq;
using System.Security.Cryptography;
using System.Text;
using System.Text.RegularExpressions;
using System.Threading.Tasks;
using System.Windows.Forms;

namespace test518
{
public partial class register : Form
{
    public register()
    {
        InitializeComponent();
    }
    private void Register_Load(object sender, EventArgs e)
    {

    }
    public static string EncryptWithMD5(string source)
    {
        byte[] sor = Encoding.UTF8.GetBytes(source);
        MD5 md5 = MD5.Create();
        byte[] result = md5.ComputeHash(sor);
        StringBuilder strbul = new StringBuilder(40);
        for (int i = 0; i < result.Length; i++)
        {
            strbul.Append(result[i].ToString("x2"));//加密结果"x2"结果为32位,"x3"结果为48位,"x4"结果为64位
        }
        return strbul.ToString();
    }

    private void button2_Click(object sender, EventArgs e)
    {
        this.Close();
    }

    private void button1_Click(object sender, EventArgs e)
    {
        try
        {
            string connString = "Data Source=.;Initial Catalog=STUDENT;User ID=sa;Password=woaini123";
            SqlConnection connection = new SqlConnection(connString);
            string sql = "insert into UserTable (用户名称,密码,学号,手机号码,出生日期)" +
                                                    "values (@userid, @userpassword,@userschoolid,@usermobile,@userbirthday)";
            SqlCommand command = new SqlCommand(sql, connection);

            SqlParameter sqlParameter = new SqlParameter("@userid", textBox1.Text);
            command.Parameters.Add(sqlParameter);
            sqlParameter = new SqlParameter("@userpassword", EncryptWithMD5(textBox2.Text));
            command.Parameters.Add(sqlParameter);
            sqlParameter = new SqlParameter("@userschoolid", textBox3.Text);
            command.Parameters.Add(sqlParameter);
            sqlParameter = new SqlParameter("@usermobile", textBox4.Text);
            command.Parameters.Add(sqlParameter);
            sqlParameter = new SqlParameter("@userbirthday", dateTimePicker1.Value);
            command.Parameters.Add(sqlParameter);

            //打开数据库连接
            connection.Open();
            command.ExecuteNonQuery();
            connection.Close();
            MessageBox.Show("register succeed");
        }
        catch (Exception ex)
        {
            MessageBox.Show(ex.Message);
        }
        this.Close();
    }
    private void textBox1_Leave(object sender, EventArgs e)
    {
        if (textBox1.Text.Trim() != "")
        {
            Regex regex = new Regex(@"(?=.*[0-9])(?=.*[a-z])(?=.*[A-Z]).{3,20}");

            if (regex.IsMatch(textBox1.Text))
            {
                //MessageBox.Show("输入密码格式正确!");
            }
            else
            {
                MessageBox.Show("至少有数字、大写字母、小写字母各一个。最少3个字符、最长20个字符！");
                textBox1.Focus();
            }
        }
        else
        {
            MessageBox.Show("请填写全部信息！");
        }
    }
}
}

在这里插入图片描述

找回密码窗口代码：

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Linq;
using System.Security.Cryptography;
using System.Text;
using System.Text.RegularExpressions;
using System.Threading.Tasks;
using System.Windows.Forms;

namespace test518
{
public partial class Form3 : Form
{
    public Form3()
    {
        InitializeComponent();
    }
    public string code;
    public Byte[] mybyte = new byte[0];
    public static string EncryptWithMD5(string source)
    {
        byte[] sor = Encoding.UTF8.GetBytes(source);
        MD5 md5 = MD5.Create();
        byte[] result = md5.ComputeHash(sor);
        StringBuilder strbul = new StringBuilder(40);
        for (int i = 0; i < result.Length; i++)
        {
            strbul.Append(result[i].ToString("x2"));//加密结果"x2"结果为32位,"x3"结果为48位,"x4"结果为64位
        }
        return strbul.ToString();
    }
    private void button1_Click(object sender, EventArgs e)
    {
        string username = textBox1.Text.Trim();
        string cellphone = textBox2.Text.Trim();
        int flag1 = 0;
        int flag2 = 0;

        string myConnString = "Data Source=.;Initial Catalog=STUDENT;User ID=sa;Password=woaini123";

        SqlConnection sqlConnection = new SqlConnection(myConnString);
        sqlConnection.Open();

        string sql1 = "select 用户名称,手机号码 from UserTable where 用户名称 = '" + username + "' and 手机号码 = '" + cellphone + "'";                                            
        SqlCommand sqlCommand1 = new SqlCommand(sql1, sqlConnection);
    
        SqlDataReader sqlDataReader1 = sqlCommand1.ExecuteReader();
        if (sqlDataReader1.HasRows)
        {
            if (textBox3.Text.Trim() != "")
            {
                Regex regex = new Regex(@"(?=.*[0-9]).{3,15}");

                if (regex.IsMatch(textBox3.Text))
                {
                    flag1 = 1;
                }

            }
        }
            sqlDataReader1.Close();
        if (flag1 == 1)
        {
            string password = EncryptWithMD5(textBox3.Text.Trim());
            string sql3 = "update UserTable set 密码='" + password + "' where 用户名称='" + username + "'";
            SqlCommand sqlCommand3 = new SqlCommand(sql3, sqlConnection);
            SqlDataReader sqlDataReader3 = sqlCommand3.ExecuteReader();
            MessageBox.Show("修改成功");
            sqlDataReader3.Close();
            Form1 form1 = new Form1();
            form1.Show();
            this.Hide();
        }
        else
        {
            label5.Text = "输入密码错误或手机号码错误，请重新输入";
            textBox1.Text = "";
            textBox2.Text = "";
            textBox3.Text = "";
            return;
        }
            sqlConnection.Close();
        }

    private void button2_Click(object sender, EventArgs e)
    {
        Form1 form1 = new Form1();
        form1.Show();
        this.Hide();
    }
}
}

在这里插入图片描述

管理员界面代码：

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;

namespace test518
{
public partial class Manager : Form
{
    public Manager()
    {
        InitializeComponent();
    }

    private void button1_Click(object sender, EventArgs e)
    {
        Form1 form1 = new Form1();
        form1.Show();
        this.Hide();
    }

    private void button2_Click(object sender, EventArgs e)
    {
        manageruser manageruser = new manageruser();
        manageruser.Show();
        this.Hide();
    }

    private void button3_Click(object sender, EventArgs e)
    {
        managercourse managercourse = new managercourse();
        managercourse.Show();
        this.Hide();
    }

    private void button4_Click(object sender, EventArgs e)
    {
        managercs managercs = new managercs();
        managercs.Show();
        this.Hide();
    }

    private void label1_Click(object sender, EventArgs e)
    {
        
    }
}
}

在这里插入图片描述

学生信息界面代码：

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Linq;
using System.Security.Cryptography;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;

namespace test518
{
public partial class manageruser : Form
{
    public manageruser()
    {
        InitializeComponent();
    }
    SqlConnection con = new SqlConnection("Data Source=.;Initial Catalog=STUDENT;User ID=sa;Password=woaini123");


    private void manageruser_Load(object sender, EventArgs e)
    {
        this.studentTableTableAdapter.Fill(this.sTUDENTDataSet2.StudentTable);


    }
    public static string EncryptWithMD5(string source)
    {
        byte[] sor = Encoding.UTF8.GetBytes(source);
        MD5 md5 = MD5.Create();
        byte[] result = md5.ComputeHash(sor);
        StringBuilder strbul = new StringBuilder(40);
        for (int i = 0; i < result.Length; i++)
        {
            strbul.Append(result[i].ToString("x2"));
        }
        return strbul.ToString();
    }

    private void button5_Click(object sender, EventArgs e)
    {
        Manager manager = new Manager();
        manager.Show();
        this.Hide();
    }

    private void button1_Click(object sender, EventArgs e)
    {
        try
        {
            String Mno = textBox1.Text.Trim();
            String Mname = textBox2.Text.Trim();
            String Msex = textBox3.Text.Trim();
            String Mbirth = textBox4.Text.Trim();
            String Mzhuan = textBox5.Text.Trim();
            String Mdept = textBox6.Text.Trim();
            String Mcelllphone = textBox7.Text.Trim();
            String Mming = textBox8.Text.Trim();

            con.Open();
            string insertStr = "INSERT INTO StudentTable(学号,姓名,性别,出生日期,手机号码,民族,年级,专业) " +
                "VALUES('" + Mno + "','" + Mname + "','" + Msex + "','" + Mbirth + "','" + Mcelllphone + "','" + Mming + "','" + Mdept + "','" + Mzhuan + "')";
            SqlCommand cmd = new SqlCommand(insertStr, con);
            cmd.ExecuteNonQuery();
        }
        catch
        {
            MessageBox.Show("输入不符要求！");
        }
        finally
        {
            con.Dispose();
        }
       
        this.studentTableTableAdapter.Fill(this.sTUDENTDataSet2.StudentTable);
    }


    private void button2_Click(object sender, EventArgs e)
    {
        try
        {

            con.Open();
            string select_id = dataGridView1.SelectedRows[0].Cells[0].Value.ToString();
            string delete_by_id = "delete from StudentTable where 学号=" + select_id;
            SqlCommand cmd = new SqlCommand(delete_by_id, con);
            cmd.ExecuteNonQuery();
        }
        catch
        {
            MessageBox.Show("请正确选择行!");
        }
        finally
        {
            con.Dispose();
        }

        this.studentTableTableAdapter.Fill(this.sTUDENTDataSet2.StudentTable);
    }

    private void button3_Click_1(object sender, EventArgs e)
    {
        String Mno = textBox1.Text.Trim();
        String Mname = textBox2.Text.Trim();
        String Msex = textBox3.Text.Trim();
        String Mbirth = textBox4.Text.Trim();
        String Mzhuan = textBox5.Text.Trim();
        String Mdept = textBox6.Text.Trim();
        String Mcelllphone = textBox7.Text.Trim();
        String Mming = textBox8.Text.Trim();
        try
        {
            con.Open();
            if (Mname != "")
            {
                string insertStr = "UPDATE StudentTable SET 姓名 = '" + Mname + "' WHERE   学号='" + Mno + "'";
                SqlCommand cmd = new SqlCommand(insertStr, con);
                cmd.ExecuteNonQuery();
            }
            if (Msex != "")
            {
                string insertStr = "UPDATE StudentTable SET 性别 = '" + Msex + "' WHERE   学号='" + Mno + "'";
                SqlCommand cmd = new SqlCommand(insertStr, con);
                cmd.ExecuteNonQuery();
            }
            if (Mbirth != "")
            {
                string insertStr = "UPDATE StudentTable SET 出生日期 = '" + Mbirth + "' WHERE   学号='" + Mno + "'";
                SqlCommand cmd = new SqlCommand(insertStr, con);
                cmd.ExecuteNonQuery();
            }
            if (Mzhuan != "")
            {
                string insertStr = "UPDATE StudentTable SET 籍贯 = '" + Mzhuan + "' WHERE  学号='" + Mno + "'";
                SqlCommand cmd = new SqlCommand(insertStr, con);
                cmd.ExecuteNonQuery();
            }
            if (Mcelllphone != "")
            {
                string insertStr = "UPDATE StudentTable SET 手机号码 = '" + Mcelllphone + "' WHERE   学号='" + Mno + "'";
                SqlCommand cmd = new SqlCommand(insertStr, con);
                cmd.ExecuteNonQuery();
            }
            if (Mming != "")
            {
                string insertStr = "UPDATE StudentTable SET 民族 = '" + Mming + "' WHERE   学号='" + Mno + "'";
                SqlCommand cmd = new SqlCommand(insertStr, con);
                cmd.ExecuteNonQuery();
            }
            if (Mdept != "")
            {
                string insertStr = "UPDATE StudentTable SET 年级 = '" + Mdept + "' WHERE   学号='" + Mno + "'";
                SqlCommand cmd = new SqlCommand(insertStr, con);
                cmd.ExecuteNonQuery();
            }
        }
        catch
        {
            MessageBox.Show("输入数据违反要求!");
        }
        finally
        {
            con.Dispose();
        }

        this.studentTableTableAdapter.Fill(this.sTUDENTDataSet2.StudentTable);
    }

    private void button4_Click_1(object sender, EventArgs e)
    {

            String Mno = textBox1.Text.Trim();
            String Mname = textBox2.Text.Trim();
            String Msex = textBox3.Text.Trim();
            String Mbirth = textBox4.Text.Trim();
            String Mzhuan = textBox5.Text.Trim();
            String Mdept = textBox6.Text.Trim();
            String Mcelllphone = textBox7.Text.Trim();
            String Mming = textBox8.Text.Trim();

            String conn = "Data Source=.;Initial Catalog=STUDENT;User ID=sa;Password=woaini123";
            SqlConnection sqlConnection = new SqlConnection(conn);
        try
        {

            if (Mno != "")
            {
                sqlConnection.Open();
                String select_by_id = "select * from StudentTable where 学号='" + Mno + "'";
                SqlCommand sqlCommand = new SqlCommand(select_by_id, sqlConnection);
                SqlDataReader sqlDataReader = sqlCommand.ExecuteReader();
                BindingSource bindingSource = new BindingSource();
                bindingSource.DataSource = sqlDataReader;
                dataGridView1.DataSource = bindingSource;
            }
            if (Mname != "")
            {
                sqlConnection.Open();
                String select_by_id = "select * from StudentTable where 姓名 Like'" + Mname + "%'";
                SqlCommand sqlCommand = new SqlCommand(select_by_id, sqlConnection);
                SqlDataReader sqlDataReader = sqlCommand.ExecuteReader();
                BindingSource bindingSource = new BindingSource();
                bindingSource.DataSource = sqlDataReader;
                dataGridView1.DataSource = bindingSource;
            }
            if (Msex != "")
            {
                sqlConnection.Open();
                String select_by_id = "select * from StudentTable where 性别='" + Msex + "'";
                SqlCommand sqlCommand = new SqlCommand(select_by_id, sqlConnection);
                SqlDataReader sqlDataReader = sqlCommand.ExecuteReader();
                BindingSource bindingSource = new BindingSource();
                bindingSource.DataSource = sqlDataReader;
                dataGridView1.DataSource = bindingSource;
            }
            if (Mbirth != "")
            {
                sqlConnection.Open();
                String select_by_id = "select * from StudentTable where 出生日期 Like'" + Mbirth + "%'";
                SqlCommand sqlCommand = new SqlCommand(select_by_id, sqlConnection);
                SqlDataReader sqlDataReader = sqlCommand.ExecuteReader();
                BindingSource bindingSource = new BindingSource();
                bindingSource.DataSource = sqlDataReader;
                dataGridView1.DataSource = bindingSource;
            }
            if (Mzhuan != "")
            {
                sqlConnection.Open();
                String select_by_id = "select * from StudentTable where 专业 Like'" + Mzhuan + "%'";
                SqlCommand sqlCommand = new SqlCommand(select_by_id, sqlConnection);
                SqlDataReader sqlDataReader = sqlCommand.ExecuteReader();
                BindingSource bindingSource = new BindingSource();
                bindingSource.DataSource = sqlDataReader;
                dataGridView1.DataSource = bindingSource;
            }
            if (Mcelllphone != "")
            {
                sqlConnection.Open();
                String select_by_id = "select * from StudentTable where 手机号码='" + Mcelllphone + "'";
                SqlCommand sqlCommand = new SqlCommand(select_by_id, sqlConnection);
                SqlDataReader sqlDataReader = sqlCommand.ExecuteReader();
                BindingSource bindingSource = new BindingSource();
                bindingSource.DataSource = sqlDataReader;
                dataGridView1.DataSource = bindingSource;
            }
            if (Mming != "")
            {
                sqlConnection.Open();
                String select_by_id = "select * from StudentTable where 民族 Like'" + Mming + "%'";
                SqlCommand sqlCommand = new SqlCommand(select_by_id, sqlConnection);
                SqlDataReader sqlDataReader = sqlCommand.ExecuteReader();
                BindingSource bindingSource = new BindingSource();
                bindingSource.DataSource = sqlDataReader;
                dataGridView1.DataSource = bindingSource;
            }
            if (Mdept != "")
            {
                sqlConnection.Open();
                String select_by_id = "select * from StudentTable where 专业 Like'" + Mdept + "%'";
                SqlCommand sqlCommand = new SqlCommand(select_by_id, sqlConnection);
                SqlDataReader sqlDataReader = sqlCommand.ExecuteReader();
                BindingSource bindingSource = new BindingSource();
                bindingSource.DataSource = sqlDataReader;
                dataGridView1.DataSource = bindingSource;
            }
        }
        catch
        {
            MessageBox.Show("查询失败！！！");
        }
        finally
        {
            sqlConnection.Close();
        }
    }

    private void textBox7_TextChanged(object sender, EventArgs e)
    {

    }
}
}

在这里插入图片描述

课程信息界面代码：

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;

namespace test518
{
public partial class managercourse : Form
{
    SqlConnection con = new SqlConnection("Data Source=.;Initial Catalog=STUDENT;User ID=sa;Password=woaini123");
    public managercourse()
    {
        InitializeComponent();
    }

    private void managercourse_Load(object sender, EventArgs e)
    {
        // TODO: 这行代码将数据加载到表“sTUDENTDataSet2.Course”中。您可以根据需要移动或删除它。
        this.courseTableAdapter.Fill(this.sTUDENTDataSet2.Course);

    }

    private void button1_Click(object sender, EventArgs e)
    {
        String Cno = textBox1.Text.Trim();//课程号
        String Cname = textBox2.Text.Trim();//课程名
        String Credit = textBox3.Text.Trim();//学分
        try
        {
            con.Open();
            string insertStr = "INSERT INTO Course(课程号,课程名,学分) " +
                "VALUES('" + Cno + "','" + Cname + "','" + Credit + "')";
            SqlCommand cmd = new SqlCommand(insertStr, con);
            cmd.ExecuteNonQuery();
        }
        catch
        {
            MessageBox.Show("输入数据违反要求");
        }
        finally
        {
            con.Dispose();
        }
        this.courseTableAdapter.Fill(this.sTUDENTDataSet2.Course);

    }

    private void button2_Click(object sender, EventArgs e)
    {
        try
        {
            con.Open();
            string select_id = dataGridView1.SelectedRows[0].Cells[0].Value.ToString();
            string delete_by_id = "delete from Course where 课程号=" + select_id;
            SqlCommand cmd = new SqlCommand(delete_by_id, con);
            cmd.ExecuteNonQuery();
        }
        catch
        {
            MessageBox.Show("请正确选择行!");
        }
        finally
        {
            con.Dispose();
        }
        this.courseTableAdapter.Fill(this.sTUDENTDataSet2.Course);
    }

    private void button3_Click(object sender, EventArgs e)
    {
        String Cno = textBox1.Text.Trim();//课程号
        String Cname = textBox2.Text.Trim();//课程名
        String Credit = textBox3.Text.Trim();//学分
        try
        {
            con.Open();
            if (Cname != "")
            {
                string insertStr = "UPDATE Course SET 课程名 = '" + Cname + "' WHERE   课程号='" + Cno + "'";
                SqlCommand cmd = new SqlCommand(insertStr, con);
                cmd.ExecuteNonQuery();
            }
            if (Credit != "")
            {
                string insertStr = "UPDATE Course SET 学分 = '" + Credit + "' WHERE   课程号='" + Cno + "'";
                SqlCommand cmd = new SqlCommand(insertStr, con);
                cmd.ExecuteNonQuery();
            }
        }
        catch
        {
            MessageBox.Show("修改出错！");
        }
        finally
        {
            con.Dispose();
        }
        this.courseTableAdapter.Fill(this.sTUDENTDataSet2.Course);
    }

    private void button4_Click(object sender, EventArgs e)
    {
        String Cno = textBox1.Text.Trim();//课程号
        String Cname = textBox2.Text.Trim();//课程名
        String Credit = textBox3.Text.Trim();//学分
        String conn = "Data Source=.;Initial Catalog=STUDENT;User ID=sa;Password=woaini123";
        SqlConnection sqlConnection = new SqlConnection(conn);
        try
        {
            if (Cno != "")
            {
                sqlConnection.Open();
                String select_by_id = "select * from Course where 课程号='" + Cno + "'";
                SqlCommand sqlCommand = new SqlCommand(select_by_id, sqlConnection);
                SqlDataReader sqlDataReader = sqlCommand.ExecuteReader();
                BindingSource bindingSource = new BindingSource();
                bindingSource.DataSource = sqlDataReader;
                dataGridView1.DataSource = bindingSource;
            }
            if (Cname != "")
            {
                sqlConnection.Open();
                String select_by_id = "select * from Course where 课程名 Like'" + Cname + "%'";
                SqlCommand sqlCommand = new SqlCommand(select_by_id, sqlConnection);
                SqlDataReader sqlDataReader = sqlCommand.ExecuteReader();
                BindingSource bindingSource = new BindingSource();
                bindingSource.DataSource = sqlDataReader;
                dataGridView1.DataSource = bindingSource;
            }
            if (Credit != "")
            {
                sqlConnection.Open();
                String select_by_id = "select * from Course where 学分='" + Credit + "'";
                SqlCommand sqlCommand = new SqlCommand(select_by_id, sqlConnection);
                SqlDataReader sqlDataReader = sqlCommand.ExecuteReader();
                BindingSource bindingSource = new BindingSource();
                bindingSource.DataSource = sqlDataReader;
                dataGridView1.DataSource = bindingSource;
            }
          
        }
        catch
        {
            MessageBox.Show("查询语句有误！");
        }
        finally
        {
            sqlConnection.Close();
        }
    }

    private void button5_Click(object sender, EventArgs e)
    {
        Manager manager = new Manager();
        manager.Show();
        this.Hide();
    }
}
}

在这里插入图片描述

学生成绩信息界面代码：

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;

namespace test518
{
public partial class managercs : Form
{
    SqlConnection con = new SqlConnection("Data Source=.;Initial Catalog=STUDENT;User ID=sa;Password=woaini123");
    public managercs()
    {
        InitializeComponent();
    }

    private void managercs_Load(object sender, EventArgs e)
    {
        // TODO: 这行代码将数据加载到表“sTUDENTDataSet2.SC”中。您可以根据需要移动或删除它。
        this.sCTableAdapter.Fill(this.sTUDENTDataSet2.SC);

    }

    private void button5_Click(object sender, EventArgs e)
    {
        Manager manager = new Manager();
        manager.Show();
        this.Hide();
    }

    private void button1_Click(object sender, EventArgs e)
    {
        String Sno = textBox1.Text.Trim();
        String Sname = textBox2.Text.Trim();
        String Cno = textBox3.Text.Trim();
        String Cname = textBox4.Text.Trim();
        String Grade = textBox5.Text.Trim();
        String Credit = textBox6.Text.Trim();

        try
        {
            con.Open();
            if (Grade != "" && Credit != "")
            {
                string insertStr = "INSERT INTO SC(学号,姓名,课程号,课程名,成绩,学分) " +
                "VALUES('" + Sno + "','" + Sname + "','" + Cno + "','" + Cname + "'," + Grade + "," + Credit + ")";
                SqlCommand cmd = new SqlCommand(insertStr, con);
                cmd.ExecuteNonQuery();
            }
        }
        catch
        {
            MessageBox.Show("输入数据违反要求");
        }
        finally
        {
            con.Dispose();
        }
        this.sCTableAdapter.Fill(this.sTUDENTDataSet2.SC);
    }

    private void button2_Click(object sender, EventArgs e)
    {
        try
        {
            con.Open();
            string select_id1 = dataGridView1.SelectedRows[0].Cells[0].Value.ToString();
            string select_id2 = dataGridView1.SelectedRows[0].Cells[2].Value.ToString().Trim();
            string delete_by_id = "delete from SC where 学号='" + select_id1 + "' AND 课程号='" + select_id2 + "'";
            SqlCommand cmd = new SqlCommand(delete_by_id, con);
            cmd.ExecuteNonQuery();
        }
        catch
        {
            MessageBox.Show("请正确选择行!");
        }
        finally
        {
            con.Dispose();
        }
        this.sCTableAdapter.Fill(this.sTUDENTDataSet2.SC);
    }

    private void button3_Click(object sender, EventArgs e)
    {
        String Sno = textBox1.Text.Trim();
        String Cno = textBox3.Text.Trim();
        String Grade = textBox5.Text.Trim();
        try
        {
            con.Open();
            string insertStr = "UPDATE SC SET 成绩 = " + Grade + " WHERE   学号='" + Sno + "' AND　课程号='" + Cno + "'";
            SqlCommand cmd = new SqlCommand(insertStr, con);
            cmd.ExecuteNonQuery();
        }
        catch
        {
            MessageBox.Show("输入数据违反要求");
        }
        finally
        {
            con.Dispose();
        }
        this.sCTableAdapter.Fill(this.sTUDENTDataSet2.SC);
    }

    private void button4_Click(object sender, EventArgs e)
    {
        String Sno = textBox1.Text.Trim();
        String Sname = textBox2.Text.Trim();
        String Cno = textBox3.Text.Trim();
        String Cname = textBox4.Text.Trim();
        String Grade = textBox5.Text.Trim();
        String Credit = textBox6.Text.Trim();
        String conn = "Data Source=.;Initial Catalog=STUDENT;User ID=sa;Password=woaini123";
        SqlConnection sqlConnection = new SqlConnection(conn);
        try
        {
            if (Sno != "")
            {
                sqlConnection.Open();
                String select_by_id = "select * from SC where 学号='" + Sno + "'";
                SqlCommand sqlCommand = new SqlCommand(select_by_id, sqlConnection);
                SqlDataReader sqlDataReader = sqlCommand.ExecuteReader();
                BindingSource bindingSource = new BindingSource();
                bindingSource.DataSource = sqlDataReader;
                dataGridView1.DataSource = bindingSource;
            }
            if (Sname != "")
            {
                sqlConnection.Open();
                String select_by_id = "select * from SC where 姓名 Like'" + Sname + "%'";
                SqlCommand sqlCommand = new SqlCommand(select_by_id, sqlConnection);
                SqlDataReader sqlDataReader = sqlCommand.ExecuteReader();
                BindingSource bindingSource = new BindingSource();
                bindingSource.DataSource = sqlDataReader;
                dataGridView1.DataSource = bindingSource;
            }
            if (Cno != "")
            {
                sqlConnection.Open();
                String select_by_id = "select * from SC where 课程号='" + Cno + "'";
                SqlCommand sqlCommand = new SqlCommand(select_by_id, sqlConnection);
                SqlDataReader sqlDataReader = sqlCommand.ExecuteReader();
                BindingSource bindingSource = new BindingSource();
                bindingSource.DataSource = sqlDataReader;
                dataGridView1.DataSource = bindingSource;
            }
            if (Cname != "")
            {
                sqlConnection.Open();
                String select_by_id = "select * from SC where 课程名 Like'" + Cname + "%'";
                SqlCommand sqlCommand = new SqlCommand(select_by_id, sqlConnection);
                SqlDataReader sqlDataReader = sqlCommand.ExecuteReader();
                BindingSource bindingSource = new BindingSource();
                bindingSource.DataSource = sqlDataReader;
                dataGridView1.DataSource = bindingSource;
            }
            if (Grade != "")
            {
                sqlConnection.Open();
                String select_by_id = "select * from SC where 成绩 =" + Grade;
                SqlCommand sqlCommand = new SqlCommand(select_by_id, sqlConnection);
                SqlDataReader sqlDataReader = sqlCommand.ExecuteReader();
                BindingSource bindingSource = new BindingSource();
                bindingSource.DataSource = sqlDataReader;
                dataGridView1.DataSource = bindingSource;
            }
            if (Credit != "")
            {
                sqlConnection.Open();
                String select_by_id = "select * from SC where 学分=" + Credit;
                SqlCommand sqlCommand = new SqlCommand(select_by_id, sqlConnection);
                SqlDataReader sqlDataReader = sqlCommand.ExecuteReader();
                BindingSource bindingSource = new BindingSource();
                bindingSource.DataSource = sqlDataReader;
                dataGridView1.DataSource = bindingSource;
            }


        }
        catch
        {
            MessageBox.Show("查询语句有误！");
        }
        finally
        {
            sqlConnection.Close();
        }
    }
}
}

在这里插入图片描述
普通用户界面代码：

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;

namespace test518

{
public partial class Form2 : Form
{
public Form2()
{
InitializeComponent();
}

    private void Form2_Load(object sender, EventArgs e)
    {
        

    }

    private void button1_Click(object sender, EventArgs e)
    {
        this.Close();
    }

    private void button1_Click_1(object sender, EventArgs e)
    {
        Form1 form1 = new Form1();
        form1.Show();
        this.Hide();
    }

    private void button4_Click(object sender, EventArgs e)
    {
        Form4 form4 = new Form4();
        form4.Show();
        this.Hide();
    }

    private void button3_Click(object sender, EventArgs e)
    {
        STUCOURSE sTUCOURSE = new STUCOURSE();
        sTUCOURSE.Show();
        this.Hide();
    }
}
}

在这里插入图片描述

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;

namespace test518
{
public partial class Form4 : Form
{
    public Form4()
    {
        InitializeComponent();
    }
    SqlConnection con = new SqlConnection("Data Source=.;Initial Catalog=STUDENT;User ID=sa;Password=woaini123");
    private void Form4_Load(object sender, EventArgs e)
    {
        // TODO: 这行代码将数据加载到表“sTUDENTDataSet2.SC”中。您可以根据需要移动或删除它。
        this.sCTableAdapter.Fill(this.sTUDENTDataSet2.SC);

    }

    private void button4_Click(object sender, EventArgs e)
    {
        String Sno = textBox1.Text.Trim();
        String Sname = textBox2.Text.Trim();
        String Cno = textBox3.Text.Trim();
        String Cname = textBox4.Text.Trim();
        String Grade = textBox5.Text.Trim();
        String Credit = textBox6.Text.Trim();
        String conn = "Data Source=.;Initial Catalog=STUDENT;User ID=sa;Password=woaini123";
        SqlConnection sqlConnection = new SqlConnection(conn);
        try
        {
            if (Sno != "")
            {
                sqlConnection.Open();
                String select_by_id = "select * from SC where 学号='" + Sno + "'";
                SqlCommand sqlCommand = new SqlCommand(select_by_id, sqlConnection);
                SqlDataReader sqlDataReader = sqlCommand.ExecuteReader();
                BindingSource bindingSource = new BindingSource();
                bindingSource.DataSource = sqlDataReader;
                dataGridView1.DataSource = bindingSource;
            }
            if (Sname != "")
            {
                sqlConnection.Open();
                String select_by_id = "select * from SC where 姓名 Like'" + Sname + "%'";
                SqlCommand sqlCommand = new SqlCommand(select_by_id, sqlConnection);
                SqlDataReader sqlDataReader = sqlCommand.ExecuteReader();
                BindingSource bindingSource = new BindingSource();
                bindingSource.DataSource = sqlDataReader;
                dataGridView1.DataSource = bindingSource;
            }
            if (Cno != "")
            {
                sqlConnection.Open();
                String select_by_id = "select * from SC where 课程号='" + Cno + "'";
                SqlCommand sqlCommand = new SqlCommand(select_by_id, sqlConnection);
                SqlDataReader sqlDataReader = sqlCommand.ExecuteReader();
                BindingSource bindingSource = new BindingSource();
                bindingSource.DataSource = sqlDataReader;
                dataGridView1.DataSource = bindingSource;
            }
            if (Cname != "")
            {
                sqlConnection.Open();
                String select_by_id = "select * from SC where 课程名 Like'" + Cname + "%'";
                SqlCommand sqlCommand = new SqlCommand(select_by_id, sqlConnection);
                SqlDataReader sqlDataReader = sqlCommand.ExecuteReader();
                BindingSource bindingSource = new BindingSource();
                bindingSource.DataSource = sqlDataReader;
                dataGridView1.DataSource = bindingSource;
            }
            if (Grade != "")
            {
                sqlConnection.Open();
                String select_by_id = "select * from SC where 成绩 =" + Grade;
                SqlCommand sqlCommand = new SqlCommand(select_by_id, sqlConnection);
                SqlDataReader sqlDataReader = sqlCommand.ExecuteReader();
                BindingSource bindingSource = new BindingSource();
                bindingSource.DataSource = sqlDataReader;
                dataGridView1.DataSource = bindingSource;
            }
            if (Credit != "")
            {
                sqlConnection.Open();
                String select_by_id = "select * from SC where 学分=" + Credit;
                SqlCommand sqlCommand = new SqlCommand(select_by_id, sqlConnection);
                SqlDataReader sqlDataReader = sqlCommand.ExecuteReader();
                BindingSource bindingSource = new BindingSource();
                bindingSource.DataSource = sqlDataReader;
                dataGridView1.DataSource = bindingSource;
            }


        }
        catch
        {
            MessageBox.Show("查询语句有误！");
        }
        finally
        {
            sqlConnection.Close();
        }
    }

    private void button5_Click(object sender, EventArgs e)
    {
        Form2 form2 = new Form2();
        form2.Show();
        this.Hide();
    }
}
}

在这里插入图片描述

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;

namespace test518
{
public partial class STUCOURSE : Form
{
    public STUCOURSE()
    {
        InitializeComponent();
    }
    SqlConnection con = new SqlConnection("Data Source=.;Initial Catalog=STUDENT;User ID=sa;Password=woaini123");
    private void STUCOURSE_Load(object sender, EventArgs e)
    {
        // TODO: 这行代码将数据加载到表“sTUDENTDataSet2.Course”中。您可以根据需要移动或删除它。
        this.courseTableAdapter.Fill(this.sTUDENTDataSet2.Course);

    }

    private void button5_Click(object sender, EventArgs e)
    {
        Form2 form2 = new Form2();
        form2.Show();
        this.Hide();
    }

    private void button1_Click(object sender, EventArgs e)
    {
        String Cno = textBox1.Text.Trim();//课程号
        String Cname = textBox2.Text.Trim();//课程名
        String Credit = textBox3.Text.Trim();//学分
        try
        {
            con.Open();
            string insertStr = "INSERT INTO Course(课程号,课程名,学分) " +
                "VALUES('" + Cno + "','" + Cname + "','" + Credit + "')";
            SqlCommand cmd = new SqlCommand(insertStr, con);
            cmd.ExecuteNonQuery();
        }
        catch
        {
            MessageBox.Show("输入数据违反要求");
        }
        finally
        {
            con.Dispose();
        }
        this.courseTableAdapter.Fill(this.sTUDENTDataSet2.Course);
    }
}
}
海绵宝宝凯文儿
关注
  • 1
    点赞
  • 踩
  • 9
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
数据库常用代码
qq_53121574的博客
07-29 6415
用户创建和授权 创建用户：create user ‘username’@’host’identified by ‘password’ 授权：grant all privileges on *.* to ‘username’@’host’identified by ‘password’ 刷新权限：flush privileges 撤销授权：revoke all on *.* from ‘username’@’host’ 删除与用户：drop user ‘username’@’host’ 数据库..
数据库常见操作代码(可直接复制粘贴修改提示内容）
xiaoyuzui的博客
03-12 8116
一、操作数据库 二、操作表（增删改查） 1、查 （1）show tables； （2）desc 表名称； 2、增 （1）create table 表名{ 字段1 数据类型, 字段2 数据类型, 字段3 数据类型 }; ...
mysql基础代码
qq_58202550的博客
08-05 3739
基础代码
数据库 代码总结
qq_45786520的博客
09-20 2929
代码 # 数据库emp如果存在就删除 drop database if exists emp; # 创建数据库emp Create database emp # 默认中国字符集编码 # 网页编码和数据库编码要对应起来，不然可能会乱码 default character set=gb2312 default collate=gb2312_chinese_ci; use emp; # 创建数据表 Create table dept(deptID char(9) primary key , /* 列级完整性约
数据库代码总结
李晨璐的博客
09-23 7069
有关数据库的代码内容 创建数据库： CREATE DATABASE 教务管理系统 On ‘ 数据库名称 ‘存储位置 ‘初始大小 ‘最大的值（默认是没有最大值） ‘文件增长的速率或大小 LOG ON ( NAME=教务管理系统_LOG, FILENAME='E:\教务管理系统_LOG.ldf'， SIZE=2MB MAXSIZE=10MB FILEGROWTH=1MB ...
课程设计JavaWeb大作业web电脑考试系统项目源码+数据库.zip
06-15
课程设计JavaWeb大作业web电脑考试系统项目源码和数据库，内含详细使用说明，项目文档，初学者的福音啊（捂脸）高手可以二次开发 项目特色 1. 精美炫酷的登录页面 2. 设计合理，左侧式导航栏，顶部二级菜单 3. 32位 ...
JavaScript期末大作业图书管理系统源代码.zip
06-09
JavaScript期末大作业图书管理系统源代码。 逻辑： 用户登录之前： 到时候会将项目部署到我的服务器上面，所以会有一个公网IP（项目地址） 输入项目地址，进入index（初始页面）： 页面用来展示介绍咱项目的具体...
基于python数据库大作业-关于电影数据库的数据系统+源代码+文档说明+数据集+数据分析+操作报告
12-18
开发一个基于WEB的数据库应用，这个应用是查询一个关于电影数据库的数据，数据部分信息经过了脱密处理，数据及相关数据文档由教师指定。开发的功能如下： 搜索任务 A 根据用户ID，搜索用户所看的电影名字和评分，...
数据库课程大作业-租车预约网页设计
01-01
内容概要：是数据库课程的大作业，包括展示PPT，以及课程报告，还有所有代码。 适合临近课程结束需要资源的同学。
数据库大作业：火车售票管理系统（Python、pyqt5、QT、mysql）
01-29
本系统是由五位华工学子（刘同学、陈...由于系统的代码量较大，因此将会较为抽象地对思想进行介绍，在必要时会举出一些实例，还会附上成果展示以及安装方法。最后补充一下这次团伙作案的心得体会，也是非常宝贵的财富。
数据库大作业代码展示1
karive的博客
06-07 2541
SQL server中的操作： --创建数据库 DROP DATABASE IF EXISTS curricula_variable_system; CREATE DATABASE curricula_variable_system; --建表 USE curricula_variable_system; DROP TABLE IF EXISTS SC DROP TABLE IF EXISTS Student DROP TABLE IF EXISTS Course DROP TAB
数据库SQL代码
hhhfdhhgf_的博客
06-24 2470
where (spj.sno=s.sno and s.city='天津') and (spj.pno=p.pno and p.color='红')select sc.cno 课程号,cname 课程名,max(grade) 最高成绩,min(grade) 最低成绩, avg(grade) 平均成绩。插入语句：insert into 表 values ('Z001','大胜教育',null,'淄博',null);统计各专业的学生选课的平均成绩，如果某专业尚未有任何学生选修课程或成绩为空时，平均分计为0。
带你轻松掌握6种 Python 数据库操作及代码案例
m0_59596937的博客
12-03 2106
在数据处理和管理领域，Python作为一种高效、易用的编程语言，拥有丰富的数据库操作模块，可以轻松实现对关系型数据库的数据操作。本文将介绍六种常见的Python数据库操作模块，并提供相应的代码案例，帮助读者快速上手。
数据库复习/样例及代码
weixin_54372988的博客
05-25 1588
3.2 SQL数据定义 一、创建数据库： CREATE DATABASE lcr; 二、基本表的创建 1)使用数据库lcr use lcr; 2)创建表 CREATE TABLE `department` ( `Dno` varchar(3) NOT NULL, `Dname` varchar(30) DEFAULT NULL, `Office` varchar(4) DEFAULT NULL, PRIMARY KEY (`Dno`), UNIQUE KEY `Dname` (`Dn
数据库 常用代码
weixin_45554040的博客
10-02 1767
解析数据部分代码 MySqlCommand cmd = new MySqlCommand("select * fromaccount where acct = @acct", conn); cmd.Parameters.AddWithValue("acct", acct); reader = cmd.ExecuteReader(); id = reade...
mysql代码大全
m0_72222015的博客
12-21 1386
笔记
MySQL基本代码
m0_48215210的博客
08-03 7393
MySQL数据库的基本SQL
数据库（SQL）代码编写——数据查询(学习笔记)
m0_67466364的博客
08-29 834
eg.查询计算机系（cs）、数学系（ma）和信息系（is）学生的姓名和性别。语法：[not] like’<匹配串>’ [escape’<换码字符>']eg.查询计算机系（cs）、数学系（ma）和信息系（is）eg.查询名字中第二个字为“阳”的学生的姓名和学号。20~30岁之间的学生的姓名、系别和年龄。(in谓词其实是多个or运算符的缩写）eg.查询年龄在20~30岁（）之间的学生的姓名、系别和年龄。（2）查询满足条件的元组。（3）查询经过计算的值。（1）消除取值重复的行。的学生的姓名和性别。
如何用代码操作数据库（JDBC编程）
weixin_64874291的博客
06-09 959
前言。
数据库大作业visualstudio
最新发布
02-04
数据库大作业Visual Studio是一个基于数据库的项目，使用Visual Studio开发工具进行开发。它通常涉及设计和实现一个数据库系统，包括数据库的结构设计、数据模型设计、数据表设计、数据查询和操作等。 在Visual ...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值