SQLite數據庫存儲_實現登錄注冊功能

注冊活動代碼

public class RegisterActivity extends AppCompatActivity {
    MyDatabaseHelper myDatabaseHelper;
    EditText editText_name;
    EditText editText_password;
    Cursor cursor;

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_register);
        ActionBar actionBar = getSupportActionBar();
        if (actionBar != null) {
            actionBar.hide();
        }
    }

    @Override
    protected void onDestroy() {
        super.onDestroy();
        cursor.close();//關閉
    }

    public void btn_register(View v) {
        myDatabaseHelper= new MyDatabaseHelper(this,"users",null,1);
        SQLiteDatabase dbWrite = myDatabaseHelper.getWritableDatabase();
        SQLiteDatabase dbRead = myDatabaseHelper.getReadableDatabase();
        // ContentValues values= new ContentValues();
        editText_name = findViewById(R.id.edit_name);
        editText_password = findViewById(R.id.edit_password);
        String name = editText_name.getText().toString();
        String password = Hashcode.hashCode(editText_password.getText().toString());
        Log.d("即將進入數據庫", "btn_register: ");
        if (name.equals("") || password.equals("")) {
            Toast.makeText(RegisterActivity.this, "用戶名或密碼為空", Toast.LENGTH_LONG).show();
        } else {
            //查詢用戶表中的所有數據
            cursor = dbRead.rawQuery("select name from users", null);
            if (cursor.moveToFirst()) {
                do {
                    String name1 = cursor.getString(cursor.getColumnIndex("name"));
                    if (name1.equals(name)) {
                        Toast.makeText(RegisterActivity.this, "用戶名已存在", Toast.LENGTH_LONG).show();
                        return;
                    }
                } while (cursor.moveToNext());
            }
            dbWrite.execSQL("insert into users(name,password) values (?,?)", new String[]{name, password});
            //插入，刪除，查詢等等，查詢比較特殊
            Toast.makeText(RegisterActivity.this, "注冊成功", Toast.LENGTH_LONG).show();
            Intent intent = new Intent(RegisterActivity.this, LoginActivity.class);
            startActivity(intent);
        }
    }

}

登錄活動代碼

public class LoginActivity extends AppCompatActivity {
    MyDatabaseHelper myDatabaseHelper;
    EditText editText_name;
    EditText editText_password;
    Cursor cursor;

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.login_layout);
        ActionBar actionBar = getSupportActionBar();
        if (actionBar != null) {
            actionBar.hide();
        }
    }

    public void textviewClick(View v){
        Intent intent = new Intent(LoginActivity.this,RegisterActivity.class);
        startActivity(intent);
    }

    @Override
    protected void onDestroy() {
        super.onDestroy();
        cursor.close();
    }

    public void btn_login(View v) {
        myDatabaseHelper= new MyDatabaseHelper(this,"users",null,1);
        SQLiteDatabase dbRead = myDatabaseHelper.getReadableDatabase();
        // ContentValues values= new ContentValues();
        editText_name = findViewById(R.id.edit_name);
        editText_password = findViewById(R.id.edit_password);
        String name = editText_name.getText().toString();
        String password = Hashcode.hashCode(editText_password.getText().toString());

        if (name.equals("") || password.equals("")) {
            Toast.makeText(LoginActivity.this, "用戶名或密碼為空", Toast.LENGTH_LONG).show();
        } else {
            //查詢用戶表中的所有數據
            cursor = dbRead.rawQuery("select * from users", null);
            if (cursor.moveToFirst()) {
                do {
                    String name1 = cursor.getString(cursor.getColumnIndex("name"));
                    String password1 = cursor.getString(cursor.getColumnIndex("password"));

                    if (name.equals(name1) && password.equals(password1))
                    // db.execSQL("insert into users(name,password) values (?,?)",new String[]{name,password});
                    {
                        Toast.makeText(LoginActivity.this, "登錄成功", Toast.LENGTH_LONG).show();
                        Intent intent = new Intent(LoginActivity.this, MainActivity.class);
                        startActivity(intent);
                        return;
                    }
                } while (cursor.moveToNext());
                Toast.makeText(LoginActivity.this, "用戶名或密碼錯誤", Toast.LENGTH_LONG).show();
                editText_name.setText("");
                editText_password.setText("");
                return;
            }
            Intent intent = new Intent(LoginActivity.this, MainActivity.class);
            startActivity(intent);
        }
    }
}
**可以直接用sql來操作數據庫**

SQLiteOpenHelper幫助類

package com.example.youthgo;

public class MyDatabaseHelper extends SQLiteOpenHelper {

    public static final String CREATE_USERS="create table users(name varchar(20),password varchar(20))";
    //創建數據庫表
    private Context mContent;

    public MyDatabaseHelper(@Nullable Context context, @Nullable String name, @Nullable SQLiteDatabase.CursorFactory factory, int version) {
        super(context, name, factory, version);
        mContent=context;
    }

    @Override
    public void onCreate(SQLiteDatabase db) {
        db.execSQL(CREATE_USERS);
        //執行sql語句相應的操作

    }

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

    }
}