【Android】家庭记账本手机版开发报告一

一、说在前面

昨天	学习了数据库的一些简单操作
今天	使用数据库，完成对记账本的账单记录的增删
问题	没有

二、数据库

1、账单表的结构

（注 id：账单的唯一标识，uid：记录账单的用户的id，cost_time：记录账单的时间，cost_type：账单类型，cost_money：账单金额。）

2、Entity：AccountRecord.java

package com.me.familybookkeepingbook;

import androidx.room.ColumnInfo;

import androidx.room.Entity;

import androidx.room.PrimaryKey;

@Entity

public class AccountRecord {

    @PrimaryKey(autoGenerate = true)

    private int id;

    @ColumnInfo(name = "uid")

    private int uid;

    @ColumnInfo(name = "cost_time")

    private String costTime;

    @ColumnInfo(name = "cost_type")

    private String costType;

    @ColumnInfo(name = "cost_money")

    private Double costMoney;

    public AccountRecord(int uid, String costTime, String costType, Double costMoney) {

        this.uid = uid;

        this.costTime = costTime;

        this.costType = costType;

        this.costMoney = costMoney;

    }

    public int getId() {

        return id;

    }

    public void setId(int id) {

        this.id = id;

    }

    public int getUid() {

        return uid;

    }

    public void setUid(int uid) {

        this.uid = uid;

    }

    public String getCostTime() {

        return costTime;

    }

    public void setCostTime(String costTime) {

        this.costTime = costTime;

    }

    public String getCostType() {

        return costType;

    }

    public void setCostType(String costType) {

        this.costType = costType;

    }

    public Double getCostMoney() {

        return costMoney;

    }

    public void setCostMoney(Double costMoney) {

        this.costMoney = costMoney;

    }

}

3、对数据库的操作：AccountRecordDao.java

package com.me.familybookkeepingbook;

import androidx.room.Dao;

import androidx.room.Delete;

import androidx.room.Insert;

import androidx.room.Query;

import androidx.room.Update;

import java.util.List;

@Dao

public interface AccountRecordDao {

    @Insert

    void insertAccountRecord (AccountRecord ... AccountRecords);

    @Update

    void updateAccountRecord (AccountRecord ... AccountRecords);

    @Delete

    void deleteAccountRecord (AccountRecord ... AccountRecords);

    @Query("DELETE From ACCOUNTRECORD")

    void deleteAllAccountRecord ();

    @Query("SELECT * From ACCOUNTRECORD ORDER BY ID DESC")

    List<AccountRecord> getAllAccountRecord ();

}

AccountRecordDatabase.java

package com.me.familybookkeepingbook;

import androidx.room.Database;

import androidx.room.RoomDatabase;

@Database(entities = {AccountRecord.class },version = 1,exportSchema = false)

public abstract class AccountRecordDatabase extends RoomDatabase {

    public abstract AccountRecordDao getAccountRecordDao();

}

三、界面布局

<?xml version="1.0" encoding="utf-8"?>

<androidx.constraintlayout.widget.ConstraintLayout xmlns:android="http://schemas.android.com/apk/res/android"

    xmlns:app="http://schemas.android.com/apk/res-auto"

    xmlns:tools="http://schemas.android.com/tools"

    android:layout_width="match_parent"

    android:layout_height="match_parent"

    tools:context=".MainActivity">

    <androidx.constraintlayout.widget.Guideline

        android:id="@+id/guideline"

        android:layout_width="wrap_content"

        android:layout_height="wrap_content"

        android:orientation="horizontal"

        app:layout_constraintGuide_percent="0.8" />

    <ScrollView

        android:layout_width="0dp"

        android:layout_height="0dp"

        android:layout_marginStart="1dp"

        android:layout_marginLeft="1dp"

        android:layout_marginEnd="1dp"

        android:layout_marginRight="1dp"

        app:layout_constraintBottom_toTopOf="@+id/guideline"

        app:layout_constraintEnd_toEndOf="parent"

        app:layout_constraintHorizontal_bias="0.0"

        app:layout_constraintStart_toStartOf="parent"

        app:layout_constraintTop_toTopOf="parent">

        <TextView

            android:id="@+id/textView"

            android:layout_width="match_parent"

            android:layout_height="wrap_content"

            android:text="@string/textview"

            android:textSize="24sp" />

    </ScrollView>

    <Button

        android:id="@+id/buttonInsert"

        android:layout_width="wrap_content"

        android:layout_height="wrap_content"

        android:text="@string/buttonInsert"

        app:layout_constraintBottom_toBottomOf="parent"

        app:layout_constraintEnd_toStartOf="@+id/buttonDelete"

        app:layout_constraintHorizontal_bias="0.5"

        app:layout_constraintStart_toStartOf="parent"

        app:layout_constraintTop_toTopOf="@+id/guideline" />

    <Button

        android:id="@+id/buttonDelete"

        android:layout_width="wrap_content"

        android:layout_height="wrap_content"

        android:text="@string/buttonDalete"

        app:layout_constraintBottom_toBottomOf="@+id/buttonInsert"

        app:layout_constraintEnd_toEndOf="parent"

        app:layout_constraintHorizontal_bias="0.5"

        app:layout_constraintStart_toEndOf="@+id/buttonInsert"

        app:layout_constraintTop_toTopOf="@+id/buttonInsert" />

</androidx.constraintlayout.widget.ConstraintLayout>

四、界面和数据的绑定

1、界面的更新

void updateView(){

        List<AccountRecord> list = accountRecordDao.getAllAccountRecord();

        String text = "";

        for (int i=0;i<list.size();i++){

            AccountRecord accountRecord = list.get(i);

            text += accountRecord.getId() + "   " + accountRecord.getCostType() + "   "+accountRecord.getCostTime() +"   "+

                    accountRecord.getCostMoney() +"\n";

        }

        textView.setText(text);

    }

2、按键的监听

 buttonInsert.setOnClickListener(new View.OnClickListener() {

            @Override

            public void onClick(View v) {

                AccountRecord accountRecord = new AccountRecord(1,"2020-01-26","学习",100.0);

                accountRecordDao.insertAccountRecord(accountRecord);

                updateView();

            }

        });

        buttonDelete.setOnClickListener(new View.OnClickListener() {

            @Override

            public void onClick(View v) {

                accountRecordDao.deleteAllAccountRecord();

                updateView();

            }

        });

巴特西

【Android】家庭记账本手机版开发报告一

一、说在前面

二、数据库

1、账单表的结构

2、Entity：AccountRecord.java

3、对数据库的操作：AccountRecordDao.java

AccountRecordDatabase.java

三、界面布局

四、界面和数据的绑定

1、界面的更新

2、按键的监听

五、运行测试

1、插入：

2、删除

最新文章

热门文章