Android项目SQLite登录失效及数据库无法定位问题求助

问题概述 #

我使用Java开发Android Studio应用，已实现MyDatabaseHelper类处理SQLite数据库操作，注册页面功能正常，但登录页面无法完成账号验证；同时无法在项目目录中找到对应的SQLite数据库文件，调整代码及AI排查均未解决问题。

一、登录验证失败的修复 #

核心问题分析 #

登录页面的验证逻辑存在根本性错误：当前代码用checkEmailExists(email) && checkPasswordExists(password)判断登录，这个逻辑是验证“存在该邮箱”且“存在该密码”，而非验证“存在同时匹配该邮箱和密码的用户”。比如只要数据库里有任意用户用了相同密码，即使邮箱不匹配，也可能误判；反之，若用户的邮箱和密码正确，但密码未在其他用户中出现，也可能因为逻辑错误导致验证失败。

另外，注册时对用户名、密码、邮箱做了trim()处理后存入数据库，但登录页面未对输入内容做同样处理，若用户输入时前后有空格，会导致匹配失败。

修复步骤 #

1. 替换验证逻辑：直接使用MyDatabaseHelper中已实现的checkLogin()方法，该方法会同时匹配邮箱和密码，逻辑正确。
2. 统一输入处理：登录时对输入框的内容做trim()，与注册时的处理保持一致。

修改后的登录页面代码 #

submit.setOnClickListener(new View.OnClickListener() {
    @Override
    public void onClick(View v) {
        // 先获取并处理输入内容
        String inputEmail = em.getText().toString().trim();
        String inputPassword = pass.getText().toString().trim();
        
        // 使用正确的登录验证方法
        if (myDB.checkLogin(inputEmail, inputPassword)) {
            Toast.makeText(context, "登录成功", Toast.LENGTH_SHORT).show();
            Intent intent = new Intent(login.this, fragments_host.class);
            startActivity(intent);
        } else {
            Toast.makeText(context, "账号不存在或密码错误", Toast.LENGTH_SHORT).show();
        }
    }
});

二、找不到SQLite数据库文件的解决方法 #

Android的SQLite数据库默认存储在设备内部存储的/data/data/[你的应用包名]/databases/目录下，不会出现在本地项目目录中。以下是几种查看数据库的方式：

方法1：使用Android Studio内置工具 #

1. 打开Android Studio，点击顶部菜单栏的View > Tool Windows > Device File Explorer
2. 在左侧导航栏中找到你的应用包名（比如com.example.findyourworker），展开后进入databases文件夹，即可看到accounts.db文件
3. 右键点击数据库文件，选择Save As可导出到本地查看

方法2：代码导出数据库到外部存储（可选） #

如果需要快速导出数据库到手机的Download目录，可在MyDatabaseHelper中添加以下方法（需申请外部存储权限）：

void exportDatabase() {
    try {
        File dbFile = context.getDatabasePath(DATABASE_NAME);
        File exportFile = new File(Environment.getExternalStoragePublicDirectory(Environment.DIRECTORY_DOWNLOADS), "accounts_export.db");
        
        FileInputStream fis = new FileInputStream(dbFile);
        FileOutputStream fos = new FileOutputStream(exportFile);
        
        byte[] buffer = new byte[1024];
        int length;
        while ((length = fis.read(buffer)) > 0) {
            fos.write(buffer, 0, length);
        }
        
        fos.flush();
        fos.close();
        fis.close();
        Toast.makeText(context, "数据库已导出到Download目录", Toast.LENGTH_SHORT).show();
    } catch (IOException e) {
        e.printStackTrace();
        Toast.makeText(context, "导出失败", Toast.LENGTH_SHORT).show();
    }
}

注意：Android 10及以上需在AndroidManifest.xml中添加android:requestLegacyExternalStorage="true"，同时动态申请WRITE_EXTERNAL_STORAGE权限。

附：原代码参考 #

MyDatabaseHelper类 #

package com.example.findyourworker;

import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.widget.Toast;

import androidx.annotation.Nullable;

class MyDatabaseHelper extends SQLiteOpenHelper {
    private Context context;
    private static final String DATABASE_NAME = "accounts.db";
    private static final int DATABASE_VERSION = 1;
    private static final String TABLE_NAME = "users_data";
    private static final String COLUMN_ID = "_id";
    private static final String COLUMN_USERNAME = "username";
    private static final String COLUMN_PASSWORD = "password";
    private static final String COLUMN_EMAIL = "email";
    
    public MyDatabaseHelper(@Nullable Context context) {
        super(context, DATABASE_NAME, null, DATABASE_VERSION);
        this.context = context;
    }

    @Override
    public void onCreate(SQLiteDatabase db) {
        String query ="CREATE TABLE " + TABLE_NAME +
                " (" + COLUMN_ID + " INTEGER PRIMARY KEY AUTOINCREMENT, " +
                COLUMN_USERNAME + " TEXT, " +
                COLUMN_PASSWORD + " TEXT, " +
                COLUMN_EMAIL + " TEXT);";
        db.execSQL(query);
    }

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

    void addAccount(String username,String password,String email) {
        SQLiteDatabase db = this.getWritableDatabase();
        ContentValues cv = new ContentValues();

        cv.put(COLUMN_USERNAME, username);
        cv.put(COLUMN_PASSWORD, password);
        cv.put(COLUMN_EMAIL, email);
        long result = db.insert(TABLE_NAME, null, cv);
        if (result == -1) {
            Toast.makeText(context, "注册失败", Toast.LENGTH_SHORT).show();
        } else {
            Toast.makeText(context, "注册成功", Toast.LENGTH_SHORT).show();
        }
    }

    boolean checkLogin(String email, String password) {
        SQLiteDatabase db = this.getReadableDatabase();
        String[] columns = {COLUMN_ID};
        String selection = COLUMN_EMAIL + "=? AND " + COLUMN_PASSWORD + "=?";
        String[] selectionArgs = {email, password};
        Cursor cursor = db.query(TABLE_NAME, columns, selection, selectionArgs, null, null, null);
        boolean loginSuccessful = cursor != null && cursor.getCount() > 0;
        if (cursor != null) {
            cursor.close();
        }
        return loginSuccessful;
    }

    boolean checkUsernameExists(String username) {
        SQLiteDatabase db = this.getReadableDatabase();
        String[] columns = {COLUMN_ID};
        String selection = COLUMN_USERNAME + "=?";
        String[] selectionArgs = {username};
        Cursor cursor = db.query(TABLE_NAME, columns, selection, selectionArgs, null, null, null);
        boolean usernameExists = cursor != null && cursor.getCount() > 0;
        if (cursor != null) {
            cursor.close();
        }
        return usernameExists;
    }

    boolean checkPasswordExists(String password) {
        SQLiteDatabase db = this.getReadableDatabase();
        String[] columns = {COLUMN_ID};
        String selection = COLUMN_PASSWORD + "=?";
        String[] selectionArgs = {password};
        Cursor cursor = db.query(TABLE_NAME, columns, selection, selectionArgs, null, null, null);
        boolean passwordExists = cursor != null && cursor.getCount() > 0;
        if (cursor != null) {
            cursor.close();
        }
        return passwordExists;
    }

    boolean checkEmailExists(String email) {
        SQLiteDatabase db = this.getReadableDatabase();
        String[] columns = {COLUMN_ID};
        String selection = COLUMN_EMAIL + "=?";
        String[] selectionArgs = {email};
        Cursor cursor = db.query(TABLE_NAME, columns, selection, selectionArgs, null, null, null);
        boolean emailExists = cursor != null && cursor.getCount() > 0;
        if (cursor != null) {
            cursor.close();
        }
        return emailExists;
    }
}

注册页面原代码 #

submit.setOnClickListener(new View.OnClickListener() {
    @Override
    public void onClick(View v) {
        username = un.getText().toString();
        password = pass.getText().toString();
        email = em.getText().toString();

        unValid = !TextUtils.isEmpty(username) && isUsernameValid(username);
        passValid = !TextUtils.isEmpty(password) && isValidPassword(password);
        emailValid = !TextUtils.isEmpty(email) && isValidEmail(email);

        if (unValid && passValid && emailValid) {
            if (!myDB.checkUsernameExists(username) && !myDB.checkEmailExists(email)) {
                myDB.addAccount(username.trim(), password.trim(), email.trim());
                Intent intent = new Intent(signup.this, fragments_host.class);
                // startActivity(intent);
            } else {
                if (myDB.checkEmailExists(email) && myDB.checkUsernameExists(username)) {
                    Toast.makeText(context, "邮箱和用户名已存在", Toast.LENGTH_SHORT).show();
                } else if (myDB.checkUsernameExists(username)) {
                    Toast.makeText(context, "用户名已存在", Toast.LENGTH_SHORT).show();
                } else if (myDB.checkEmailExists(email)) {
                    Toast.makeText(context, "邮箱已存在", Toast.LENGTH_SHORT).show();
                }
            }
        } else {
            if (!unValid) {
                un.setTextColor(Color.RED);
                vibrateDevice(signup.this, 200);
                new Handler().postDelayed(() -> un.setTextColor(Color.BLACK), 200);
            }
            if (!passValid) {
                pass.setTextColor(Color.RED);
                vibrateDevice(signup.this, 200);
                new Handler().postDelayed(() -> pass.setTextColor(Color.BLACK), 200);
            }
            if (!emailValid) {
                em.setTextColor(Color.RED);
                vibrateDevice(signup.this, 200);
                new Handler().postDelayed(() -> em.setTextColor(Color.BLACK), 200);
            }
        }
    }
});

内容的提问来源于stack exchange，提问作者Tamir nab