使用litePal来做为数据库的框架:
0:首先导入litepal 的依赖和fastjson的依赖
dependencies {
compile fileTree(include: ['*.jar'], dir: 'libs')
testCompile 'junit:junit:4.12'
compile 'com.android.support:appcompat-v7:23.4.0'
compile 'org.litepal.android:core:1.3.2'
compile 'com.alibaba:fastjson:1.2.13'
}
1:创建一个MyApplication,
package tech.androidstudio.dbtest;
import org.litepal.LitePalApplication;
/**
* Created by Kodulf on 2016/6/30.
*/
public class MyApplication extends LitePalApplication {
@Override
public void onCreate() {
super.onCreate();
}
}
然后修改清单文件:android:name=".MyApplication"
<?xml version="1.0" encoding="utf-8"?>
<manifest xmlns:android="http://schemas.android.com/apk/res/android"
package="tech.androidstudio.dbtest">
<uses-permission android:name="android.permission.READ_EXTERNAL_STORAGE"></uses-permission>
<uses-permission android:name="android.permission.WRITE_EXTERNAL_STORAGE"></uses-permission>
<application
android:allowBackup="true"
android:icon="@mipmap/ic_launcher"
android:label="@string/app_name"
android:name=".MyApplication"
android:supportsRtl="true"
android:theme="@style/AppTheme">
<activity android:name=".MainActivity">
<intent-filter>
<action android:name="android.intent.action.MAIN" />
<category android:name="android.intent.category.LAUNCHER" />
</intent-filter>
</activity>
</application>
</manifest>
2:在main的文件夹下面创建一个assets的文件夹,然后创建一个litepal.xml的文件,
里面的list 是我们下面的创建的类Account,就是会映射为一个表
<?xml version="1.0" encoding="utf-8"?>
<litepal>
<dbname value="demo" ></dbname>
<version value="1" ></version>
<list>
<mapping class="tech.androidstudio.dbtest.Account"></mapping>
</list>
</litepal>
3:创建Account的类:记住一定要包含一个空的参数的构造方法,因为下面会用到FastJson转换的时候用到,不然会报错的。
package tech.androidstudio.dbtest;
import org.litepal.crud.DataSupport;
import java.util.Date;
/**
* Created by Kodulf on 2016/6/30.
*/
public class Account extends DataSupport {
//(uid, acc_no, realname, mobile, attribute, status, cdate, edate)
// VALUES ('20009', null, null, '18329160075', 1, 1, '2012-08-30 15:12:35', '2014-02-28 02:54:25');
private int uid;
private String acc_no;
private String realname;
private String mobile;
private int attribute;
private int status;
private Date cdate;
private Date edate;
public Account() {
}
public Account(int uid, String acc_no, String realname, String mobile, int attribute, int status, Date cdate, Date edate) {
this.uid = uid;
this.acc_no = acc_no;
this.realname = realname;
this.mobile = mobile;
this.attribute = attribute;
this.status &#