andriod sqlite 数据库 增删改查 实例源码

【实例截图】

【核心代码】

package com.yangliansheng.news;

import java.util.ArrayList;

import android.os.Bundle;
import android.app.Activity;
import android.app.AlertDialog;
import android.content.DialogInterface;
import android.content.Intent;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.view.Menu;
import android.view.View;
import android.view.View.OnClickListener;
import android.widget.AdapterView;
import android.widget.AdapterView.OnItemClickListener;
import android.widget.ArrayAdapter;
import android.widget.Button;
import android.widget.ListView;
import android.widget.Toast;

public class MainActivity extends Activity {
    private ListView lv_title,lv_id;
    private Button bt_add;
    SqliteDatabaseCreate sd;
    SQLiteDatabase db;
    int id;
    Cursor cr;
    AlertDialog ad;
    @Override
    public void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);
        lv_title=(ListView) findViewById(R.id.lv_title);
        lv_id=(ListView) findViewById(R.id.lv_id);
        bt_add=(Button) findViewById(R.id.bt_add);
        dataInit();
        lv_title.setOnItemClickListener(new OnItemClickListener() {

			public void onItemClick(AdapterView<?> arg0, View arg1, int position,
					long uid) {
				// TODO Auto-generated method stub
				cr.moveToPosition(position);
				id=cr.getInt(cr.getColumnIndex(InformationTable.ID));
				
				alertDialogCreat();
	              ad.show();
			}
		});
        lv_id.setOnItemClickListener(new OnItemClickListener() {

			public void onItemClick(AdapterView<?> arg0, View arg1, int position,
					long uid) {
				// TODO Auto-generated method stub
				cr.moveToPosition(position);
				id=cr.getInt(cr.getColumnIndex(InformationTable.ID));
				
				alertDialogCreat();
	              ad.show();
			}
		});
        bt_add.setOnClickListener(new OnClickListener() {
			
			public void onClick(View arg0) {
				// TODO Auto-generated method stub
				Intent in=new Intent(MainActivity.this,AddActivity.class);
				startActivity(in);
			}
		});
    }

	private void alertDialogCreat() {
		ad=new AlertDialog.Builder(this).create();
        ad.setMessage("提示信息：");
		ad.setButton("查看", new DialogInterface.OnClickListener() {
			
			public void onClick(DialogInterface arg0, int arg1) {
				// TODO Auto-generated method stub
				Intent in=new Intent(MainActivity.this,SelectActivity.class);
				Bundle bd=new Bundle();
				bd.putInt("id", id);
				in.putExtras(bd);
				startActivity(in);
			}

			public void onClick(View arg0) {
				// TODO Auto-generated method stub
				
			}
		});
        ad.setButton2("修改", new DialogInterface.OnClickListener() {
			
			public void onClick(DialogInterface arg0, int arg1) {
				// TODO Auto-generated method stub
				Intent in=new Intent(MainActivity.this,UpdateActivity.class);
				Bundle bd=new Bundle();
				bd.putInt("id", id);
				in.putExtras(bd);
				startActivity(in);
			}

			public void onClick(View arg0) {
				// TODO Auto-generated method stub
				
			}
		});
       ad.setButton3("直接删除", new DialogInterface.OnClickListener() {
			
			public void onClick(DialogInterface arg0, int arg1) {
				// TODO Auto-generated method stub
				String condition=" " id "=" InformationTable.ID;
                db.delete(InformationTable.DataTable_Name, condition, null);
                Toast.makeText(MainActivity.this, "删除成功",Toast.LENGTH_SHORT).show();
                dataInit();
			}

			public void onClick(View arg0) {
				// TODO Auto-generated method stub
				
			}
		});
		
	}

	private void dataInit() {
		ArrayList<String> al_title=new ArrayList<String>();
		ArrayList<String> al_id=new ArrayList<String>();
        sd=new SqliteDatabaseCreate(MainActivity.this);
        db=sd.getReadableDatabase();
        String []col={InformationTable.ID,InformationTable.Title,InformationTable.Content};
        cr=db.query(InformationTable.DataTable_Name, col, null, null, null, null, null);
        startManagingCursor(cr);
        while(cr.moveToNext())
        {
        	String title=cr.getString(cr.getColumnIndex(InformationTable.Title));
        	String id=cr.getString(cr.getColumnIndex(InformationTable.ID));
        	al_title.add(title);
        	al_id.add(id);
        }
        ArrayAdapter<String> aa=new ArrayAdapter<String>(MainActivity.this, R.layout.tv_lv, R.id.tv_lv_title,al_title);
        lv_title.setAdapter(aa);
        ArrayAdapter<String> a=new ArrayAdapter<String>(MainActivity.this, R.layout.tv_lv, R.id.tv_lv_id,al_id);
        lv_id.setAdapter(a);
		
	}

    @Override
    public boolean onCreateOptionsMenu(Menu menu) {
        getMenuInflater().inflate(R.menu.activity_main, menu);
        return true;
    }
}