ORMLiteDatabase的简单使用并且与其他的表相互联系

1、下载jar

具体到Android，需要在 http://ormlite.com/releases 页面下载两个jar 包（本文基于ORMLite的版本是：ormlite 4.49-SNAPSHOT）：
（1）core列表下的jar包；
（2）android列表下的jar包。
如图所示：

 

 

将上面的两个jar包下载后放到Android工程项目中的libs包中，如图所示：

 

以上完成后，ORMLite开发环境搭建就完成了，接下来就可以使用了。

 

2、代码：

表student.java和AClass.java

package com.zzw.ormlitedatabasetest;

import com.j256.ormlite.field.DatabaseField;
import com.j256.ormlite.table.DatabaseTable;

@DatabaseTable(tableName = "Student")
public class Student {

    @DatabaseField(id = true, columnName = "Student_id")
    public int Student_id;
    @DatabaseField(columnName = "name")
    public String name;
    @DatabaseField(columnName = "sex")
    public String sex;
    @DatabaseField(columnName = "age")
    public int age;
    @DatabaseField(foreign = true, foreignAutoRefresh = true)
    public AClass aClass;

    public Student() {

    }

    public Student(String name, String sex, int age) {
        super();
        this.name = name;
        this.sex = sex;
        this.age = age;
    }

    @Override
    public String toString() {
        return "Student [Student_id=" + Student_id + ", name=" + name + ", sex=" + sex + ", age=" + age + ",className="
                + aClass.name + "]";
    }

}

Student

package com.zzw.ormlitedatabasetest;

import com.j256.ormlite.dao.ForeignCollection;
import com.j256.ormlite.field.DataType;
import com.j256.ormlite.field.DatabaseField;
import com.j256.ormlite.field.ForeignCollectionField;
import com.j256.ormlite.table.DatabaseTable;

@DatabaseTable(tableName = "Classess")
public class AClass {

    @DatabaseField(id = true, columnName = "classess_id")
    public int classess_id;
    @DatabaseField(dataType = DataType.STRING)
    public String name;
    @ForeignCollectionField(eager = false)
    public ForeignCollection<Student> students = null;

    public AClass() {
        super();
    }

    public AClass(int classess_id, String name, ForeignCollection<Student> students) {
        super();
        this.classess_id = classess_id;
        this.name = name;
        this.students = students;
    }

}

AClass

ORMLite数据库管理工具类ORMLiteDatabaseHelper.java：

package com.zzw.ormlitedatabasetest;

import java.sql.SQLException;

import com.j256.ormlite.android.apptools.OrmLiteSqliteOpenHelper;
import com.j256.ormlite.dao.Dao;
import com.j256.ormlite.support.ConnectionSource;
import com.j256.ormlite.table.TableUtils;

import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteDatabase.CursorFactory;
import android.util.Log;

public class OrmLiteDatabaseHelper extends OrmLiteSqliteOpenHelper {
    private static final String TAG = "OrmLiteDatabaseHelper";

    public static OrmLiteDatabaseHelper mDatabaseHelper = null;

    public Dao<Student, Integer> mStudentDao = null;
    public Dao<AClass, Integer> mAClassDao = null;

    public static String database_NAME = "school.db";
    public static int database_VERSION = 1;

    public OrmLiteDatabaseHelper(Context context, String databaseName, CursorFactory factory, int databaseVersion) {
        super(context, databaseName, factory, databaseVersion);
    }

    public static OrmLiteDatabaseHelper getInstance(Context context) {
        if (mDatabaseHelper == null) {
            mDatabaseHelper = new OrmLiteDatabaseHelper(context, database_NAME, null, database_VERSION);
        }
        Log.d(TAG, "数据库school.db创建成功");
        return mDatabaseHelper;
    }

    @Override
    public void onCreate(SQLiteDatabase arg0, ConnectionSource arg1) {
        try {
            TableUtils.createTableIfNotExists(arg1, AClass.class);
            Log.e(TAG, "AClass表在School.db中被创建");
            TableUtils.createTableIfNotExists(arg1, Student.class);
            Log.e(TAG, "Student表在School.db中被创建");
        } catch (SQLException e) {
            e.printStackTrace();
        }

    }

    @Override
    public void onUpgrade(SQLiteDatabase arg0, ConnectionSource arg1, int arg2, int arg3) {

    }

    public Dao<Student, Integer> getStudentDao() {
        if (mStudentDao == null) {
            try {
                mStudentDao = getDao(Student.class);
                Log.e(TAG, "得到Student的Dao");
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
        return mStudentDao;
    }

    public Dao<AClass, Integer> getAClassDao() {
        if (mAClassDao == null) {
            try {
                mAClassDao = getDao(AClass.class);
                Log.e(TAG, "得到AClass的Dao");
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
        return mAClassDao;
    }

    @Override
    public void close() {
        super.close();
        if (mAClassDao != null) {
            mAClassDao = null;
        }
        if (mStudentDao != null) {
            mStudentDao = null;
        }
    }
}

MainActivity:

package com.zzw.ormlitedatabasetest;

import java.sql.SQLException;
import java.util.List;

import com.j256.ormlite.dao.Dao;

import android.app.Activity;
import android.graphics.Color;
import android.os.Bundle;
import android.util.Log;
import android.widget.ScrollView;
import android.widget.TextView;
import android.widget.Toast;

public class MainActivity extends Activity {

    private static final String TAG = "MainActivity";

    private Dao<AClass, Integer> mAClassDao = null;
    private Dao<Student, Integer> mStudentDao = null;

    AClass aClass1, aClass2, aClass3, aClass4, aClass5;

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);

        OrmLiteDatabaseHelper mOrmLiteDatabaseHelper = OrmLiteDatabaseHelper.getInstance(this);

        mAClassDao = mOrmLiteDatabaseHelper.getAClassDao();
        mStudentDao = mOrmLiteDatabaseHelper.getStudentDao();

    }

    @Override
    protected void onStart() {
        Log.d(TAG, ">>>>>>>>>>>>");
        super.onStart();
        int AClasses_count = createAClasses();
        if (AClasses_count == 5) {
            try {
                aClass1 = mAClassDao.queryForId(1);
                aClass2 = mAClassDao.queryForId(2);
                aClass3 = mAClassDao.queryForId(3);
                aClass4 = mAClassDao.queryForId(4);
                aClass5 = mAClassDao.queryForId(5);

                createStudents();

            } catch (Exception e) {
                e.printStackTrace();
            }
        } else {
            Toast.makeText(this, "班级创建错误", 0).show();
        }
        queryAllStudents();
    }

    private void createStudents() {
        Log.d(TAG, "学生创建开始------>");
        Student student = new Student();
        for (int i = 1; i <= 20; i++) {
            student.Student_id = i;
            student.age = (int) (Math.random() * 100);
            if (i % 2 == 0) {
                student.sex = "男";
            } else {
                student.sex = "女";
            }
            if (i > 0 && i <= 4) {
                student.aClass = aClass1;
                student.name = "陶" + i;
            } else if (i > 4 && i <= 8) {
                student.aClass = aClass2;
                student.name = "李" + i;
            } else if (i > 8 && i <= 12) {
                student.aClass = aClass3;
                student.name = "阿" + i;
            } else if (i > 12 && i <= 16) {
                student.aClass = aClass4;
                student.name = "曾" + i;
            } else {
                student.aClass = aClass5;
                student.name = "蒋" + i;
            }

            try {
                mStudentDao.createIfNotExists(student);
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
        Log.d(TAG, "学生创建成功------>");
    }

    private int createAClasses() {
        Log.d(TAG, "班级创建开始------>");
        AClass aClass = new AClass();
        int AClasses_count = 0;
        for (int i = 1; i <= 5; i++) {
            aClass.classess_id = i;
            aClass.name = "高三" + i + "班";
            try {
                mAClassDao.createIfNotExists(aClass);
                AClasses_count++;
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
        Log.d(TAG, "班级创建成功------>");
        return AClasses_count;
    }

    private void queryAllStudents() {
        Log.d(TAG, "查询全部学生开始------>>>>");
        try {
            List<Student> students = mStudentDao.queryForAll();
            if (students != null && students.size() > 0) {
                for (Student student : students) {
                    Log.i(TAG, student.toString());
                }
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }
        Log.d(TAG, "查询全部学生完毕------>>>>");
    }

    @Override
    protected void onDestroy() {
        super.onDestroy();
        if (mAClassDao != null) {
            mAClassDao = null;
        }
        if (mStudentDao != null) {
            mStudentDao = null;
        }
        Log.d(TAG, "<<<<<<<<<<<");
    }

}