private async voidCreateAndOperateSQLiteDataBase()
{
//數(shù)據(jù)文件保存的位置
vardataBasePath =Path.Combine(Windows.Storage.ApplicationData.Current.LocalFolder.Path,"MSISQLiteDataBase.sqlite");
//vardataBasePath = Path.Combine(KnownFolders.MusicLibrary.Path,"MSISQLiteDataBase.sqlite");
//創(chuàng)建或打開數(shù)據(jù)庫
vardataBase = new SQLite.SQLiteConnection(dataBasePath);
//vardataBase = new SQLite.SQLiteAsyncConnection(dataBasePath);
//創(chuàng)建表
dataBase.CreateTable();
//awaitdataBase.CreateTableAsync();
//單條插入語句
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);
//更新語句
//方法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();
//查詢所有數(shù)據(jù)綁定到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; }
}
