SQLite简单使用

1.配置SQLite表信息参数：

public interface ConstantValue {

    /*staff表*/
    interface Staff{
        String DBName = "db_staff";//数据库名称
        int DBVersion = 1;//数据库版本号
        String Job = "tb_job";//Job表
    }

}

2.构建SQLiteOpenHelper:

public class StaffDBHelper extends SQLiteOpenHelper{
    public StaffDBHelper(Context context, String name, SQLiteDatabase.CursorFactory factory, int version) {
        super(context, name, factory, version);
    }

    @Override
    public void onCreate(SQLiteDatabase sqLiteDatabase) {
        //创建员工职位数据表

        sqLiteDatabase.execSQL("create table "+ ConstantValue.Staff.Job+"(" +
                "_id integer primary key autoincrement," +
                "jobId integer," +//职位id
                "jobName text," +//职位名称
                "jobType text," +//职位类型
                "remark text)");//说明备注
    }

    @Override
    public void onUpgrade(SQLiteDatabase sqLiteDatabase, int i, int i1) {

    }
}

3.database初始化

StaffDBHelper staffDBHelper = new StaffDBHelper(this, ConstantValue.Staff.DBName, null, ConstantValue.Staff.DBVersion);
        database = staffDBHelper.getReadableDatabase();

4.插入数据

for (int i = 0; i < jobs.size(); i++) {
                        LoginResult.MdBean.JobsBean jobsBean = jobs.get(i);
                        ContentValues values = new ContentValues();
                        values.put("jobId",jobsBean.getJobId());
                        values.put("jobName",jobsBean.getJobName());
                        values.put("jobType",jobsBean.getJobType());
                        values.put("remark",jobsBean.getRemark());
                        database.insert(ConstantValue.Staff.Job,null,values);
                    }

5.字段获取

Cursor cursor = database.query(ConstantValue.Staff.Job, null, null, null, null, null, null);
        while (cursor.moveToNext()) {
            //根据列名获取列索引
            int jobNameIndex = cursor.getColumnIndex("jobName");
            String jobName = cursor.getString(jobNameIndex);
        }