///接口
public interface DBinfos {
public static final String DB_NAME = "hcs.db"; public static final int DB_VERSION = 1;
public static final String TABLE_NAME= "note1";
public static final String TABLE_FIELD_TIME= "_id";
public static final String TABLE_FIELD_CONTENT= "content";
}
/////DBHelp
public class DBHelper extends SQLiteOpenHelper {
private static final String TAG = "DBHelper";
public DBHelper(Context context) {
super(context, DBinfos.DB_NAME, null,
DBinfos.DB_VERSION);
} @Override
public void onCreate(SQLiteDatabase db) {
try {
StringBuffer sql = new StringBuffer();
sql.append("CREATE TABLE ");
sql.append(DBinfos.TABLE_NAME);
sql.append(" (");
sql.append(DBinfos.TABLE_FIELD_TIME);
sql.append(" NUMERIC(13) PRIMARY KEY ,");
sql.append(DBinfos.TABLE_FIELD_CONTENT);
sql.append(" Text");
sql.append(");");
Log.i(TAG, sql.toString());
db.execSQL(sql.toString());
}
catch (Exception e) {
Log.e(TAG, e.getMessage()); }
} @Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
db.execSQL("DROP TABLE IF EXISTS " + DBinfos.TABLE_NAME);
onCreate(db);
}
}
public interface DBinfos {
public static final String DB_NAME = "hcs.db"; public static final int DB_VERSION = 1;
public static final String TABLE_NAME= "note1";
public static final String TABLE_FIELD_TIME= "_id";
public static final String TABLE_FIELD_CONTENT= "content";
}
/////DBHelp
public class DBHelper extends SQLiteOpenHelper {
private static final String TAG = "DBHelper";
public DBHelper(Context context) {
super(context, DBinfos.DB_NAME, null,
DBinfos.DB_VERSION);
} @Override
public void onCreate(SQLiteDatabase db) {
try {
StringBuffer sql = new StringBuffer();
sql.append("CREATE TABLE ");
sql.append(DBinfos.TABLE_NAME);
sql.append(" (");
sql.append(DBinfos.TABLE_FIELD_TIME);
sql.append(" NUMERIC(13) PRIMARY KEY ,");
sql.append(DBinfos.TABLE_FIELD_CONTENT);
sql.append(" Text");
sql.append(");");
Log.i(TAG, sql.toString());
db.execSQL(sql.toString());
}
catch (Exception e) {
Log.e(TAG, e.getMessage()); }
} @Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
db.execSQL("DROP TABLE IF EXISTS " + DBinfos.TABLE_NAME);
onCreate(db);
}
}
05-18 08:26:13.740: E/AndroidRuntime(13353): java.lang.RuntimeException: Unable to start activity ComponentInfo{com.hcs/com.hcs.more.NoteList}: android.database.sqlite.SQLiteException: no such table: note1: , while compiling: SELECT _id, content FROM note1 ORDER BY _id asc