예제 #1
0
        public LinkedList <NameValueCollection> TestGet()
        {
            SqliteImpl sqliteImpl = new SqliteImpl();
            string     sql        = @"select * from finalance";

            return(sqliteImpl.Get(sql));
        }
예제 #2
0
        private LinkedList <NameValueCollection> GetFromSql()
        {
            SqliteImpl sqliteImpl = new SqliteImpl();
            string     sql        = @"select * from finalance";

            return(sqliteImpl.Get(sql));
        }
예제 #3
0
        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);
        }
예제 #4
0
        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();
        }