数据库增删改查

一、数据库代码

  //1.通过DaoMaster获取DevSession对象

        DaoSession daoSession = DaoMaster.newDevSession(this, BeanDao.TABLENAME);

        //2.通过DevSession获取Dao对象

        beanDao = daoSession.getBeanDao();

        //通过Dao对象进行增删改查

二、数据库增加

//添加数据

                Bean bean = new Bean(null, "小强", "男", 23);

                beanDao.insert(bean);

三、数据库修改

//修改数据

                bean = new Bean(1L, "小强", "男", 23);

                bean.setAge(20);

                beanDao.update(bean);

四、数据库删除

  //删除数据

                beanDao.delete(mList.get(a));

                //查询所有

               popupWindow.dismiss();

                public void cha(){

                //查询所有

                List beans = beanDao.loadAll();

                mList.clear();

                mList.addAll(beans);

                myRecyclerViewAdapter.notifyDataSetChanged();

            }

五、数据库查找

//查询所有

                List beans = beanDao.loadAll();

                Log.e("Tag",beans.toString());

六、数据库实体类

//主键

@Id(autoincrement = true) private Long id;

@Entity

public class Bean {

    @Id(autoincrement = true)

    private Long id;

    @Property(nameInDb = "sname")

    private String name;

    private String gender;

    private int age;