如何更正错误数据库异常(接近")"：语法错误

Question

error DatabaseException(near ")":语法错误(代码1 SQLITE_ERROR):，编译时:I/flutter (21754): _id INTEGER主键，I/flutter(21754):名称文本非空，I/flutter(21754):地址文本不是NULL，I/flutter(21754):注释文本不为空，I/flutter (21754): sigURL TEXT NOT NULL，I/flutter (21754): selfpicurltext NOT NULL，我/颤振(21754):I/flutter (21754): hi INT NOT NULL，I/flutter (21754): time TEXT NOT NULL，

import 'dart:io';
import 'package:path/path.dart';
import 'package:sqflite/sqflite.dart';
import 'package:path_provider/path_provider.dart';
class DatabaseHelper {
static final _databaseName = "MyDatabase.db";
static final _databaseVersion = 1;
static final table = 'my_table';
static final columnId = '_id';
static final columnName = 'name';
static final address = 'address';
static final comments = 'comments';
static final sigURL = 'sigURL';
static final columnAge = 'hi';
static final  selfpicURL = 'selfpicURL';
static final  createdTime = 'time';
DatabaseHelper._privateConstructor();
static final DatabaseHelper instance = DatabaseHelper._privateConstructor();
static Database? _database;
Future<Database> get database async {
if (_database != null) return _database!;
// lazily instantiate the db the first time it is accessed
_database = await _initDatabase();
return _database!;
}
_initDatabase() async {
Directory documentsDirectory = await getApplicationDocumentsDirectory();
String path = join(documentsDirectory.path, _databaseName);
return await openDatabase(path,
version: _databaseVersion,
onCreate: _onCreate);
}
Future _onCreate(Database db, int version) async {
await db.execute('''
CREATE TABLE $table (
$columnId INTEGER PRIMARY KEY,
$columnName TEXT NOT NULL,
$address TEXT NOT NULL,
$comments TEXT NOT NULL,
$sigURL TEXT NOT NULL,
$selfpicURL TEXT NOT NULL,
$columnAge INT NOT NULL,
$createdTime TEXT NOT NULL,



)
''');
}

Future<int> insert(Map<String, dynamic> row) async {
Database db = await instance.database;
return await db.insert(table, row);
}

Future<List<Map<String, dynamic>>> queryAllRows() async {
Database db = await instance.database;
return await db.query(table);
}

Future queryRowCount() async {
Database db = await instance.database;
return Sqflite.firstIntValue(await db.rawQuery('SELECT COUNT(*) FROM $table'));
}

Future<int> update(Map<String, dynamic> row) async {
Database db = await instance.database;
int id = row[columnId];
return await db.update(table, row, where: '$columnId = ?', whereArgs: [id]);
}

Future<int> delete(int id) async {
Database db = await instance.database;
return await db.delete(table, where: '$columnId = ?', whereArgs: [id]);
}
}

Answer 1

SQLite SQL解析器不支持结束括号前的尾随逗号

而不是(在语句的末尾)

...
$createdTime TEXT NOT NULL,
)

...
$createdTime TEXT NOT NULL
)

Answer 2

create table $tableTodo ( 
$columnId integer primary key autoincrement, 
$columnTitle text not null,
$columnDone integer not null)
''');

如果你仔细看最后一行$columnDone integer not null它没有像其他两行一样的逗号，这就是你代码中的问题。

查看更多信息

快乐编码

Answer 3

SQLite不支持尾随逗号。尝试删除关于创建表的最后一个语句中的逗号。例如

如果你这样写;

$createdTime TEXT NOT NULL，

尝试相反;

$createdTime TEXT NOT NULL