登录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代码
注册.java
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
数据库.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) {
}
}



