add IOC DataBase

11.SQLite数据库

SQLite使用了IOC框架。

11.1创建表

新建的创建表需要继承Node并且写出注解类。

    // 表名
    @TableName(tableName = "lfkdsk")
    public class User extends Node {

    // 主键自增 INTEGER型
    @LabelName(autoincrement = true,
            type = LabelName.Type.INTEGER,
            columnName = "name",
            generatedId = true)
    private int name;

    // TEXT型 栏名为user_name
    @LabelName(type = LabelName.Type.TEXT,
            columnName = "user_name")
    private String user_name;

    // 自增主键所以只需要提供其他信息
    public User(String user_name) {
        super(user_name);
        this.user_name = user_name;
    }

    public User(int name, String user_name) {
        super(name, user_name);
        this.name = name;
        this.user_name = user_name;
    }

    public int getName() {
        return name;
    }

    public void setName(int name) {
        this.name = name;
    }

    public String getUser_name() {
        return user_name;
    }

    public void setUser_name(String user_name) {
        this.user_name = user_name;
    }
    }

    // 通过这种方式获取数据库   表名
    private DataBase dataBase = DataBase.initAndOpen("user", User.class);

11.2增删查改

    // add
    database.insert(User user);
    // find
    database.get(int position);
    // delete
    database.delete(int position);
    // update
    database.update(User user);
    ...