团队十日冲刺3

团队十日冲刺3

 

今天学习了相关的数据库操作以及页面的跳转实验了一下再界面上简单的输出一下所求的数据，为下一步整合数据进行相关操作做铺垫：

 相关的数据库表的设计目前只涉及三个表

分别是：用户信息表、配置表、收支明细表

public void onCreate(SQLiteDatabase db){
    //user table
    db.execSQL("create table if not exists user_tb(_id integer primary key autoincrement," +
            "userID text not null," +
            "pwd text not null)");

    //Configuration table
    db.execSQL("create table if not exists refCode_tb(_id integer primary key autoincrement," +
            "CodeType text not null," +
            "CodeID text not null," +
            "CodeName text null)");

    //costDetail_tb
    db.execSQL("create table if not exists basicCode_tb(_id integer primary key autoincrement," +
            "userID text not null," +
            "Type integer not null," +
            "incomeWay text not null," +
            "incomeBy text not null," +
            "category text not null," +
            "item text not null," +
            "cost money not null," +
            "note text not null," +
            "makeDate text not null)");
}