C#面向对象程序设计 第2版 作者 郑宇军 CSCH15.pptVIP

* * 单表查询 多表查询 * 函数计算 * 插入 * 删除 * 修改 * 插入 * * * * * * 读取数据 数据阅读器DbDataReader Read(): 读取当前记录 this[int/string]: 当前记录的指定字段 Close(): 关闭阅读器 public DbDataReader ReadStudent(DbConnection conn) { DbCommand cmd = conn.CreateCommand(); cmd.CommandText = SELECT * FROM Student; return cmd.ExecuteReader(CommandBehavior.CloseConnection); } 关闭DbDataReader时自动关闭连接 connectionStrings add name=TravelDB connectionString=Provider=Microsoft.Jet.OLEDB.4.0; Data Source=.\\stds.mdb; MultipleActiveResultSets=True/ /connectionStrings 读取数据 数据阅读器DbDataReader 默认: 一个数据连接上只能有一个活动的阅读器 MARS: 多活动结果集 读取数据 数据命令DbCommand ExecuteReader: DbDataReader ExecuteScalar: Object DbCommand cmd = conn.CreateCommand(); cmd.CommandText = SELECT COUNT(*) FROM Student; int count = (int)cmd.ExecuteScalar(); 修改数据 数据命令DbCommand ExecuteReader: DbDataReader ExecuteScalar: Object ExecuteNonQuery DbCommand cmd = conn.CreateCommand(); cmd.CommandText = TRUNCATE TABLE Student; cmd.ExecuteNonQuery(); 修改数据 数据命令DbCommand ExecuteReader: DbDataReader ExecuteScalar: Object ExecuteNonQuery void Add(Student s) { DbCommand cmd = conn.CreateCommand(); cmd.CommandText = string.Format(INSERT INTO Student ({0},{1}), s.Id, s.Name); cmd.ExecuteNonQuery(); } 修改数据 数据命令DbCommand ExecuteReader: DbDataReader ExecuteScalar: Object ExecuteNonQuery void Update(Student s) { DbCommand cmd = conn.CreateCommand(); cmd.CommandText = string.Format(UPDATE Student SET Name={0} WHERE ID={1}, s.Name, s.Id); cmd.ExecuteNonQuery(); } 修改数据 数据命令DbCommand ExecuteReader: DbDataReader ExecuteScalar: Object ExecuteNonQuery void Delete(Student s) { DbCommand cmd = conn.CreateCommand(); cmd.CommandText = DELETE FROM Student WHERE ID= + s.Id; cmd.ExecuteNonQuery(); } * ADO .NET数据访问模型 连接类型 DbConnection DbCommand DbDataReader DbDataAdapter 离线数据访问 DataTable Load(DbDataReader): 从阅读器载入数据 DbDataAdapter.Fill(DataTable): 从适配器载入数据 DbCommand cmd = conn.CreateCommand(); cmd.CommandText = SELECT * FROM