wildanfuady

Database Helper Step #1

Nov 26th, 2019
397
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.71 KB | None | 0 0
  1. class DatabaseHelper {
  2.  
  3. static Database _db;
  4.  
  5. Future<Database> get db async {
  6.  
  7. if (_db != null) {
  8. return _db;
  9. }
  10.  
  11. _db = await initDatabase();
  12. return _db;
  13.  
  14. }
  15.  
  16. initDatabase() async {
  17.  
  18. io.Directory documentDirectory = await getApplicationDocumentsDirectory();
  19. String path = join(documentDirectory.path, 'student.db');
  20. var db = await openDatabase(path, version: 1, onCreate: _onCreate);
  21. return db;
  22.  
  23. }
  24.  
  25. _onCreate(Database db, int version) async {
  26. await db
  27. .execute('CREATE TABLE student (id INTEGER PRIMARY KEY, nama_depan TEXT, nama_belakang TEXT, no_hp TEXT, gender TEXT, jenjang TEXT, hobi TEXT, alamat TEXT, email TEXT)');
  28. }
  29. }
Advertisement
Add Comment
Please, Sign In to add comment