Sixth time Assignment

Member name	Four digits after the study number	Contribution points
Zhang Xue (captain)	1150	4
Mushaf Feather	1172	2
Mauruiri	6015	2
Zhao Ruiling	1156	2

Specific design ideas:

Create a database, connect to the database, the query command is based on the user name entered to query out the password, when the data is not read to indicate ' user name does not exist ', when the read out of the password and the input password is inconsistent with the expression

' Password is wrong, please re-enter ', when the read out password and enter the password consistent with ' Congratulations on your login success '.

Code implementation:

Using system.componentmodel;using system.data;using system.drawing;using system.linq;using System.Text;using System.windows.forms;using system.data.sqlclient;namespace Login {public partial class Form1:form {public for        M1 () {InitializeComponent (); private void Button1_Click (object sender, EventArgs e) {SqlConnection conn = new SqlConnection ("Data source=lenovo-pc\\data;            attachdbfilename=i:\\repair.mdf;integrated security=true "); String sql = "Select PassWord from User_info where Username= '" +txtuser.            text+ "'";            SqlCommand comm = new SqlCommand (SQL, conn); Conn.            Open (); SqlDataReader reader = Comm.            ExecuteReader (); if (!reader. Read ()) {label3.                Visible = true; Label3. Text = "User name does not exist!"            "; } else {if (reader["PassWord"]. ToString (). Trim () = = Txtpwd.               Text.trim ()) {     Label3.                    Visible = true; Label3. Text = "Congratulations on your successful login!"                "; } else {label3.                    Visible = true; Label3. Text = "Bad password, please re-enter."                "; }} reader.            Close (); Conn.        Close (); }    }}

　　

Test:

PSP Time-consuming analysis:

Psp	Personal Software Process Stages	Time (min)
Planning	Plan	20
· Estimate	• Estimate how long this task will take	60
Development	Development	120
· Analysis	• Demand Analysis	20
· Design Spec	• Generate design files	20
· Design Review	• Design Review	20
· Coding Standard	• Code Specification	10
· Design	• Specific Design	30
· Coding	• Specific coding	80
· Code Review	• Code review	10
· Test	• Test	10
Reporting	Report	30
· Test Report	• Test reports	10
· Size Measurement	• Computational effort	10
· Postmortem & Process Improvement Plan	• Post-mortem summary and propose process improvement plans	10

Team Summary:

This team work is not particularly difficult for us because we have started to learn the information needed to connect to the database on our website, and we are still more confident about this assignment.

Code specification.

Sixth time Assignment