Sqlite 数据库的创建
package com.example.wanglibo20171123;
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteDatabase.CursorFactory;
import android.database.sqlite.SQLiteOpenHelper;
public class SQlitepoen extends SQLiteOpenHelper{
public SQlitepoen(Context context) {
super(context, "user.db", null, 1);
// TODO Auto-generated constructor stub
}
@Override
public void onCreate(SQLiteDatabase db) {
// TODO Auto-generated method stub
db.execSQL(" create table user(id integer primary key autoincrement," +
"goods_id varchar(100)," +
"goods_name varchar(100)," +
"goods_num varcahr(100)," +
"goods_price double(7,2)," +
"goods_total double(7,2)" +
")");
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
// TODO Auto-generated method stub
}
}
Userdao 类的代码
package com.example.wanglibo20171123;
/**
* dao 类
*/
import java.util.Currency;
import java.util.List;
import com.example.wanglibo20171123.user.datas.cart;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.widget.Toast;
public class goodsdao {
private SQlitepoen sp;
private SQLiteDatabase rd;
public goodsdao(Context context){
sp=new SQlitepoen(context);
}
//添加数据库
public void add(List<cart> list){
rd = sp.getReadableDatabase();
for (int i = 0; i <list.size(); i++) {
// cart c = new user().new datas().new cart();
cart ca = list.get(i);
String goods_id = ca.getGoods_id();
String goods_name = ca.getGoods_name();
String goods_num = ca.getGoods_num();
String goods_price = ca.getGoods_price();
String goods_total = ca.getGoods_total();
rd.execSQL("insert into user(goods_id,goods_name,goods_num,goods_price,goods_total) values(?,?,?,?,?)",new String[]{goods_id,goods_name,goods_num,goods_price,goods_total});
}
rd.close();
}
//从数据库删除
public void delete(String name){
rd.execSQL("delete from user where goods_name=?",new String[]{name});
// rd.close();
}
//查询价格的
public double select(Context context){
double h=0;
Cursor cursor = rd.rawQuery("select * from user", new String[]{});
while(cursor!=null){
double price = cursor.getDouble(cursor.getColumnIndex("goods_price"));
Toast.makeText(context, price+"", 0).show();
h+=price;
}
return h;
}
}