package com.doumee.keyCabinet.dao;
|
|
import androidx.room.Dao;
|
import androidx.room.Delete;
|
import androidx.room.Insert;
|
import androidx.room.Query;
|
import androidx.room.Transaction;
|
import androidx.room.Update;
|
|
import java.util.List;
|
|
@Dao
|
public interface FingerPrintDao {
|
|
@Transaction
|
@Query("SELECT * FROM finger_print")
|
List<FingerPrintDo> loadAll();
|
|
@Transaction
|
@Query("SELECT * FROM finger_print WHERE id = :id")
|
FingerPrintDo getFingerById(int id);
|
|
@Transaction
|
@Query("SELECT * FROM finger_print WHERE member_id = :memberId")
|
List<FingerPrintDo> getFingerByMemberId(int memberId);
|
|
@Transaction
|
@Query("SELECT * FROM finger_print WHERE finger_id = :fingerId")
|
FingerPrintDo getByFingerId(int fingerId);
|
|
@Transaction
|
@Insert
|
void insert(FingerPrintDo data);
|
|
@Transaction
|
@Insert
|
void insertAll(FingerPrintDo... datas);
|
|
@Transaction
|
@Insert
|
void insert(List<FingerPrintDo> studentLists);
|
|
@Transaction
|
@Update
|
void update(FingerPrintDo... datas);
|
|
@Transaction
|
@Delete
|
void delete(FingerPrintDo... datas);
|
}
|
