DbUtil的增删改查

表的创建 package com.example.bean; import com.lidroid.xutils.db.annotation.Column; import com.lidroid.xutils.db.annotation.Table; @Table(name="user") public class User { @Column(column="id") private int id; @Column(column="name") private String name; @Column(column="age") private int age; @Column(column="address") private String address; // 此封装类必须有无参构造 方法 快递客服问题件处理详细方法山木方法pdf计算方法pdf华与华方法下载八字理论方法下载 @Override public String toString() { return "User [id=" + id + ", name=" + name + ", age=" + age + ", address=" + address + "]"; } public int getId() { return id; } public void setId(int id) { this.id = id; } public String getName() { return name; } public void setName(String name) { this.name = name; } public int getAge() { return age; } public void setAge(int age) { this.age = age; } public String getAddress() { return address; } public void setAddress(String address) { this.address = address; } } 主程序开始了MainActivity package com.example.test_xutils_3a; import java.util.ArrayList; import java.util.list; import android.app.Activity; import android.graphics.Bitmap; import android.os.Bundle; import android.util.Log; import android.view.Gravity; import android.View.LayoutInflater; import android.view.View; import android.view.View.OnClickListener; import android.widget.Button; import android.widget.ImageView; import android.widget.PopupWindow; import android.widget.RelativeLayout.LayoutParams; import com.example.bean.User; import com.example.utils.Utils; import com.lidroid.xutils.BitmapUtils; import com.lidroid.xutils.DbUtils; import com.lidroid.xutils.HttpUtils; import com.lidroid.xutils.ViewUtils; import com.lidroid.xutils.db.sqlite.Selector; import com.lidroid.xutils.db.sqlite.WhereBuilder; import com.lidroid.xutils.exception.DbException; import com.lidroid.xutils.exception.HttpException; import com.lidroid.xutils.http.RequestParams; import com.lidroid.xutils.http.ResponseInfo; import com.lidroid.xutils.http.callback.RequestCallBack; import com.lidroid.xutils.http.client.HttpRequest.HttpMethod; import com.lidroid.xutils.view.annotation.ViewInject; /** * 测试类,测试Xutils * * @author wangfei */ public class MainActivity extends Activity implements OnClickListener{ private Imageview imageView1; private BitmapUtils bitmapUtils; private Button Button1; private Button add,select,update; @ViewInject(R.id.delete) private Button delete; PopupWindow pop; private DbUtils dbutils; @Override protected void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); setContentView(R.layout.activity_main); ViewUtils.inject(this); //初始化View initview(); // 初始化Xutils xutil_creat(); Utils dd = new Utils(); pop = dd.getpopwindow(this); } /** * 初始化Xutils */ private void xutil_creat(){ // 实例化DBUtils对象 dbutils = DbUtils.create(this,"1403a.db"); bitmapUtils =BitmapHelp.getBitmapUtils(this); bitmapUtils.configDefaultLoadingImage(R.drawable.ic_launcher); bitmapUtils.configDefaultLoadFailedImage(R.drawable.ic_launcher); bitmapUtils.configDefaultBitmapConfig(Bitmap.Config.RGB_565); bitmapUtils.display(imageview1, ""); } private void initView(){ add = (Button) findviewById(R.id.add); select = (Button) findViewById(R.id.select); imageView1 = (ImageView) findViewById(R.id.imageView1); button1 = (Button) findViewById(R.id.button1); update = (Button) findViewById(R.id.update); update.setOnClickListener(this); add.setOnClicklistener(this); select.setOnClickListener(this); button1.setOnClicklistener(this); delete.setOnClickListener(this); } @Override public void onClick(final View v) { switch (v.getId()) { case R.id.add: List list_user = new ArrayList(); for(int i=0;i<10;i++){ User user = new User(); user.setAddress("SD卡积分"+i); user.setAge(i); user.setName("张三"+i); List_user.add(user); } try { dbutils.saveAll(list_user); // dbutils.save(user); } catch (DbException e) { // TODO Auto-generated catch block e.printStackTrace(); } break; case R.id.select://查询 try { // User user = dbutils.findFirst(Selector.from(User.class).where("name", "=", "张三4")); List list = new ArrayList(); list = dbutils.findAll(Selector.from(User.class)); Log.e("TAG", "查询数据库=="+list.toString()); } catch (DbException e) { // TODO Auto-generated catch block e.printStackTrace(); } break; case R.id.update://修改----单个---多个 // List list_upuser = new ArrayList(); // // for(int i=0;i<2;i++){ User upuser = new User(); // upuser.setId(i+1); upuser.setName("仓老师"); upuser.setAddress("家住八维"); upuser.setAge(16); // list_upuser.add(upuser); // } // try { dbutils.update(upuser, WhereBuilder.b("age", "=", "16"), "address","name"); // dbutils.update(upuser, "age","address"); // dbutils.updateAll(List_upuser, "name","address","age"); // dbutils.updateAll(list_upuser, WhereBuilder.b("age", "=","16"), "name","address"); } catch (DbException e) { // TODO Auto-generated catch block e.printStackTrace(); } break; case R.id.delete://删除 List d_list = new ArrayList(); for(int i=3;i<7;i++){ User duser = new User(); duser.setId(i); d_list.add(duser); } try { // dbutils.delete(duser); // dbutils.delete(User.class, WhereBuilder.b("name", "=","仓老师")); dbutils.deleteAll(d_list); } catch (DbException e) { // TODO Auto-generated catch block e.printStackTrace(); } break; } } }