Example #1
0
        public static void Register(Account item)
        {
            Ass2Adapter Ass2adapter = Ass2Adapter.createInstance();

            SQLiteConnection sQLiteConnection = Ass2adapter.sQLiteConnection;
            var sqlString = "INSERT INTO User(id,username,password) VALUES(?,?,?)";
            var stt       = sQLiteConnection.Prepare(sqlString);

            stt.Bind(1, item.id);
            stt.Bind(2, item.username);
            stt.Bind(3, item.password);

            stt.Step();
        }
Example #2
0
        public static void CheckLogin()
        {
            {
                SQLiteConnection sQLiteConnection = Ass2Adapter.createInstance().sQLiteConnection;
                string           sqlCommand       = "select * from User;";
                var            stt  = sQLiteConnection.Prepare(sqlCommand);
                List <Account> list = new List <Account>();
                while (SQLiteResult.ROW == stt.Step())
                {
                    string name = (string)stt[0];

                    int pass = Convert.ToInt32(stt[1]);
                    list.Add(new Account(username, password));
                }
                return(list);
            }
        }