cn.vonce.sql.android.helper.SQLiteHelper Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of vonce-sqlbean-android Show documentation

This is a tool that uses Java object-oriented thinking to write and generate Sql statements, and on this basis, it implements lightweight plug-in support for Android. A large number of commonly used Sql execution methods are built into the plug-in, the purpose is to improve development efficiency, reduce a large number of Sql statement writing, and let developers focus more on writing business code.

The newest version!

package cn.vonce.sql.android.helper;

import android.content.Context;
import android.util.Log;
import cn.vonce.sql.android.util.PackageUtil;
import cn.vonce.sql.annotation.SqlTable;
import cn.vonce.sql.bean.Table;
import cn.vonce.sql.uitls.SqlBeanUtil;

import java.util.List;
import java.util.Map;
import java.util.WeakHashMap;

/**
 * 数据库连接助手
 *
 * @author Jovi
 */
public class SQLiteHelper {

    private volatile static SQLiteHelper defaultSqLiteHelper;
    private final static Map sqLiteHelperMap = new WeakHashMap<>();
    private final Map, SqlBeanHelper> sqlBeanHelperMap = new WeakHashMap<>();

    private Context context;
    private String name;
    private int version;
    private DatabaseHelper databaseHelper;

    private SQLiteHelper(Context context, String name, int version) {
        this.context = context;
        this.name = name;
        this.version = version;
    }

    /**
     * 初始化默认数据库参数
     *
     * @param context 上下文
     * @param name    数据库名称
     * @param version 数据库版本
     */
    public static void init(Context context, String name, int version) {
        if (defaultSqLiteHelper == null) {
            synchronized (SQLiteHelper.class) {
                if (defaultSqLiteHelper == null) {
                    defaultSqLiteHelper = new SQLiteHelper(context, name, version);
                }
            }
        }
    }

    /**
     * 动态设置数据库参数
     *
     * @param context 上下文
     * @param name    数据库名称
     * @param version 数据库版本
     * @return
     */
    public static SQLiteHelper db(Context context, String name, int version) {
        SQLiteHelper sqLiteHelper = sqLiteHelperMap.get(name);
        if (sqLiteHelper == null) {
            sqLiteHelper = new SQLiteHelper(context, name, version);
        } else {
            if (sqLiteHelper.version != version) {
                sqLiteHelper.version = version;
                sqLiteHelper.sqlBeanHelperMap.clear();
                sqLiteHelperMap.put(name, sqLiteHelper);
            }
        }
        return sqLiteHelper;
    }

    /**
     * 获取默认数据库参数
     *
     * @return
     */
    public static SQLiteHelper db() {
        SqlBeanUtil.isNull(defaultSqLiteHelper, "请初始化默认数据库");
        return defaultSqLiteHelper;
    }

    /**
     * 获得数据库连接
     *
     * @param clazz
     * @return
     */
    public  SqlBeanHelper get(Class clazz) {
        SqlBeanHelper sqlBeanHelper = sqlBeanHelperMap.get(clazz);
        if (sqlBeanHelper == null) {
            if (databaseHelper == null) {
                databaseHelper = new DatabaseHelper(clazz, context, name, null, version);
                this.initSqlBeanHelper(clazz);
            }
            sqlBeanHelper = sqlBeanHelperMap.get(clazz);
            if (sqlBeanHelper == null) {
                sqlBeanHelper = new SqlBeanHelper<>(clazz, databaseHelper);
                sqlBeanHelperMap.put(clazz, sqlBeanHelper);
            }
        }
        return sqlBeanHelper;
    }

    private void initSqlBeanHelper(Class beanClazz) {
        new Thread(() -> {
            List classNames = PackageUtil.getClasses(context, beanClazz.getPackage().getName());
            try {
                for (String className : classNames) {
                    Class clazz = Class.forName(className);
                    SqlBeanHelper sqlBeanHelper = new SqlBeanHelper<>(clazz, databaseHelper);
                    sqlBeanHelperMap.put(clazz, sqlBeanHelper);
                    SqlTable sqlTable = SqlBeanUtil.getSqlTable(clazz);
                    //更新表结构
                    if (sqlTable != null && sqlTable.autoAlter()) {
                        Table table = SqlBeanUtil.getTable(clazz);
                        sqlBeanHelper.alter(table, sqlBeanHelper.getColumnInfoList(table.getName()));
                    }
                }
            } catch (ClassNotFoundException e) {
                e.printStackTrace();
                Log.e("sqlbean", e.getMessage(), e);
            }
        }).start();
    }

}