android studio实现注册、登录所有代码（mydatabase数据库）

方圆几里tb

已于 2022-05-25 14:16:18 修改

阅读量1.1k

点赞数 3

分类专栏： android studio开发笔记文章标签：数据库 android android studio

于 2022-05-25 13:14:47 首次发布

本文链接：https://blog.csdn.net/weixin_45768801/article/details/124964222

版权

android studio开发笔记专栏收录该内容

11 篇文章 0 订阅

订阅专栏

登录java代码

import androidx.appcompat.app.AppCompatActivity;

import android.content.Intent;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.view.View;
import android.widget.Button;
import android.widget.EditText;
import android.widget.Toast;

import com.example.memo.sql.MyDatabaseHelper;

public class Login extends AppCompatActivity {
    private MyDatabaseHelper dbHelper;
    private Button login,adddata;
    private EditText edit1,edit2;
    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_login);
        dbHelper = new MyDatabaseHelper(this,"aaa.db",null,1);
        edit1 = (EditText) findViewById(R.id.idd);
        edit2 = (EditText) findViewById(R.id.password);
        login= (Button) findViewById(R.id.login);
        login.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View view) {
                SQLiteDatabase db1=dbHelper.getWritableDatabase();
                Cursor cursor = db1.query("aaa", null, null,null,null,null,null);
                int a=0;
                if(cursor.moveToFirst()){
                    do{
                        String idd=cursor.getString(cursor.getColumnIndex("id"));
                        String pass=cursor.getString(cursor.getColumnIndex("pass"));
                        if(edit1.getText().toString().equals(idd) && edit2.getText().toString().equals(pass))
                            a=1;
                    }while (cursor.moveToNext());
                }
                cursor.close();
                if(a==1)
                {
                    edit2.setText("");
                    Intent intent = new Intent();
                    intent.setClass(getApplicationContext(), MainActivity.class);
                    startActivity(intent);
                }
                else
                    Toast.makeText(getApplicationContext(),"用户名或密码错误！",Toast.LENGTH_SHORT).show();
            }
        });

        adddata= (Button) findViewById(R.id.add_data);
        adddata.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View view) {
                dbHelper.getWritableDatabase();
                Intent intent1 = new Intent();
                intent1.setClass(getApplicationContext(),Enroll.class);
                startActivity(intent1);

            }
        });
    }
}

登录xml代码

<?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:id="@+id/activity_main"
    android:layout_width="match_parent"
    android:layout_height="match_parent"
    android:paddingLeft="16dp"
    android:paddingRight="16dp"
    android:paddingTop="16dp"
    tools:context="com.example.memo.Login">

    <TextView
        android:text="1.0.1"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:id="@+id/textView2"
        android:textSize="19sp"
        android:layout_alignParentBottom="true"
        android:layout_centerHorizontal="true" />


    <Button
        android:id="@+id/add_data"
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:layout_alignParentEnd="true"
        android:layout_alignParentRight="true"
        android:layout_alignParentBottom="true"
        android:layout_marginBottom="50dp"
        android:background="@android:color/background_light"
        android:text="新用户注册"
        android:textAppearance="@android:style/Theme.Black.NoTitleBar.Fullscreen"
        android:textSize="20sp" />

    <TextView
        android:text="密码"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:id="@+id/textView5"
        android:layout_alignBaseline="@+id/password"
        android:layout_alignBottom="@+id/password"
        android:layout_alignLeft="@+id/textView4"
        android:layout_alignStart="@+id/textView4"
        android:textSize="20sp" />

    <TextView
        android:text="账号"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:id="@+id/textView4"
        android:layout_alignBaseline="@+id/idd"
        android:layout_alignBottom="@+id/idd"
        android:layout_alignLeft="@+id/textView"
        android:layout_alignStart="@+id/textView"
        android:textSize="20sp" />

    <Button
        android:id="@+id/login"
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:layout_alignParentEnd="true"
        android:layout_alignParentRight="true"
        android:layout_alignParentBottom="true"
        android:layout_marginBottom="150dp"
        android:background="@android:color/background_light"
        android:text="登录"
        android:textSize="20sp" />

    <TextView
        android:id="@+id/textView"
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:layout_alignParentStart="true"
        android:layout_alignParentLeft="true"
        android:layout_alignParentTop="true"
        android:layout_marginTop="50dp"
        android:text="备忘录 登陆"
        android:textSize="24sp" />


    <EditText
        android:id="@+id/idd"
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:layout_alignParentStart="true"
        android:layout_alignParentLeft="true"
        android:layout_alignParentTop="true"
        android:layout_marginStart="90dp"
        android:layout_marginLeft="90dp"
        android:layout_marginTop="150dp"
        android:ems="10"
        android:inputType="textPersonName" />

    <EditText
        android:id="@+id/password"
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:layout_alignParentStart="true"
        android:layout_alignParentLeft="true"
        android:layout_alignParentTop="true"
        android:layout_marginStart="90dp"
        android:layout_marginLeft="90dp"
        android:layout_marginTop="250dp"
        android:ems="10"
        android:inputType="textPassword" />


</RelativeLayout>

import androidx.appcompat.app.AppCompatActivity;

import android.content.ContentValues;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.view.View;
import android.widget.Button;
import android.widget.EditText;
import android.widget.Toast;

import com.example.memo.sql.MyDatabaseHelper;

public class Enroll extends AppCompatActivity {
    public MyDatabaseHelper dbHelper;
    private Button zc;
    private Button back;
    private EditText edit1,edit2,edit3;
    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_enroll);

        edit1= (EditText) findViewById(R.id.zc1);
        edit2= (EditText) findViewById(R.id.zc2);
        edit3= (EditText) findViewById(R.id.zc3);

        zc = (Button) findViewById(R.id.buttonzc);
        dbHelper=new MyDatabaseHelper(this,"aaa.db",null,1);
        zc.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View v) {
                if(!edit1.equals("")){
                    SQLiteDatabase db1=dbHelper.getWritableDatabase();
                    Cursor cursor = db1.query("aaa", null, null,null,null,null,null);
                    int a=0;
                    if(cursor.moveToFirst()){
                        do{
                            String idd=cursor.getString(cursor.getColumnIndex("id"));
                            if(edit1.getText().toString().equals(idd))
                            {
                                a=1;
                            }
                        }while (cursor.moveToNext());
                    }
                    cursor.close();
                    if(edit2.getText().toString().equals(edit3.getText().toString())&&a==0)
                    {
                        ContentValues values = new ContentValues();
                        values.put("id",edit1.getText().toString());
                        values.put("pass",edit2.getText().toString());
                        db1.insert("aaa",null,values);
                        finish();
                        Toast.makeText(getApplicationContext(),"注册成功",Toast.LENGTH_SHORT).show();
                    }
                    else if (a==1)
                        Toast.makeText(getApplicationContext(),"账号已存在,请重新输入账号",Toast.LENGTH_SHORT).show();
                    else
                        Toast.makeText(getApplicationContext(),"两次密码输入不一致",Toast.LENGTH_SHORT).show();
                }
                else
                    Toast.makeText(getApplicationContext(),"输入账号为空！",Toast.LENGTH_SHORT).show();
            }
        });

        back = (Button) findViewById(R.id.buttonzc2);
        back.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View view) {
                finish();
            }
        });

    }
}

<?xml version="1.0" encoding="utf-8"?>
<RelativeLayout xmlns:android="http://schemas.android.com/apk/res/android"
    xmlns:tools="http://schemas.android.com/tools"
    android:id="@+id/activity_main3"
    android:layout_width="match_parent"
    android:layout_height="match_parent"
    tools:context="com.example.memo.Enroll">

    <EditText
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:inputType="textPersonName"
        android:ems="10"
        android:layout_alignParentTop="true"
        android:layout_centerHorizontal="true"
        android:layout_marginTop="49dp"
        android:id="@+id/zc1"
        android:hint="请输入账号" />

    <EditText
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:inputType="textPassword"
        android:ems="10"
        android:layout_below="@+id/zc1"
        android:layout_alignRight="@+id/zc1"
        android:layout_alignEnd="@+id/zc1"
        android:layout_marginTop="45dp"
        android:id="@+id/zc2"
        android:hint="请输入密码" />

    <EditText
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:inputType="textPassword"
        android:ems="10"
        android:layout_marginTop="55dp"
        android:id="@+id/zc3"
        android:layout_below="@+id/zc2"
        android:layout_alignLeft="@+id/zc2"
        android:layout_alignStart="@+id/zc2"
        android:hint="重复输入密码" />


    <Button
        android:text="确认注册"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_marginTop="59dp"
        android:id="@+id/buttonzc"
        android:layout_below="@+id/zc3"
        android:layout_alignLeft="@+id/zc3"
        android:layout_alignStart="@+id/zc3" />

    <Button
        android:text="返回"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:id="@+id/buttonzc2"
        android:layout_alignBaseline="@+id/buttonzc"
        android:layout_alignBottom="@+id/buttonzc"
        android:layout_alignRight="@+id/zc3"
        android:layout_alignEnd="@+id/zc3" />

</RelativeLayout>

数据库.java

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

public class MyDatabaseHelper  extends SQLiteOpenHelper {
    public static final String CREATE_aaa="create table aaa("
            +"id text primary key,"
            +"pass text)";
    private Context mContext;

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

    @Override
    public void onCreate(SQLiteDatabase db1) {
        db1.execSQL(CREATE_aaa);
        Toast.makeText(mContext, "Creat succeeded",Toast.LENGTH_SHORT).show();

    }

    @Override
    public void onUpgrade(SQLiteDatabase sqLiteDatabase, int i, int i1) {
    }

}