Flutter连接MySQL云数据库

Flutter连接MySQL云数据库

使用mysql1插件

在pub.dev上找到mysql1插件（点击前往），
添加mysql1插件到pubspec.yaml文件中：

mysql1: ^0.17.1

调用mysql1插件

首先在需要处引入包：

import 'package:mysql1/mysql1.dart' as mysql;

因为包中的Row会和布局中的Row控件冲突，所以这里务必重命名。

如何使用：

Future Database() async {
   
   
    var settings = new mysql.ConnectionSettings(
        host: 'rm-xxxxxx.mysql.rds.aliyuncs.com',  // 这里以阿里云DMS为例
        port: 3306,
        user: 'your username', 	// 更换用户名
        password: 'your psw',		//更换密码
        db: 'python_catch_info');
    var conn = await mysql.MySqlConnection.connect(settings);
    var result =
        await conn.query("select * from movie_info ORDER BY movie_rank limit 20");
    await conn.close();
    print(result);
  }

官方example：

import 'dart:async';

import 'package:mysql1/mysql1.dart';

Future main() async {
   
   
  // Open a connection (testdb should already exist)
  final conn = await MySqlConnection.connect(ConnectionSettings(
      host: 'localhost',
      port: 3306,
      user: 'root',
      db: 'testdb',
      password: 'secret'));

  // Create a table
  await conn.query(
      'CREATE TABLE users (id int NOT NULL AUTO_INCREMENT PRIMARY KEY, name varchar(255), email varchar(255), age int)');

  // Insert some data
  var result = await conn.query(
      'insert into users (name, email, age) values (?, ?, ?)',
      ['Bob', 'bob@bob.com', 25]);
  print('Inserted row id=${result.insertId}');

  // Query the database using a parameterized query
  var results = await conn.query(
      'select name, email, age from users where id = ?', [result.insertId]);
  for (var row in results) {
   
   
    print('Name: ${row[0]}, email: ${row[1]} age: ${row[2]}');
  }

  // Update some data
  await conn.query('update users set age=? where name=?', [26, 'Bob']);

  // Query again database using a parameterized query
  var results2 = await conn.query(
      'select name, email, age from users where id = ?', [result.insertId]);
  for (var row in results2) {
   
   
    print('Name: ${row[0]}, email: ${row[1]} age: ${row[2]}');</