android:
id="+id/id_ib_delete"
android:
layout_width="0dp"
android:
layout_height="wrap_content"
android:
layout_weight="1"
android:
src="drawable/ic_menu_delete"
android:
background="#ffffffff"
android:
onClick="deleteItem"/>
3.创建数据库
package.LIQI.Stuff;
importandroid.content.Context;
importandroid.database.sqlite.SQLiteDatabase;
importandroid.database.sqlite.SQLiteDatabase.CursorFactory;
importandroid.database.sqlite.SQLiteOpenHelper;
publicclassMySQLiteOpenHelperextendsSQLiteOpenHelper{
publicMySQLiteOpenHelper（Contextcontext
）{
super（context,"LIQI.db",null,1）;
//TODOAuto-generatedconstructorstub
}
Override
publicvoidonCreate（SQLiteDatabasedb）{
db.execSQL（"createtableLIQI（_idintegerprimarykeyautoincrement,stuff,amount,price）"）;
}
Override
publicvoidonUpgrade（SQLiteDatabasedb,intoldVersion,intnewVersion）{
//TODOAuto-generatedmethodstub
}
}
4.创建account类
package.LIQI.Stuff;
publicclassStuff{
privateStringstuffName;
privateintStuffAmount;
privatefloatStuffPrice;
publicStringgetStuffName（）{
returnstuffName;
}
publicvoidsetStuffName（StringstuffName）{
this.stuffName=stuffName;
}
publicintgetStuffAmount（）{
returnStuffAmount;
}
publicvoidsetStuffAmount（intstuffAmount）{
StuffAmount=stuffAmount;
}
publicfloatgetStuffPrice（）{
returnStuffPrice;
}
publicvoidsetStuffPrice（floatstuffPrice）{
StuffPrice=stuffPrice;
}
}
5.创建数据操作逻辑
package.LIQI.Stuff;
importjava.util.ArrayList;
importjava.util.List;
importandroid.app.Activity;
importandroid.database.Cursor;
importandroid.database.sqlite.SQLiteDatabase;
importandroid.os.Bundle;
importandroid.view.View;
importandroid.view.View.OnClickListener;
importandroid.view.ViewGroup;
importandroid.widget.BaseAdapter;
importandroid.widget.ImageButton;
importandroid.widget.ImageView;
importandroid.widget.ListView;
importandroid.widget.TextView;
importandroid.widget.Toast;
publicclassStuffListextendsActivity{
privateListViewlv;
privateSQLiteDatabasemDataBase;
privateListstuffInfos;
privateMySQLiteOpenHelpermHelper;
Override
protectedvoidonCreate（BundlesavedInstanceState）{
setContentView（R.layout.show_all）;
mHelper=newMySQLiteOpenHelper（this）;
lv=（ListView）findViewById（R.id.id_lv）;
all（）;
super.onCreate（savedInstanceState）;
}
publicvoidall（）{
mDataBase=mHelper.getWritableDatabase（）;
Cursorcursor=mDataBase.query（"LIQI",null,null,null,null,null,null）;
stuffInfos=newArrayList（）;
while（cursor.moveToNext（））{
Stuffstuff=newStuff（）;
stuff.setStuffName（cursor.getString
（1））;
stuff.setStuffAmount（cursor.getInt
（2））;
stuff.setStuffPrice（cursor.getFloat（3））;
stuffInfos.add（stuff）;
}
cursor.close（）;
mDataBase.close（）;
lv.setAdapter（newMyadapter（））;
}
classMyadapterextendsBaseAdapter{
Override
publicintgetCount（）{
returnstuffInfos.size（）;
}
Override
publicObjectgetItem（intposition）{
//TODOAuto-generatedmethodstub
returnnull;
}
Override
publiclonggetItemId（intposition）{
//TODOAuto-generatedmethodstub
return0;
}
Override
publicViewgetView（finalintposition,Viewview,ViewGroupparent）{
view=View.inflate（StuffList.this,R.layout.stuff_item,null）;
TextViewtv_name=（TextView）view.findViewById（R.id.id_tv_name）;
TextViewtv_amount=（TextView）view.findViewById（R.id.id_tv_amount）;
TextViewtv_price=（TextView）view.findViewById（R.id.id_tv_price）;
ImageButtoniButton=（ImageButton）view.findViewById（R.id.id_ib_delete）;
tv_name.setText（stuffInfos.get（position）.getStuffName（））;
tv_amount.setText（"数量（个）"+stuffInfos.get（position）.getStuffAmount（））;
tv_price.setText（"单价（元）"+stuffInfos.get（position）.getStuffPrice（））;
iButton.setOnClickListener（newOnClickListener（）{
Override
publicvoidonClick（Viewv）{
mDataBase=mHelper.getWritableDatabase（）;
mDataBase.delete（"LIQI","stuff=?
",newString[]{stuffInfos.get（position）.getStuffName（）}）;
mDataBase.close（）;
stuffInfos.remove（position）;
Myadapter.this.notifyDataSetChanged（）;
}
}）;
returnview;
}
}
}
6.编写界面交互代码
package.LIQI.Stuff;
importandroid.app.Activity;
importandroid.content.ContentValues;
importandroid.content.Intent;
importandroid.database.sqlite.SQLiteDatabase;
importandroid.os.Bundle;
importandroid.view.View;
importandroid.view.View.OnClickListener;
importandroid.widget.Button;
importandroid.widget.EditText;
importandroid.widget.Toast;
publicclassMainActivityextendsActivityimplementsOnClickListener{
privateMySQLiteOpenHelpermHelper;
privateSQLiteDatabasemDataBase;
privateButtonbt_add,bt_all;
privateEditTextet_stuffName,et_stuffAmount,et_stuffPrice;
Override
protectedvoidonCreate（BundlesavedInstanceState）{
super.onCreate（savedInstanceState）;
setContentView（R.layout.add_data）;
mHelper=newMySQLiteOpenHelper（this）;
initView（）;
initAction（）;
}
publicvoidinitView（）{
et_stuffName=（EditText）findViewById（R.id.id_et_stuffname）;
et_stuffAmount=（EditText）findViewById（R.id.id_et_stuffamount）;
et_stuffPrice=（EditText）findViewById（R.id.id_et_stuffprize）;
bt_add=（Button）findViewById（R.id.id_bt_add）;
bt_all=（Button）findViewById（R.id.id_bt_all）;
}
publicvoidinitAction（）{
bt_add.setOnClickListener（this）;
bt_all.setOnClickListener（this）;
}
Override
publicvoidonClick（Viewv）{
switch（v.getId（））{
caseR.id.id_bt_add:
add（）;
break;
caseR.id.id_bt_all:
Intentintent=newIntent（this,StuffList.class）;
startActivity（intent）;
break;
}
}
publicvoida
升级会员 