DBUtils 的增删改查

Xutils_DBUtils 的增删改查

依赖：implementation ‘org.xutils:xutils:3.5.1’

初始化：

public class MyApplication extends Application {
    @Override
    public void onCreate() {
        super.onCreate();
        x.Ext.init(this);
        x.Ext.setDebug(true);
    }
}

DB实体类：

@Table(name="DbTable")
public class DBBean {
    @Column(name = "id",isId = true)
    private int id;
    @Column(name = "name")
    private String name;

    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 class MainActivity extends AppCompatActivity implements View.OnClickListener {

    private DbManager db;
    private Button main_add;
    private Button main_delete;
    private Button main_updata;
    private Button main_serch;
    private ListView main_list;
    private ArrayList<Bean> list;
    private MyAdapter adapter;

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);
        initView();
        x.view().inject(this);
        DbManager.DaoConfig daoConfig = new DbManager.DaoConfig();
        daoConfig.setDbVersion(1);
        daoConfig.setDbName("DbBase");
        db = x.getDb(daoConfig);

    }

    private void initView() {
        list = new ArrayList<>();

        main_add = (Button) findViewById(R.id.main_add);
        main_delete = (Button) findViewById(R.id.main_delete);
        main_updata = (Button) findViewById(R.id.main_updata);
        main_serch = (Button) findViewById(R.id.main_serch);
        main_list = (ListView) findViewById(R.id.main_list);

        adapter = new MyAdapter(this);
        main_list.setAdapter(adapter);



        main_add.setOnClickListener(this);
        main_delete.setOnClickListener(this);
        main_updata.setOnClickListener(this);
        main_serch.setOnClickListener(this);
    }

    @Override
    public void onClick(View v) {
        switch (v.getId()) {
            case R.id.main_add:
                 MyAdd();
                break;
            case R.id.main_delete:
                 MyDelete();
                break;
            case R.id.main_updata:
                 MyUpData();
                break;
            case R.id.main_serch:
                 MySerch();
                break;
        }
    }

    
    //查询数据
    private void MySerch() {
        list.clear();
        try {
            List<DBBean> all = db.findAll(DBBean.class);
            for (int i = 0; i < all.size(); i++) {
                int id = all.get(i).getId();
                String name = all.get(i).getName();
                Bean bean = new Bean();
                bean.setId(id);
                bean.setName(name);
                list.add(bean);
            }
            adapter.setList(list);
        } catch (DbException e) {
            e.printStackTrace();
        }
    }

    
    //修改数据
    private void MyUpData() {
        try {

            KeyValue keyValue = new KeyValue("name","王五");
            db.update(DBBean.class,WhereBuilder.b("name","=","张三"),keyValue);
        } catch (DbException e) {
            e.printStackTrace();
        }
    }

    //删除数据
    private void MyDelete() {
        try {
            db.delete(DBBean.class,WhereBuilder.b("name","=","王五"));
        } catch (DbException e) {
            e.printStackTrace();
        }
    }

    
    //增加数据
    private void MyAdd() {

        int num = (int) (Math.random() * 100);
        DBBean dbBean = new DBBean();
        dbBean.setId(0);
        dbBean.setName("张三");
        try {
            db.saveOrUpdate(dbBean);
        } catch (DbException e) {
            e.printStackTrace();
        }

    }
}