3.21

个人开发作业 一些工具类

package com.example.my2mysql.tool;

import android.content.Context;
import android.view.LayoutInflater;
import android.view.View;
import android.view.ViewGroup;
import android.widget.ArrayAdapter;
import android.widget.TextView;

import androidx.annotation.NonNull;
import androidx.annotation.Nullable;

import com.example.my2mysql.Pojo.Plan;
import com.example.my2mysql.R;

import java.util.List;

public  class MyAdapter extends ArrayAdapter<Plan> {
    private Context context;

    public MyAdapter(Context context, List<Plan> data) {
        super(context, 0, data);
        this.context = context;
    }

    @NonNull
    @Override
    public View getView(int position, @Nullable View convertView, @NonNull ViewGroup parent) {
        View listItemView = convertView;
        if (listItemView == null) {
            listItemView = LayoutInflater.from(getContext()).inflate(R.layout.list_item, parent, false);
        }

        Plan currentPlan = getItem(position);

        TextView dataid = listItemView.findViewById(R.id.dataid);
        TextView datastarttime = listItemView.findViewById(R.id.datastarttime);
        TextView dataendtime = listItemView.findViewById(R.id.dataendtime);
        TextView dataisdone = listItemView.findViewById(R.id.dataisdone);

        if (currentPlan != null) {
            dataid.setText(String.valueOf(currentPlan.getId()));
            datastarttime.setText(currentPlan.getStartdate());
            dataendtime.setText(currentPlan.getEnddate());
            dataisdone.setText(currentPlan.getIsdone());
        }

        return listItemView;
    }
}

package com.example.my2mysql.Pojo;

import android.content.Context;
import android.database.sqlite.SQLiteDatabase;

import com.example.my2mysql.tool.SQLiteOpenHelper;

public class DatabaseHelper extends SQLiteOpenHelper {
    private static final String DATABASE_NAME = "plans.db";
    private static final int DATABASE_VERSION = 1;

    public DatabaseHelper(Context context) {
        super(context, DATABASE_NAME, null, DATABASE_VERSION);
    }

    @Override
    public void onCreate(SQLiteDatabase db) {
        db.execSQL("CREATE TABLE plans (id INTEGER PRIMARY KEY, startdate TEXT, enddate TEXT, isdone TEXT)");
    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        db.execSQL("DROP TABLE IF EXISTS plans");
        onCreate(db);
    }
}