C#结合数据库开发通讯录管理系统

男娘i 2022-08-22 00:29 203阅读 0赞

通讯录管理系统，数据库关系模式为:账户(账户名,登录密码,头像)，联系人(ID,姓名,电话,QQ,Email)。主要功能包括：注册，登录，注销账号，修改账户名以及密码，更换头像，以及对联系人的增删改查。

工具：Visual Studio 2015,sql server2014

数据库关系表：

Account:                                                                           Contact:

![865264-20160505225400419-2140861622.png][]                   ![865264-20160505225848888-896174822.png][]

VS中主要界面及代码：

登录主界面：Login

![865264-20160505230235091-1205153169.png][]

注册窗体（登录界面中点击注册事件时将跳转到此窗体）：Regist

此处更换头像利用了openFileDialog控件打开系统文件会话框,选择图片之后显示在pictureBox控件中,数据库中存放了图片所在的路径，图片的路径可以利用openFileDialog对象.FileName.ToString()获得，点击注册按钮将所有注册信息加入数据库中。

![865264-20160508180242640-1821790434.png][]

注销账号(在登录界面的注销事件中实例化此窗体):Logout

![865264-20160505232555326-2041505729.png][]

菜单：Menu

![865264-20160508172801671-1646555550.png][]

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 Contact_Manage
    {
        public partial class Menu : Form
        {
            public Menu()
            {
                InitializeComponent();
            }
    
            private void btt_Add_Contact_Click(object sender, EventArgs e)
            {
                AddContact add = new AddContact();
                add.Show();
            }
    
            private void btt_Manage_Contact_Click(object sender, EventArgs e)
            {
                Contact_Manage query= new Contact_Manage();
                query.Show();
            }
    
            //修改密码
            private void btt_Modification_Password_Click(object sender, EventArgs e)
            {
                Modification_Password modif_Pwd = new Modification_Password();
                modif_Pwd.Show();
            }
    
            //更换头像
            private void btt_Change_Image_Click(object sender, EventArgs e)
            {
                Change_Image cImg = new Change_Image();
                cImg.Show();
            }
    
            //修改账户名
            private void btt_Mdfct_Username_Click(object sender, EventArgs e)
            {
                Mdfct_Acct_Username m = new Mdfct_Acct_Username();
                m.Show();
            }
        }
    }

添加联系人：AddContact

![865264-20160508173039796-710546930.png][]

修改密码：Modification\_Password

![865264-20160508173558984-84161031.png][]

更换头像：Change\_Image

![865264-20160508173857874-696544675.png][]

修改账户名：Mdfct_Acct_Username

联系人管理：Contact\_Manage

![865264-20160508175050999-1732013707.png][]

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;
    using System.Data.SqlClient;
    using System.Configuration;
    
    
    namespace Contact_Manage
    {
        public partial class Contact_Manage : Form
        {
            //数据库连接字符串
            string sqlcon = "server=.;database=phone_Book;uid=sa;pwd=666888";
            public Contact_Manage()
            {
                InitializeComponent();
            }
            //查询事件
            private void button1_Click(object sender, EventArgs e)
            {
                string condition = " 1=1";
                //姓名
                if (tB_Name.Text != "")
                    condition = condition + " and Contact_Name like'" + tB_Name.Text + "%'";
                //电话
                if (tB_Phone.Text != "")
                    condition = condition + " and Contact_Phone like'" + tB_Phone.Text + "%'";
                //QQ
                if (tB_QQ.Text != "")
                    condition = condition + " and Contact_QQ like'" + tB_QQ.Text + "%'";
                //Email
                if (tB_Email.Text != "")
                    condition = condition + " and Contact_Email like'" + tB_Email.Text + "%'";
                //ID
                if (tB_ID.Text != "")
                {
                    condition = condition + " and Contact_ID='" + tB_ID.Text + "'";
                }
                string sqlcom = "select * from Contact where" + condition;
                
                SqlConnection con = new SqlConnection(sqlcon);
                con.Open();
                SqlDataAdapter adapter = new SqlDataAdapter(sqlcom, con);
                //设置默认列不显示
                //dataGridView1.AutoGenerateColumns = false;
                DataSet ds = new DataSet();
                adapter.Fill(ds,"cs");
                dataGridView1.DataSource = ds.Tables["cs"];//绑定
    
                con.Close();
    
                //清空所有文本框
                foreach (Control item in this.Controls)
                {
                    if (item is TextBox)
                    {
                        item.Text = "";
                    }
                }
    
                //显示用户名
                lb_Username.Text = Login.txtLogin_Username;
            
                String sqlcom2 = "select Account_Image from Account where Account_Username='" + Login.txtLogin_Username + "'";
                SqlConnection con2 = new SqlConnection(sqlcon);
                SqlCommand com2 = new SqlCommand(sqlcom2, con2);
                con2.Open();
                //返回结果集的第一行第一列
                object obj = com2.ExecuteScalar();
                //将数据库中读取到的路径放入变量中
                String image_Path = obj.ToString();
    
                con2.Close();
                pctrB_Image.Image = Image.FromFile(image_Path);
                //将图片居中显示
                pctrB_Image.SizeMode = PictureBoxSizeMode.StretchImage;
    
            }
    
            //修改事件
            private void btt_Modification_Click(object sender, EventArgs e)
            {
    
                //获取用户输入的要修改的联系人ID
                String modification_ID = tB_ID.Text;
                //如果文本框为空，则说明用户没有点击联系人
                if (modification_ID != "")
                {
                    String condition = "";
                    //姓名
                   /* if (tB_Name.Text != "")
                        condition = condition + ",Contact_Name='" + tB_Name.Text + "'";*/
                    //电话
                    if (tB_Phone.Text != "")
                        condition = condition + ",Contact_Phone='" + tB_Phone.Text + "'";
                    //QQ
                    if (tB_QQ.Text != "")
                        condition = condition + ",Contact_QQ='" + tB_QQ.Text + "'";
                    //Email
                    if (tB_Email.Text != "")
                        condition = condition + ",Contact_Email='" + tB_Email.Text + "'";
    
                    String sqlcom = "update Contact set Contact_Name='" + tB_Name.Text + "'" + condition + " where Contact_ID = '" + modification_ID + "'";
    
                    SqlConnection con = new SqlConnection(sqlcon);
                    SqlCommand com = new SqlCommand(sqlcom, con);
                    con.Open();
                    int eq = com.ExecuteNonQuery();
                    if (eq != 0)
                    {
                        MessageBox.Show("修改成功思密达！");
                    }
                    else MessageBox.Show("修改失败思密达！");
                    con.Close();
                    
                    foreach (Control item in this.Controls)
                    {
                        if (item is TextBox)
                        {
                            item.Text = "";
                        }
                    }
                }
                else MessageBox.Show("请先点击联系人再进行修改操作！");
    
            }
    
            //删除事件
            private void btt_Delete_Click(object sender, EventArgs e)
            {
                //获取用户输入的要删除的联系人ID
                String delete_ID = tB_ID.Text;
    
                //连接数据库将该联系人数据删除
                String sqlcom = "delete from Contact where Contact_ID='" + delete_ID + "'";
                SqlConnection con = new SqlConnection(sqlcon);
                SqlCommand com = new SqlCommand(sqlcom, con);
                con.Open();
                int eq = com.ExecuteNonQuery();
                if (eq != 0)
                {
                    MessageBox.Show("删除成功思密达！");
                }
                else MessageBox.Show("删除失败思密达！");
                con.Close();
    
                //清空文本框
                foreach (Control item in this.Controls)
                {
                    if (item is TextBox)
                    {
                        item.Text = "";
                    }
                }
    
            }
    
            //提示用户进行联系人管理时的操作说明 并显示用户名和头像
            private void btt_Hint_Click(object sender, EventArgs e)
            {
                //显示用户名
                lb_Username.Text = Login.txtLogin_Username;
                
                String sqlcom = "select Account_Image from Account where Account_Username='" + Login.txtLogin_Username + "'";
                SqlConnection con = new SqlConnection(sqlcon);
                SqlCommand com = new SqlCommand(sqlcom, con);
                con.Open();
                //返回结果集的第一行第一列
                object obj = com.ExecuteScalar();
                //将数据库中读取到的路径放入变量中
                String image_Path = obj.ToString();
    
                con.Close();
                pctrB_Image.Image = Image.FromFile(image_Path);
                //将图片居中显示
                pctrB_Image.SizeMode = PictureBoxSizeMode.StretchImage;
    
                MessageBox.Show("查询：文本框全为空时，点击查询将列出所有数据，除ID之外都为模糊查询。\r删除：点击要删除的行。\r修改：ID不可改");
            }
    
            private void tB_Name_MouseClick(object sender, MouseEventArgs e)
            {
                //显示用户名
                lb_Username.Text = Login.txtLogin_Username;
                
                String sqlcom = "select Account_Image from Account where Account_Username='" + Login.txtLogin_Username + "'";
                SqlConnection con = new SqlConnection(sqlcon);
                SqlCommand com = new SqlCommand(sqlcom, con);
                con.Open();
                //返回结果集的第一行第一列
                object obj = com.ExecuteScalar();
                //将数据库中读取到的路径放入变量中
                String image_Path = obj.ToString();
    
                con.Close();
                pctrB_Image.Image = Image.FromFile(image_Path);
                //将图片居中显示
                pctrB_Image.SizeMode = PictureBoxSizeMode.StretchImage;
            }
    
            private void dataGridView1_CellMouseClick(object sender, DataGridViewCellMouseEventArgs e)
            {
                tB_ID.Text = this.dataGridView1.Rows[e.RowIndex].Cells[0].Value.ToString();
                tB_Name.Text = this.dataGridView1.Rows[e.RowIndex].Cells[1].Value.ToString();
                tB_QQ.Text = this.dataGridView1.Rows[e.RowIndex].Cells[2].Value.ToString();
                tB_Phone.Text = this.dataGridView1.Rows[e.RowIndex].Cells[3].Value.ToString();
                tB_Email.Text = this.dataGridView1.Rows[e.RowIndex].Cells[4].Value.ToString();
            }
        }
    }

课余时间写了这么个东西，技术不成熟，勿怪，winform入门可做参考！

有需要的可以下载：[https://download.csdn.net/download/xch\_yang/10376660][https_download.csdn.net_download_xch_yang_10376660]

或者关注我的公众号回复“通讯录管理”即可获取（包含数据库备份）。  
  微信搜索“ChaoYoung”或扫描下面二维码即可关注，后续该公众号将分享更多技术干货和工具

--------------------

更多技术干货，欢迎关注我的公众号：ChaoYoung

![20181121154451700.jpg][]

[865264-20160505225400419-2140861622.png]: http://images2015.cnblogs.com/blog/865264/201605/865264-20160505225400419-2140861622.png
[865264-20160505225848888-896174822.png]: /images/20220724/a03ced8e2d08428d9239f4c06cbe315e.png
[865264-20160505230235091-1205153169.png]: /images/20220724/70e61c1e88f74130b11b619f72339855.png
[865264-20160508180242640-1821790434.png]: /images/20220724/6de3291b6b404af2b30a6252a874100c.png
[865264-20160505232555326-2041505729.png]: /images/20220724/b58a792a97d9459092260368f99f2844.png
[865264-20160508172801671-1646555550.png]: /images/20220724/d6b172e6ed994dff827bdfbde0d09546.png
[865264-20160508173039796-710546930.png]: /images/20220724/701834057cf044febf0528a03e9d798a.png
[865264-20160508173558984-84161031.png]: /images/20220724/4e78c2fa557a49cca19d318f8bb47546.png
[865264-20160508173857874-696544675.png]: /images/20220724/46c64b84cdfe44568a75d4d8dc454623.png
[865264-20160508175050999-1732013707.png]: /images/20220724/864494be5ff0480daf86405fd9428016.png
[https_download.csdn.net_download_xch_yang_10376660]: https://download.csdn.net/download/xch_yang/10376660
[20181121154451700.jpg]: /images/20220724/263b07e5645943009017ef572fe4d156.png