mssql_connection 1.0.0

A robust and efficient Flutter plugin for connecting to Microsoft SQL Server databases using the JTDS driver. This plugin provides seamless integration with your Flutter application, enabling you to p [...]

example/lib/main.dart

import 'dart:developer';

import 'package:flutter/material.dart';
import 'package:flutter/services.dart';
import 'package:fluttertoast/fluttertoast.dart';
import 'package:mssql_connection/mssql_connection.dart';

void main() async {
  runApp(const MyApp());
}

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

  @override
  State<MyApp> createState() => _MyAppState();
}

class _MyAppState extends State<MyApp> {
  String ip = '',
      port = '',
      username = '',
      password = '',
      databaseName = '',
      readQuery = '',
      writeQuery = '';
  final _sqlConnection = MssqlConnection.getInstance();
  final pageController = PageController();

  @override
  void initState() {
    super.initState();
  }

  @override
  Widget build(BuildContext context) {
    const textStyle = TextStyle(fontSize: 18);
    return MaterialApp(
      debugShowCheckedModeBanner: false,
      home: Scaffold(
        appBar: AppBar(
          title: const Text('SQL Connection Example'),
        ),
        body: PageView(
          controller: pageController,
          children: [
            SingleChildScrollView(
              child: Padding(
                padding: const EdgeInsets.all(10.0),
                child: Column(children: [
                  Row(children: [
                    Flexible(
                        child: customTextField("IP address",
                            onchanged: (p0) => ip = p0,
                            keyboardType: TextInputType.number)),
                    const SizedBox(width: 10),
                    Flexible(
                        child: customTextField("Port",
                            onchanged: (p0) => port = p0,
                            keyboardType: TextInputType.number))
                  ]),
                  customTextField("Database Name",
                      onchanged: (p0) => databaseName = p0),
                  customTextField("Username", onchanged: (p0) => username = p0),
                  customTextField("Password", onchanged: (p0) => password = p0),
                  const SizedBox(height: 15.0),
                  FloatingActionButton.extended(
                      onPressed: connect, label: const Text("Connect"))
                ]),
              ),
            ),
            SingleChildScrollView(
              child: Padding(
                padding: const EdgeInsets.all(10.0),
                child: Column(
                  children: [
                    Card(
                      child: Padding(
                        padding: const EdgeInsets.all(10.0),
                        child: Column(
                          crossAxisAlignment: CrossAxisAlignment.start,
                          children: [
                            Row(
                              mainAxisAlignment: MainAxisAlignment.spaceBetween,
                              children: [
                                const Text("Read Data", style: textStyle),
                                IconButton(
                                    onPressed: () => execute("Read"),
                                    icon: const Icon(Icons.play_arrow_rounded))
                              ],
                            ),
                            customTextField('query',
                                onchanged: (p0) => readQuery = p0,
                                autovalidateMode: false,
                                enableLabel: false)
                          ],
                        ),
                      ),
                    ),
                    const SizedBox(height: 10),
                    Card(
                      child: Padding(
                        padding: const EdgeInsets.all(10.0),
                        child: Column(
                          crossAxisAlignment: CrossAxisAlignment.start,
                          children: [
                            Row(
                              mainAxisAlignment: MainAxisAlignment.spaceBetween,
                              children: [
                                const Text("Write Data", style: textStyle),
                                IconButton(
                                    onPressed: () => execute("write"),
                                    icon: const Icon(Icons.play_arrow_rounded))
                              ],
                            ),
                            customTextField('query',
                                onchanged: (p0) => writeQuery = p0,
                                autovalidateMode: false,
                                enableLabel: false)
                          ],
                        ),
                      ),
                    ),
                  ],
                ),
              ),
            ),
          ],
        ),
      ),
    );
  }

  TextFormField customTextField(String title,
          {void Function(String)? onchanged,
          TextInputType? keyboardType,
          bool autovalidateMode = true,
          bool enableLabel = true}) =>
      TextFormField(
        autocorrect: true,
        autovalidateMode:
            autovalidateMode ? AutovalidateMode.onUserInteraction : null,
        inputFormatters: [
          if (title == "IP address")
            FilteringTextInputFormatter.allow(RegExp(r'[\d\.]')),
          if (title == "Port") ...[
            FilteringTextInputFormatter.digitsOnly,
            LengthLimitingTextInputFormatter(4)
          ]
        ],
        keyboardType: keyboardType,
        onChanged: onchanged,
        decoration: InputDecoration(
            border: title == "Port" || title == "IP address"
                ? const OutlineInputBorder()
                : null,
            hintText: "Enter $title ${title == "Port" ? "number" : ""}",
            labelText: enableLabel ? title : null),
        validator: (value) {
          if (value!.isEmpty) {
            return "Please Enter $title";
          }
          return null;
        },
      );

  connect() async {
    if (ip.isEmpty ||
        port.isEmpty ||
        databaseName.isEmpty ||
        username.isEmpty ||
        password.isEmpty) {
      toastMessage("Please enter all fields", color: Colors.redAccent);

      return;
    }
    _sqlConnection
        .connect(
            ip: ip,
            port: port,
            databaseName: databaseName,
            username: username,
            password: password)
        .then((value) {
      if (value) {
        toastMessage("Connection Established", color: Colors.green);
        pageController.nextPage(
            duration: const Duration(milliseconds: 500),
            curve: Curves.easeInOut);
      } else {
        toastMessage("Connection Failed", color: Colors.redAccent);
      }
    });
  }

  Future<bool?> toastMessage(String message,
      {Color color = Colors.blueAccent}) {
    return Fluttertoast.showToast(
        msg: message,
        toastLength: Toast.LENGTH_SHORT,
        timeInSecForIosWeb: 1,
        backgroundColor: color,
        textColor: Colors.white,
        fontSize: 16.0);
  }

  execute(String s) async {
    if (s == "Read") {
      if (readQuery.isEmpty) {
        toastMessage("Empty query", color: Colors.redAccent);
        return;
      }
      var result = await _sqlConnection.getData(readQuery);
      log(result.toString(), name: "Read DATA");
      toastMessage("Please check the console for data");
    } else {
      if (writeQuery.isEmpty) {
        toastMessage("Empty query", color: Colors.redAccent);
        return;
      }
      var result = await _sqlConnection.writeData(writeQuery);
      log(result.toString(), name: "Write DATA");
      toastMessage("Please check the console for data");
    }
  }
}