SQLITE Database CRUD

 

import 'package:flutter/material.dart';
import 'package:sqflite/sqflite.dart';
import 'package:path/path.dart';

void main() {
  runApp(Myapp());
}

class Myapp extends StatelessWidget {
  const Myapp({super.key});

  @override
  Widget build(BuildContext context) {
    return MaterialApp(
      title: "This is Sqlite Demo",
      theme: ThemeData(primarySwatch: Colors.blue),
      home: HomePage(),
    );
  }
}

class HomePage extends StatefulWidget {
  const HomePage({super.key});

  @override
  State<HomePage> createState() => _HomePageState();
}

class _HomePageState extends State<HomePage> {
  TextEditingController controller = new TextEditingController();
  GlobalKey<FormState> _formkey = GlobalKey<FormState>();
  Future<Database>? database;

  @override
  void initState() {
    // TODO: implement initState
    super.initState();
    opendatabse();
  }

  Future<void> opendatabse() async {
    database = openDatabase(join(await getDatabasesPath(), "mydb.db"),
        onCreate: (db, version) {
      return db.execute(
        "CREATE TABLE USER1(ID INTEGER PRIMARY KEY AUTOINCREMENT, NAME TEXT)",
      );
    }, version: 1);
  }

  Future<void> insert(String name) async {
    final Database? db = await database;
    db?.insert(
      "USER1",
      {
        'NAME': name,
      },
      conflictAlgorithm: ConflictAlgorithm.replace,
    );
  }

  @override
  Widget build(BuildContext context) {
    return Scaffold(
      appBar: AppBar(
        title: Text("Sqlite Insert"),
      ),
      body: Center(
        child: Form(
          key: _formkey,
          child: Column(
            mainAxisAlignment: MainAxisAlignment.center,
            children: <Widget>[
              Padding(
                padding: EdgeInsets.symmetric(horizontal: 20),
                child: TextFormField(
                  controller: controller,
                  decoration: InputDecoration(labelText: "Enter Name"),
                  validator: (value) {
                    if (value!.isEmpty) {
                      return "Please Ente Text";
                    }
                    return null;
                  },
                ),
              ),
              SizedBox(
                height: 20,
              ),
              ElevatedButton(
                  onPressed: () {
                    if (_formkey.currentState!.validate()) {
                      insert(controller.text);
                      controller.clear();
                      ScaffoldMessenger.of(context).showSnackBar(
                          SnackBar(content: Text("Data Inserted")));
                      Navigator.push(
                          context,
                          MaterialPageRoute(
                              builder: (context) => Displaydata()));
                    }
                  },
                  child: Text("SAVE"))
            ],
          ),
        ),
      ),
    );
  }
}

class Displaydata extends StatefulWidget {
  const Displaydata({super.key});

  @override
  State<Displaydata> createState() => _DisplaydataState();
}

class _DisplaydataState extends State<Displaydata> {
  Future<List<Map<String, dynamic>>>? userdata;

  Future<Database>? database;

  Future<void> opendatabse() async {
    database = openDatabase(join(await getDatabasesPath(), "mydb.db"),
        onCreate: (db, version) {
      return db.execute(
        "CREATE TABLE USER1(ID INTEGER PRIMARY KEY AUTOINCREMENT, NAME TEXT)",
      );
    }, version: 1);
  }

  Future<List<Map<String, dynamic>>> getUserdata() async {
    final Database database =
        await openDatabase(join(await getDatabasesPath(), "mydb.db"));
    final List<Map<String, dynamic>> maps = await database.query('USER1');
    return maps;
  }

  @override
  void initState() {
    // TODO: implement initState
    super.initState();
    userdata = getUserdata();
    opendatabse();
  }

  Future<void> deleteData(int id) async {
    final db = await database;
    await db?.delete("USER1", where: 'ID=?', whereArgs: [id]);
    setState(() {
      userdata = getUserdata();
    });
  }

  @override
  Widget build(BuildContext context) {
    return Scaffold(
      appBar: AppBar(
        title: Text("USERLIST"),
      ),
      body: FutureBuilder<List<Map<String, dynamic>>>(
        future: userdata,
        builder: (context, snapshot) {
          if (snapshot.connectionState == ConnectionState.waiting) {
            return Center(
              child: CircularProgressIndicator(),
            );
          } else if (snapshot.hasError) {
            return Center(
              child: Text("Error: ${snapshot.error}"),
            );
          } else if (!snapshot.hasData || snapshot.data!.isEmpty) {
            return Center(
              child: Text("No data available"),
            );
          } else {
            return ListView.builder(
                itemCount: snapshot.data!.length,
                itemBuilder: (context, index) {
                  return ListTile(
                    title: Text(snapshot.data![index]['NAME']),
                    trailing: Row(
                      mainAxisSize: MainAxisSize.min,
                      children: [
                        IconButton(
                          icon: Icon(Icons.edit),
                          onPressed: () {
                            Navigator.push(
                                context,
                                MaterialPageRoute(
                                    builder: (context) => Updatedata(
                                        userid: snapshot.data![index]['ID'],
                                        name: snapshot.data![index]['NAME'],
                                        onDataUpdate: () {
                                          setState(() {
                                            userdata = getUserdata();
                                          });
                                        })));
                          },
                        ),
                        IconButton(
                            onPressed: () {
                              deleteData(snapshot.data![index]['ID']);
                              setState(() {
                                userdata = getUserdata();
                              });
                            },
                            icon: Icon(Icons.delete))
                      ],
                    ),
                  );
                });
          }
        },
      ),
    );
  }
}

class Updatedata extends StatefulWidget {
  int userid;
  String name;
  final Function() onDataUpdate;

  Updatedata(
      {super.key,
      required this.userid,
      required this.name,
      required this.onDataUpdate});

  @override
  State<Updatedata> createState() => _UpdatedataState();
}

class _UpdatedataState extends State<Updatedata> {
  TextEditingController txt = new TextEditingController();
  late Future<Database> database;

  @override
  void initState() {
    // TODO: implement initState
    super.initState();
    txt.text = widget.name;
    initialize();
  }

  void initialize() async {
    final dbpath = await getDatabasesPath();
    final path = join(dbpath, "mydb.db");
    database = openDatabase(path, onCreate: (db, version) {
      return db.execute(
        "CREATE TABLE USER1(ID INTEGER PRIMARY KEY AUTOINCREMENT, NAME TEXT)",
      );
    }, version: 1);
  }

  @override
  Widget build(BuildContext context) {
    return Scaffold(
      appBar: AppBar(
        title: Text("Update"),
      ),
      body: Center(
        child: Column(
          mainAxisAlignment: MainAxisAlignment.center,
          children: <Widget>[
            Padding(
              padding: EdgeInsets.symmetric(horizontal: 20),
              child: TextFormField(
                controller: txt,
                decoration: InputDecoration(labelText: "Enter Name"),
                validator: (value) {
                  if (value!.isEmpty) {
                    return "Please Enter Text";
                  }
                  return null;
                },
              ),
            ),
            SizedBox(
              height: 20,
            ),
            ElevatedButton(
                onPressed: () async {
                  await updatedata1(widget.userid, txt.text);
                  widget.onDataUpdate();
                  Navigator.pop(context);
                },
                child: Text("UPDATE"))
          ],
        ),
      ),
    );
  }

  Future<void> updatedata1(int id, String name) async {
    final db = await database;
    await db.update("USER1", {"NAME": name}, where: 'ID=?', whereArgs: [id]);
    widget.onDataUpdate();
  }
}