实现收藏夹

话不到说,先上代码
布局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();
            }   
       });
      }
}

项目文件目录
这里写图片描述
效果图
这里写图片描述
这里写图片描述
这里写图片描述

评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值