7.19作业1

helper

package com.example.month7day19.evening1.Helpers;

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

public class MyHelper extends SQLiteOpenHelper {
public MyHelper(Context context,String name,SQLiteDatabase.CursorFactory factory, int version) {
super(context, name, factory, version);
}

@Override
public void onCreate(SQLiteDatabase db) {
    db.execSQL("create table student(id integer primary key autoincrement,name varchar(20),age int)");
}

@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {

}

}

activety

package com.example.month7day19.evening1;

import android.app.AlertDialog;
import android.app.Dialog;
import android.content.DialogInterface;
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.AdapterView;
import android.widget.ArrayAdapter;
import android.widget.ListView;
import android.widget.Toast;

import com.example.month7day19.R;
import com.example.month7day19.evening1.Helpers.MyHelper;
import com.example.month7day19.evening1.fragment.EP_fragment_gravity;

import java.util.ArrayList;
import java.util.List;

public class EP_activity extends AppCompatActivity {
private MyHelper mh;
private SQLiteDatabase db;
private ListView lv;
private List list=new ArrayList<>();
private ArrayAdapter aaaa;
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_ep_activity);

    mh=new MyHelper(this,"student.db",null,1);
    db=mh.getReadableDatabase();
    lv=findViewById(R.id.EP_activity);

    for (int i = 0; i < 10; i++) {
        db.execSQL("insert into student values(null,'丁铃当啷"+i+"',"+(i+1)+")");
    }

    lv.setOnItemLongClickListener(new AdapterView.OnItemLongClickListener() {
        @Override
        public boolean onItemLongClick(AdapterView<?> parent, View view, final int position, long id) {
            AlertDialog.Builder builder = new AlertDialog.Builder(EP_activity.this);
            builder.setTitle("提示");
            builder.setMessage("是否确认删除？");
            builder.setPositiveButton("确定", new DialogInterface.OnClickListener() {
                @Override
                public void onClick(DialogInterface dialog, int which) {
                    Log.i("123321", "onClick: "+position);
                    list.remove(position);

// ArrayAdapter aaaa = new ArrayAdapter(EP_activity.this, R.layout.support_simple_spinner_dropdown_item, list);
// lv.setAdapter(aaaa);
aaaa.notifyDataSetChanged();
}
});
builder.show();
return false;
}
});

    mySelect( );

}

private void mySelect() {
    String sql="select * from student";
    Cursor cursor = db.rawQuery(sql, null);
    if( cursor!=null){
        while( cursor.moveToNext()){
            String name = cursor.getString(cursor.getColumnIndex("name"));
            int id = cursor.getInt(cursor.getColumnIndex("id"));
            int age = cursor.getInt(cursor.getColumnIndex("age"));
            String str="id:"+id+"\tname:"+name+"\tage:"+age;
            list.add(str);
        }
        //刷新适配器

// lv.deferNotifyDataSetChanged();
aaaa = new ArrayAdapter(this, R.layout.support_simple_spinner_dropdown_item, list);
lv.setAdapter(aaaa);
}else{
Toast.makeText(this, “没有数据。”, Toast.LENGTH_SHORT).show();
}
}
}

fragment

package com.example.month7day19.evening1.fragment;

import android.content.Context;
import android.net.Uri;
import android.os.Bundle;
import android.support.annotation.Nullable;
import android.support.v4.app.Fragment;
import android.util.AttributeSet;
import android.util.Log;
import android.view.LayoutInflater;
import android.view.View;
import android.view.ViewGroup;

import com.example.month7day19.R;

/**

• A simple {@link Fragment} subclass.

• Activities that contain this fragment must implement the

• {@link EP_fragment_gravity.OnFragmentInteractionListener} interface

• to handle interaction events.

• Use the {@link EP_fragment_gravity#newInstance} factory method to

• create an instance of this fragment.
  */
  public class EP_fragment_gravity extends Fragment {
  // TODO: Rename parameter arguments, choose names that match
  // the fragment initialization parameters, e.g. ARG_ITEM_NUMBER
  private static final String ARG_PARAM1 = “param1”;
  private static final String ARG_PARAM2 = “param2”;

  // TODO: Rename and change types of parameters
  private String mParam1;
  private String mParam2;
  private static final String TAG = “123321”;

  private OnFragmentInteractionListener mListener;

  public EP_fragment_gravity() {
  // Required empty public constructor
  }

  /**

  • Use this factory method to create a new instance of
  • this fragment using the provided parameters.
  • @param param1 Parameter 1.
  • @param param2 Parameter 2.
  • @return A new instance of fragment EP_fragment_gravity.
    */
    // TODO: Rename and change types and number of parameters
    public static EP_fragment_gravity newInstance(String param1, String param2) {
    EP_fragment_gravity fragment = new EP_fragment_gravity();
    Bundle args = new Bundle();
    args.putString(ARG_PARAM1, param1);
    args.putString(ARG_PARAM2, param2);
    fragment.setArguments(args);
    return fragment;
    }

  @Override
  public void onCreate(Bundle savedInstanceState) {
  super.onCreate(savedInstanceState);
  if (getArguments() != null) {
  mParam1 = getArguments().getString(ARG_PARAM1);
  mParam2 = getArguments().getString(ARG_PARAM2);
  }
  Log.i(TAG, "onCreate: ");
  }

  @Override
  public View onCreateView(LayoutInflater inflater, ViewGroup container,
  Bundle savedInstanceState) {
  // Inflate the layout for this fragment
  Log.i(TAG, "onCreateView: ");
  return inflater.inflate(R.layout.fragment_ep_fragment_gravity, container, false);
  }

  // TODO: Rename method, update argument and hook method into UI event
  public void onButtonPressed(Uri uri) {
  if (mListener != null) {
  mListener.onFragmentInteraction(uri);
  }
  }

  @Override
  public void onAttach(Context context) {
  super.onAttach(context);
  // if (context instanceof OnFragmentInteractionListener) {
  // mListener = (OnFragmentInteractionListener) context;
  // } else {
  // throw new RuntimeException(context.toString()
  // + " must implement OnFragmentInteractionListener");
  // }
  Log.i(TAG, "onAttach: ");
  }

  @Override
  public void onActivityCreated(@Nullable Bundle savedInstanceState) {
  super.onActivityCreated(savedInstanceState);
  Log.i(TAG, "onActivityCreated: ");
  }

  @Override
  public void onStart() {
  super.onStart();
  Log.i(TAG, "onStart: ");
  }

  @Override
  public void onResume() {
  super.onResume();
  Log.i(TAG, "onResume: ");
  }

  @Override
  public void onPause() {
  super.onPause();
  Log.i(TAG, "onPause: ");
  }

  @Override
  public void onStop() {
  super.onStop();
  Log.i(TAG, "onStop: ");
  }

  @Override
  public void onDestroyView() {
  super.onDestroyView();
  Log.i(TAG, "onDestroyView: ");
  }

  @Override
  public void onDestroy() {
  super.onDestroy();
  Log.i(TAG, "onDestroy: ");
  }

  @Override
  public void onDetach() {
  super.onDetach();
  mListener = null;
  }

  /**

  • This interface must be implemented by activities that contain this
  • fragment to allow an interaction in this fragment to be communicated
  • to the activity and potentially other fragments contained in that
  • activity.
  • See the Android Training lesson <a href=
  • “http://developer.android.com/training/basics/fragments/communicating.html”

  • Communicating with Other Fragments for more information.
    */
    public interface OnFragmentInteractionListener {
    // TODO: Update argument type and name
    void onFragmentInteraction(Uri uri);
    }
    }

activity xml代码

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

</ListView>