public LinkedList <NameValueCollection> TestGet()
{
SqliteImpl sqliteImpl = new SqliteImpl();
string sql = @"select * from finalance";
return(sqliteImpl.Get(sql));
}
private LinkedList <NameValueCollection> GetFromSql()
{
SqliteImpl sqliteImpl = new SqliteImpl();
string sql = @"select * from finalance";
return(sqliteImpl.Get(sql));
}
public void TestInsert()
{
SqliteImpl sqliteImpl = new SqliteImpl();
string tt = "'s2020-2'";
string sql = "insert into finalance (name,insto,data,description) values('lhy-7',21," + tt + ",'description test')";
sqliteImpl.Insert(sql);
}
static void Main(string[] args)
{
SqliteImpl impl = new SqliteImpl("", "test.db3", "", "", false);
//impl.createTable(typeof(Model.user_table));
//Model.user_table user = new Model.user_table() { ID = 1, LoginName = "s", LoginSys = "1", LoginPwa = "s", loginREName = " s", Logintime = "ss" };
//Console.WriteLine(impl.Insert(user));
//Console.WriteLine("删除行：" + impl.delete<Model.user_table>(6));
Console.ReadLine();
}