关于Android sqlite 的问题求助

[baidu_20510615]

package tjuci.dl.myweixin;

import android.app.Activity;
import android.content.ContentValues;
import android.content.Intent;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.util.Log;
import android.widget.Toast;

public class Sqlite extends Activity {

private SQLiteDatabase db = null;
private final static String DATABASE_NAME = "Regist.sqlite";
private final static int version = 1;
public final static String TABLE_NAME = "regist";

final DbHelper helper = new DbHelper(this , DATABASE_NAME , null ,version);

@Override
public void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.sql);

Intent get_data = getIntent();
Bundle bundle = get_data.getExtras();
String username = bundle.getString("username");
String password = bundle.getString("password");

//从辅助类获得数据库对象
db = helper.getWritableDatabase();
//db = helper.getReadableDatabase();

ContentValues cv = new ContentValues();
cv.put("username", username);
cv.put("userpassword", password);
long long_1 = db.insert(TABLE_NAME, null, cv);
if(long_1 == -1){
Toast.makeText(getApplicationContext(), "插入失败", Toast.LENGTH_SHORT).show();
}else{
Intent intent = new Intent(Sqlite.this , MainActivity.class);
startActivity(intent);
Sqlite.this.finish();
}

Log.i("guwei", username + " " + password);
db.close();
}
}


package tjuci.dl.myweixin;

import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteDatabase.CursorFactory;
import android.database.sqlite.SQLiteOpenHelper;

public class DbHelper extends SQLiteOpenHelper {

public DbHelper(Context context, String name, CursorFactory factory,
int version) {
super(context, name, factory, version);
// TODO Auto-generated constructor stub
}

@Override
public void onCreate(SQLiteDatabase db) {
String sql = "create table regist(_id integer primary key ,username varchar(10),userpassword varchar(10));";
db.execSQL(sql);
}

@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {

}

}

以上是代码部分 主要是想 向sqlite中创一个叫Register的数据库 建一个 叫做regist 的表 （有id ，username ，userpassword）三个字段。 在运行时总是给出没有username这个列的 错误 求解

[baidu_20510615]

错误信息

[李元静]

我看你的主键id并没有设置自动增长autoincrement，也没看你在contentvalue里面添加id，那你怎么能添加成功呢，把primary key 后面加上autoincrement

[sagittarius1988]

难道你用的是之前创建的表？表里没有这个字段？卸载apk再安装试试