对象关系型数据库
-
GreenDao 是一个数据库框架 也是注解型的框架
-
通过注解可以直接吧java的实体类直接创建成数据库
-
如何配置GreenDao:
-
在项目的build.grade文件buildscript标签下dependencies标签里加入一行代码:
-
classpath 'org.greenrobot:greendao-gradle-plugin:3.2.0'
-
在app的build.grade顶部里面加上代码
-
apply plugin: 'org.greenrobot.greendao'
-
在app的build.grad里面Android{}里加上代码:
-
`greendao{
-
schemaVersion 1 //指定数据库schema版本号,迁移等操作会用到
-
//包名是活的这是变动的
-
daoPackage ‘soexample.umeng.com.greendaodemo.mydao’ //dao的包名,包名默认是entity所在的包;
-
targetGenDir ‘src/main/java’//生成数据库文件的目录
-
}`
-
在自己的modle里导入依赖:
-
implementation 'org.greenrobot:greendao:3.2.0' implementation 'org.greenrobot:greendao-generator:3.2.0'
需要新建一个实体类 通过@Entity -
通过锤子(make Project)
-
- 1:DaoMaster
-
2:DaoSession
-
3:StudentDao
新建一个application:
package com.example.ap4;
import android.app.Application;
import android.database.sqlite.SQLiteDatabase;
/**
* 用来配置数据库
*/
public class MyApp extends Application {
private static DaoSession mDaoSession;
@Override
public void onCreate() {
super.onCreate();
initGreenDao();
}
private void initGreenDao() {
//第一步创建OpenHelper类
DaoMaster.DevOpenHelper openHelper = new DaoMaster.DevOpenHelper(this, "lxx.db");
//开启一个可写数据库类
SQLiteDatabase writableDatabase = openHelper.getWritableDatabase();
//通过DaoMaster封装
DaoMaster master = new DaoMaster(writableDatabase);
mDaoSession = master.newSession();
}
public static DaoSession getDaoSession() {
return mDaoSession;
}
}
bean类:
package com.example.ap4.bean;
import org.greenrobot.greendao.annotation.Entity;
import org.greenrobot.greendao.annotation.Id;
import org.greenrobot.greendao.annotation.Generated;
@Entity
public class MyStudent {
//主键自增
@Id(autoincrement = true)
private Long id;
private String name;
private String sex;
private int age;
public MyStudent( String name, String sex, int age) {
this.name = name;
this.sex = sex;
this.age = age;
}
@Generated(hash = 1927847488)
public MyStudent() {
}
@Generated(hash = 1533596811)
public MyStudent(Long id, String name, String sex, int age) {
this.id = id;
this.name = name;
this.sex = sex;
this.age = age;
}
public Long getId() {
return this.id;
}
public void setId(Long id) {
this.id = id;
}
public String getName() {
return this.name;
}
public void setName(String name) {
this.name = name;
}
public String getSex() {
return this.sex;
}
public void setSex(String sex) {
this.sex = sex;
}
public int getAge() {
return this.age;
}
public void setAge(int age) {
this.age = age;
}
}
package com.example.ap4;
import android.os.Bundle;
import android.support.v7.app.AppCompatActivity;
import android.view.View;
import android.widget.Button;
import android.widget.TextView;
import android.widget.Toast;
import com.example.ap4.bean.MyStudent;
import java.util.List;
/**
* 对象关系型数据库
* GreenDao 是一个数据库框架 也是注解型的框架
* 通过注解可以直接吧java的实体类直接创建成数据库
* 如何配置GreenDao
* 1:在项目的build.grade文件里加入一行代码 classpath 'org.greenrobot:greendao-gradle-plugin:3.2.0'
* 2:在app的build.grade里面加上代码 apply plugin: 'org.greenrobot.greendao'
* 3:在app的build.grad里面Android{}里加上代码
* greendao{
* schemaVersion 1 //指定数据库schema版本号,迁移等操作会用到
* //包名是活的这是变动的
* daoPackage 'soexample.umeng.com.greendaodemo.mydao' //dao的包名,包名默认是entity所在的包;
* targetGenDir 'src/main/java'//生成数据库文件的目录
* }
* 4:导入依赖
* 需要新建一个实体类 通过@Entity
* 通过锤子(make Project)
* 1:DaoMaster
* 2:DaoSession
* 3:StudentDao
* <p>
* 查看当前市面上有多少开源框架 数据库的
* ORMLite 数据框架 GreenDao Facebook推出的Stetho
*/
public class MainActivity extends AppCompatActivity implements View.OnClickListener {
private MyStudentDao mStuDao;
private Button Insert_Btn;
private Button Delete_Btn;
private Button Update_Btn;
private Button Select_Btn;
private TextView Get_Content;
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
initView();
mStuDao = MyApp.getDaoSession().getMyStudentDao();
}
//插入数据
private void insertStu() {
MyStudent student = new MyStudent("李广强", "丑八怪", 38);
long insert = mStuDao.insert(student);
if (insert > 0) {
Toast.makeText(this, "插入成功", Toast.LENGTH_SHORT).show();
}
}
//删除数据 删除必须要删除数据库里面存在的数据
private void deleteStu() {
mStuDao.deleteByKey(1l);
Toast.makeText(this, "删除成功", Toast.LENGTH_SHORT).show();
}
//修改数据
private void updateStu() {
//修改必须要修改数据库里面存在的数据
MyStudent student = mStuDao.load(1l);
student.setAge(3);
student.setName("wwd");
student.setSex("奇丑无比");
mStuDao.update(student);
}
//查询数据
private void selectStu() {
//查询所有数据
Get_Content.setText("");
List<MyStudent> students = mStuDao.loadAll();
for(int i=0;i<students.size();i++)
{
Get_Content .setText(students.get(i).getName()+"");
}
}
private void initView() {
Insert_Btn = (Button) findViewById(R.id.Insert_Btn);
Delete_Btn = (Button) findViewById(R.id.Delete_Btn);
Update_Btn = (Button) findViewById(R.id.Update_Btn);
Select_Btn = (Button) findViewById(R.id.Select_Btn);
Get_Content = (TextView) findViewById(R.id.Get_Content);
Insert_Btn.setOnClickListener(this);
Delete_Btn.setOnClickListener(this);
Update_Btn.setOnClickListener(this);
Select_Btn.setOnClickListener(this);
}
@Override
public void onClick(View v) {
switch (v.getId()) {
case R.id.Insert_Btn:
insertStu();
break;
case R.id.Delete_Btn:
deleteStu();
break;
case R.id.Update_Btn:
updateStu();
break;
case R.id.Select_Btn:
selectStu();
break;
}
}
}