Android 通过ContentProvider向SQLite数据库插入数据不成功

0 0

Android 通过ContentProvider向SQLite数据库插入数据不成功3

我自己写了一个ContentProvider，在执行向SQLiteDatabase数据库中插入一条记录时不成功，打出的log如下：
11-27 02:00:11.696: ERROR/Database(997): android.database.sqlite.SQLiteException: table employee has no column named name: , while compiling: INSERT INTO employee(name) VALUES(?);

我的SQLiteOpenHelper类的派生类如下：

package com.hgl.test;

import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.util.Log;

import com.hgl.test.Employees.Employee;

public class DBHelper extends SQLiteOpenHelper {
	private static final String DATABASE_NAME = "Employees.db";
	private static final int DATABASE_VERSION = 1;
	public static final String EMPLOYEES_TABLE_NAME = "employee";
	
	// 创建数据库
	public DBHelper(Context context) {
		super(context, DATABASE_NAME, null, DATABASE_VERSION);
		Log.i("DBHelper Info===================>>>>>>>","this is DBHelper constructer function");
	}
	// 创建时调用，创建一个表
	@Override
	public void onCreate(SQLiteDatabase db) {
		// TODO Auto-generated method stub
		Log.i("DBHelper Info===================>>>>>>>","this is onCreate function");
		String createTableSQL = "CREATE TABLE " + EMPLOYEES_TABLE_NAME + "("
				+ Employee._ID + " INTEGER PRIMARY KEY," + Employee.NAME
				+ " TEXT," + Employee.GENDER + " TEXT," + Employee.AGE
				+ " INTEGER)";

		db.execSQL(createTableSQL);
		Log.d("Create Table=====================>>>>>>>>>>>", "create table "
				+ EMPLOYEES_TABLE_NAME);
	}
	// 版本更新时调用
	@Override
	public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
		// TODO Auto-generated method stub
		db.execSQL("DROP TABLE IF EXISTS "+EMPLOYEES_TABLE_NAME);
		onCreate(db);
	}	
}

自己的ContentProvider派生类如下：
public class MyContentProvider extends ContentProvider{

//.........其他的省略........
@Override
public Uri insert(Uri uri, ContentValues values) {
Log.i("Employeeprovider Info===================》》》》》","this is insert function");
// 获取数据库实例
SQLiteDatabase db = dbHelper.getWritableDatabase();
//dbHelper.onCreate(db); //创建表
// 插入数据，返回行ID
Long rowID = db.insert(DBHelper.EMPLOYEES_TABLE_NAME, Employee.NAME, values);
// 如果插入成功返回Uri
if (rowID > 0) {
Uri empUri = ContentUris
.withAppendedId(Employee.CONTENT_URI, rowID);
getContext().getContentResolver().notifyChange(empUri, null);
return empUri;
}
return null;
}

}

我在MainActivity中调用Insert方法时就报错，MainActivity中的onCreate方法中调用insert方法：

	public void insert() {
		//"content://com.hgl.test.employees/employee";
		Uri uri = Employee.CONTENT_URI;	
		// 实例化ContentValues
		ContentValues values = new ContentValues();
		values.put(Employee.NAME, "android");
		//values.put(Employee.GENDER, "software");
		//values.put(Employee.AGE, 3);
		// 获取ContentResolver，并执行插入
		getContentResolver().insert(uri, values);
	}

请问这是哪里的错误呢？

Android