引起：android.database.sqlite.SQLiteException：靠近“CREATE_TABELLOGIN”

I have an ERROR OF :

我有一个错误:

while compiling: CREATE_TABELLOGIN(IDINTEGER PRIMARY KEY AUTOINCREMENT,USERNAME text,PASSWORD text)

DATABASES CLASS:

public class LoginDataBaseAdapter {   
  static final String DATABASE_NAME="login.db";   
  static final int DATABASE_VERSION=1;   
  public static final int NAME_COLUMN=1;   
  static final String DATABASE_CREATE= "CREATE_TABEL" + "LOGIN" +
  "(" + "ID" + "INTEGER PRIMARY KEY AUTOINCREMENT," + "USERNAME text,PASSWORD text);";

6 个解决方案

#1

-2

You forgot to give a space before "INTEGER and remove the _ (underscore) between CREATE_TABLE

你忘了在“INTEGER”之前给出一个空格并删除CREATE_TABLE之间的_(下划线)

Add a space like below,

添加如下空格,

static final String DATABASE_CREATE= "CREATE TABLE" + "LOGIN" +
"(" + "ID" + " INTEGER PRIMARY KEY AUTOINCREMENT," + 
      "USERNAME text,PASSWORD text);";

#2

That's not valid SQL.

这不是有效的SQL。

You probably meant CREATE TABLE LOGIN not CREATE_TABELLOGIN and ID INTEGER not IDINTEGER.

您可能认为CREATE TABLE LOGIN不是CREATE_TABELLOGIN而ID INTEGER不是IDINTEGER。

#3

That's because you're using wrong syntax for creating a table. There's no such thing as CREATE_TABELLOGIN

那是因为您使用了错误的语法来创建表。没有CREATE_TABELLOGIN这样的东西

Refer to this page for an example

有关示例,请参阅此页面

#4

Yes there are some issue with spacing in query.

是的,查询中的间距存在一些问题。

static final String DATABASE_CREATE= "CREATE TABEL " + " LOGIN " + "(" + " ID " + " INTEGER PRIMARY KEY AUTOINCREMENT," + " USERNAME text, PASSWORD text);";

static final String DATABASE_CREATE =“CREATE TABEL”+“LOGIN”+“”(“+”ID“+”INTEGER PRIMARY KEY AUTOINCREMENT,“+”USERNAME text,PASSWORD text);“;

Try to print the query.

尝试打印查询。

It was

 CREATE TABEL LOGIN(IDINTEGER PRIMARY KEY AUTOINCREMENT,USERNAME text,PASSWORD text);

Now it is

现在它是

 CREATE TABEL  LOGIN ( ID INTEGER PRIMARY KEY AUTOINCREMENT, USERNAME text, PASSWORD text);

#5

Your DATABASES CLASS:

您的数据库类:

public class LoginDataBaseAdapter {   
  static final String DATABASE_NAME="login.db";   
  static final String DATATABLE_NAME ="LOGIN";   
  static final int DATABASE_VERSION=1;   
  public static final int NAME_COLUMN=1;   
  static final String DATABASE_CREATE= "CREATE TABLE " + DATATABLE_NAME +
  " (" + "ID" + " INTEGER PRIMARY KEY AUTOINCREMENT, " + "USERNAME TEXT, PASSWORD TEXT);";

This is your correct answer check and run it.

这是您的正确答案检查并运行它。

#6

-1

public class LoginDataBaseAdapter {
static final String DATABASE_NAME="login.db";static final int DATABASE_VERSION=1;
public static final int NAME_COLUMN=1;
 static final String DATABASE_CREATE= "CREATE TABLE " + "LOGIN" +
"(" + "ID" + " INTEGER PRIMARY KEY AUTOINCREMENT," + " USERNAME text, PASSWORD text);";

you need to add space between words and you spell TABLE is wrong.

你需要在单词之间添加空格,你拼写TABLE是错误的。

#1

-2