Android面向对象ORM数据库框架SmartSQLite

A very fast, cool, small, powerful,easy use ORM SQLite framework for Android. You can use it to add,delete,update,query sqlite by object entity,just a singleLine of code to make it Efficient.It's powerful and easy use than GreenDao,ActiveAndroid and so on.

SmartSQLite是一款强大的ORM数据库（对象关系映射，英语：Object Relational Mapping，简称ORM，或O/RM，或O/R mapping），灵感来源：因为Android每次编写数据库太麻烦，操作也麻烦，数据库升级也非常麻烦，目前的数据库框架用起来非常麻烦，效率低，如GreenDao、ActiveAndroid等，所以决定按照面向对象ORM思想自己写一个高效的库，这应该是目前Android最强大，效率最高的，学习成本最低的数据库框架了吧？那么有多么强大呢？

1.SmartSQLite功能简介

• 全自动升级，你无须再关心数据库版本号以及数据库复杂的升级逻辑了
  
• 自动检测创建和删除表
  
• 自动检测创建字段，增加字段
  
• 项目中的实体类就可以当作数据库表的实体类，直接使用增删改查全支持自动映射
  
• 支持多数据库
  
• 单例模式，无需再自己关闭打开数据库，无需担心内存泄漏了
  
• 自动检测识别类型，支持int,string,boolean,float,double,long类型，其它类型后续将会
  扩展
  
• 查询数据自动构建成对象，无需编写复杂的逻辑
  
• 无需使用SQL语句
  
• 支持模糊查询和分页查询等
  

2.SmartSQLite基本用法

引用库：

allprojects {repositories {...maven { url 'https://www.jitpack.io' }}}

 compile 'com.github.jaychou2012:SmartSQLite:1.0.0.3'

①创建实体类，例如在entity文件夹新建一个Student类，只需继承TableObject，如果实体无法继承，请看Demo的第二种方案，实现接口TableEntity即可：

public class Student extends TableObject {    private int id;    private String name;    private boolean high;    private long timeLong;    private float timeFloat;    private double timeDouble;    public boolean isHigh() {        return high;    }    public void setHigh(boolean high) {        this.high = high;    }    public int getId() {        return id;    }    public void setId(int id) {        this.id = id;    }    public String getName() {        return name;    }    public void setName(String name) {        this.name = name;    }    public long getTimeLong() {        return timeLong;    }    public void setTimeLong(long timeLong) {        this.timeLong = timeLong;    }    public float getTimeFloat() {        return timeFloat;    }    public void setTimeFloat(float timeFloat) {        this.timeFloat = timeFloat;    }    public double getTimeDouble() {        return timeDouble;    }    public void setTimeDouble(double timeDouble) {        this.timeDouble = timeDouble;    }}

②新建BaseApplication，进行相关初始化全局配置：

public class BaseApplication extends Application {    @Override    public void onCreate() {        super.onCreate();        initConfig();    }    private void initConfig() {        SmartConfig.DB_NAME = "smartsqlite.db";//必填        SmartConfig.DB_VERSION = 1;//选填，推荐写        SmartConfig.ENTITY_PACKAGE = "entity";//默认为entity        List<String> classNameList = new ArrayList<String>();//数据库表集合，也就是实体类名称集合        classNameList.add("Student");        classNameList.add("Teacher");        SmartConfig.classes = classNameList;//赋值        SmartSQLite.initSmartSQLite(this);//自动初始化，全自动升级数据库，检测创建表，增加字段，删除表等    }}

③使用：

private void initView() {        Student student = new Student();        student.setId(2);        student.setName("名字名字1");        student.setHigh(true);        student.setTimeDouble(200);        student.setTimeFloat(200.0f);        student.setTimeLong(200);        student.save(this);//        student.update(this, "id");//        student.delete(this,"id");        List<Student> list = student.getDatas(this, Student.class);//        List<Student> list = SmartSQLite.getInstance(this).getDatas(Student.class);        for (int i = 0; i < list.size(); i++) {            Student stu = list.get(i);            Log.i("info", "信息：" + stu.getId() + "  " + stu.getName() + "  " + stu.isHigh() + "  " + stu.getTimeDouble() + "  " + stu.getTimeFloat() + "  " + stu.getTimeLong());        }        Teacher teacher = new Teacher();        teacher.setId(0);        teacher.setName("教师");        teacher.save(this);        List<Teacher> listTeacher = teacher.getDatas(this, Teacher.class);        for (int i = 0; i < listTeacher.size(); i++) {            Teacher teach = listTeacher.get(i);            Log.i("info", "信息：" + teach.getId() + "  " + teach.getName());        }        SmartSQLite.getInstance(this).queryDatas(Student.class, "id", "0");        SmartSQLite.getInstance(this).queryBlurryDatas(Student.class, "name", "名字");        SmartSQLite.getInstance(this).queryPagingDatas(Student.class, new String[]{"name"}, new String[]{"名字"}, 0, 10);        SmartSQLite.getInstance(this).queryBlurryPagingDatas(Student.class, "name", "名字", 0, 10);    }

支持增删改查，后续会优化扩展更多功能

Github地址：https://github.com/jaychou2012/SmartSQLiteDemo

框架作者：谭东