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);
}
}