实现收藏夹

话不到说，先上代码
布局activity_main.xml文件

<?xml version="1.0" encoding="utf-8"?><LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"      android:layout_width="fill_parent"    android:layout_height="fill_parent"    android:orientation="vertical"    android:background="#f8f8f8" >       <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"/></LinearLayout>

DBHelper.java

package com.collect.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;import com.collect.tools.DBHelper;import com.example.point.R;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();            }          });      }}

MainActivity.java

package com.collect.activity;import android.app.Activity;import android.content.ContentValues;import android.content.Intent;import android.database.sqlite.SQLiteDatabase;import android.os.Bundle;import android.view.View;import android.view.View.OnClickListener;import android.widget.Button;import android.widget.EditText;import com.collect.tools.DBHelper;import com.example.point.R;public class MainActivity extends Activity {     private EditText et1,et2,et3;     private Button b1;    @Override    protected void onCreate(Bundle savedInstanceState) {        super.onCreate(savedInstanceState);        setContentView(R.layout.activity_main);        this.setTitle("添加收藏信息");        DBHelper helper = new DBHelper(getApplicationContext());        SQLiteDatabase db=helper.getWritableDatabase();        db.close();        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(MainActivity.this, QueryActivity.class);                startActivity(intent);          }});      }}

QueryActivity.java

package com.collect.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;import com.collect.tools.DBHelper;import com.example.point.R;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();            }          });      }}

项目文件目录

效果图