前言：SQLite，是一款輕型的數(shù)據(jù)庫，怎么輕法呢，那就只有一個(gè)數(shù)據(jù)庫文件，不僅僅如此，并且它占用資源非常的低，只需要幾百K的內(nèi)存就夠了。它能夠支持Windows/Linux/Unix等等主流的操作系統(tǒng)，同時(shí)能夠跟很多程序語言相結(jié)合，比如 Tcl、C#、PHP、Java等，還有ODBC接口，同樣比起Mysql、PostgreSQL這兩款開源的世界著名數(shù)據(jù)庫管理系統(tǒng)講，它的處理速度比他們都快。 至今，迎來的版本 SQLite 3已經(jīng)發(fā)布。

****了解SQLiteOpenHelper****

package com.same.androidclass.model;

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

import com.same.androidclass.config.AppConfig;
/**
 * 數(shù)據(jù)庫助手
 * Created by alic on 16-5-5.
 */
public class DataBaseHelper extends SQLiteOpenHelper {
    public DataBaseHelper(Context context, String name, SQLiteDatabase.CursorFactory factory, int version) {
        super(context, name, factory, version);
    }

    public DataBaseHelper(Context context, String name, SQLiteDatabase.CursorFactory factory, int version, DatabaseErrorHandler errorHandler) {
        super(context, name, factory, version, errorHandler);
    }

    /**
     * 數(shù)據(jù)庫第一次創(chuàng)建時(shí)被調(diào)用
     *
     * @param db 數(shù)據(jù)庫
     */
    @Override
    public void onCreate(SQLiteDatabase db) {
        //創(chuàng)建學(xué)生實(shí)體數(shù)據(jù)表
//        private String studentId;//學(xué)號(hào)
//        private String username;//姓名
//        private String gradeYear;//年級(jí)
//        private String profession;//專業(yè)
//        private String idCard;//身份證
//        private String email;//郵箱
//        private String gradeAdmin;//行政班
//        private String assistant;//輔導(dǎo)員
//        private String headTeacher;//班主任
        db.execSQL("CREATE TABLE "+ AppConfig.TABLE_STUDENT+"(" +
                        "id INTEGER PRIMARY KEY AUTOINCREMENT," +
                        "studentId VARCHAR(11)," +
                        "username VARCHAR(6)," +
                        "gradeYear VARCHAR(4)," +
                        "profession VARCHAR(20)," +
                        "idCard VARCHAR(18)," +
                        "email VARCHAR(20)," +
                        "gradeAdmin VARCHAR(25)," +
                        "assistant VARCHAR(6)," +
                        "headTeacher VARCHAR(6)" +
                        ")"
        );
    }

    /**
     * 軟件版本號(hào)發(fā)生改變時(shí)調(diào)用
     *
     * @param db         數(shù)據(jù)庫
     * @param oldVersion 舊版本
     * @param newVersion 新版本
     */
    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        System.out.println("應(yīng)用版本已經(jīng)修改了");
    }
}

****SQLite3 For Insert增****

//數(shù)據(jù)庫助手
DataBaseHelper dataBaseHelper = new DataBaseHelper(context, AppConfig.DATABASE_NAME,null,1);
//數(shù)據(jù)庫 寫
SQLiteDatabase writableDatabase = dataBaseHelper.getWritableDatabase();
//生成ContentValues對(duì)象，key:列名  value:想插入的值
ContentValues values = new ContentValues();
values.put("studentId", student.getStudentId());
values.put("username", student.getUsername());
values.put("gradeYear", student.getGradeYear());
values.put("profession", student.getProfession());
values.put("idCard", student.getIdCard());
values.put("email", student.getEmail());
values.put("gradeAdmin", student.getGradeAdmin());
values.put("assistant", student.getAssistant());
values.put("headTeacher", student.getHeadTeacher());
//參數(shù)1：表名  
//參數(shù)2：如果你想插入空值，那么你必須指定它的所在的列  
//參數(shù)3：ContentValues對(duì)象
writableDatabase.insert(AppConfig.TABLE_STUDENT, null,values);
System.out.println("寫進(jìn)一條數(shù)據(jù)--用戶信息");

****SQLite3 For Delete刪****

//數(shù)據(jù)庫助手
DataBaseHelper dataBaseHelper = new DataBaseHelper(context, AppConfig.DATABASE_NAME,null,1);
//數(shù)據(jù)庫 讀
SQLiteDatabase readableDatabase = dataBaseHelper.getReadableDatabase();
//參數(shù)1：表名  
//參數(shù)2：where子句  
//參數(shù)3：where子句對(duì)應(yīng)的條件值 
writableDatabase.delete(AppConfig.TABLE_STUDENT, "studentId=?", new String[]{student.getStudentId()});
System.out.println("刪除了一條數(shù)據(jù)--用戶信息");

****SQLite3 For Update改****

//數(shù)據(jù)庫助手
DataBaseHelper dataBaseHelper = new DataBaseHelper(context, AppConfig.DATABASE_NAME,null,1);
//數(shù)據(jù)庫 讀
SQLiteDatabase readableDatabase = dataBaseHelper.getReadableDatabase();
//生成ContentValues對(duì)象，key:列名  value:想插入的值
ContentValues values = new ContentValues();
values.put("username", student.getUsername());
values.put("gradeYear", student.getGradeYear());
values.put("profession", student.getProfession());
values.put("idCard", student.getIdCard());
values.put("email", student.getEmail());
values.put("gradeAdmin", student.getGradeAdmin());
values.put("assistant", student.getAssistant());
values.put("headTeacher", student.getHeadTeacher());
//參數(shù)1：表名
//參數(shù)2：ContentValues對(duì)象
//參數(shù)3：where子句
//參數(shù)4：where子句對(duì)應(yīng)的條件值
writableDatabase.update(AppConfig.TABLE_STUDENT, values, "studentId=?", new String[]{student.getStudentId()});
System.out.println("更新了一條數(shù)據(jù)--用戶信息");

****SQLite3 For Query查****

//數(shù)據(jù)庫助手
DataBaseHelper dataBaseHelper = new DataBaseHelper(context, AppConfig.DATABASE_NAME,null,1);
//數(shù)據(jù)庫 讀
SQLiteDatabase readableDatabase = dataBaseHelper.getReadableDatabase();‘
//參數(shù)1：表名
//參數(shù)2：要想顯示的列
//參數(shù)3：where子句
//參數(shù)4：where子句對(duì)應(yīng)的條件值
//參數(shù)5：分組方式
//參數(shù)6：having條件
//參數(shù)7：排序方式
Cursor cursor = readableDatabase.query(AppConfig.TABLE_STUDENT, null, "studentId=?", new String[]{student.getStudentId()}, null, null, null, null);
//遍歷
//cursor.getCount()；結(jié)果集的數(shù)量
while(cursor.moveToNext()){
cursor.getString(cursor.getColumnIndex("username"));
}  

****SQLite3可視化工具****
圖形界面（一）sqlitebrowser程式（qt3）

sudo apt-get install sqlitebrowser

啟動(dòng)圖形界面可以在終端提示符后輸入sqlitebrowser

圖形界面（二）sqliteman

sudo apt-get install sqliteman

Paste_Image.png

****價(jià)值源于技術(shù)，貢獻(xiàn)源于分享****