import 'package:path/path.dart'; import 'package:sqflite/sqflite.dart' as Sqlite; import 'package:sqflite/sqflite.dart'; import 'package:taskservice/Model/JXMemberModel.dart'; import 'package:taskservice/Model/JXServiceModel.dart'; class MyDataBase { static MyDataBase _instance; Database _database; String tableMembers = 'members'; String tableServices = 'services'; static Future get database async { if(_instance == null){ _instance = MyDataBase(); await _instance.init(); } return _instance; } Future init() async { _database = await Sqlite.openDatabase(join((await Sqlite.getDatabasesPath()), 'data.db')); List> result = await _database.rawQuery("CREATE TABLE IF NOT EXISTS $tableMembers(id INTEGER PRIMARY KEY, " "name TEXT, tel TEXT, birth TEXT, prov TEXT, city TEXT, area TEXT, addr TEXT, remark TEXT)"); } Future> queryAllMembers() async { List> data = await _database.query("$tableMembers"); return data.map((e) => JXMemberModel()..id = e['id']..name = e['name']..tel = e['tel'] ).toList(); } Future saveMember(JXMemberModel jxMemberModel) async { await _database.insert( tableMembers, jxMemberModel.toMap(), conflictAlgorithm: ConflictAlgorithm.replace, ); } Future saveService(JXMemberModel jxMemberModel, JXServiceModel jxServiceModel) { } }