【安卓作业】Android Studio记事本2
一、界面展示
二、功能介绍
添加备忘,修改备忘,删除备忘
三、项目结构
四、关键代码展示
(1)MainActivity
public class MainActivity extends Activity implements View.OnClickListener {
private ListView lv;
private SQLiteDatabase dbReader;
private Cursor cursor;
private NotesDB notesDB;
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
initView();
}
private void initView() {
Button addbtn = (Button) findViewById(R.id.main_add);
lv = (ListView) findViewById(R.id.main_list);
addbtn.setOnClickListener(this);
notesDB = new NotesDB(this);
dbReader = notesDB.getReadableDatabase();
lv.setOnItemClickListener(new AdapterView.OnItemClickListener() {
@Override
public void onItemClick(AdapterView<?> parent, View view, int position, long id) {
cursor.moveToPosition(position);
Intent i = new Intent(MainActivity.this, SelectAct.class);
i.putExtra(NotesDB.ID, cursor.getInt(cursor.getColumnIndex(NotesDB.ID)));
i.putExtra(notesDB.CONTENT, cursor.getString(cursor.getColumnIndex(NotesDB.CONTENT)));
i.putExtra(notesDB.TIME, cursor.getString(cursor.getColumnIndex(NotesDB.TIME)));
startActivity(i);
}
});
}
@Override
public void onClick(View v) {
Intent i = new Intent(this, Addcontent.class);
startActivity(i);
}
private void selectDB() {
cursor = dbReader.query(NotesDB.TABLE_NAME, null, null, null, null, null, null);
MyAdapter adapter = new MyAdapter(this, cursor);
lv.setAdapter(adapter);
}
@Override
protected void onResume() {
super.onResume();
selectDB();
}
}
(2)MyAdapter
public class MyAdapter extends BaseAdapter {
private Context context;
private Cursor cursor;
public MyAdapter(MainActivity context, Cursor cursor){
this.context = context;
this.cursor = cursor;
}
@Override
public int getCount() {
return cursor.getCount();
}
@Override
public Object getItem(int position) {
return cursor.getPosition();
}
@Override
public long getItemId(int position) {
return position;
}
@Override
public View getView(int position, View convertView, ViewGroup parent) {
LayoutInflater inflater = LayoutInflater.from(context);
LinearLayout layout = (LinearLayout) inflater.inflate(R.layout.list, null);
TextView contenttv = (TextView) layout.findViewById(R.id.list_content);
TextView timetv = (TextView) layout.findViewById(R.id.list_time);
cursor.moveToPosition(position);
String content = cursor.getString(cursor.getColumnIndex("content"));
String time = cursor.getString(cursor.getColumnIndex("time"));
contenttv.setText(content);
timetv.setText(time);
return layout;
}
}
(3)NotesDB
public class NotesDB extends SQLiteOpenHelper {
public static final String TABLE_NAME = "notes";
public static final String CONTENT = "content";
public static final String ID = "_id";
public static final String TIME = "time";
public NotesDB(Context context) {
super(context, "notes", null, 1);
}
@Override
public void onCreate(SQLiteDatabase db) {
db.execSQL("create table " + TABLE_NAME + " (" + ID + " integer primary key autoincrement,"
+ CONTENT + " text not null," + TIME + " text not null)");
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
}
}