sqlite-我所认识的数据库引擎.docVIP

SQLite - 我所认识的数据库引擎 2013-01-04 06:17 by DanielWise,?4237?阅读,?19?评论,?收藏,?编辑 SQLite 是一款轻量级的、被设计用于嵌入式系统的关联式数据库管理系统。SQLite 是一个实现自我依赖、纯客户端、零配置且支持事务的数据库引擎。它由D. Richard Hipp首次开发，目前已是世界上最广泛部署的开源数据库引擎。 ? 本文中，我们将介绍如下内容： 创建一个SQLite 数据库 SQLiteConnection conn = new SQLiteConnection(Data Source=mytest.s3db); conn.Open(); SQLite 数据插入 /// summary /// Allows the programmer to easily insert into the DB /// /summary /// param name=tableNameThe table into which we insert the data./param /// param name=dataA dictionary containing the column names and data for the insert./param /// returnsA boolean true or false to signify success or failure./returns public bool Insert(string tableName, Dictionarystring, string data) { Boolean returnCode = true; StringBuilder columnBuilder = new StringBuilder(); StringBuilder valueBuilder = new StringBuilder(); foreach (KeyValuePairstring, string val in data) { columnBuilder.AppendFormat( {0},, val.Key); valueBuilder.AppendFormat( {0},, val.Value); } columnBuilder.Remove(columnBuilder.Length - 1, 1); valueBuilder.Remove(valueBuilder.Length - 1, 1); try { this.ExecuteNonQuery(string.Format(INSERT INTO {0}({1}) VALUES({2});, tableName, columnBuilder, valueBuilder)); } catch (Exception ex) { mLog.Warn(ex.ToString()); returnCode = false; } return returnCode; } for (int i = 0; i = ROWS4ACTION; i++) { insertParameterDic.Clear(); DateTime entryTime; string name = string.Empty, title = string.Empty; GetSampleData(out name, out title, out entryTime); int id = random.Next(); insertParameterDic.Add(Id, id.ToString()); insertParameterDic.Add(Name, name); insertParameterDic.Add(Title, title); insertParameterDic.Add(EntryTime, entryTime.ToString(yyyy-MM-dd HH:mm:ss)); db.Insert(Person, insertParameterDic); } SQLite 的事务处理方式 Begin Transaction: Commit Transaction: Rollback Transaction: try { db.Op