mainactivity代码如下：
package com.example.notes;
import android.app.ListActivity;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.view.Menu;
import android.view.MenuItem;
import android.widget.SimpleCursorAdapter;
import com.example.notes.db.NotesDB;
public class MainActivity extends ListActivity {
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
db=new NotesDB(this);
dbRead=db.getReadableDatabase();
adapter=new SimpleCursorAdapter(this,R.layout.notes_list_cell, null, new String[]{NotesDB.COLUMN_NAME_NOTE_NAME,NotesDB.COLUMN_NAME_NOTE_DATE},new int[]{R.id.tvName,R.id.tvDate});
setListAdapter(adapter);
refreshNotesListView();
}
public void refreshNotesListView(){
adapter.changeCursor(dbRead.query(NotesDB.TABLE_NAME_NOTES, null, null,null,null,null,null));
}
@Override
public boolean onCreateOptionsMenu(Menu menu) {
// Inflate the menu; this adds items to the action bar if it is present.
getMenuInflater().inflate(R.menu.main, menu);
return true;
}
private SimpleCursorAdapter adapter=null;
private NotesDB db;
private SQLiteDatabase dbRead;
@Override
public boolean onOptionsItemSelected(MenuItem item) {
// Handle action bar item clicks here. The action bar will
// automatically handle clicks on the Home/Up button, so long
// as you specify a parent activity in AndroidManifest.xml.
int id = item.getItemId();
if (id == R.id.action_settings) {
return true;
}
return super.onOptionsItemSelected(item);
}
}

NotesDB代码：
package com.example.notes.db;
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
public class NotesDB extends SQLiteOpenHelper {
public NotesDB(Context context) {
super(context,"notes",null, 1);
// TODO Auto-generated constructor stub
}
@Override
public void onCreate(SQLiteDatabase db) {
db.execSQL("CREATE TABLE"+TABLE_NAME_NOTES+"(" +
COLUMN_NAME_ID+"INTEGER PRIMARY KEY AUTOINCREAMENT," +
COLUMN_NAME_NOTE_NAME+"TEXT NOT NULL DEFAULT \"\"," +
COLUMN_NAME_NOTE_CONTENT+"TEXT NOT NULL DEFAULT \"\"," +
COLUMN_NAME_NOTE_DATE+"TEXT NOT NULL DEFAULT \"\"" +
")");
db.execSQL("CREATE TABLE"+TABLE_NAME_MEDIA+"(" +
COLUMN_NAME_ID+"INTEGER PRIMARY KEY AUTOINCREAMENT," +
COLUMN_NAME_MEDIA_PATH+"TEXT NOT NULL DEFAULT \"\"," +
COLUMN_NAME_MEDIA_OWNER_NOTE_ID+"INTEGER NOT NULL DEFAULT 0" +
")");
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
// TODO Auto-generated method stub
}
public static final String TABLE_NAME_NOTES="notes";
public static final String TABLE_NAME_MEDIA="media";
public static final String COLUMN_NAME_ID="_id";
public static final String COLUMN_NAME_NOTE_NAME="name";
public static final String COLUMN_NAME_NOTE_CONTENT="content";
public static final String COLUMN_NAME_NOTE_DATE="date";
public static final String COLUMN_NAME_MEDIA_PATH="path";
public static final String COLUMN_NAME_MEDIA_OWNER_NOTE_ID="note_id";
}

少了些什么？还是哪里错了？

求教大神

laishen