Android数据库SQLlite操作demo

package com.example.sqlitedemo1; import androidx.appcompat.app.AppCompatActivity; import android.content.ContentResolver; import android.os.Bundle; import android.text.method.ScrollingMovementMethod; import android.view.View; import android.widget.AdapterView; import android.widget.Button; import android.widget.EditText; import android.widget.ListView; import android.widget.SimpleAdapter; import android.widget.TextView; import android.widget.Toast; import android.widget.GridLayout; import android.widget.RelativeLayout; import android.widget.LinearLayout; import android.text.Layout; import android.text.TextUtils; import android.app.AlertDialog; import android.content.DialogInterface.OnClickListener; import android.content.DialogInterface; import android.content.SharedPreferences; import android.content.SharedPreferences.Editor; import android.util.Log; import java.util.ArrayList; import java.util.HashMap; import java.util.List; import java.util.Map; import java.util.Random; public class MainActivity extends AppCompatActivity implements View.OnClickListener { private MyTablesUtils tbu; private MyTable mTb; private EditText nameEdit, mWorkEdit, mDepartmentEdit, mCompletionStatusEdit, mWorkWayEdit, mUserNameEdit, mPassWdEdit, mTimeEdit; private TextView nameText, mWorkText, mDepartmentText, mCompletionStatusText, mWorkWayText; private Button mSaveBtn, mQueryBtn, mUpdateBtn, mDeleteBtn, mLoginBtn, mForgetBtn; private GridLayout mLoginView; private LinearLayout mWorkView; private ListView lv_show; private ArrayList<MyTable> datas; private int mId = -1; private boolean isRegister = false; private boolean isLogin = false; private SharedPreferences sp = null; String TAG = "[sjh_debug]"; @Override protected void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); setContentView(R.layout.activity_main); sp = MainActivity.this.getSharedPreferences("SPDATA", MODE_PRIVATE); if (sp != null) { String tmp = sp.getString("PASSWD", "none"); if (tmp != "none") { isRegister = true; } } //创建数据库 init(); tbu = new MyTablesUtils(this); } public void updateView() { if (isRegister && isLogin) { mLoginView.setVisibility(View.GONE); mWorkView.setVisibility(View.VISIBLE); mUpdateBtn.setEnabled(false); //mDepartmentEdit.setVisibility(View.GONE); //mDepartmentText.setVisibility(View.GONE); //nameEdit.setVisibility(View.GONE); //nameText.setVisibility(View.GONE); } else { mWorkView.setVisibility(View.GONE); if (!isRegister) { mLoginBtn.setText("注册"); } } } public void init() { mWorkView = findViewById(R.id.work_view); //nameEdit = findViewById(R.id.et_name); mWorkEdit = findViewById(R.id.et_work); mTimeEdit = findViewById(R.id.et_time_query); //mDepartmentEdit = findViewById(R.id.et_department); mCompletionStatusEdit = findViewById(R.id.et_status); mWorkWayEdit = findViewById(R.id.et_work_way); //nameText = findViewById(R.id.tv_name); mWorkText = findViewById(R.id.tv_work); //mDepartmentText = findViewById(R.id.tv_department); mCompletionStatusText = findViewById(R.id.tv_status); mWorkWayText = findViewById(R.id.tv_work_way); mSaveBtn = findViewById(R.id.bt_save); mQueryBtn = findViewById(R.id.bt_query); mUpdateBtn = findViewById(R.id.bt_update); mDeleteBtn = findViewById(R.id.bt_delete); mLoginView = findViewById(R.id.login_view); mUserNameEdit = findViewById(R.id.et_user_name); mPassWdEdit = findViewById(R.id.et_passwd); mLoginBtn = findViewById(R.id.btn_login); mForgetBtn = findViewById(R.id.btn_forget); lv_show = findViewById(R.id.lv_show); mSaveBtn.setOnClickListener(this); mQueryBtn.setOnClickListener(this); mUpdateBtn.setOnClickListener(this); mDeleteBtn.setOnClickListener(this); mLoginBtn.setOnClickListener(this); mForgetBtn.setOnClickListener(this); updateView(); } public boolean layoutIsellipsized(TextView tv) { Layout l = tv.getLayout(); if( l != null){ int lines = l.getLineCount(); Log.d(TAG, "line is " + lines); if(lines > 0) { if(l.getEllipsisCount(lines - 1) > 0) { Log.d(TAG, "is layoutIsellipsized"); return true; } } } else { Log.d(TAG, "Layout is null"); } return false; } @Override public void onClick(View v) { switch (v.getId()) { case R.id.bt_save: { //保存插入数据 String work = mWorkEdit.getText().toString(); //String dp = mDepartmentEdit.getText().toString(); //String name = nameEdit.getText().toString(); String sts = mCompletionStatusEdit.getText().toString(); String ww = mWorkWayEdit.getText().toString(); if (work.equals("") ||/* dp.equals("") || name.equals("") || */sts.equals("") || ww.equals("")) { Toast.makeText(this, "输入不能为空!", Toast.LENGTH_LONG).show(); break; } //mTb = new MyTable(work, dp, name, sts, ww); mTb = new MyTable(work, "x", "x", sts, ww); mass(tbu.insert(mTb)); break; } case R.id.bt_query: { //查询数据 ArrayList datas_map = null; String work = mWorkEdit.getText().toString(); //String dp = mDepartmentEdit.getText().toString(); //String name = nameEdit.getText().toString(); String sts = mCompletionStatusEdit.getText().toString(); String ww = mWorkWayEdit.getText().toString(); String time = mTimeEdit.getText().toString(); if (work.equals("") && /*dp.equals("") && name.equals("") &&*/ sts.equals("") && ww.equals("") && time.equals("")) { datas = tbu.queryAll(); } else { datas = tbu.queryByInfo(work, "", "", sts, time); } datas_map = new ArrayList(); for (int i = 0; i < datas.size(); i++) { HashMap listData = new HashMap(); listData.put("id", datas.get(i).getId()); listData.put("time", datas.get(i).getTime()); listData.put("work", datas.get(i).getWorkItems()); listData.put("department", datas.get(i).getDepartment()); listData.put("name", datas.get(i).getName()); listData.put("work_way", datas.get(i).getWorkWay()); listData.put("status", datas.get(i).getCompletionStatus()); datas_map.add(listData); } Log.d(TAG, " query size = "+ datas.size()); //创建适配器对象 SimpleAdapter starAdapter = new SimpleAdapter(this, datas_map, R.layout.item_list, new String[] {"time", "work", /*"department", "name", */"work_way", "status"}, new int[]{R.id.time, R.id.work,/* R.id.department, R.id.name, */R.id.work_way, R.id.status}); //设置适配器 lv_show.setAdapter(starAdapter);