通讯录管理系统

通讯录管理系统一、目标根据实际需要，设计并实现通讯录管理系统。

该系统提供多用户的通讯录管理，并能对通讯录的联系人分组。

二、功能需求本系统实现的主要功能如下:(1)登录(2)添加联系人、(3)修改联系人、(4)删除联系人、(5)查找联系人。

(6)用户的信息进行管理。

三、系统模块设计四、数据库结构设计1、表名：用户。

作用：存储登录用户的用户名和密码。

表中各字段的描述如表所示。

2、表名：联系人。

作用：存储联系人的信息。

表中各字段的描述如表所示。

五、详细设计1．登录模块（1）模块设计登录窗体是客户端程序运行后显示的第一个窗体，用于验证用户的身份。

如图所示：（2）程序代码：using System;using System.Collections.Generic;using ponentModel;using System.Data;using System.Drawing;using System.Text;using System.Windows.Forms;using System.Data.SqlClient;namespace PhoneBook{public partial class frmLogin : Form{public frmLogin(){InitializeComponent();}private void btnCancel_Click(object sender, EventArgs e) {Application.Exit();}private void btnOK_Click(object sender, EventArgs e){try{//检测文本框内容if (txtUserName.Text.Trim() == "" || txtPassword.Text.Trim() == ""){MessageBox.Show("用户名和密码不能为空!","登录失败",MessageBoxButtons.OK,MessageBoxIcon.Error);return;}//验证用户SqlConnection conn = new SqlConnection();conn.ConnectionString = "Data Source=PC-201112160941\\SQLEXPRESS;Initial Catalog=PhoneBook;Integrated Security=True";conn.Open();string sql = "select count(*) from 用户where 用户名='"+txtUserName.Text.Trim()+"' and 密码='"+txtPassword.Text.Trim()+"'";SqlCommand cmd = new SqlCommand();cmd.Connection=conn;mandText=sql;int result = Convert.ToInt32(cmd.ExecuteScalar());conn.Close();if (result == 1){//登录成功frmMain f = new frmMain();f.tsslUserName.Text = txtUserName.Text.Trim();f.Show();this.Hide();}else{MessageBox.Show("用户名和密码错误!", "登录失败", MessageBoxButtons.OK, MessageBoxIcon.Error);return;}}catch (Exception ee){MessageBox.Show("发生错误/r/n"+ee.Message, "登录失败", MessageBoxButtons.OK, MessageBoxIcon.Error);return;}}private void frmLogin_Load(object sender, EventArgs e){}}}2主窗体模块（1）模块设计主窗体是衔接各个子窗体的桥梁。

用户可以通过主窗体找到各个操作的入口，例如，用户想添加一个联系人，就可以点击工具栏的“新增”按钮，或者也可以点击菜单栏的“联系人”-“新增…”菜单项，这时，主窗体会将添加联系人的子窗体显示，供用户操作。

如图所示：（2）程序代码：using System;using System.Collections.Generic;using ponentModel;using System.Data;using System.Drawing;using System.Text;using System.Windows.Forms;using System.Data.SqlClient;using System.Configuration;namespace PhoneBook{public partial class frmMain : Form{public frmMain(){InitializeComponent();}private string strConn =System.Configuration.ConfigurationManager.AppSettings["ConnectionString"];private void frmMain_Load(object sender, EventArgs e){LoadGroup();if (trvGroup.Nodes.Count > 0){trvGroup.SelectedNode = trvGroup.Nodes[0];LoadList();}else{lvContact.Clear();}}private void LoadGroup(){try{trvGroup.Nodes.Clear();SqlConnection conn = new SqlConnection(strConn);SqlCommand cmd = new SqlCommand();cmd.Connection = conn;mandText = "select distinct 组别from 联系人where 用户名='"+tsslUserName.Text+"'";conn.Open();SqlDataReader sdr = cmd.ExecuteReader();while (sdr.Read()){trvGroup.Nodes.Add(sdr[0].ToString());}sdr.Close();conn.Close();}catch{ }}private void LoadList(){if (trvGroup.Nodes.Count == 0){lvContact.Clear();return;}if (trvGroup.SelectedNode.Index >= 0){string strGroup = trvGroup.SelectedNode.Text;try{lvContact.Clear();lvContact.Columns.Add("姓名",100);lvContact.Columns.Add("工作单位", 150);lvContact.Columns.Add("联系电话", 100);lvContact.Columns.Add("电子邮箱", 150);SqlConnection conn = new SqlConnection(strConn);SqlCommand cmd = new SqlCommand();cmd.Connection = conn;mandText = "select 编号,姓名,工作单位,联系电话,电子邮箱from 联系人where 组别='" + strGroup + "' and 用户名='" + tsslUserName.Text + "'";conn.Open();SqlDataReader sdr = cmd.ExecuteReader();int count = 0;while (sdr.Read()){ListViewItem lvi = new ListViewItem();lvi.Text = sdr["姓名"].ToString();lvi.SubItems.Add(sdr["工作单位"].ToString());lvi.SubItems.Add(sdr["联系电话"].ToString());lvi.SubItems.Add(sdr["电子邮箱"].ToString());lvi.Tag = sdr["编号"];lvi.ImageIndex = 0;lvContact.Items.Add(lvi);count++;}tsslCount.Text = "共计"+count.ToString()+"个联系人";sdr.Close();conn.Close();}catch{ }}}private void frmMain_FormClosed(object sender, FormClosedEventArgs e){Application.Exit();}private void trvGroup_AfterSelect(object sender, TreeViewEventArgs e){LoadList();}private void详细信息ToolStripMenuItem_Click(object sender, EventArgs e) {lvContact.View = View.Details;}private void详细信息ToolStripMenuItem1_Click(object sender, EventArgs e) {lvContact.View = View.Details;}private void图标ToolStripMenuItem_Click(object sender, EventArgs e){lvContact.View = rgeIcon;}private void图标ToolStripMenuItem1_Click(object sender, EventArgs e){lvContact.View = rgeIcon;}private void Add(){frmAdd f = new frmAdd();if (f.ShowDialog(this) == DialogResult.OK){LoadGroup();if (trvGroup.Nodes.Count > 0){trvGroup.SelectedNode = trvGroup.Nodes[0];LoadList();}else{lvContact.Clear();}}}private void Edit(){if (lvContact.SelectedItems.Count == 1){int id = Convert.ToInt32(lvContact.SelectedItems[0].Tag);frmEdit f = new frmEdit(id);if (f.ShowDialog(this) == DialogResult.OK){LoadGroup();if (trvGroup.Nodes.Count > 0){trvGroup.SelectedNode = trvGroup.Nodes[0];LoadList();}else{lvContact.Clear();}}}}private void Delete(){if (lvContact.SelectedItems.Count < 1){return;}if (MessageBox.Show("是否要删除选中的联系人?", "删除确认",MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) {string strWhere = " where 编号in (";foreach (ListViewItem lvi in lvContact.SelectedItems) {strWhere += lvi.Tag.ToString() + ",";}strWhere = strWhere.Substring(0, strWhere.Length - 1); strWhere += ")";try{SqlConnection conn = new SqlConnection(strConn);SqlCommand cmd = new SqlCommand();cmd.Connection = conn;mandText = "delete from 联系人" + strWhere; conn.Open();cmd.ExecuteNonQuery();conn.Close();LoadGroup();if (trvGroup.Nodes.Count > 0){trvGroup.SelectedNode = trvGroup.Nodes[0];LoadList();}else{lvContact.Clear();}}catch { }}}private void Search(){frmSearch f = new frmSearch(tsslUserName.Text);f.ShowDialog();}private void tsbtnAdd_Click(object sender, EventArgs e){Add();}private void增加ToolStripMenuItem_Click(object sender, EventArgs e){Add();}private void修改MToolStripMenuItem_Click(object sender, EventArgs e){Edit();}private void tsbtnEdit_Click(object sender, EventArgs e){Edit();}private void删除ToolStripMenuItem_Click(object sender, EventArgs e){Delete();}private void tsbtnDelete_Click(object sender, EventArgs e){Delete();}private void lvContact_MouseDoubleClick(object sender, MouseEventArgs e) {Edit();}private void lvContact_KeyDown(object sender, KeyEventArgs e){if (e.KeyCode == Keys.Delete){Delete();}}private void tsbtnSearch_Click(object sender, EventArgs e){Search();}private void搜索SToolStripMenuItem_Click(object sender, EventArgs e){Search();}private void视图ToolStripMenuItem_Click(object sender, EventArgs e){}}}3．新增联系人模块（1）模块设计在本模块中，通过搜集用户输入联系人的各项信息（姓名、电话必填，其余可为空），向数据库中的联系人表添加记录。