CODEWITHSUNDEEP
mysqldatabasedart
hoantrung
hoantrung

Reputation: 191

How to connect mysql Database with Dart?

Does anyone can tell me how to connect to mysql database with Dart? I've been reading and searching for days but can't find any suitable answers. I just learning web programming. Thank you!

Upvotes: 16

Views: 33398

Answers (4)

Nae
Nae

Reputation: 15335

I think for dart 2 mysql1 is a simple choice.

Example:

import 'package:mysql1/mysql1.dart';

Future main() async {
  // Open a connection (testdb should already exist)
  final connection = await MySqlConnection.connect(new ConnectionSettings(
      host: '10.0.2.2',
      port: 3306,
      user: 'root',
      password: '0123456789',
      db: 'development',
      ));
  var results = await connection.query('select * from tableName');
  for (var row in results) {
    print('${row[0]}');
  }

  // Finally, close the connection
  await connection.close();
}

(tested on Dart version 2.1.0 (build 2.1.0-dev.9.4 f9ebf21297))

Upvotes: 9

adlerluiz
adlerluiz

Reputation: 1

You can try using sqljocky -> http://pub.dartlang.org/packages/sqljocky

Upvotes: 0

Lars Tackmann
Lars Tackmann

Reputation: 20865

You can use SQLJocky to connect to MySQL. Add 

dependencies:
  sqljocky: 0.0.4

to your pubspec.yaml an run pub install. Now you can connect to MySQL like this

var cnx = new Connection();
cnx.connect(username, password, dbName, port, hostname).then((nothing) {
    // Do something with the connection
    cnx.query("show tables").then((Results results) {
    print("tables");
    for (List row in results) {
      print(row);
    }
  });
});

Upvotes: 15

mwattsun
mwattsun

Reputation: 1

I haven't tried this, but here is one: http://github.com/jamesots/sqljocky

Upvotes: 0

Related Questions