sql

package com.example.xiaomimall;

import java.util.ArrayList;
import java.util.HashMap;

import com.wuxifu.utils.Constant;
import com.wuxifu.utils.DowmImage;
import com.wuxifu.utils.MySqlite;

import android.os.Bundle;
import android.app.Activity;
import android.app.Dialog;
import android.content.ContentValues;
import android.content.Intent;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.graphics.Bitmap;
import android.view.ContextMenu;
import android.view.LayoutInflater;
import android.view.Menu;
import android.view.MenuItem;
import android.view.View;
import android.view.ContextMenu.ContextMenuInfo;
import android.view.View.OnClickListener;
import android.view.View.OnCreateContextMenuListener;
import android.view.ViewGroup;
import android.widget.AdapterView;
import android.widget.AdapterView.OnItemClickListener;
import android.widget.AdapterView.OnItemSelectedListener;
import android.widget.ArrayAdapter;
import android.widget.BaseAdapter;
import android.widget.Button;
import android.widget.ImageView;
import android.widget.ListView;
import android.widget.RelativeLayout;
import android.widget.SimpleCursorAdapter;
import android.widget.Spinner;
import android.widget.TextView;
import android.widget.Toast;

public class ShoppingCart extends Activity
{

    private static final int THREE = 3;
    private static final int TWO = 2;
    private static final int ONE = 1;
    private MySqlite mySqlite;
    private SQLiteDatabase db;
    private Cursor cursor;
    ArrayList<String>  urls=new ArrayList<String>();
    private HashMap<Integer, Bitmap> hs=new HashMap<Integer, Bitmap>();
    private SimpleCursorAdapter simpleCursorAdapter;
    private CharSequence product_name;

    @Override
    protected void onCreate(Bundle savedInstanceState)
    {
        super.onCreate(savedInstanceState);
       // setContentView(R.layout.activity_shopping_cart);
        mySqlite = new MySqlite(this, Constant.DB_NAME, null, 1);
        db = mySqlite.getWritableDatabase();
       cursor = db.query(Constant.TABLE_NAME, null, null, null, null, null, null);
        boolean succ = cursor.moveToFirst();
       
        if(!succ)
        {
            toFailedView();
        }
        else
        {
        toSucceedView();
        }
    }

    private void toSucceedView()
    {
        setContentView(R.layout.activity_shopping_cart2);
        ListView listView1 = (ListView) findViewById(R.id.listView1);
        simpleCursorAdapter = new SimpleCursorAdapter(this,R.layout.item_shoppingcart, cursor,new String[]{ "bigTitle","price","number"},new int[]{R.id.tv_bigTitle,R.id.tv_price,R.id.tv_num});
        listView1.setAdapter(simpleCursorAdapter);

//长按listview的某一个item就会出现上下文菜单，this就是当前activity监听了该事件，

//由activity显示上下文菜单(1)
        listView1.setOnCreateContextMenuListener(this);

    }

    private void toFailedView()
    {
        setContentView(R.layout.activity_shopping_cart);
        Button tomain = (Button) findViewById(R.id.button1);
        tomain.setOnClickListener(new OnClickListener()
        {
           
            @Override
            public void onClick(View v)
            {
                      startActivity(new Intent(ShoppingCart.this, MainMall.class));    
            }
        });
    }

    @Override
    public boolean onCreateOptionsMenu(Menu menu)
    {
        // Inflate the menu; this adds items to the action bar if it is present.
        getMenuInflater().inflate(R.menu.activity_shopping_cart, menu);
        return true;
    }

//建一个上下文菜单（2）
    @Override
    public void onCreateContextMenu(ContextMenu menu, View v,
            ContextMenuInfo menuInfo)
    {
        super.onCreateContextMenu(menu, v, menuInfo);
        menu.add(0, 1, ONE, "增加");
        menu.add(0, 2, TWO, "删除");
        menu.add(0, 3, THREE, "修改");
        //menu.add(0, 4, 4, "");
        Toast.makeText(this, v.getClass()+"", Toast.LENGTH_SHORT).show();
    }
    @Override
    public boolean onContextItemSelected(MenuItem item)
    {

//获取长按了listview的某一item的信息 menuInfo 
        AdapterView.AdapterContextMenuInfo menuInfo = (AdapterView.AdapterContextMenuInfo)item.getMenuInfo();

//获取item的.position
       int position= menuInfo.position;

//获取item某一子view的内容menuInfo.targetView.findViewById(R.id.tv_bigTitle);
       TextView text = (TextView)menuInfo.targetView.findViewById(R.id.tv_bigTitle);
       product_name = text.getText();
    Toast.makeText(this, position+" "+product_name, Toast.LENGTH_SHORT).show();
       switch (item.getOrder())
    {
    case ONE:
        add(product_name);
        break;
    case TWO:
        delete(product_name);
        break;
    case THREE:
        update(product_name);
        break;

    default:
        break;
    }
        return super.onContextItemSelected(item);
    }

    private void add(CharSequence product_name)
    {
      showDialog(0, null); 
    }

    private void delete(CharSequence product_name)
    {
      db.delete(Constant.TABLE_NAME, "bigTitle=?", new String[]{product_name+""});
      //重新查数据库，更新listview
      simpleCursorAdapter.changeCursor(getCursor());
      simpleCursorAdapter.notifyDataSetChanged();
    }

    private void update(CharSequence product_name)
    {
        showDialog(0, null);        
    }
    private Cursor getCursor()
    {
        Cursor cursor=db.query(Constant.TABLE_NAME, null, null, null, null, null, null);
        boolean moveToFirst = cursor.moveToFirst();
        return cursor;
    }
    @Override
    protected void onStop()
    {
        //该activity退出后关闭数据库
        db.close();
        super.onStop();
    }
    @Override
    protected Dialog onCreateDialog(int id, Bundle args)
    {
        Dialog dialog = new Dialog(this);
       
        View view=getLayoutInflater().inflate(R.layout.dialog, null);
        Spinner spinner =(Spinner) view.findViewById(R.id.spinner1);
        Button confirm =(Button) view.findViewById(R.id.button1);
        iniSpinner(spinner);
        iniButton( confirm,id);
        dialog.setContentView(view);
        dialog.setTitle("输入你想购买的数量:");
        return dialog;
    }
    private void iniButton(Button confirm, int id)
    {
      confirm.setOnClickListener(new OnClickListener()
    {
       
        @Override
        public void onClick(View v)
        {
         ContentValues values=new ContentValues();
         values.put("number",number );
        db.update(Constant.TABLE_NAME, values, "bigTitle=?", new String[]{product_name+""});
        simpleCursorAdapter.changeCursor(getCursor());
        simpleCursorAdapter.notifyDataSetChanged();
        dismissDialog(0);
        }
    });       
    }
    int number=1;
    private void iniSpinner(Spinner spinner)
    {
            ArrayAdapter<CharSequence> adapter = ArrayAdapter.createFromResource(
                    this, R.array.number, android.R.layout.simple_spinner_item);
            adapter.setDropDownViewResource(android.R.layout.simple_spinner_dropdown_item);
            spinner.setAdapter(adapter);
            spinner.setOnItemSelectedListener(
                    new OnItemSelectedListener() {
                      

                        public void onItemSelected(
                                AdapterView<?> parent, View view, int position, long id) {
                            String[] num = getResources().getStringArray(R.array.number);
                            number=Integer.valueOf(num[position]);
                            showToast("购买 数量"+number);
                        }

                        private void showToast(String string)
                        {
                         Toast.makeText(ShoppingCart.this, string,Toast.LENGTH_LONG).show();                           
                        }

                        public void onNothingSelected(AdapterView<?> parent) {
                            showToast("Spinner1: unselected");
                        }
                    });

           
    }

}

////////////////////////////////////////////////////

package com.wuxifu.utils;

import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteDatabase.CursorFactory;
import android.database.sqlite.SQLiteOpenHelper;

public class MySqlite extends SQLiteOpenHelper
{

    public MySqlite(Context context, String name, CursorFactory factory,
            int version)
    {
        super(context, name, factory, version);
    }

    @Override
    public void onCreate(SQLiteDatabase db)
    {
      String sql="CREATE TABLE IF NOT EXISTS  " +Constant.TABLE_NAME+" (_id INTEGER PRIMARY KEY AUTOINCREMENT " +
        "                        ,url VATCHAR(50),bigTitle VATCHAR(20)" +
        "                        ,subTitle VATCHAR(20),price VATCHAR(20),number INTEGER NOT NULL DEFAULT 1)";
    db.execSQL(sql);
    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion)
    {
        String sql="CREATE TABLE IF NOT EXISTS  " +Constant.TABLE_NAME+" (_id INTEGER PRIMARY KEY AUTOINCREMENT " +
                "                        ,url VATCHAR(50),bigTitle VATCHAR(20)" +
                "                        ,subTitle VATCHAR(20),price VATCHAR(20),number INTEGER NOT NULL DEFAULT 1)";
        db.execSQL(sql);

    }

}