private async voidCreateAndOperateSQLiteDataBase()
{
//數據文件保存的位置
vardataBasePath =Path.Combine(Windows.Storage.ApplicationData.Current.LocalFolder.Path,"MSISQLiteDataBase.sqlite");
//vardataBasePath = Path.Combine(KnownFolders.MusicLibrary.Path,"MSISQLiteDataBase.sqlite");
//創(chuàng )建或打開(kāi)數據庫
vardataBase = new SQLite.SQLiteConnection(dataBasePath);
//vardataBase = new SQLite.SQLiteAsyncConnection(dataBasePath);
//創(chuàng )建表
dataBase.CreateTable();
//awaitdataBase.CreateTableAsync();
//單條插入語(yǔ)句
dataBase.Insert(new Person() { FirstName = "Jack", LastName ="Slater" });
//Personperson = new Person(){ FirstName = "Jack", LastName = "Slater"};
//awaitdataBase.InsertAsync(person);
//插入操作.首先聲明一個(gè)集合,多條插入集合
ObservableCollection personCollection = newObservableCollection();
personCollection.Add(new Person() { FirstName = "Lebron", LastName= "James" });
personCollection.Add(new Person() { FirstName = "Yao", LastName ="Ming" });
personCollection.Add(new Person() { FirstName = "Ray", LastName ="Allen" });
int rows =dataBase.InsertAll(personCollection);
//int rows= await dataBase.InsertAllAsync(personCollection);
//更新語(yǔ)句
//方法1
SQLiteCommand cmd = dataBase.CreateCommand("update person setFirstName='Jake'where FirstName='Lebron'");
cmd.ExecuteNonQuery();
//方法2
dataBase.Update(new Person() { ID = 2, FirstName = "Yao", LastName= "LiCheng" });
try
{
//單行刪除操作
int pKey = 3;
dataBase.Delete(pKey);
}
catch(Exception ex)
{
Debug.WriteLine(ex.Message);
}
//多行刪除
//dataBase.DeleteAll();
//查詢(xún)所有數據綁定到UI
List
//Listlist = await dataBase.QueryAsync("select * from Person");
this.listView.ItemsSource = list;
//dataBase.Dispose();
//dataBase.Close();
}
class Person
{
[SQLite.AutoIncrement, SQLite.PrimaryKey]
public int ID { get; set; }
public string FirstName { get; set; }
public string LastName { get; set; }
}
