如何使用VSTS写单元测试（2）

-

我的两段代码

userLoginJudge（）

 1    public bool userLoginJudge()
 2    {
 3        SqlConnection conn = new SqlConnection(connstring);
 4        SqlCommand cmd = new SqlCommand("select UserPass from users where username='" + _LoginName + "'",conn);
 5        SqlDataReader passread;
 6        
 7        conn.Open();
 8        passread = cmd.ExecuteReader(CommandBehavior.SingleRow);
 9        passread.Read();

        if ((passread.HasRows) && (_LoginPass == passread.GetString(0)))
        {
            passread.Close();
            conn.Close();
            return true; }
        else
        {
            passread.Close();
            conn.Close();
            return false; }

    }

 

 

userLogin（）构造函数

 

    public userLogin(string LoginName, string LoginPass)
    {
        this._LoginName = LoginName;
        this._LoginPass = LoginPass;
    }
    #endregion

 

 

生成的两段已修改的测试代码

 

 1        /**//// <summary>
 2        ///userLoginJudge 的测试
 3        ///</summary>
 4        [TestMethod()]
 5        [HostType("ASP.NET")]
 6        [AspNetDevelopmentServerHost("%PathToWebRoot%\\WebSite5", "/WebSite5")]
 7        [UrlToTest("http://localhost/WebSite5")]
 8        public void userLoginJudgeTest()
 9        {
            userLogin_Accessor target = new userLogin_Accessor(); // TODO: 初始化为适当的值
            bool expected = true; // TODO: 初始化为适当的值
            bool actual;
            target._LoginName = "admin";
            target._LoginPass = "888888";
            actual = target.userLoginJudge();
            Assert.AreEqual(expected, actual, "错误出现于userLoginJudgeTest");
        }

        /**//// <summary>
        ///userLogin 构造函数 的测试
        ///</summary>
        [TestMethod()]
        [HostType("ASP.NET")]
        [AspNetDevelopmentServerHost("%PathToWebRoot%\\WebSite5", "/WebSite5")]
        [UrlToTest("http://localhost/WebSite5")]
        public void userLoginConstructorTest()
        {
            string LoginName = "admin"; // TODO: 初始化为适当的值
            string LoginPass = "888888"; // TODO: 初始化为适当的值
            userLogin_Accessor target = new userLogin_Accessor(LoginName, LoginPass);
            bool expected = false; // TODO: 初始化为适当的值
            bool actual;
            actual = target.userLoginJudge();
            Assert.AreEqual(expected,actual);
        }