litepal

1、下载jar包

https://github.com/LitePalFramework/LitePal#latest-downloads

2、导入jar包

3、在assets建立一个litepal.xml文件

<?xml version="1.0" encoding="utf-8"?>  
<litepal>  
    <dbname value="student" ></dbname>  
    <version value="1" ></version>  
    <list>  
    </list>  
</litepal>  

version版本号·，dbname你要建立数据库的名字

4、修改清单文件

 <application
        android:name="org.litepal.LitePalApplication"
        android:allowBackup="true"
        android:icon="@drawable/ic_launcher"
        android:label="@string/app_name"
        android:theme="@style/AppTheme" >

5、定义一个学生类

public class Student {


private int id;
private int age;
private String name;
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public int getAge() {
return age;
}
public void setAge(int age) {
this.age = age;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}

}

6、将其添加到litepal.xml文件中

<list>  
        <mapping class="com.example.litepal.Student"></mapping>
    </list>  

7、创建数据库

public void click(View v) {
switch(v.getId()){
case R.id.btnCreate:
Connector.getDatabase();
break;
default:
break;
}

}

8、添加数据

让student继承DataSupport

Student s=new Student();
s.setId(1);
s.setAge(20);
s.setName("xiaoming");
s.save();

9、更新数据

Student s1 = new Student();
s1.setId(10);
s1.setAge(3);
s1.updateAll("age=? and id=?","20","1");
break;

10、删除数据

DataSupport.deleteAll(Student.class, "age<?","20");
break;

11、查询数据

List<Student> list = DataSupport.findAll(Student.class);
for (Student student:list) {
Log.i("MainActivity", student.getName()+"");
Log.i("MainActivity", student.getAge()+"");
Log.i("MainActivity", student.getId()+"");
}