如何使用?
- eclipseAPP项目:导入jar包
- Android StudioAPP项目:引入源码库
implementation 'org.litepal.android:core:2.0.0' 版本去gethub上看
- 创建litepal.xml文件
<?xml version="1.0" encoding="utf-8" ?> <litepal> <!--数据库名称--> <dbname value = "test"/> <!--数据库版本--> <version value = "1"/>
<list> <!--数据库表映射的java类(ORM) litepal会自动创建自增长主键,不支持自定义主键--> <mapping class="com.example.com.litepaldemo.Demo.User"/>
</list>
</litepal> |
- 件在AndroidManifest.xml配置文件中进行配置
android:name="org.litepal.LitePalApplication"
- 建表以及增删改查(CRUD)(通过LitePal【增删改查工具】进行操作)
注意:DataSupport在2.0版本以后弃用,改用LitePal
// 初始化LitePal数据库 LitePal.initialize(this); //================================创建数据库======================================= btn_createDB.setOnClickListener(new View.OnClickListener() { @Override public void onClick(View view) { //在获取数据库的时候,先创建,如果有也要创建然后把原来的数据同步过来,删掉原来的 Connector.getDatabase(); Toast.makeText(MainActivity.this,"db success",Toast.LENGTH_LONG).show(); } }); //================================insert 添加======================================= btn_insert.setOnClickListener(new View.OnClickListener() { @Override public void onClick(View view) { User u = new User(); u.setName("张三"); u.setAge(12); u.setSex("男"); //save()添加方法 u.save(); User u1 = new User(); u1.setName("李四"); u1.setAge(12); u1.setSex("男"); u1.save(); u.save(); User u2 = new User(); u2.setName("王五"); u2.setAge(12); u2.setSex("男"); u2.save(); u.save(); User u3 = new User(); u3.setName("胖六"); u3.setAge(12); u3.setSex("男"); u3.save(); Toast.makeText(MainActivity.this,"insert success",Toast.LENGTH_LONG).show(); } }); //================================update 修改======================================= btn_update.setOnClickListener(new View.OnClickListener() { @Override public void onClick(View view) { //find() 按照id查询出来,然后修改在save()保存 // User u = LitePal.find(User.class,3); // u.setAge(33); // u.setSex("man"); // u.save(); //通过查询条件进行修改 //要修改的值 ContentValues values = new ContentValues(); values.put("name","哈哈"); values.put("age",66); //查出来符合条件的修改 LitePal.updateAll(User.class,values,"name = ? and age = ? ","张三","12"); Toast.makeText(MainActivity.this,"update success",Toast.LENGTH_LONG).show(); } }); //================================delete 删除======================================= btn_delete.setOnClickListener(new View.OnClickListener() { @Override public void onClick(View view) { //delete() 按照id删除 // LitePal.delete(User.class,1); //通过条件进行删除 LitePal.deleteAll(User.class,"name = ? and age = ?","李四","12"); Toast.makeText(MainActivity.this,"delete success",Toast.LENGTH_LONG).show(); } }); //================================find 查询======================================= btn_find.setOnClickListener(new View.OnClickListener() { @Override public void onClick(View view) { //find()方法只能按照id进行查询 // User u = LitePal.find(User.class,3); List<User> userList = LitePal.select("name","age","sex") .where("age > ?","10") .limit(2) .offset(1) .order("age asc") .find(User.class); for(User u:userList){ Log.e("err",u.toString(u)); } Toast.makeText(MainActivity.this,"find success",Toast.LENGTH_LONG).show(); } }); |