用NUnit为.NET程序做测试---数据库测试之二 数据操作测试

要操作数据库，当然少不了增删改查了。

首先新建一个Person的实体类：

    public class Person
    {
        private int id;
        private string username;
        private string password;
        private int age;

        public int Id
        {
            get { return id; }
            set { id = value; }
        }


        public string Username
        {
            get { return username; }
            set { username = value; }
        }

        public string Password
        {
            get { return password; }
            set { password = value; }
        }

        public int Age
        {
            get { return age; }
            set { age = value; }
        }
        
    }

接下来新建一个对数据库操作类：

   1:          public void Insert(Person person)

   2:          {
  

   3:              string sql = "insert into person(username,password,age) values(@username,@password,@age)";

   4:   

   5:              SqlConnection conn = Connection.GetConnection();

   6:   

   7:              SqlCommand command = new SqlCommand(sql,conn);

   8:   

   9:              command.Parameters.Add(new SqlParameter("@username", SqlDbType.VarChar));

  10:              command.Parameters.Add(new SqlParameter("@password",SqlDbType.VarChar));

  11:              command.Parameters.Add(new SqlParameter("@age",SqlDbType.Int));

  12:   

  13:              command.Parameters["@username"].Value = person.Username;

  14:              command.Parameters["@password"].Value = person.Password;

  15:              command.Parameters["@age"].Value = person.Age;

  16:   

  17:              try

  18:              {
  

  19:                  command.ExecuteNonQuery();

  20:              }

  21:              catch (Exception ex)

  22:              {
  

  23:                  Console.WriteLine(ex.Message);

  24:              }

  25:              finally

  26:              {
  

  27:                  conn.Close();

  28:              }

  29: