第七次作业（用户报修系统）

最新推荐文章于 2025-08-10 13:24:43 发布

转载最新推荐文章于 2025-08-10 13:24:43 发布 · 135 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/harlem/p/5042439.html

文章标签：

#数据库 #c#

本文介绍了一个使用C#实现的简单用户注册和报修系统的开发过程，包括界面设计、数据库操作及团队分工等内容。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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

namespace Theuserservice
{
    public partial class Form1 : Form
    {
       
        public Form1()
        {
            InitializeComponent();
        }

        DBCon db = new DBCon();

        private void denglu_Click(object sender, EventArgs e)
        {
          
                db.dbcon();

                if (textBoxname.Text != "" & textBoxpass.Text != "")
                {

                    string com = "select count(*) passWord from user_info where userName='" + textBoxname.Text + "' ";
                    SqlCommand comm = new SqlCommand(com, db.conn);
                    int a = (int)comm.ExecuteScalar();
                    if (a == 0)
                    {
                        this.label1.Text = "用户名不存在哦！请重新输入用户名··";
                        //MessageBox.Show("用户名不存在！");

                    }
                    else
                    {
                        string com1 = "select count(*) passWord from user_info where userName='" + textBoxname.Text + "' and  passWord='" + textBoxpass.Text + "'";
                        SqlCommand comd = new SqlCommand(com1, db.conn);
                        int a1 = (int)comd.ExecuteScalar();
                        if (a1 == 0)
                        {
                            this.label1.Text = "密码错误！请重新输入密码··";
                            //MessageBox.Show("密码错误哦！");
                        }
                        else
                        {
                            this.label1.Text = "登陆成功！欢迎··";
                            
                            WindowsFormsApplication1.Form3 fm = new WindowsFormsApplication1.Form3(textBoxname.Text);
                            fm.Show();
                            //MessageBox.Show("登录成功！");
                        }
                    }
                    db.conn.Close();

                }
                else
                {
                    this.label1.Text = "用户名或者密码不能为空！";
                }
            
        }

        private void button1_Click(object sender, EventArgs e)
        {
            WindowsFormsApplication1.Form2 fm = new WindowsFormsApplication1.Form2();
            fm.Show();
        }

        private void Form1_Load(object sender, EventArgs e)
        {

        }
    }
}

Form2；

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

namespace WindowsFormsApplication1
{
    public partial class Form2 : Form
    {
        public Form2()
        {
            InitializeComponent();
        }
        DBCon db = new DBCon();
        private void button1_Click(object sender, EventArgs e)
        {
            db.dbcon();
            string name = this.txtxname.Text.Trim();
            string pwd1 = this.txtpwd1.Text.Trim();
            string pwd2 = this.txtpwd2.Text.Trim();
            if (name == "")
            {
                MessageBox.Show("用户名不能为空！");
                return;
            }
            if (pwd1 == "")
            {
                MessageBox.Show("密码不能为空！");
                return;
            }
            if (pwd2 == "")
            {
                MessageBox.Show("请再次输入密码！");
                return;
            }
            if (pwd1 == pwd2)
            {
                string sql = "insert into user_info (userName,passWord) values ('" + name + "','" + pwd1 + "')";
                SqlCommand comd = new SqlCommand(sql, db.conn);
                int a1 = db.ExecuteSQL(sql);
                if (a1 > 0)
                {
                    MessageBox.Show("注册成功，请返回登录！");
                    this.Hide();
                    Form1 fm = new Form1();
                    fm.Show();
                }
                else
                {
                    MessageBox.Show("请重试！");
                }
            }
            else
            {
                MessageBox.Show("两次密码不一致，请重新输入！");
            }
        }

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

        private void Form2_Load(object sender, EventArgs e)
        {

        }
    }
}

　Form3:

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

namespace WindowsFormsApplication1
{
    public partial class Form3 : Form
    {
        DBCon db = new DBCon();
        public string name = "";
        public Form3( string value)
        {
            InitializeComponent();
            this.name = value; 
        }
        private void button1_Click(object sender, EventArgs e)
        {
            if (this.txtaddress.Text.Trim()=="")
            {
                MessageBox.Show("报修失败！请输入报修地点！");
                return;
            }
            if (this.txtleixing.Text.Trim() == "")
            {
                MessageBox.Show("报修失败！请输入报修内容！");
                return;
            }
            string sql = "insert into repair_info (username,leixing,didian,leirong,riqi,cishu) values ('" + name + "','" + comboBox1.SelectedItem.ToString()+"','" + this.txtaddress.Text + "','" + this.txtleixing.Text + "','" + Time.Now.ToShortDateString() + "','1')";
            SqlCommand comd = new SqlCommand(sql, db.conn);
            int a1 = db.ExecuteSQL(sql);
            if (a1 > 0)
            {
                MessageBox.Show("报修成功！");
                this.txtleixing.Text = "";
                this.txtaddress.Text = "";
                this.comboBox1.Text = "电脑类";
            }
        }

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

        private void Form3_Load(object sender, EventArgs e)
        {

        }

        private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
        {

        }
    }
}

　DBCon.cs；

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.SqlClient;
using System.Data;
using System.Windows.Forms;

namespace Theuserservice
{
    class DBCon
    {
        public string ConnectString = "Data Source=.;Initial Catalog=repair;Integrated Security=True";
        public SqlConnection conn = new SqlConnection();

        public void dbcon()
        {
            try
            {
                conn = new SqlConnection(ConnectString);
                conn.Open();
            }
            catch (Exception e)
            {
                
                MessageBox.Show("数据库连接不成功" + e.ToString());
            }
        }
        public int ExecuteSQL(String SqlString)
        {
            int count = -1;
            SqlConnection connectionTemp = new SqlConnection(ConnectString);
            connectionTemp.Open();
            try
            {
                SqlCommand cmd = new SqlCommand(SqlString, connectionTemp);
                count = cmd.ExecuteNonQuery();
            }
            catch
            {
                count = -1;
            }
            finally
            {
                connectionTemp.Close();
            }
            return count;
        }
    }
}

　数据库创建截图：