基于SQLite的Android登录APP

时间：2022-02-19 09:39:47|栏目：Android代码|点击：次

该登录APP主要包括三个模块：

1、登录：用户选择登录方式、登录身份，输入账号密码，完成登录。
2、忘记密码：用户输入新密码及验证码修改登录密码。
3、个人信息：用户完成登录后设置个人信息并显示。

使用控件：

1、单选按钮RadioButton：区分是密码登录还是验证码登录。
2、下拉框Spinner：区分是个人用户还是公司用户。
3、编辑框EditText：输入手机号和密码（或验证码）。
4、复选框CheckBox：判断是否记住密码。
5、相对布局RelativeLayout：界面的整体布局，方便将各个控件按照相对位置摆放。
6、框架布局FrameLayout：在框架布局中后面添加的子视图会把之前的子视图覆盖掉，一般用于需要重叠显示的场合。用于实现忘记密码按钮和密码输入框的叠加。

采用的存储方式

1、共享参数SharedPreferences：

是Android的一个轻量级存储工具，采用的存储结构是Key-Value的键值对方式，类似于Java的Properties类，都是把Key-Value的键值对保存在配置文件中，不同的是Properties的文件内容是Key=Value的形式，而SharedPreferences的存储介质是符合XML规范的配置文件。本案例中用于保存用户的账号和密码。

2、数据库SQLite：

是一个小巧的嵌入式数据库。本案例中用于存储用户的个人信息。

成果展示：

界面设计：

1. 登录界面

<?xml version="1.0" encoding="utf-8"?>
<RelativeLayout 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=".LoginActivity"
 android:paddingTop="10dp"
 android:padding="8dp">

 <RadioGroup
 android:id="@+id/rg_login_way"
 android:layout_width="match_parent"
 android:layout_height="wrap_content"
 android:orientation="horizontal"
 android:layout_marginTop="20dp">

 <RadioButton
  android:id="@+id/rb_password"
  android:layout_width="wrap_content"
  android:layout_height="wrap_content"
  android:text="密码登录"
  android:textSize="25sp" />
 <RadioButton
  android:id="@+id/rb_checkcode"
  android:layout_width="wrap_content"
  android:layout_height="wrap_content"
  android:text="验证码登录"
  android:layout_marginLeft="50dp"
  android:textSize="25sp" />

 </RadioGroup>
 <TextView
 android:id="@+id/tv_shenfen"
 android:layout_width="wrap_content"
 android:layout_height="wrap_content"
 android:text="我是："
 android:layout_below="@+id/rg_login_way"
 android:textSize="25sp"
 android:layout_marginTop="40dp"
 android:textColor="@color/black"
 android:layout_marginLeft="30dp"
 android:layout_alignRight="@+id/tv_phonenum"/>
 <Spinner
 android:id="@+id/sp_shenfen"
 android:layout_width="match_parent"
 android:layout_height="wrap_content"
 android:layout_toRightOf="@+id/tv_shenfen"
 android:layout_alignBottom="@+id/tv_shenfen"

 android:spinnerMode="dialog"/>

 <TextView
 android:id="@+id/tv_phonenum"
 android:layout_width="wrap_content"
 android:layout_height="wrap_content"
 android:layout_below="@+id/tv_shenfen"
 android:text="手机号码："
 android:textSize="25sp"
 android:textColor="@color/black"
 android:layout_marginTop="40dp"/>
 <EditText
 android:id="@+id/et_phone"
 android:layout_width="match_parent"
 android:layout_height="50dp"
 android:layout_alignBaseline="@id/tv_phonenum"
 android:layout_toRightOf="@+id/tv_phonenum"
 android:background="@drawable/eb_selector"
 android:textSize="25sp"
 android:hint="请输入手机号码"
 android:inputType="number" />

 <TextView
 android:id="@+id/tv_psw"
 android:layout_width="wrap_content"
 android:layout_height="40dp"
 android:text="登录密码："
 android:layout_below="@id/tv_phonenum"
 android:textSize="25sp"
 android:layout_marginTop="40dp"
 android:textColor="@color/black"/>
 <FrameLayout
 android:id="@+id/fm_psw"
 android:layout_width="match_parent"
 android:layout_height="50dp"
 android:layout_toRightOf="@id/tv_psw"
 android:layout_alignBottom="@+id/tv_psw"
 android:layout_alignLeft="@+id/et_phone">

 <EditText
  android:id="@+id/et_psw"
  android:layout_width="match_parent"
  android:layout_height="match_parent"
  android:hint="请输入密码"
  android:textSize="25sp"
  android:background="@drawable/eb_selector" />
 <Button
  android:id="@+id/btn_pswforget"
  android:layout_width="wrap_content"
  android:layout_height="match_parent"
  android:text="忘记密码"
  android:textSize="25sp"
  android:background="@color/darkgray"
  android:padding="10dp"
  android:layout_gravity="end"/>
 </FrameLayout>

 <CheckBox
 android:id="@+id/cb_pswrmb"
 android:layout_width="wrap_content"
 android:layout_height="wrap_content"
 android:layout_below="@+id/tv_psw"
 android:text="记住密码"
 android:textSize="25sp"
 android:layout_marginTop="30dp"/>
 <Button
 android:id="@+id/btn_login"
 android:layout_width="match_parent"
 android:layout_height="60dp"
 android:layout_below="@id/cb_pswrmb"
 android:text="登录"
 android:textSize="25sp"
 android:layout_marginTop="30dp"
 android:background="@color/darkgray"/>


</RelativeLayout>

2.忘记密码界面

<?xml version="1.0" encoding="utf-8"?>
<RelativeLayout 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"
 android:padding="8dp"
 android:paddingTop="10dp"
 tools:context=".PswForgetActivity">
 <TextView
 android:id="@+id/tv_newpsw"
 android:layout_width="wrap_content"
 android:layout_height="wrap_content"
 android:text="输入新密码："
 android:textColor="@color/black"
 android:textSize="25sp"
 android:layout_marginTop="20dp"/>
 <EditText
 android:id="@+id/et_newpsw"
 android:layout_width="match_parent"
 android:layout_height="wrap_content"
 android:layout_toRightOf="@+id/tv_newpsw"
 android:background="@drawable/eb_selector"
 android:layout_alignBaseline="@+id/tv_newpsw"
 android:hint="请输入新密码"
 android:textSize="25sp"
 android:inputType="textPassword"
 />
 <TextView
 android:id="@+id/tv_chknewpsw"
 android:layout_width="wrap_content"
 android:layout_height="wrap_content"
 android:layout_marginTop="40dp"
 android:text="确认新密码："
 android:layout_below="@+id/tv_newpsw"
 android:textSize="25sp"
 android:textColor="@color/black"/>
 <EditText
 android:id="@+id/et_chknewpsw"
 android:layout_width="match_parent"
 android:layout_height="wrap_content"
 android:layout_toRightOf="@+id/tv_chknewpsw"
 android:layout_alignBaseline="@+id/tv_chknewpsw"
 android:background="@drawable/eb_selector"
 android:textSize="25sp"
 android:hint="请再次输入新密码"
 android:inputType="textPassword"/>
 <TextView
 android:id="@+id/tv_checkcode"
 android:layout_width="wrap_content"
 android:layout_height="wrap_content"
 android:text="验证码："
 android:layout_below="@+id/tv_chknewpsw"
 android:textSize="25sp"
 android:textColor="@color/black"
 android:layout_marginTop="40dp"/>
 <FrameLayout
 android:layout_width="match_parent"
 android:layout_height="wrap_content"
 android:layout_toRightOf="@+id/tv_checkcode"
 android:layout_below="@+id/et_chknewpsw"
 android:layout_marginTop="20dp">
 <EditText
  android:id="@+id/et_checkcode"
  android:layout_width="match_parent"
  android:layout_height="match_parent"
  android:textSize="25sp"
  android:hint="输入验证码"
  android:inputType="number"
  android:background="@drawable/eb_selector"
  android:maxLines="1"/>
 <Button
  android:id="@+id/btn_sendcheckcode"
  android:layout_width="wrap_content"
  android:layout_height="match_parent"
  android:layout_gravity="right"
  android:text="获取验证码"
  android:textSize="25sp"
  android:padding="10dp"
  android:textColor="@color/black"
  android:background="@color/darkgray"/>

 </FrameLayout>

 <Button
 android:id="@+id/btn_check"
 android:layout_width="match_parent"
 android:layout_height="60dp"
 android:layout_below="@id/tv_checkcode"
 android:text="确定"
 android:textSize="25sp"
 android:layout_marginTop="30dp"
 android:background="@color/darkgray" />


</RelativeLayout>

3.个人信息填写界面

<?xml version="1.0" encoding="utf-8"?>
<RelativeLayout 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=".SharedPreferencesActivity"
 android:padding="10dp">
 <TextView
 android:id="@+id/tv_name"
 android:layout_width="wrap_content"
 android:layout_height="wrap_content"
 android:text="姓名："
 android:textSize="25sp"
 android:textColor="@color/black"
 android:layout_marginTop="20dp"/>
 <EditText
 android:id="@+id/et_name"
 android:layout_width="match_parent"
 android:layout_height="wrap_content"
 android:layout_toRightOf="@+id/tv_name"
 android:layout_alignBaseline="@+id/tv_name"
 android:background="@drawable/eb_selector"
 android:maxLines="1"/>

 <TextView
 android:id="@+id/tv_age"
 android:layout_width="wrap_content"
 android:layout_height="wrap_content"
 android:text="年龄："
 android:textSize="25sp"
 android:textColor="@color/black"
 android:layout_below="@+id/tv_name"
 android:layout_marginTop="20dp"/>
 <EditText
 android:id="@+id/et_age"
 android:layout_width="match_parent"
 android:layout_height="wrap_content"
 android:layout_toRightOf="@+id/tv_age"
 android:layout_alignBaseline="@+id/tv_age"
 android:background="@drawable/eb_selector"
 android:maxLines="1"
 android:inputType="number"/>
 <TextView
 android:id="@+id/tv_height"
 android:layout_width="wrap_content"
 android:layout_height="wrap_content"
 android:text="身高："
 android:textSize="25sp"
 android:textColor="@color/black"
 android:layout_below="@+id/tv_age"
 android:layout_marginTop="20dp"/>
 <EditText
 android:id="@+id/et_height"
 android:layout_width="match_parent"
 android:layout_height="wrap_content"
 android:layout_toRightOf="@+id/tv_height"
 android:layout_alignBaseline="@+id/tv_height"
 android:background="@drawable/eb_selector"
 android:maxLines="1"
 android:inputType="number"/>
 <TextView
 android:id="@+id/tv_weight"
 android:layout_width="wrap_content"
 android:layout_height="wrap_content"
 android:text="体重："
 android:textSize="25sp"
 android:textColor="@color/black"
 android:layout_below="@+id/tv_height"
 android:layout_marginTop="20dp"/>
 <EditText
 android:id="@+id/et_weight"
 android:layout_width="match_parent"
 android:layout_height="wrap_content"
 android:layout_toRightOf="@+id/tv_weight"
 android:layout_alignBaseline="@+id/tv_weight"
 android:background="@drawable/eb_selector"
 android:maxLines="1"
 android:inputType="number"/>
 <TextView
 android:id="@+id/tv_married"
 android:layout_width="wrap_content"
 android:layout_height="wrap_content"
 android:text="婚否："
 android:layout_below="@+id/tv_weight"
 android:textSize="25sp"
 android:textColor="@color/black"
 android:layout_marginTop="20dp"/>
 <Spinner
 android:id="@+id/sp_married"
 android:layout_width="match_parent"
 android:layout_height="40dp"
 android:spinnerMode="dropdown"
 android:layout_toRightOf="@+id/tv_married"
 android:layout_alignBottom="@+id/tv_married"/>

 <Button
 android:id="@+id/btn_save"
 android:layout_width="match_parent"
 android:layout_height="wrap_content"
 android:layout_below="@+id/tv_married"
 android:layout_marginTop="20dp"
 android:background="@drawable/selector"
 android:text="保存"
 android:textSize="25sp"
 android:textColor="@color/black"/>

</RelativeLayout>

4.个人信息显示界面

<?xml version="1.0" encoding="utf-8"?>
<RelativeLayout 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=".SharedPreferencesActivity2">

 <TextView
 android:id="@+id/tv_show"
 android:layout_width="match_parent"
 android:layout_height="wrap_content"
 android:layout_below="@+id/btn_delete"
 android:textSize="25sp"/>
 <Button
 android:id="@+id/btn_delete"
 android:layout_width="match_parent"
 android:layout_height="wrap_content"
 android:text="删除"
 android:textSize="25sp"/>

</RelativeLayout>

代码实现

UserDBHelper

package com.example.helloworld;

import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.util.Log;


import androidx.annotation.Nullable;
import androidx.core.app.NavUtils;

import java.util.ArrayList;
import java.util.Locale;

public class UserDBHelper extends SQLiteOpenHelper {

 private static final String TAG = "UserDBHelper";
 private static final String DB_NAME = "user.db"; //数据库名
 private static final int DB_VERSION = 1;  //数据库版本
 private static UserDBHelper mHelper = null;
 private SQLiteDatabase mDB = null;
 private static final String TABLE_NAME = "user_info"; //表名

 private UserDBHelper(Context context){
 super(context,DB_NAME,null,DB_VERSION);

 }

 private UserDBHelper(Context context,int version){
 super(context,DB_NAME,null,version);
 }

 public static UserDBHelper getInstance(Context context,int version){
 if(version > 0 && mHelper == null){
  mHelper = new UserDBHelper(context,version);
 }else if(mHelper == null){
  mHelper = new UserDBHelper(context);
 }
 return mHelper;
 }

 public SQLiteDatabase openReadLink(){
 if (mDB == null || !mDB.isOpen()){
  mDB = mHelper.getReadableDatabase();
 }
 return mDB;
 }

 public SQLiteDatabase openWriteLink(){
 if (mDB == null || !mDB.isOpen()){
  mDB = mHelper.getWritableDatabase();
  Log.d(TAG, "openWriteLink: 打开了读数据库");
 }
 return mDB;
 }

 public void closeLink(){
 if (mDB != null && mDB.isOpen()){
  mDB.close();
  mDB = null;
 }
 }

 public String getDBName(){
 if(mHelper != null){
  return mHelper.getDatabaseName();
 }else {
  return DB_NAME;
 }
 }

 @Override
 public void onCreate(SQLiteDatabase db) {
 Log.d(TAG, "onCreate: 创建数据库");
 String drop_sql = "DROP TABLE IF EXISTS " + TABLE_NAME + ";";
 db.execSQL(drop_sql);
 String create_sql = "CREATE TABLE IF NOT EXISTS " + TABLE_NAME + " ("
  + "_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,"
  + "name VARCHAR NOT NULL,"
  + "age INTEGER NOT NULL,"
  + "height LONG NOT NULL,"
  + "weight FLOAT NOT NULL,"
  + "married INTEGER NOT NULL,"
  + "update_time VARCHAR NOT NULL,"
  + "phone VARCHAR NOT NULL,"
  + "password VARCHAR NOT NULL"
  + ");";
 Log.d(TAG, "create_sql" + create_sql);
 db.execSQL(create_sql);
 }

 @Override
 public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
 Log.d(TAG, "onUpgrade oldVersion=" +oldVersion+",newVersion=" + newVersion+"数据库新旧版本号");
 if (newVersion > 1){
  String alter_sql = "ALTER TABLE" + TABLE_NAME + "ADD COLUMN" + "phone VARCHAR;";
  Log.d(TAG, "alter_sql:" + alter_sql);
  db.execSQL(alter_sql);
  alter_sql = "ALTER TABLE" + TABLE_NAME + "ADD COLUMN" + "password VARCHAR;";
  Log.d(TAG, "alter_sql:" + alter_sql);
  db.execSQL(alter_sql);
 }
 }

 public int delete(String condition){
 int count = mDB.delete(TABLE_NAME,condition,null);
 return count;
 }
 public int deleteAll(){
 int count = mDB.delete(TABLE_NAME,"1=1",null);
 return count;
 }

 public long insert(UserInfo info){
 ArrayList<UserInfo> infoArray = new ArrayList<UserInfo>();
 infoArray.add(info);
 return insert(infoArray);
 }

 public ArrayList<UserInfo>query(String condition) {
 String sql = String.format(Locale.CHINA,"select rowid,_id,name,age,height,weight,married,update_time," + "phone,password from %s where %s;", TABLE_NAME,condition);
 Log.d(TAG, "query sql: " + sql);
 ArrayList<UserInfo> infoArray = new ArrayList<UserInfo>();
 Cursor cursor = mDB.rawQuery(sql, null);
 while (cursor.moveToNext()) {
  UserInfo info = new UserInfo();
  info.rowid = cursor.getLong(0);
  info.xuhao = cursor.getInt(1);
  info.name = cursor.getString(2);
  info.age = cursor.getInt(3);
  info.height = cursor.getLong(4);
  info.weight = cursor.getFloat(5);
  info.married = (cursor.getInt(6) == 0) ? false : true;
  info.update_time = cursor.getString(7);
  info.phone = cursor.getString(8);
  info.password = cursor.getString(9);
  infoArray.add(info);
 }
 cursor.close();
 return infoArray;
 }

 public long insert(ArrayList<UserInfo> infoArray) {
 long result = -1;
 for (int i = 0; i < infoArray.size(); i++) {
  UserInfo info = infoArray.get(i);
  ArrayList<UserInfo> tempArray = new ArrayList<UserInfo>();
  
  if (info.name != null && info.name.length() > 0) {
  String condition = String.format("name='%s'", info.name);
  tempArray = query(condition);
  if (tempArray.size() > 0) {
   update(info, condition);
   result = tempArray.get(0).rowid;
   continue;
  }
  }
  
  if (info.phone != null && info.phone.length() > 0) {
  String condition = String.format("phone='%s'", info.phone);
  tempArray = query(condition);
  if (tempArray.size() > 0) {
   update(info, condition);
   result = tempArray.get(0).rowid;
   continue;
  }
  }
  Log.d(TAG, "insert: 当前版本号"+mDB.getVersion());

  ContentValues cv = new ContentValues();
  cv.put("name", info.name);
  cv.put("age", info.age);
  cv.put("height", info.height);
  cv.put("weight", info.weight);
  cv.put("married", info.married);
  cv.put("update_time", info.update_time);
  cv.put("phone", info.phone);
  cv.put("password", info.password);
  result = mDB.insert(TABLE_NAME, "", cv);
  if (result == -1) {
  return result;
  }
 }
 return result;
 }

 public int update(UserInfo info, String condition) {
 ContentValues cv = new ContentValues();
 cv.put("name", info.name);
 cv.put("age", info.age);
 cv.put("height", info.height);
 cv.put("weight", info.weight);
 cv.put("married", info.married);
 cv.put("update_time", info.update_time);
 cv.put("phone", info.phone);
 cv.put("password", info.password);
 // 执行更新记录动作，该语句返回记录更新的数目
 return mDB.update(TABLE_NAME, cv, condition, null);
 }


 public int update(UserInfo info) {
 return update(info, "rowid=" + info.rowid);
 }


 public UserInfo queryByPhone(String phone){
 UserInfo info = null;
 ArrayList<UserInfo> infoArray = query(String.format("phone=%s",phone));
 if (infoArray.size() > 0 ){
  info = infoArray.get(0);
 }
 return info;
 }
}

UserInfo

package com.example.helloworld;

public class UserInfo {
 public long rowid;
 public int xuhao;
 public String name;
 public int age;
 public long height;
 public float weight;
 public boolean married;
 public String update_time;
 public String phone;
 public String password;

 public UserInfo() {
 rowid = 0l;
 xuhao = 0;
 name = "";
 age = 0;
 height = 0l;
 weight = 0.0f;
 married = false;
 update_time = "";
 phone = "";
 password = "";
 }
}

LoginActivity

package com.example.helloworld;

import androidx.annotation.Nullable;
import androidx.appcompat.app.AlertDialog;
import androidx.appcompat.app.AppCompatActivity;

import android.content.Context;
import android.content.DialogInterface;
import android.content.Intent;
import android.content.SharedPreferences;
import android.graphics.Rect;
import android.os.Bundle;
import android.text.InputType;
import android.text.method.PasswordTransformationMethod;
import android.text.method.TransformationMethod;
import android.util.Log;
import android.view.View;
import android.widget.AdapterView;
import android.widget.ArrayAdapter;
import android.widget.Button;
import android.widget.CheckBox;
import android.widget.CompoundButton;
import android.widget.EditText;
import android.widget.RadioButton;
import android.widget.RadioGroup;
import android.widget.Spinner;
import android.widget.Toast;

import java.net.PasswordAuthentication;

public class LoginActivity extends AppCompatActivity implements View.OnClickListener {
 private EditText et_phone;
 private RadioButton rb_psw;
 private RadioButton rb_checkcode;
 private EditText et_psw;
 private Button btn_pswforget;
 private String mPassword;
 private int mRequestcode; 
 private String mCheckCode;
 private int mType;
 private String TAG = "huahua";


 @Override
 protected void onCreate(Bundle savedInstanceState) {
 super.onCreate(savedInstanceState);
 setContentView(R.layout.activity_login);
 rb_psw = findViewById(R.id.rb_password);
 rb_checkcode = findViewById(R.id.rb_checkcode);
 et_phone = findViewById(R.id.et_phone);
 et_psw = findViewById(R.id.et_psw);
 CheckBox cb_pswforget = findViewById(R.id.cb_pswrmb);
 Button btn_login = findViewById(R.id.btn_login);
 btn_pswforget = findViewById(R.id.btn_pswforget);
 btn_login.setOnClickListener(this);
 btn_pswforget.setOnClickListener(this);
 RadioGroup rg = findViewById(R.id.rg_login_way);
 mPassword = et_psw.getText().toString();

 rg.setOnCheckedChangeListener(new RadioGroup.OnCheckedChangeListener() {
  @Override
  public void onCheckedChanged(RadioGroup group, int checkedId) {
  RadioButton rb = findViewById(checkedId);
  Log.i(TAG, "onCheckedChanged: 密码登录"+ rb_psw.isChecked());
  Log.i(TAG, "onCheckedChanged: 验证码登录"+rb_checkcode.isChecked());
  if(rb_psw.isChecked()){
   et_psw.setInputType(InputType.TYPE_TEXT_VARIATION_PASSWORD | InputType.TYPE_CLASS_TEXT);
  }
  }
 });

 cb_pswforget.setOnCheckedChangeListener(new CompoundButton.OnCheckedChangeListener() {
  @Override
  public void onCheckedChanged(CompoundButton buttonView, boolean isChecked) {

  }
 });

 ArrayAdapter<String> typeAdapter = new ArrayAdapter<String>(this,R.layout.item_dropdown,typeArray);
 typeAdapter.setDropDownViewResource(R.layout.item_dropdown);
 Spinner sp_type = findViewById(R.id.sp_shenfen);
 sp_type.setAdapter(typeAdapter);
 sp_type.setSelection(0);
 sp_type.setPrompt("选择你的登录身份：");
 sp_type.setOnItemSelectedListener(new MyOnItemSeclectedListener());
 }
 private String[] typeArray = {"个人用户","企业用户"};
 private class MyOnItemSeclectedListener implements AdapterView.OnItemSelectedListener{
 @Override
 public void onItemSelected(AdapterView<?> parent, View view, int position, long id) {
  mType = position;
 }

 @Override
 public void onNothingSelected(AdapterView<?> parent) {

 }
 }

 @Override
 protected void onActivityResult(int requestCode, int resultCode, @Nullable Intent data) {
 super.onActivityResult(requestCode, resultCode, data);
 if (requestCode == mRequestcode && data != null) {
  mPassword = data.getStringExtra("newpsw");
 }
 }

 @Override
 protected void onRestart() {
 et_psw.setText("");
 super.onRestart();
 }

 @Override
 public void onClick(View v) {
 String phone = et_phone.getText().toString();
 switch (v.getId()){
  case R.id.btn_pswforget: {
  Log.i(TAG, "onClick: 点击了忘记密码");
  if (phone == null || phone.length() < 11) {
   Toast.makeText(this, "请输入正确的手机号", Toast.LENGTH_SHORT).show();
   return;
  }
  if (rb_psw.isChecked()) {
   Log.i(TAG, "onClick: 进入忘记密码界面");
   Intent intent = new Intent(this, PswForgetActivity.class);
   intent.putExtra("phone", phone);
   startActivityForResult(intent, mRequestcode);
  } else if (rb_checkcode.isChecked()) {
   mCheckCode = String.format("%06d", (int) (Math.random() * 1000000 % 1000000));
   Log.i(TAG, "onClick: 发送验证码");
   AlertDialog.Builder builder = new AlertDialog.Builder(this);
   builder.setTitle("请记住验证码！");
   builder.setMessage("手机号" + phone + "，本次验证码是：" + mCheckCode + "，请输入验证码");
   builder.setPositiveButton("确定", null);
   AlertDialog alert = builder.create();
   alert.show();
  }
  }
  break;
  case R.id.btn_login: {
  if (phone == null || phone.length() < 11) {
   Toast.makeText(this, "请输入正确的手机号！", Toast.LENGTH_SHORT).show();
   Log.i(TAG, "onClick: 验证密码");
   return;
  }
  if (rb_psw.isChecked()) {
   if (!et_psw.getText().toString().equals(mPassword) || et_psw.getText().toString().equals("")) {
   Toast.makeText(this, "请输入正确的密码", Toast.LENGTH_SHORT).show();
   return;
   } else {
   loginSuccess();
   }
  } else if (rb_checkcode.isChecked()) {
   if (!et_psw.getText().toString().equals(mCheckCode)) {
   Toast.makeText(this, "请输入正确的验证码", Toast.LENGTH_SHORT).show();
   return;
   } else {
   loginSuccess();
   }
  }
  }
 }
 }
 private void loginSuccess(){
 String desc = String.format("您的手机号码是%s，类型是%s。恭喜你通过登录验证，点击“确定”按钮返回上个页面",et_phone.getText().toString(),typeArray[mType]);
 AlertDialog.Builder builder = new AlertDialog.Builder(this);
 builder.setTitle("登录成功");
 builder.setMessage(desc);
 builder.setPositiveButton("确定", new DialogInterface.OnClickListener() {
  @Override
  public void onClick(DialogInterface dialog, int which) {
  Intent intent = new Intent(LoginActivity.this,SharedPreferencesActivity.class);
  startActivity(intent);
  SharedPreferences sps = getSharedPreferences("Login", Context.MODE_PRIVATE);
  SharedPreferences.Editor editor = sps.edit();
  editor.putString("phone",et_phone.getText().toString());
  editor.putString("password",et_psw.getText().toString());
  editor.apply();
  }
 });
 builder.setNegativeButton("取消",null);
 AlertDialog alert = builder.create();
 alert.show();
 }
}

PswForgetActivity

package com.example.helloworld;

import androidx.appcompat.app.AlertDialog;
import androidx.appcompat.app.AppCompatActivity;

import android.app.Activity;
import android.content.Intent;
import android.os.Bundle;
import android.text.InputType;
import android.view.View;
import android.widget.AdapterView;
import android.widget.EditText;
import android.widget.Toast;

public class PswForgetActivity extends AppCompatActivity implements View.OnClickListener {
 private EditText et_newpsw;
 private EditText et_chknewpsw;
 private EditText et_checkcode;
 private String mCheckCode;
 private String mPhone;
 @Override
 protected void onCreate(Bundle savedInstanceState) {
 super.onCreate(savedInstanceState);
 setContentView(R.layout.activity_psw_forget);
 et_newpsw = findViewById(R.id.et_newpsw);
 et_chknewpsw = findViewById(R.id.et_chknewpsw);
 et_checkcode = findViewById(R.id.et_checkcode);
 findViewById(R.id.btn_sendcheckcode).setOnClickListener(this);
 findViewById(R.id.btn_check).setOnClickListener(this);
 mPhone = getIntent().getStringExtra("phone");
 et_newpsw.setInputType(InputType.TYPE_TEXT_VARIATION_PASSWORD | InputType.TYPE_CLASS_TEXT);
 et_chknewpsw.setInputType(InputType.TYPE_TEXT_VARIATION_PASSWORD | InputType.TYPE_CLASS_TEXT);
 }

 @Override
 public void onClick(View v) {
 switch (v.getId()){
  case R.id.btn_sendcheckcode:
  if(mPhone == null || mPhone.length() < 11){
   Toast.makeText(this,"请输入正确的手机号",Toast.LENGTH_SHORT).show();
   return;
  }
  mCheckCode = String.format("%06d",(int)(Math.random()*1000000%1000000));
  AlertDialog.Builder builder = new AlertDialog.Builder(this);
  builder.setTitle("请记住验证码");
  builder.setMessage("手机号"+mPhone+"，本次验证码是"+mCheckCode+"，请输入验证码");
  builder.setPositiveButton("确定",null);
  AlertDialog alertDialog = builder.create();
  alertDialog.show();
  case R.id.btn_check:
  String newpsw = et_newpsw.getText().toString();
  String chknewpsw = et_chknewpsw.getText().toString();
  if(newpsw == null || newpsw.length() < 6 || chknewpsw == null || chknewpsw.length() < 6){
   Toast.makeText(this,"请输入正确的新密码",Toast.LENGTH_SHORT).show();
   return;
  }else if(!newpsw.equals(chknewpsw)){
   Toast.makeText(this,"两次输入的新密码不一致",Toast.LENGTH_SHORT).show();
   return;
  }else if(!et_checkcode.getText().toString().equals(mCheckCode)){
   Toast.makeText(this,"请输入正确的验证码",Toast.LENGTH_SHORT).show();
   return;
  }else {
   Toast.makeText(this,"密码修改成功",Toast.LENGTH_SHORT).show();
   Intent intent = new Intent();
   intent.putExtra("newpsw",newpsw);
   setResult(Activity.RESULT_OK,intent);
   finish();
  }
 }
 }
}

InfoWriteActivity

package com.example.helloworld;

import androidx.appcompat.app.AppCompatActivity;

import android.content.Context;
import android.content.Intent;
import android.content.SharedPreferences;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.util.Log;
import android.view.View;
import android.widget.AdapterView;
import android.widget.ArrayAdapter;
import android.widget.EditText;
import android.widget.Spinner;
import android.widget.Toast;

public class InfoWriteActivity extends AppCompatActivity implements View.OnClickListener {
 private static final String TAG = "huahua";
 private UserDBHelper mHelper;
 private EditText et_name;
 private EditText et_age;
 private EditText et_height;
 private EditText et_weight;
 private boolean Married = false;
 private String phone;
 private String password;

 @Override
 protected void onCreate(Bundle savedInstanceState) {
 super.onCreate(savedInstanceState);
 setContentView(R.layout.activity_shared_preferences);
 et_name = findViewById(R.id.et_name);
 et_age = findViewById(R.id.et_age);
 et_height = findViewById(R.id.et_height);
 et_weight = findViewById(R.id.et_weight);
 findViewById(R.id.btn_save).setOnClickListener(this);

 SharedPreferences sps = getSharedPreferences("Login",Context.MODE_PRIVATE);
 SharedPreferences.Editor editor = sps.edit();
 phone = sps.getString("phone","");
 password = sps.getString("password","");


 ArrayAdapter<String> typeAdapter = new ArrayAdapter<String>(this, R.layout.item_dropdown, typeArray);
 typeAdapter.setDropDownViewResource(R.layout.item_dropdown);
 Spinner sp_married = findViewById(R.id.sp_married);
 sp_married.setAdapter(typeAdapter);
 sp_married.setPrompt("请选择婚姻状况");
 sp_married.setSelection(0);
 sp_married.setOnItemSelectedListener(new TypeSelectedListener());

 


 }

 private String[] typeArray = {"未婚", "已婚"};

 class TypeSelectedListener implements AdapterView.OnItemSelectedListener {
 public void onItemSelected(AdapterView<?> arg0, View arg1, int arg2, long arg3) {
  Married = (arg2 == 0) ? false : true;
 }

 public void onNothingSelected(AdapterView<?> arg0) {
 }
 }

 @Override
 protected void onStart() {
 super.onStart();
 SQLiteDatabase mDB = getApplicationContext().openOrCreateDatabase("user.db", Context.MODE_PRIVATE, null);
 mHelper = UserDBHelper.getInstance(this, 1);
 mHelper.openWriteLink();
 }

 @Override
 protected void onStop() {
 super.onStop();
 mHelper.closeLink();
 }

 @Override
 public void onClick(View v) {
 if (v.getId() == R.id.btn_save) {
  String name = et_name.getText().toString();
  String age = et_age.getText().toString();
  String height = et_height.getText().toString();
  String weight = et_weight.getText().toString();
  if (name == null || name.length() <= 0) {
  showToast("请先填写姓名");
  return;
  }
  if (age == null || age.length() <= 0) {
  showToast("请先填写年龄");
  return;
  }
  if (height == null || height.length() <= 0) {
  showToast("请先填写身高");
  return;
  }
  if (weight == null || weight.length() <= 0) {
  showToast("请先填写体重");
  return;
  }

  UserInfo info = new UserInfo();

  info.name = name;
  info.age = Integer.parseInt(age);
  info.height = Long.parseLong(height);
  info.weight = Float.parseFloat(weight);
  info.married = Married;
  info.phone = phone;
  info.password = password;

  //info.update_time = DateUtil.getCurDateStr("yyyy-MM-dd HH:mm:ss");
  info.update_time = DateUtil.getNowDate(DateUtil.DatePattern.ALL_TIME);
  Log.d(TAG, "onClick: 手机号" + info.phone+info.password+info.name+info.update_time+info.married);
  mHelper.insert(info);
  Intent intent = new Intent(InfoWriteActivity.this, InfoReadActivity.class);
  startActivity(intent);
  showToast("数据已写入SQLite数据库");
 }
 }

 private void showToast(String desc) {
 Toast.makeText(this, desc, Toast.LENGTH_SHORT).show();
 }

 public static void startHome(Context mContext) {
 Intent intent = new Intent(mContext, InfoWriteActivity.class);
 mContext.startActivity(intent);
 }
}

InfoReadActivity

package com.example.helloworld;

import androidx.appcompat.app.AppCompatActivity;

import android.content.Context;
import android.content.Intent;
import android.content.SharedPreferences;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.util.Log;
import android.view.View;
import android.widget.AdapterView;
import android.widget.ArrayAdapter;
import android.widget.EditText;
import android.widget.Spinner;
import android.widget.Toast;

public class InfoWriteActivity extends AppCompatActivity implements View.OnClickListener {
 private static final String TAG = "huahua";
 private UserDBHelper mHelper;
 private EditText et_name;
 private EditText et_age;
 private EditText et_height;
 private EditText et_weight;
 private boolean Married = false;
 private String phone;
 private String password;

 @Override
 protected void onCreate(Bundle savedInstanceState) {
 super.onCreate(savedInstanceState);
 setContentView(R.layout.activity_shared_preferences);
 et_name = findViewById(R.id.et_name);
 et_age = findViewById(R.id.et_age);
 et_height = findViewById(R.id.et_height);
 et_weight = findViewById(R.id.et_weight);
 findViewById(R.id.btn_save).setOnClickListener(this);

 SharedPreferences sps = getSharedPreferences("Login",Context.MODE_PRIVATE);
 SharedPreferences.Editor editor = sps.edit();
 phone = sps.getString("phone","");
 password = sps.getString("password","");


 ArrayAdapter<String> typeAdapter = new ArrayAdapter<String>(this, R.layout.item_dropdown, typeArray);
 typeAdapter.setDropDownViewResource(R.layout.item_dropdown);
 Spinner sp_married = findViewById(R.id.sp_married);
 sp_married.setAdapter(typeAdapter);
 sp_married.setPrompt("请选择婚姻状况");
 sp_married.setSelection(0);
 sp_married.setOnItemSelectedListener(new TypeSelectedListener());
 }

 private String[] typeArray = {"未婚", "已婚"};

 class TypeSelectedListener implements AdapterView.OnItemSelectedListener {
 public void onItemSelected(AdapterView<?> arg0, View arg1, int arg2, long arg3) {
  Married = (arg2 == 0) ? false : true;
 }

 public void onNothingSelected(AdapterView<?> arg0) {
 }
 }

 @Override
 protected void onStart() {
 super.onStart();
 SQLiteDatabase mDB = getApplicationContext().openOrCreateDatabase("user.db", Context.MODE_PRIVATE, null);
 mHelper = UserDBHelper.getInstance(this, 1);
 mHelper.openWriteLink();
 }

 @Override
 protected void onStop() {
 super.onStop();
 mHelper.closeLink();
 }

 @Override
 public void onClick(View v) {
 if (v.getId() == R.id.btn_save) {
  String name = et_name.getText().toString();
  String age = et_age.getText().toString();
  String height = et_height.getText().toString();
  String weight = et_weight.getText().toString();
  if (name == null || name.length() <= 0) {
  showToast("请先填写姓名");
  return;
  }
  if (age == null || age.length() <= 0) {
  showToast("请先填写年龄");
  return;
  }
  if (height == null || height.length() <= 0) {
  showToast("请先填写身高");
  return;
  }
  if (weight == null || weight.length() <= 0) {
  showToast("请先填写体重");
  return;
  }

  UserInfo info = new UserInfo();

  info.name = name;
  info.age = Integer.parseInt(age);
  info.height = Long.parseLong(height);
  info.weight = Float.parseFloat(weight);
  info.married = Married;
  info.phone = phone;
  info.password = password;

  info.update_time = DateUtil.getNowDate(DateUtil.DatePattern.ALL_TIME);
  Log.d(TAG, "onClick: 手机号" + info.phone+info.password+info.name+info.update_time+info.married);
  mHelper.insert(info);
  Intent intent = new Intent(InfoWriteActivity.this, InfoReadActivity.class);
  startActivity(intent);
  showToast("数据已写入SQLite数据库");
 }
 }

 private void showToast(String desc) {
 Toast.makeText(this, desc, Toast.LENGTH_SHORT).show();
 }

 public static void startHome(Context mContext) {
 Intent intent = new Intent(mContext, InfoWriteActivity.class);
 mContext.startActivity(intent);
 }
}

上一篇：利用Flutter实现“孔雀开屏”的动画效果

栏目：Android代码

下一篇：android bitmap compress(图片压缩)代码

本文标题：基于SQLite的Android登录APP

本文地址：http://www.codeinn.net/misctech/193916.html

更多Android代码

Android代码

基于SQLite的Android登录APP

使用控件：

采用的存储方式

界面设计：

代码实现

阅读排行

推荐教程