学习ado.net(3):概述 3-3
下面是一个基本的demo
public class Student
{
public Student()
{ }
public Student(int stuID, string name, int age)
{
this._stuID = stuID;
this._stuName = name;
this._stuAge = age;
}
#region 属性
private int _stuID;
public int StuID
{
get { return _stuID; }
set { _stuID = value; }
}
private string _stuName;
public string StuName
{
get { return _stuName; }
set { _stuName = value; }
}
private int _stuAge;
public int StuAge
{
get { return _stuAge; }
set { _stuAge = value; }
}
#endregion
#region 方法
public void SaveNewToDb()
{
string sql = "insert into Students values (@name, @age)";
Dal.SqlHelper.ExecuteNonQuery(
sql,
new SqlParameter("@name", StuName),
new SqlParameter("@age", StuAge)
);
}
public void SaveModToDb()
{
string sql = "update Students set StuName=@0, StuAge=@1 where StuID=@2";
Dal.SqlHelper.ExecuteNonQuery(sql,
new SqlParameter("@0", StuName),
new SqlParameter("@1", StuAge),
new SqlParameter("@2", StuID)
);
}
public void Delete()
{
string sql = "delete Students where StuID=@0";
Dal.SqlHelper.ExecuteNonQuery(
sql,
new SqlParameter("@0", StuID)
);
}
public static List<Student> FindAll()
{
List<Student> lst = new List<Student>();
string sql = "select * from Students";
SqlDataReader reader = Dal.SqlHelper.ExecuteReader(sql);
while (reader.Read())
{
Student stu = new Student();
stu.StuID = reader.GetInt32(0);
stu.StuName = reader.GetString(1);
stu.StuAge = Convert.ToInt32(reader["StuAge"]);
lst.Add(stu);
}
reader.Close();
return lst;
}
#endregion
}