通讯录管理系统的项目总结
信息1011-2010822109-田文静
通过这一阶段的学习，我们对这个通讯录管理系统有了一定的了解。我们组的项目设计主要是面向通讯录管理部分,首先我们做的是通讯录的登录界面，其次还有添加好友信息、修改好友信息、修改密码、注册新会员等界面。在课程设计中,程序设计主要的是采用C#语言,数据的存储采用文本存储的方式.程序设计主要是由我们大二第一学期的桌面软件开发转变为web项目开发.程序设计后通过运行调试,基本上可以实现解决班级通讯管理问题. 在进行通讯录管理系统开发之前我们所涉及到的是一些基本控件的使用.例如在lable控件中显示日期和时间:lable.Text=DateTime.Now.ToString;除了控件以外还学习了一些控件的具体属性.而后就是数据库,数据库设计的任务是确定系统所需的数据库,数据库是表的集合,通常一个系统只需要一个数据库,设计的任务是根据需求分析,确定数据库所包含的表及字段,表间的关系,然后具体确定表的结构,包括字段名,字段类型及宽度,需要的索引.在此基础上我们就进入了通讯录管理系统的学习.总共是四个Panel,分别为PanelQuery,PanelAdd,PanelEdit,以及PanelDetail,在PanelQuery主要的是插入一个Gridview控件和一个SqlDataSourse,而在PanelAdd中主要是添加一些最基本的button和lable以及textbox控件,此外还涉及到一些之前没有用过的控件一些属性,例如RequireFieldValidator的ErrorMessage,ControlTovalidate属性,以及RegularExpressionValidator的ErrorMessage,ControlTovalidate和ValidationExpression属性 在后面的三个Panel中用到的基本控件的属性跟前面的差不多.
在项目实施的过程中，我们首先对项目进行了整体规划。然后进行小组分工合作完成项目规划，然后由组长进行整合。在老师的细心教导和积极指导下，我们首先是将所有的界面做好,然后就是开始编写代码。在整个项目实施过程中，我们小组成员之间的相互合作和互动非常默契。我们积极处理各种在项目中遇到的问题，自己解决不了的就寻求帮助，整个项目完成的很顺利。
接下来是我们项目过程中实施过程中的相关代码：
1. login（用户登录界面）
public partial class _Default : System.Web.UI.Page
{
amendPassword transfer;
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Button1_Click(object sender, EventArgs e)
{
transfer = new amendPassword();
string NewPwd = this.txtUserPwd.Text.Trim();
string sqlQuery = "select userId,userPwd from Users where userId='" + txtUserName.Text.Trim() + "'";
DataBase DB = new DataBase();
DataTable dt = DB.DataSelect(sqlQuery);
try
{
int Row = dt.Rows.Count;
if (Row == 0)
{
Response.Write(amendPassword.Show_MessageBox("没有此用户!"));
this.txtUserName.Text = "";
this.txtUserName.Focus();
return;
}
else
{
string sel_userid = dt.Rows[0]["UserID"].ToString();
string sel_Pwd = dt.Rows[0]["userPwd"].ToString().Trim();
string confirm_pwd = transfer.EncryptPassword(NewPwd, "MD5").Trim(); if (sel_Pwd != confirm_pwd)
{
Response.Write(amendPassword.Show_MessageBox("用户密码错误!")); this.txtUserPwd.Text.Trim();
this.txtUserPwd.Focus();
return;
}
else
{
Session["userID"] = txtUserName.Text.Trim();
Response.Redirect("TreeAddress/Tree.aspx");
}
}
}
catch (System.Exception ee)
{
Response.Write("script language=javascript>alert('" + ee.Message.ToString() + "')</script>");
}
}
}
2．ModifyPwd（修改密码）
public partial class ModifyPwd : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (this.Session["userID"] == null)
{
Response.Redirect("Default.aspx");
}
else
{
Label1.Text = Session["userID"].ToString();
}
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
amendPassword transfer = new amendPassword();
string oldPwd = this.txtOldPwd.Text.Trim();
string NewPwd = this.txtOldPwd.Text.Trim();
string Old_password = transfer.EncryptPassword(oldPwd, "MD5").ToString();
string New_password = transfer.EncryptPassword(NewPwd, "MD5").ToString();
//string comfirmPwd=this.txtOldPwd.Text.Trim();
SqlConnection conn = new
SqlConnection(ConfigurationManager.AppSettings["VoteConnectionString"]);
SqlCommand selectcmd = new SqlCommand("select * from Users where userId='" + Session["userID"].ToString() + "'and userPwd='" + Old_password + "'", conn);
try
{
conn.Open();
SqlDataReader sdr = selectcmd.ExecuteReader();
if (sdr.Read())
{
sdr.Close();
SqlCommand updatecmd = new SqlCommand("update Users set userPwd='" + New_password + "' where userId='" + Session["userID"].ToString() + "'", conn);
int i = updatecmd.ExecuteNonQuery();
if (i > 0)
{
Response.Write("<script language=javascript>alert('成功修改密
码!')</script>");
}
else
{
Response.Write("<script language=javascript>alert('修改密码失
败!')</script>");
}
}
else
{
Response.Write("<script language=javascript>alert('输入的密码错误，请检查后重新输入!')</script>");
}
}
catch (System.Exception ee)
{
Response.Write("<script language=javascript>alert('" + ee.Message.ToString() + "')</script>");
}
finally
{
conn.Close();
}
}
protected void btnReset_Click(object sender, EventArgs e)
{
txtConfirmPwd.Text = "";
txtNewPwd.Text = "";
txtOldPwd.Text = "";
}
3. GridViewUsage（添加好友信息）
public partial class GridViewUsage : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Session["userID"] == null || Session["userID"].ToString() == "")
{
Page.Response.Redirect("default.aspx");
}
else
{
dataBind();
lblID.Text = Session["userID"].ToString();
detailsAllBind();
}
}
}
private void dataBind()
{
string ID = Session["UserID"].ToString();
string sql1 = "select * from addresslist where userID='" + ID + "'order by id desc"; DataBase db = new DataBase();
DataSet ds = db.DataAll(sql1);
GVUsage.DataSource = ds;
GVUsage.DataKeyField = "id";
GVUsage.DataBind();
ShowStatsPage();
return;
}
private void dataBind1()
{
string ID = Session["UserID"].ToString();
string newfrdName=Session["frdName"].ToString();
string sql1 = "select * from addresslist where userID='" + ID + "'" + " frdName like '%" + newfrdName + "%'";
DataBase db = new DataBase();
DataSet ds = db.DataAll(sql1);
GVUsage.DataSource = ds;
GVUsage.DataKeyField = "id";
GVUsage.DataBind();
ShowStatsPage();
return;
}
private void detailsBind()
{
SqlConnection conn1 = new
SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString); string detailsID = ViewState["id"].ToString();
string sql2 = "select
id,userId,frdName,frdPhone,frdMobilePhone,frdAddress,frdQQ,frdEmail from addresslist where id='" + detailsID + "'";
conn1.Open();
SqlCommand cmd = new SqlCommand(sql2, conn1);
SqlDataReader myReader = cmd.ExecuteReader();
DetailsView1.DataSource = myReader;
DetailsView1.DataBind();
myReader.Close();
}
private void detailsAllBind()
{
SqlConnection conn2 = new
SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString); string sql3 = "select * from addresslist order by id desc";
conn2.Open();
SqlDataAdapter da = new SqlDataAdapter(sql3, conn2);
DataSet ds = new DataSet();
da.Fill(ds, "detailsTable");
DetailsView1.DataSource = ds;
DetailsView1.DataBind();
conn2.Close();
}
protected void btnGo_Click(object sender, EventArgs e)
{
try
{
if (txtGoPage.Text.Trim() != "")
{
int PageI = Int32.Parse(txtGoPage.Text.Trim()) - 1;
if (PageI >= 0 && PageI < (GVUsage.PageCount))
GVUsage.CurrentPageIndex = PageI;
}
}
catch
{
Response.Write("<script language=javascirpt type='text/javascript'>"); Response.Write("window.alert('输入非数字字符，请重新输入！')");
Response.Write("</script>");
}
dataBind();
}
void ShowStatsPage()
{
lblCurrentIndex.Text = "当前为第" + ((int)GVUsage.CurrentPageIndex + 1) + "页"; lblPageCount.Text = "共" + GVUsage.PageCount + "页";
}
protected void DataGrid1_SelectedIndexChanged(object sender, EventArgs e)
{
ViewState["id"] = GVUsage.DataKeys[GVUsage.SelectedIndex].ToString();
detailsBind();
}
protected void BtnAdddata_Click(object sender, EventArgs e)
{
operation op1 = new operation();
string msg = op1.Add(lblID.Text, textName.Text, textPhone.Text, textMobile.Text, textAddress.Text, TextQQ.Text, textEmail.Text);
if (msg == "")
{
lblmsg.Text = "好友资料添加成功!";
}
else
{
lblmsg.Text = msg;
}
}
protected void Button1_Click(object sender, EventArgs e)
{
textAddress.Text = "";
textEmail.Text = "";
textMobile.Text = "";
textName.Text = "";
textPhone.Text = "";
TextQQ.Text = "";
}
protected void Button2_Click(object sender, EventArgs e)
{
Page.Response.Redirect("GridViewUsage.aspx");
}
protected void GVUsage_PageIndexChanged(object source, DataGridPageChangedEventArgs e) {
GVUsage.CurrentPageIndex = e.NewPageIndex;
dataBind();
}
protected void PagerButtonClick(object sender, EventArgs e)
{
string arg = ((LinkButton)sender).CommandArgument.ToString();
switch (arg)
{
case "next":
if (GVUsage.CurrentPageIndex < (GVUsage.PageCount - 1))
{
GVUsage.CurrentPageIndex += 1;
}
break;
case "prev":
if (GVUsage.CurrentPageIndex > 0)
{
GVUsage.CurrentPageIndex -= 1;
}
break;
case "last":
GVUsage.CurrentPageIndex = (GVUsage.PageCount - 1);
break;
case "fist":
GVUsage.CurrentPageIndex = 0;
break;
default:
GVUsage.CurrentPageIndex = System.Convert.ToInt32(arg);
break;
}
dataBind();
ShowStatsPage();
}
protected void Button3_Click(object sender, EventArgs e)
{
dataBind1();
}
}
这些代码是我们界面中使用的一部分，由于小组的能力有限，代码大部分参考老师所给的资料，虽然如此，我们还是从中学到了一些新知识，这对接下来我们要学习的大欧地板项目有一定的奠基作用。在整个项目实施过程中，我们小组合作的很愉快，也极大培养的我们分工合作以及团队合作精神。