1.01.01.06.008 - Flutter ile Mobil Uygulama Geliştirme Uzaktan Eğitim Kursu

main.dart

import 'package:flutter/material.dart';
import 'package:flutterveritabani/db/dbHelper.dart';
import 'package:flutterveritabani/models/urun.dart';

import 'ekranlar/urunListesi.dart';

void main() => runApp(MyApp());

class MyApp extends StatelessWidget {
  // This widget is the root of your application.
  @override
  Widget build(BuildContext context) {
    List<Urun> urunler = new List<Urun>();
    DbHelper dbHelper = new DbHelper();

  dbHelper.dbOlustur().then((database)=>dbHelper.getUrunler().then((GelenUrunler)=>urunler=GelenUrunler));
   dbHelper.dbOlustur().then((database) => {});

    Urun urun1 = new Urun("A8 2017", "Samsung", 2000);
    dbHelper.ekle(urun1);
    Urun urun2 = new Urun("M30", "Samsung", 1800);
    dbHelper.ekle(urun2);
    Urun urun3 = new Urun("S10", "Samsung", 12000);
    dbHelper.ekle(urun3);
    Urun urun4 = new Urun("Note 10", "Samsung", 14000);
    dbHelper.ekle(urun4);

   return MaterialApp(
     title: "E-Ticaret Demo",
     home:Anasayfa(),
   );

  }
}

class Anasayfa extends StatefulWidget{
  @override
  State<StatefulWidget> createState() {
    // TODO: implement createState
    return AnasayfaState();
  }

}

class AnasayfaState extends State<Anasayfa>{
  @override
  Widget build(BuildContext context) {
    // TODO: implement build
    return Scaffold(
      appBar: AppBar(
        title: Text("E-Ticaret Deneme2"),
      ),
      body: UrunListesi(),
    );
  }
}

Urun.dart

class Urun {
  int _id;

  double get fiyat => _fiyat;

  set fiyat(double value) {
    _fiyat = value;
  }

  String _ad;

  int get id => _id;

  set id(int value) {
    _id = value;
  }

  String _aciklama;

  String get aciklama => _aciklama;

  set aciklama(String value) {
    _aciklama = value;
  }

double _fiyat;

  String get ad => _ad;

  set ad(String value) {
    _ad = value;
  }

  Urun(this._ad, this._aciklama, this._fiyat);
  Urun.Idli(this._id, this._ad, this._aciklama, this._fiyat);

  Map<String, dynamic> MapYap() {
    var map = Map<String, dynamic>();
    map["ad"] = _ad;
    map["aciklama"] = _aciklama;
    map["fiyat"] = _fiyat;
    if (_id != null) {
      map["id"] = _id;
    }
    return map;
  }

  Urun.fromObject(dynamic o) {
    this._id = o["id"];
    this._ad = o["ad"];
    this._aciklama = o["aciklama"];
    this._fiyat =double.tryParse(o["fiyat"].toString());
  }
}

import 'package:fluttereticaret/models/Urun.dart';
import 'package:sqflite/sqflite.dart';
import 'dart:async';
import 'dart:io';
import 'package:path_provider/path_provider.dart';

class DbHelper {
  String tblUrun = "urunler";
  String colId = "id";
  String colAd = "ad";
  String colFiyat = "fiyat";
  String colAciklama = "aciklama";

  static final DbHelper _dbHelper = DbHelper._internal();

  DbHelper._internal();

  factory DbHelper() {
    return _dbHelper;
  }

  static Database _db;

  Future<Database> get db async {
    if (_db == null) {
      _db = await dbOlustur();
    }
    return _db;
  }

  Future<Database> dbOlustur() async {
    Directory directory = await getApplicationDocumentsDirectory();
    String yol = directory.path + "eticaret.db";

    var eTicaretdb=await openDatabase(yol,version: 1,onCreate: olustur);
    return eTicaretdb;

  }

  void olustur(Database db,int versiyon) async{
    await db.execute("Create table $tblUrun($colId integer primary key,$colAd text, $colAciklama text,$colFiyat int)");
  }

  Future<int> ekle(Urun urun) async{
    Database db=await this.db;
    var sonuc =await db.insert(tblUrun, urun.mapYap());
    return sonuc;
  }

  Future<List> getUrunler() async{
    Database db=await this.db;
    var sonuc=await db.rawQuery("Select * from $tblUrun");
    return sonuc;
  }
}