OrmLite数据库操作框架

一、运行前配置

在http://ormlite.com/releases/下载两个jar包

打开AndroidStudio，选择

ctrl+v将jar包复制进libs文件夹下

点击ctrl键，鼠标左键选择两个jar包后，鼠标右键，选择

二、编写实体类

Student.java

package com.administrator.ormlitedemo;

import com.j256.ormlite.field.DataType;
import com.j256.ormlite.field.DatabaseField;
import com.j256.ormlite.table.DatabaseTable;

/**
 * Created by Administrator on 2018/5/16.
 */

@DatabaseTable(tableName = "tb_student")//tableName可以不写，不写默认表名是类名即Student，写了是改写表名
public class Student {
    @DatabaseField(generatedId = true)//字段              generatedId = true自动增长标识列
    private int id;
    @DatabaseField(columnName = "name",dataType = DataType.STRING,canBeNull = false)//列名      canBeNull = false不能为空
    private String name;
    @DatabaseField  //使用默认属性
    private int age;
    @DatabaseField
    private String phone;

    public Student() {
    }

    public Student(String name, int age, String phone) {
        this.name = name;
        this.age = age;
        this.phone = phone;
    }

    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }

    public String getName() {
        return name;
    }

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

    public int getAge() {
        return age;
    }

    public void setAge(int age) {
        this.age = age;
    }

    public String getPhone() {
        return phone;
    }

    public void setPhone(String phone) {
        this.phone = phone;
    }

    @Override
    public String toString() {
        return "Student{" +
                "id=" + id +
                ", name='" + name + '\'' +
                ", age=" + age +
                ", phone='" + phone + '\'' +
                '}';
    }
}

三、实现数据库帮助类

DatabaseHelper.java

package com.administrator.ormlitedemo;

import android.content.Context;
import android.database.sqlite.SQLiteDatabase;

import com.j256.ormlite.android.apptools.OrmLiteSqliteOpenHelper;
import com.j256.ormlite.support.ConnectionSource;
import com.j256.ormlite.table.TableUtils;

import java.sql.SQLException;

/**
 * Created by Administrator on 2018/5/16.
 */

public class DatabaseHelper extends OrmLiteSqliteOpenHelper {
    private DatabaseHelper(Context context){
        super(context,"test.db",null,1);//当版本值变化时， onUpgrade方法会被调用
    }
    private static DatabaseHelper sHelper = null;

    public static synchronized DatabaseHelper getInstance(Context context){
        if (sHelper == null){
            sHelper = new DatabaseHelper(context);
        }
        return sHelper;
    }
    @Override
    public void o