介紹一個ORM框架，LitePal绢陌。
GitHub：https://github.com/LitePalFramework/LitePal
使用方法很簡單，導(dǎo)入xx包就不說了。
- 創(chuàng)建一個類阻塑，繼承DataSupport。
public class StudentBean extends DataSupport {
private int studentID;
private String studentName;
private String studentAge;
private String studentSex;
private String studentPhone;
public int getStudentID() {
return studentID;
}
public void setStudentID(int studentID) {
this.studentID = studentID;
}
public String getStudentName() {
return studentName;
}
public void setStudentName(String studentName) {
this.studentName = studentName;
}
public String getStudentAge() {
return studentAge;
}
public void setStudentAge(String studentAge) {
this.studentAge = studentAge;
}
public String getStudentSex() {
return studentSex;
}
public void setStudentSex(String studentSex) {
this.studentSex = studentSex;
}
public String getStudentPhone() {
return studentPhone;
}
public void setStudentPhone(String studentPhone) {
this.studentPhone = studentPhone;
}
}
- assets目錄下創(chuàng)建一個名為litepal.xml的配置文件
<?xml version="1.0" encoding="utf-8"?>
<litepal>
<dbname value="litepal" >
</dbname>
<version value="3" >
</version>
<list>
<mapping class="com.jeremy.universal_android.sqlite.bean.StudentBean"></mapping>
</list>
</litepal>
- application繼承LitePalApplication
public class UniversalAndroidApplication extends LitePalApplication {
@Override
public void onCreate() {
super.onCreate();
// 初始化sqlite庫
LitePalApplication.initialize(this);
}
}
如何使用果复？
private void insertWithTs() {
StudentBean studentBean = null;
for (int i = 0; i < 1000; i++) {
studentBean = new StudentBean();
studentBean.setStudentName("小明" + i);
studentBean.setStudentAge("" + i);
studentBean.save();
}
}
private void insertWithoutTs() {
List<StudentBean> studentBeanList = new ArrayList<>();
StudentBean studentBean = null;
for (int i = 0; i < 1000; i++) {
studentBean = new StudentBean();
studentBean.setStudentName("小明" + i);
studentBean.setStudentAge("" + i);
studentBeanList.add(studentBean);
}
DataSupport.saveAll(studentBeanList);
}
問題來了陈莽，上面兩個方法同樣是插入1000條數(shù)據(jù)，區(qū)別是什么呢虽抄？insertWithTs()調(diào)用的是對象的save()走搁，執(zhí)行1000次；而insertWithoutTs()是把1000個對象放在一個集合中迈窟，最后調(diào)用一次saveAll()私植。
看一下兩種方法效率如何。
insertWithTs()车酣，單位是毫秒
E/SQLITE: begin --> 1470285148375
E/SQLITE: end --> 1470285156347
E/SQLITE: gap --> 7972
insertWithoutTs()曲稼，單位是毫秒
E/SQLITE: begin --> 1470285043075
E/SQLITE: end --> 1470285045001
E/SQLITE: gap --> 1926
差別如此之大索绪，原因在哪里？看源碼
save()方法是這樣的
public synchronized void saveThrows() {
SQLiteDatabase db = Connector.getDatabase();
db.beginTransaction();
try {
// some code
db.setTransactionSuccessful();
} catch (Exception e) {
throw new DataSupportException(e.getMessage());
} finally {
db.endTransaction();
}
}
而saveAll()呢贫悄？
public static synchronized <T extends DataSupport> void saveAll(Collection<T> collection) {
SQLiteDatabase db = Connector.getDatabase();
db.beginTransaction();
try {
//code to save collection
db.setTransactionSuccessful();
} catch (Exception e) {
throw new DataSupportException(e.getMessage());
} finally {
db.endTransaction();
}
}
每一次save()都涉及到一個事務(wù)的begin和end瑞驱，當(dāng)數(shù)據(jù)量變大時，代碼執(zhí)行效率就會明顯低于saveAll()的方式窄坦。另外需要注意的是唤反，數(shù)據(jù)插入屬于耗時操作，應(yīng)開啟線程鸭津。
