Android Room数据库多表查询的使用实例
作者:人言落日是天涯 时间:2022-11-07 02:49:49
Android-Room数据库(介绍)
前言
在SQLite数据库中,我们可以指定对象之间的关系,因此我们可以将一个或多个对象与一个或多个其他对象绑定。这就是所谓的一对多和多对多的关系。
既然要多表查询,所以表之间就得有关联。这时候我们就得使用新的注解符@ForeignKey
接下来的内容,就需要上节的内容了
@Entity
public class Company {
@PrimaryKey(autoGenerate = true)
private int id;
private String name;
private int age;
private String address;
private double salary;
public Company(String name, int age, String address, double salary) {
this.name = name;
this.age = age;
this.address = address;
this.salary = salary;
}
//省略了getter/setter方法
}
下面我们再新建一个与之关联的表
@Entity(foreignKeys = @ForeignKey(entity = Company.class,parentColumns = "id",childColumns = "emp_id",onDelete = CASCADE),
indices = @Index(value={"emp_id"},unique = true))
public class Department {
@PrimaryKey(autoGenerate = true)
private int id;
private String dept;
@ColumnInfo(name = "emp_id")
private int empId;
public Department(String dept, int empId) {
this.dept = dept;
this.empId = empId;
}
//省略了getter/setter方法
}
这里我使用了@ForeignKey关联了company表,主键id,外键emp_id,紧接着使用了indices创建了唯一索引。
下面就是创建Dao
@Dao
public interface CompanyDao {
@Query("SELECT * FROM company")
List<Company> getAllCompany();
}
@Dao
public interface DepartmentDao {
@Query("SELECT * FROM department")
List<Department> getAllDepartment();
//使用内连接查询
@Query("SELECT emp_id,name,dept from company INNER JOIN department ON Company.id=Department.emp_id")
List<InnerJoinResult> getDepartmentFromCompany();
}
最后就是创建Database
@Database(entities = {Department.class, Company.class}, version = 1, exportSchema = false)
public abstract class DepartmentDatabase extends RoomDatabase {
public static final String DB_NAME = "CompanyDatabase.db";
private static volatile DepartmentDatabase instance;
public static synchronized DepartmentDatabase getInstance(Context context) {
if (instance == null) {
instance = create(context);
}
return instance;
}
private static DepartmentDatabase create(final Context context) {
return Room.databaseBuilder(
context,
DepartmentDatabase.class,
DB_NAME).allowMainThreadQueries().build();
}
public abstract DepartmentDao getDepartmentDao();
public abstract CompanyDao getCompanyDao();
}
这里我想大家经过之前的文章介绍都很熟悉了吧。这里就不多解释了,不记得的,请看之前的文章。
具体使用
List<Company> list = new ArrayList<>();
Company company = new Company("Paul",32,"California",20000.0);
list.add(company);
company = new Company("Allen",25,"Texas",15000.0);
list.add(company);
company = new Company("Teddy",23,"Norway",20000.0);
list.add(company);
company = new Company("Mark",25,"Rich-Mond",65000.0);
list.add(company);
company = new Company("David",27,"Texas",85000.0);
list.add(company);
company = new Company("Kim",22,"South-Hall",45000.0);
list.add(company);
company = new Company("James",24,"Houston",10000.0);
list.add(company);
List<Department> departmentList = new ArrayList<>();
Department department = new Department("IT Billing",1);
departmentList.add(department);
department = new Department("Engineerin",2);
departmentList.add(department);
department = new Department("Finance",7);
departmentList.add(department);
DepartmentDatabase.getInstance(this)
.getCompanyDao().insert(list);
DepartmentDatabase.getInstance(this)
.getDepartmentDao().insert(departmentList);
这样我们就把需要的数据插入到数据库了,下面我们查询一下,看看有没有插入成功。
查询代码如下:
List<Company> company = DepartmentDatabase.getInstance(this).getCompanyDao().getAllCompany();
LogUtil.debug("Company----->" + company.size());
for (Company result : company) {
LogUtil.debug("result--->" + result.getName() + " " + result.getAge()+" "+result.getAddress()+" "+result.getSalary());
}
List<Department> department = DepartmentDatabase.getInstance(this).getDepartmentDao().getAllDepartment();
LogUtil.debug("Department----->" + department.size());
for (Department result : department) {
LogUtil.debug("result--->" + result.getDept() + " " + result.getEmpId());
}
这样看来是插入成功了的。。。
来源:https://www.jianshu.com/p/f4923374885b
标签:Android,Room数据库
0
投稿
猜你喜欢
DecimalFormat多种用法详解
2022-11-13 15:06:52
mybatis insert foreach循环插入方式
2023-10-15 22:32:53
Android中ListView分页加载数据功能实现
2022-04-09 08:36:12
C#实现简单串口通讯实例
2022-06-18 11:29:42
Android开发之使用150行代码实现滑动返回效果
2023-03-20 11:08:50
idea2017建立jsp工程及tomcat配置教程
2023-06-04 20:24:40
Java实现的两个线程同时运行案例
2023-05-14 09:10:40
Java Spring MVC 上传下载文件配置及controller方法详解
2023-11-22 04:13:59
用Newtonsoft将json串转为对象的方法(详解)
2022-12-31 23:32:21
Android 自定义底部上拉控件的实现方法
2023-08-18 18:41:19
java复制文件和java移动文件的示例分享
2023-09-17 08:18:06
手把手教你SpringBoot过滤器N种注册方式
2023-08-08 08:28:45
Android本地验证码的生成代码
2023-05-03 18:44:02
Android高级图片滚动控件实现3D版图片轮播器
2022-03-14 23:36:30
C#异步编程之async/await详解
2022-10-08 02:50:07
Java 实战项目之仓库管理系统的实现流程
2021-10-05 09:14:07
Java中如何快速构建项目脚手架的实现
2023-10-30 03:37:50
Android开发5:应用程序窗口小部件App Widgets的实现(附demo)
2023-04-22 20:15:36
Android开发实现查询远程服务器的工具类QueryUtils完整实例
2021-11-06 14:57:10
Spring Security 实现用户名密码登录流程源码详解
2023-05-31 11:13:59