SQLITE

-   Tạo class Database

public class SQLITE extends SQLiteOpenHelper {



    public SQLITE(Context context) {

        super(context,"SQLite.sqlite", null , 1);

    }





    @Override

    public void onCreate(SQLiteDatabase db) {



    }



    public Cursor SQLite_GetData(String sql){

        SQLiteDatabase db = getWritableDatabase();

        Cursor c = db.rawQuery(sql , null);

        return c ;

    }

    public void SQL_QueryData(String sql){

        SQLiteDatabase db = getWritableDatabase();

        db.execSQL(sql);



    }



    @Override

    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {



    }

- Sử dụng class Database

         SQLITE sql = new SQLITE(this);

sql.SQL_QueryData("insert into thongtinsinhvien values( null, '" + edtHoTen.getText().toString() +"','" + edtSDT.getText().toString() + "','"+ edtEmail.getText().toString()+"')");

sql.SQL_QueryData("CREATE TABLE IF NOT EXISTS thongtinsinhvien (ID INTEGER PRIMARY KEY , HOTEN VARCHAR(100) NOT NULL , SDT VARCHAR(100) NOT NULL , EMAIL VARCHAR(100) NOT NULL)");

mang.clear();

Cursor c = sql.SQLite_GetData("SELECT * FROM thongtinsinhvien");

String s = "";

while(c.moveToNext()) {



   mang.add(new SinhVien(c.getString(1),c.getString(2),c.getString(3)));

}



SinhVienAdapter adapter = new SinhVienAdapter( getApplication() , R.layout.activity_dong_sinh_vien , mang );

lv.setAdapter(adapter);