安卓收藏夹，增删查功能实现

main.xml

<?xml version="1.0" encoding="utf-8"?>
<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
    android:orientation="vertical"
    android:layout_width="fill_parent"
    android:layout_height="fill_parent"
    >
 <TextView
    android:text="网站名称"
    android:id="@+id/TextView01"
    android:layout_width="wrap_content"
    android:layout_height="wrap_content"></TextView>
    <EditText
    android:text=""
    android:id="@+id/EditTextName"
    android:layout_width="fill_parent"
    android:layout_height="wrap_content"></EditText>
    <TextView
    android:text="URL"
    android:id="@+id/TextView02"
    android:layout_width="wrap_content"
    android:layout_height="wrap_content"></TextView>
    <EditText
    android:text=""
    android:id="@+id/EditTextURL"
    android:layout_width="fill_parent"
    android:layout_height="wrap_content"></EditText>
    <TextView
    android:text="网站描述"
    android:id="@+id/TextView03"
    android:layout_width="wrap_content"
    android:layout_height="wrap_content"></TextView>
    <EditText
    android:text=""
    android:id="@+id/EditTextDesc"
    android:layout_width="fill_parent"
    android:layout_height="wrap_content"
    android:height="100px"></EditText>
    <Button
    android:text="添加"
    android:id="@+id/ButtonAdd"
    android:layout_width="wrap_content"
    android:layout_height="wrap_content"></Button>
   
</LinearLayout>
row.xml

<?xml version="1.0" encoding="UTF-8"?>
<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
    android:orientation="vertical"
    android:layout_width="fill_parent"
    android:layout_height="fill_parent"
    >
    <TextView
    android:id="@+id/text0"
    android:layout_width="wrap_content"
    android:layout_height="wrap_content"
    android:paddingRight="10px"></TextView>
     <TextView
    android:id="@+id/text1"
    android:layout_width="wrap_content"
    android:layout_height="wrap_content"
    android:paddingRight="10px"></TextView>
     <TextView
    android:id="@+id/text2"
    android:layout_width="wrap_content"
    android:layout_height="wrap_content"
    android:paddingRight="10px"></TextView>
     <TextView
    android:id="@+id/text3"
    android:layout_width="wrap_content"
    android:layout_height="wrap_content"
    android:paddingRight="10px"></TextView>
    </LinearLayout>

工具类

import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;

public class DBHelper extends SQLiteOpenHelper {
 private static final String DB_NAME = "coll.db";
 private static final String TBL_NAME = "CollTbl";
 //创建表sql语句
 private static final String CREATE_TBL = "create table"
  +
  " CollTbl(_id integer primary key autoincrement,name text,url text,desc text)";
 private SQLiteDatabase db;
 DBHelper(Context c) {
  super(c,DB_NAME,null,2);
 }
 @Override
 public void onCreate(SQLiteDatabase db) {
  this.db = db;
  db.execSQL(CREATE_TBL);
  
 }
 public void insert(ContentValues values) {
  SQLiteDatabase db = getWritableDatabase();
  db.insert(TBL_NAME, null, values);
  db.close();
 }
 public Cursor query() {
  SQLiteDatabase db = getWritableDatabase();
  Cursor c = db.query(TBL_NAME, null, null, null, null, null, null);
  return c;
  
 }
 @Override
 public void onUpgrade(SQLiteDatabase arg0, int arg1, int arg2) {
  // TODO Auto-generated method stub
  
 }
 public void del(int id) {
  if(db == null) {
   db = getWritableDatabase();
   db.delete(TBL_NAME, " _id=?", new String[]{String.valueOf(id)});
  }
 }
 public void close() {
  if(db != null) {
   db.close();
  }
 }

}

主activity

import android.app.Activity;
import android.content.ContentValues;
import android.content.Intent;
import android.os.Bundle;
import android.view.View;
import android.view.View.OnClickListener;
import android.widget.Button;
import android.widget.EditText;

public class atcitydfjkd extends Activity {
 private EditText et1,et2,et3;
 private Button b1;
    /** Called when the activity is first created. */
    @Override
    public void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.main);
        this.setTitle("添加收藏信息");
        et1 = (EditText)findViewById(R.id.EditTextName);
        et2 = (EditText)findViewById(R.id.EditTextURL);
        et3 = (EditText)findViewById(R.id.EditTextDesc);
        b1 = (Button)findViewById(R.id.ButtonAdd);
        b1.setOnClickListener(new OnClickListener() {
   
   @Override
   public void onClick(View arg0) {
    // TODO Auto-generated method stub
    String name = et1.getText().toString();
    String url = et2.getText().toString();
    String desc = et3.getText().toString();
    ContentValues values = new ContentValues();
    values.put("name", name);
    values.put("url", url);
    values.put("desc", desc);
    DBHelper helper = new DBHelper(getApplicationContext());
    helper.insert(values);
    Intent intent = new Intent(atcitydfjkd.this, QueryActivity.class);
    startActivity(intent);
   }
  });
    }
}

查询activity

import android.app.AlertDialog;
import android.app.ListActivity;
import android.content.DialogInterface;
import android.database.Cursor;
import android.os.Bundle;
import android.view.View;
import android.widget.AdapterView;
import android.widget.AdapterView.OnItemClickListener;
import android.widget.ListView;
import android.widget.SimpleCursorAdapter;

public class QueryActivity extends ListActivity {
  @Override
  protected void onCreate(Bundle savedInstanceState) {
   // TODO Auto-generated method stub
   super.onCreate(savedInstanceState);
   this.setTitle("浏览收藏信息");
   final DBHelper helpter = new DBHelper(this);
   Cursor c= helpter.query();
   String[] from = {"_id","name","url","desc"};
   int[] to = {R.id.text0,R.id.text1,R.id.text2,R.id.text3};
   SimpleCursorAdapter adapter =
    new SimpleCursorAdapter(this, R.layout.row, c, from, to);
   ListView listView = getListView();
   listView.setAdapter(adapter);
   final AlertDialog.Builder builder = new AlertDialog.Builder(this);
   listView.setOnItemClickListener(new OnItemClickListener() {

    @Override
    public void onItemClick(AdapterView<?> arg0, View arg1,
      int arg2, long arg3) {
     // TODO Auto-generated method stub
     final long temp = arg3;
     builder.setMessage("真的要删除吗").
     setPositiveButton("是", new DialogInterface.OnClickListener() {
      
      @Override
      public void onClick(DialogInterface dialog, int which) {
       // TODO Auto-generated method stub
       helpter.del((int)temp);
       /*Cursor c = helpter.query();--y有错误
       String[] from = {"_id","naem","url","desc"};
       int[] to ={R.id.text0,R.id.text1,R.id.text2,R.id.text3};*/
       Cursor c= helpter.query();
       String[] from = {"_id","name","url","desc"};
       int[] to = {R.id.text0,R.id.text1,R.id.text2,R.id.text3};
       SimpleCursorAdapter adapter =
        new SimpleCursorAdapter(getApplicationContext(), R.layout.row, c, from, to);
       ListView listView = getListView();
       listView.setAdapter(adapter);
      }
     }).setNegativeButton("否", new DialogInterface.OnClickListener() {
      
      @Override
      public void onClick(DialogInterface dialog, int which) {
       // TODO Auto-generated method stub
       
      }
     });
     AlertDialog ad  = builder.create();
     ad.show();
    }
   });
  }
}