安卓简易日程表实现

最新推荐文章于 2024-05-13 21:01:08 发布

yogima

最新推荐文章于 2024-05-13 21:01:08 发布

阅读量8.7k

点赞数 19

分类专栏：安卓文章标签： android 日程表 CalendarView

本文链接：https://blog.csdn.net/yogima/article/details/90583579

版权

安卓专栏收录该内容

12 篇文章 0 订阅

订阅专栏

文章目录

一、前言

这次也没啥新的内容，本来准备用service的，但是接下去想做个打地鼠玩玩，这个就随便写了写。service的内容等之后有机会写吧。

二、运行截图与功能说明

功能主要实现：对日程的增删改查
大概就长这样：点击添加日程可以直接在该界面添加日程，点击某个日程则会跳转到另一个界面，可以进行删除和修改。
在这里插入图片描述

三、知识点与参考

1.数据库的操作

看我之前的一篇文章安卓之数据库（SQLite）

2.显示月日历

①布局文件中设置一个CalendarView

<CalendarView
	  android:id="@+id/calendarViewId"
	  android:layout_width="match_parent"
	  android:layout_height="match_parent"/>

②覆写setOnDateChangeListener

参考：日历视图（Calendarview）

3.给TextView添加点击事件

①设定TextView的clickable属性为true
xml文件中设置：android:clickable=“true”
java代码中设置：textView.setClickable(true);
②setOnClickListener
参考：Android 给TextView添加点击事件

四、完整代码

1.数据库有关的类MySQLiteOpenHelper

package com.example.yogi.mycalenderschedule;

import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.view.View;

public class MySQLiteOpenHelper extends SQLiteOpenHelper{
    private static final String db_name = "MySchedule";//自定义的数据库名；
    private static final int version = 1;//版本号

    public MySQLiteOpenHelper(Context context) {
        super(context, db_name, null, version);
    }

    // 该方法会自动调用，首先系统会检查该程序中是否存在数据库名为‘MySchedule’的数据库
    // 如果存在则不会执行该方法，如果不存在则会执行该方法。
    @Override
    public void onCreate(SQLiteDatabase db) {
        String  sql ="create table schedules(" +
                "id Integer primary key autoincrement," +     //id自增,只支持integer不支持int
                "scheduleDetail varchar(50)," +
                "time varchar(30)" +
                ")";
        db.execSQL(sql);
    }

    //数据库版本更新时执行该方法,如果表已存在则先删除再调用onCreate重新创建
    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        db.execSQL("drop table if exists schedules");
        onCreate(db);
    }

}

2.activity_main.xml

<?xml version="1.0" encoding="utf-8"?>
<android.support.constraint.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">

    <LinearLayout
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:orientation="vertical">

        <CalendarView
            android:id="@+id/calendar"
            android:layout_width="match_parent"
            android:layout_height="wrap_content">
        </CalendarView>

        <ScrollView
            android:layout_width="match_parent"
            android:layout_height="match_parent">

            <LinearLayout
                android:layout_width="match_parent"
                android:layout_height="wrap_content"
                android:orientation="vertical">

                <Button
                    android:id="@+id/addSchedule"
                    android:layout_width="match_parent"
                    android:layout_height="wrap_content"
                    android:text="添加日程" />

                <LinearLayout
                    android:layout_width="match_parent"
                    android:layout_height="wrap_content"
                    android:orientation="horizontal">

                    <EditText
                        android:id="@+id/scheduleDetailInput"
                        android:layout_width="290dp"
                        android:layout_height="wrap_content"
                        android:hint="请输入具体日程"
                        android:visibility="gone"/>

                    <Button
                        android:id="@+id/checkAdd"
                        android:layout_width="wrap_content"
                        android:layout_height="wrap_content"
                        android:text="确认添加"
                        android:visibility="gone"/>

                </LinearLayout>



                <TextView
                    android:id="@+id/schedule1"
                    android:layout_width="match_parent"
                    android:layout_height="wrap_content"
                    android:visibility="gone"
                    android:clickable="true"
                    android:textSize="30dp"
                    android:layout_marginLeft="20dp"/>

                <TextView
                    android:id="@+id/schedule2"
                    android:layout_width="match_parent"
                    android:layout_height="wrap_content"
                    android:visibility="gone"
                    android:clickable="true"
                    android:textSize="30dp"
                    android:layout_marginLeft="20dp"/>

                <TextView
                    android:id="@+id/schedule3"
                    android:layout_width="match_parent"
                    android:layout_height="wrap_content"
                    android:visibility="gone"
                    android:clickable="true"
                    android:textSize="30dp"
                    android:layout_marginLeft="20dp"/>

                <TextView
                    android:id="@+id/schedule4"
                    android:layout_width="match_parent"
                    android:layout_height="wrap_content"
                    android:visibility="gone"
                    android:clickable="true"
                    android:textSize="30dp"
                    android:layout_marginLeft="20dp"/>

                <TextView
                    android:id="@+id/schedule5"
                    android:layout_width="match_parent"
                    android:layout_height="wrap_content"
                    android:visibility="gone"
                    android:clickable="true"
                    android:textSize="30dp"
                    android:layout_marginLeft="20dp"/>

            </LinearLayout>

        </ScrollView>

        
    </LinearLayout>
    

</android.support.constraint.ConstraintLayout>

3.MainActivity

package com.example.yogi.mycalenderschedule;

import android.content.ContentValues;
import android.content.Context;
import android.content.Intent;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.support.v7.app.AppCompatActivity;
import android.os.Bundle;
import android.util.Log;
import android.view.View;
import android.widget.Button;
import android.widget.CalendarView;
import android.widget.EditText;
import android.widget.TextView;
import android.widget.Toast;

import java.util.Calendar;

public class MainActivity extends AppCompatActivity  implements View.OnClickListener{

    private CalendarView calendarView;
    private EditText scheduleInput;
    private Context context;
    private Button addSchedule,checkAdd;
    private String dateToday;//用于记录今天的日期
    private MySQLiteOpenHelper mySQLiteOpenHelper;
    private SQLiteDatabase myDatabase;
    private TextView mySchedule[] = new TextView[5];

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);

        initView();

        //这里不这样的话一进去就设置当天的日程会报错
        Calendar time = Calendar.getInstance();
        int year = time.get(Calendar.YEAR);
        int month = time.get(Calendar.MONTH)+1;//注意要+1，0表示1月份
        int day = time.get(Calendar.DAY_OF_MONTH);
        dateToday = year+"-"+month+"-"+day;
        //还要直接查询当天的日程，这个要放在initView的后面，不然会出问题
        queryByDate(dateToday);
    }

    private void initView() {
        mySQLiteOpenHelper = new MySQLiteOpenHelper(this);
        myDatabase = mySQLiteOpenHelper.getWritableDatabase();

        context = this;
        addSchedule = findViewById(R.id.addSchedule);
        addSchedule.setOnClickListener(this);
        checkAdd = findViewById(R.id.checkAdd);
        checkAdd.setOnClickListener(this);

        calendarView = findViewById(R.id.calendar);
        scheduleInput = findViewById(R.id.scheduleDetailInput);

        calendarView.setOnDateChangeListener(mySelectDate);

        mySchedule[0] = findViewById(R.id.schedule1);
        mySchedule[1] = findViewById(R.id.schedule2);
        mySchedule[2] = findViewById(R.id.schedule3);
        mySchedule[3] = findViewById(R.id.schedule4);
        mySchedule[4] = findViewById(R.id.schedule5);
        for(TextView v:mySchedule){
            v.setOnClickListener(this);
        }
    }

    private CalendarView.OnDateChangeListener mySelectDate = new CalendarView.OnDateChangeListener() {
        @Override
        public void onSelectedDayChange(CalendarView view, int year, int month, int dayOfMonth) {
            dateToday = year+"-"+(month+1)+"-"+dayOfMonth;
            Toast.makeText(context, "你选择了:"+dateToday, Toast.LENGTH_SHORT).show();

            //得把用别的日期查出来的日程删除并将其隐藏
            for(TextView v:mySchedule){
                v.setText("");
                v.setVisibility(View.GONE);
            }
            queryByDate(dateToday);
        }
    };

    //根据日期查询日程
    private void queryByDate(String date) {
        //columns为null 查询所有列
        Cursor cursor = myDatabase.query("schedules",null,"time=?",new String[]{date},null,null,null);
        if(cursor.moveToFirst()){
            int scheduleCount = 0;
            do{
                String aScheduleDetail = cursor.getString(cursor.getColumnIndex("scheduleDetail"));
                mySchedule[scheduleCount].setText("日程"+(scheduleCount+1)+"："+aScheduleDetail);
                mySchedule[scheduleCount].setVisibility(View.VISIBLE);
                scheduleCount++;
                //一定要有这句 不然TextView不够多要数组溢出了
                if(scheduleCount >= 5)
                    break;
            }while (cursor.moveToNext());
        }
        cursor.close();
    }

    @Override
    public void onClick(View v) {
        switch (v.getId()){
            case R.id.addSchedule:
                addMySchedule();
                break;
            case R.id.checkAdd:
                checkAddSchedule();
                break;
            case R.id.schedule1:case R.id.schedule2:case R.id.schedule3:case R.id.schedule4:case R.id.schedule5:
                editSchedule(v);
                break;
        }
    }

    private void editSchedule(View v) {
        Intent intent = new Intent(MainActivity.this, EditScheduleActivity.class);
        String sch = ((TextView) v).getText().toString().split("：")[1];
        intent.putExtra("schedule",sch);
        startActivity(intent);
    }

    private void checkAddSchedule() {
        ContentValues values = new ContentValues();
        //第一个参数是表中的列名
        values.put("scheduleDetail",scheduleInput.getText().toString());
        values.put("time",dateToday);
        myDatabase.insert("schedules",null,values);
        scheduleInput.setVisibility(View.GONE);
        checkAdd.setVisibility(View.GONE);
        queryByDate(dateToday);
        //添加完以后把scheduleInput中的内容清除
        scheduleInput.setText("");
    }

    private void addMySchedule() {
        scheduleInput.setVisibility(View.VISIBLE);
        checkAdd.setVisibility(View.VISIBLE);
    }
}

4.用于删除和修改的Activity的布局activity_edit_schedule.xml

<?xml version="1.0" encoding="utf-8"?>
<android.support.constraint.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=".EditScheduleActivity">

    <LinearLayout
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:orientation="vertical">

        <Button
            android:id="@+id/deleteSchedule"
            android:layout_width="match_parent"
            android:layout_height="wrap_content"
            android:text="删除该日程"/>

        <LinearLayout
            android:layout_width="match_parent"
            android:layout_height="wrap_content"
            android:orientation="horizontal"
            android:layout_marginVertical="20dp">

            <EditText
                android:id="@+id/scheduleInput"
                android:layout_width="290dp"
                android:layout_height="wrap_content" />

            <Button
                android:id="@+id/editBtn"
                android:layout_width="wrap_content"
                android:layout_height="wrap_content"
                android:text="确认修改"/>

        </LinearLayout>




    </LinearLayout>
</android.support.constraint.ConstraintLayout>

5.EditScheduleActivity

package com.example.yogi.mycalenderschedule;

import android.content.ContentValues;
import android.content.Intent;
import android.database.sqlite.SQLiteDatabase;
import android.support.v7.app.AppCompatActivity;
import android.os.Bundle;
import android.view.View;
import android.widget.Button;
import android.widget.EditText;

public class EditScheduleActivity extends AppCompatActivity  implements View.OnClickListener{

    private String schedule;
    private Button editBtn,deleteBtn;
    private EditText scheduleInput;
    private MySQLiteOpenHelper mySQLiteOpenHelper;
    private SQLiteDatabase myDatabase;

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_edit_schedule);

        // 首先获取到意图对象
        Intent intent = getIntent();
        // 获取到传递过来的姓名
        schedule = intent.getStringExtra("schedule");

        initView();
    }

    private void initView() {
        mySQLiteOpenHelper = new MySQLiteOpenHelper(this);
        myDatabase = mySQLiteOpenHelper.getWritableDatabase();

        editBtn = findViewById(R.id.editBtn);
        editBtn.setOnClickListener(this);
        deleteBtn = findViewById(R.id.deleteSchedule);
        deleteBtn.setOnClickListener(this);
        scheduleInput = findViewById(R.id.scheduleInput);
        scheduleInput.setText(schedule);
    }

    @Override
    public void onClick(View v){
        switch (v.getId()){
            case R.id.deleteSchedule:
                deleteMySchedule();
                break;
            case R.id.editBtn:
                editSchedule();
                break;
        }
    }

    private void editSchedule() {
        ContentValues values = new ContentValues();
        values.put("scheduleDetail",scheduleInput.getText().toString());

        myDatabase.update("schedules",values,"scheduleDetail=?",new String[]{schedule});

        Intent intent = new Intent(EditScheduleActivity.this, MainActivity.class);
        startActivity(intent);
    }

    private void deleteMySchedule() {
        myDatabase.delete("schedules","scheduleDetail=?",new String[]{schedule});

        Intent intent = new Intent(EditScheduleActivity.this, MainActivity.class);
        startActivity(intent);
    }
}

yogima

关注

19
点赞
踩
92

收藏

觉得还不错? 一键收藏
4
评论
安卓简易日程表实现

文章目录一、前言二、运行截图与功能说明三、知识点与参考1.数据库的操作2.显示月日历3.给TextView添加点击事件四、完整代码1.数据库有关的类MySQLiteOpenHelper2.activity_main.xml3.MainActivity4.用于删除和修改的Activity的布局activity_edit_schedule.xml5.EditScheduleActivity一、前言...
复制链接

扫一扫