Android开发案例：SQLite数据库和ListView列表结合

        SQLite是Android系统内置的轻量级的关系型数据库，运行速度非常快；ListView是Android中最常用的的控件之一，几乎所有的应用程序都会用到它。本文通过一个实例介绍如何通过ListView列表展示数据以及实现SQLite数据库的增删改查，并且用到了登录、动画等功能。

首先，新建Android应用程序FileDemo2。代码如下：

        1、src文件夹内，com.demo.adapter包内FileNameAdapter.java文件： 

public class FileNameAdapter extends ArrayAdapter<FileName> {
	private int resourceId;
	public FileNameAdapter(Context context, int resource, List<FileName> objects) {
		super(context, resource, objects);
		resourceId=resource;
	}
	@Override
	public View getView(int position, View convertView, ViewGroup parent) {
		FileName fileName=getItem(position);
		View view;
		ViewHolder viewHolder;
		if (convertView==null) {
			view=LayoutInflater.from(getContext()).inflate(resourceId, null);
			viewHolder=new ViewHolder();
			viewHolder.fileName=(TextView)view.findViewById(R.id.file_name);
			viewHolder.fileAuthor=(TextView)view.findViewById(R.id.file_author);
			viewHolder.id=0;
			view.setTag(viewHolder);
		} else {
			view=convertView;
			viewHolder=(ViewHolder)view.getTag();
		}
		viewHolder.fileName.setText(fileName.getName());
		viewHolder.fileAuthor.setText(fileName.getAuthor());
		viewHolder.id=fileName.getId();
		return view;
	}
	class ViewHolder{
		TextView fileName;
		TextView fileAuthor;
		int id;
	}
}

        2、src文件夹内，com.demo. beans包内FileName.java文件： 

public class FileName {
	private int id;
	private String name;
	private String author;
	public FileName(int id,String name, String author) {
		this.id=id;
		this.name = name;
		this.author = author;
	}	
	public int getId() {
		return id;
	}
	public String getName() {
		return name;
	}
	public String getAuthor() {
		return author;
	}
	public void setName(String name) {
		this.name = name;
	}
	public void setAuthor(String author) {
		this.author = author;
	}	
}

        3、src文件夹内，com.demo.data包内MyDatabaseHelper.java文件（创建数据库）： 

public class MyDatabaseHelper extends SQLiteOpenHelper {	
	public static final String CREATE_MENUNAME="create table MenuName ("
			+"id integer primary key autoincrement, "
			+"menuname text, "
			+"isChosen boolean)";
	public static final String CREATE_FILE="create table FileInfo("
			+"id integer primary key autoincrement, "
			+"title text, "
			+"subtitle text, "
			+"author text, "
			+"partone text, "
			+"parttwo text, "
			+"partthree text, "
			+"partfour text)";	
	private Context mContext;
	public MyDatabaseHelper(Context context, String name,
			CursorFactory factory, int version) {
		super(context, name, factory, version);
		mContext=context;
	}

	@Override
	public void onCreate(SQLiteDatabase db) {
		db.execSQL(CREATE_MENUNAME);
		db.execSQL("insert into MenuName (menuname,isChosen) values (?,?)",new String[]{"标题","1"});
		db.execSQL("insert into MenuName (menuname,isChosen) values (?,?)",new String[]{"副标题","1"});
		db.execSQL("insert into MenuName (menuname,isChosen) values (?,?)",new String[]{"作者","1"});
		db.execSQL("insert into MenuName (menuname,isChosen) values (?,?)",new String[]{"版块一","1"});
		db.execSQL("insert into MenuName (menuname,isChosen) values (?,?)",new String[]{"版块二","1"});
		db.execSQL("insert into MenuName (menuname,isChosen) values (?,?)",new String[]{"版块三","1"});
		db.execSQL("insert into MenuName (menuname,isChosen) values (?,?)",new String[]{"版块四","1"});
		db.execSQL(CREATE_FILE);		
	}

	@Override
	public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
		// TODO Auto-generated method stub		
	}
}

        4、src文件夹内，com.demo.filedemo2包内ActivityCollector.java文件： 

public class ActivityCollector {
	public static List<Activity> activities = new ArrayList<Activity>();
	//添加activity
	public static void addActivity(Activity activity){
		activities.add(activity);
	}
	//移除activity
	public static void removeActivity(Activity activity){
		activities.remove(activity);
	}
	//退出
	public static void finishAll(){
		for(Activity activity:activities){
			if (!activity.isFinishing()) {
				activity.finish();
			}
		}
	}
}

        5、src文件夹内，com.demo.filedemo2包内BaseActivity.java文件：

public class BaseActivity extends Activity {
	@Override
	protected void onCreate(Bundle savedInstanceState) {		
		super.onCreate(savedInstanceState);
		ActivityCollector.addActivity(this);		
	}
	@Override
	protected void onDestroy() {
		super.onDestroy();
		ActivityCollector.removeActivity(this);
	}
	@Override
	public boolean onCreateOptionsMenu(Menu menu) {		
		getMenuInflater().inflate(R.menu.main, menu);
		return true;
	}
	@Override
	public boolean onOptionsItemSelected(MenuItem item) {
		switch (item.getItemId()) {
		case R.id.item_show:
			Intent intent=new Intent(BaseActivity.this, ShowFileNameActivity.class);
			startActivity(intent);
			break;
		case R.id.exit:
			ActivityCollector.finishAll();
			break;
		default:
			break;
		}
		return true;
	}
}

        6、src文件夹内，com.demo.filedemo2包内FileItemActivity.java文件： 

public class FileItemActivity extends BaseActivity {
	
	private EditText titleText;
	private EditText subtitleText;
	private EditText authorText;
	private EditText partoneText;
	private EditText parttwoText;
	private EditText partthreeText;
	private EditText partfourText;
	private Button updateBtn;
	private MyDatabaseHelper dbHelper;
	
	public static void actionStart(Context context,String fileid){
		Intent intent =new Intent(context,FileItemActivity.class);
		intent.putExtra("id", fileid);
		context.startActivity(intent);
	}

	@Override
	protected void onCreate(Bundle savedInstanceState) {
		super.onCreate(savedInstanceState);
		setContentView(R.layout.activity_fileitem);
		final String fileid=getIntent().getStringExtra("id");
		titleText=(EditText)findViewById(R.id.title);
		subtitleText=(EditText)findViewById(R.id.subtitle);
		authorText=(EditText)findViewById(R.id.author);
		partoneText=(EditText)findViewById(R.id.partone);
		parttwoText=(EditText)findViewById(R.id.parttwo);
		partthreeText=(EditText)findViewById(R.id.partthree);
		partfourText=(EditText)findViewById(R.id.partfour);
		
		updateBtn=(Button)findViewById(R.id.update);
		
		dbHelper = new MyDatabaseHelper(this, "FileDemo.db", null, 1);
		final SQLiteDatabase db = dbHelper.getWritableDatabase();
		
		Cursor cursor=db.rawQuery("select * from FileInfo where id=?", new String[]{fileid});
		if (cursor.moveToFirst()) {			
				String title=cursor.getString(cursor.getColumnIndex("title"));
				String subtitle=cursor.getString(cursor.getColumnIndex("subtitle"));
				String author=cursor.getString(cursor.getColumnIndex("author"));
				String partone=cursor.getString(cursor.getColumnIndex("partone"));
				String parttwo=cursor.getString(cursor.getColumnIndex("parttwo"));
				String partthree=cursor.getString(cursor.getColumnIndex("partthree"));
				String partfour=cursor.getString(cursor.getColumnIndex("partfour"));

				titleText.setText(title);
				subtitleText.setText(subtitle);
				authorText.setText(author);
				partoneText.setText(partone);
				parttwoText.setText(parttwo);
				partthreeText.setText(partthree);
				partfourText.setText(partfour);
		}
		cursor.close();
		updateBtn.setOnClickListener(new OnClickListener() {			
			@Override
			public void onClick(View v) {
				String utitle=titleText.getText().toString();
				String usubtitle=subtitleText.getText().toString();
				String uauthor=authorText.getText().toString();
				String upartone=partoneText.getText().toString();
				String uparttwo=parttwoText.getText().toString();
				String upartthree=partthreeText.getText().toString();
				String upartfour=partfourText.getText().toString();
				db.execSQL("update FileInfo set title=? , subtitle =? , author=? , partone=? , parttwo=? , partthree=? , partfour =? where id=?",
						new String[]{utitle,usubtitle,uauthor,upartone,uparttwo,upartthree,upartfour,fileid});
				Toast.makeText(FileItemActivity.this, "更新成功", Toast.LENGTH_SHORT).show();
				Intent intent=new Intent(FileItemActivity.this,ShowFileNameActivity.class);
				startActivity(intent);
				finish();
			}
		});
	}

	@Override
	public void onBackPressed() {
		Intent intent=new Intent(FileItemActivity.this,ShowFileNameActivity.class);
		startActivity(intent);
		finish();
	}
	
}

        7、src文件夹内，com.demo.filedemo2包内LoginActivity.java文件：

public class LoginActivity extends BaseActivity {
	private SharedPreferences pref;
	private SharedPreferences.Editor editor;
	private EditText accountEdit;
	private EditText passwordEdit;
	private Button login;
	private CheckBox rememberPass;
	
	@Override
	protected void onCreate(Bundle savedInstanceState) {		
		super.onCreate(savedInstanceState);
		setContentView(R.layout.activity_login);
		pref=PreferenceManager.getDefaultSharedPreferences(this);
		accountEdit=(EditText)findViewById(R.id.account);
		passwordEdit=(EditText)findViewById(R.id.password);
		rememberPass=(CheckBox)findViewById(R.id.remember_pass);
		login=(Button)findViewById(R.id.login);
		boolean isRemember=pref.getBoolean("remember_password", false);
		if (isRemember) {
			//将账户和密码都设置到文本框中
			String account=pref.getString("account", "");
			String password=pref.getString("password", "");
			accountEdit.set