`
xiaofengtoo
  • 浏览: 493933 次
  • 性别: Icon_minigender_1
  • 来自: xiamen
社区版块
存档分类
最新评论

Column 'IS_AUTOINCREMENT' not found

 
阅读更多

java.sql.SQLException: Column 'IS_AUTOINCREMENT' not found.

 

看了java API 不应该出现错误,后来反思是否jdbc 驱动包有问题

 

我连的是mysql ,用的是mysql-connector-java-5.0.5-bin.jar 

 

然后去查看下mysql 版本为5.1

替换

mysql-connector-java-5.1.8-bin.jar

 

问题解决

分享到:
评论

相关推荐

    SQL语句_设置序列和触发器

    - `CREATE OR REPLACE TRIGGER`:声明创建或替换名为`DEPARTMENT_AUTOINCREMENT`的触发器。 - `BEFORE INSERT ON DEPARTMENT`:在对`DEPARTMENT`表进行插入操作前触发。 - `FOR EACH ROW`:表示该触发器是对每一行...

    安卓SQLite数据库相关-本程序覆盖了安卓中数据库从创建到增删改查的完整步奏适合初学者.rar

    + COLUMN_ID + " INTEGER PRIMARY KEY AUTOINCREMENT, " + COLUMN_NAME + " TEXT, " + COLUMN_AGE + " INTEGER)"; ``` 这里的TABLE_NAME是表名,COLUMN_ID、COLUMN_NAME和COLUMN_AGE是列名,分别定义了主键ID、...

    Android Studio基于数据库重置密码

    "(" + COLUMN_ID + " INTEGER PRIMARY KEY AUTOINCREMENT, " + COLUMN_USERNAME + " TEXT, " + COLUMN_PASSWORD + " TEXT)"; // ...其他方法 } ``` 在`DatabaseHelper`类中,我们需要实现`onUpgrade()`方法以...

    Android SQLiteDatabase的使用详解

    + COLUMN_ID + " INTEGER PRIMARY KEY AUTOINCREMENT," + COLUMN_NAME + " TEXT," + COLUMN_AGE + " INTEGER" + ")"; db.execSQL(CREATE_TABLE_SQL); } @Override public void onUpgrade(SQLiteDatabase db,...

    android SQLite代码

    "(" + COLUMN_ID + " INTEGER PRIMARY KEY AUTOINCREMENT," + COLUMN_NAME + " TEXT," + COLUMN_AGE + " INTEGER" + ")"; db.execSQL(CREATE_TABLE); } ``` 这里创建了一个名为`TABLE_NAME`的表,包含`COLUMN_...

    17_创建数据库与完成数据添删改查_clip3

    + COLUMN_ID + " INTEGER PRIMARY KEY AUTOINCREMENT," + COLUMN_NAME + " TEXT," + COLUMN_AGE + " INTEGER" + ")"; db.execSQL(CREATE_TABLE); } ``` 这里创建了一个名为`TABLE_NAME`的表,包含`COLUMN_ID`...

    workspace_test.rar

    + COLUMN_ID + " INTEGER PRIMARY KEY AUTOINCREMENT," + COLUMN_NAME + " TEXT," + COLUMN_AGE + " INTEGER" + ")"; db.execSQL(CREATE_TABLE); } ``` 这里创建了一个包含id(主键)、name和age三列的表。 ...

    SQLite 增删改查的工具类

    "(" + ColumnName.COLUMN_ID + " INTEGER PRIMARY KEY AUTOINCREMENT," + ColumnName.COLUMN_NAME + " TEXT," + ColumnName.COLUMN_AGE + " INTEGER" + ")"; public DatabaseHelper(Context context) { super...

    Android 操作数据库实例.rar

    + COLUMN_ID + " INTEGER PRIMARY KEY AUTOINCREMENT," + COLUMN_NAME + " TEXT," + COLUMN_AGE + " INTEGER" + ")"; db.execSQL(CREATE_TABLE); } ``` 在上述代码中,我们创建了一个名为`TABLE_NAME`的表,...

    android sqlite 示例

    COLUMN_ID + " INTEGER PRIMARY KEY AUTOINCREMENT, " + COLUMN_NAME + " TEXT, " + COLUMN_AGE + " INTEGER)"; public MyDatabaseHelper(Context context) { super(context, DATABASE_NAME, null, DATABASE_...

    Android-Android数据库SQLite的简单使用实现我的便签

    + COLUMN_ID + " INTEGER PRIMARY KEY AUTOINCREMENT," + COLUMN_TITLE + " TEXT," + COLUMN_CONTENT + " TEXT" + ")"; public NoteDatabaseHelper(Context context) { super(context, DATABASE_NAME, null, ...

    android Sqlite数据库操作demo

    + Users.COLUMN_NAME + " TEXT NOT NULL," + Users.COLUMN_EMAIL + " TEXT UNIQUE" + ")"; db.execSQL(CREATE_USERS_TABLE); } ``` 接下来,我们需要提供增删改查(CRUD)的方法。比如插入数据,可以创建一个`...

    Android SQLite 增、删、查、改操作源码.rar

    + COLUMN_ID + " INTEGER PRIMARY KEY AUTOINCREMENT," + COLUMN_NAME + " TEXT," + COLUMN_AGE + " INTEGER)"; db.execSQL(CREATE_TABLE); } ``` 插入数据时,使用SQLiteDatabase的insert()方法: ```java ...

    SQLite之Autoincrement关键字(自动递增)

    其中,`table_name`是你要创建的表格名称,`column1`是使用`AUTOINCREMENT`的整型字段,而`column2`、`column3`等是其他数据类型的列。 **3. 示例** 在给出的例子中,创建了一个名为`COMPANY`的表,包含以下列: - ...

    Android数据库SQLlite操作demo

    + COLUMN_ID + " INTEGER PRIMARY KEY AUTOINCREMENT," + COLUMN_USERNAME + " TEXT," + COLUMN_PASSWORD + " TEXT" + ")"; db.execSQL(CREATE_USER_TABLE); } ``` 接下来,我们实现插入(INSERT)操作,当用户...

    Android——使用SQLite数据库访问

    COLUMN_ID + " INTEGER PRIMARY KEY AUTOINCREMENT," + COLUMN_NAME + " TEXT," + COLUMN_AGE + " INTEGER)"; db.execSQL(CREATE_TABLE); } // onUpgrade() 方法 @Override public void onUpgrade...

    android 简单的增删查改实现

    + COLUMN_ID + " INTEGER PRIMARY KEY AUTOINCREMENT, " + COLUMN_NAME + " TEXT, " + COLUMN_AGE + " INTEGER);"; // ...构造函数和其他方法 } ``` 2. 添加数据(Add) 在添加数据时,我们需要使用SQL的...

    android sqlite数据库 demo

    COLUMN_ID + " INTEGER PRIMARY KEY AUTOINCREMENT, " + COLUMN_NAME + " TEXT, " + COLUMN_AGE + " INTEGER)"; db.execSQL(CREATE_TABLE); } @Override public void onUpgrade(SQLiteDatabase db, int old...

    Android 连接SQLite数据库源码.zip

    + COLUMN_ID + " INTEGER PRIMARY KEY AUTOINCREMENT," + COLUMN_NAME + " TEXT," + COLUMN_AGE + " INTEGER" + ")"; db.execSQL(CREATE_TABLE); } ``` 3. 实现`onUpgrade()`方法:当数据库版本发生变化时,...

Global site tag (gtag.js) - Google Analytics