1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18

public class  extends Application {

    private static App mContext;

    
    public void onCreate() {
        super.onCreate();
        
        FlowManager.init(this);
    }
    //单例模式
    public static App getInstance(){
        if (mContext == null) {
            mContext = new App();
        }
        return mContext;
    }
}

1
2
3
4
5
6
7
8
9
10
11
12
13
14

import com.raizlabs.android.dbflow.annotation.Database;

/**
 * Created by 24277 on 2016/12/6.
 */
 //以注释的方式创建
@Database(name = AppDatabase.NAME,version = AppDatabase.VERSION)
public class AppDatabase {
    //数据库名
    public static final String NAME = "AppDatabase";
    //数据库的版本号
    public static final int VERSION = 1;

}

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32

import com.raizlabs.android.dbflow.annotation.Column;
import com.raizlabs.android.dbflow.annotation.ModelContainer;
import com.raizlabs.android.dbflow.annotation.PrimaryKey;
import com.raizlabs.android.dbflow.annotation.Table;
import com.raizlabs.android.dbflow.structure.BaseModel;

/**
 * Created by 24277 on 2016/12/6.
 */
//这个表从属于AppDatabase数据库
@ModelContainer
@Table(database = AppDatabase.class)
public class Student extends BaseModel{
    //注释表示创建一列 名叫id
    @Column
    //主键，自增长
    @PrimaryKey(autoincrement = true)
    public long id;
    @Column
    public String name;
    @Column
大专栏  DBFlow框架的学习笔记之入门lass="line">    public String sex;

    
    public String toString() {
        return "Student{" +
                "id=" + id +
                ", name='" + name + ''' +
                ", sex='" + sex + ''' +
                '}';
    }
}

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87

package com.soildog.testdbflow.manager;

import android.content.Context;
import android.widget.Toast;

import com.raizlabs.android.dbflow.sql.language.Select;
import com.soildog.testdbflow.App;
import com.soildog.testdbflow.entity.Student;
import com.soildog.testdbflow.entity.Student_Table;

import java.util.List;

/**
 * Created by 24277 on 2016/12/6.
 */

public class DBFLowManager {
    private Context mContext;
    private Student mStudent;

    public DBFLowManager() {
        mContext = App.getInstance();
        mStudent = new Student();
    }
    
    
    public Student queryData(String name) {
        Student record = new Select()
                .from(Student.class)
                .where(Student_Table.name.eq(name))
                .querySingle();
        return record;
    }
   
    public void insert(int id,String name,String sex){
        mStudent = queryData(name);
        if (mStudent == null) {
            mStudent = new Student();
            mStudent.name = name;
            mStudent.sex = sex;
        }
        mStudent.save();
        //people.update();//更新对象
        //people.delete();//删除对象
        //people.insert();//插入对象;
    }

    public List<Student> getData() {
        List<Student> record = new Select()
                .from(Student.class)
                .queryList();
        return record;
    }

    public void deletAllData(String name) {
        List<Student> record = new Select()
                .from(Student.class)
                //.where("name = ?",new String[]{name})
                .queryList();
        for (Student student : record) {
            student.delete();
        }
    }
    
    public void upData(int id,String name,String sex){
        Student record = new Select()
                .from(Student.class)
                //.where("id = ?",new String[]{""+id})
                .querySingle();
      if (record == null){
          Toast.makeText(mContext, "没有更改的数据", Toast.LENGTH_SHORT).show();
          return;
      }else{
          record.name = name;
          record.sex = sex;
          record.save();
          Toast.makeText(mContext, "更新成功", Toast.LENGTH_SHORT).show();
      }
    }

    public List<Student> queryAll() {
        List<Student> record = new Select()
                .from(Student.class)
                .queryList();
        return record;
    }
}