0% found this document useful (0 votes)
17 views11 pages

Login Form with SQLite in Android Studio

Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
17 views11 pages

Login Form with SQLite in Android Studio

Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

LAB2: TẠO FORM ĐĂNG NHẬP LOGIN VỚI ANDROID STUDIO BẰNG JAVA

CÓ KẾT NỐI CƠ SỞ DỮ LIỆU BẰNG SQLITE

Các bước thực hiện


Step 1: Open Android Studio. Create New Project and choose Empty Activity.
Step 2: Pre-requisites
Gradle module

buildFeatures{
viewBinding true
}

[Link]

<?xml version="1.0" encoding="utf-8"?>


<resources>
<color name="purple_200">#FFBB86FC</color>
<color name="purple_500">#FF6200EE</color>
<color name="purple_700">#FF3700B3</color>
<color name="teal_200">#FF03DAC5</color>
<color name="teal_700">#FF018786</color>
<color name="black">#FF000000</color>
<color name="white">#FFFFFFFF</color>
<color name="lavender">#8692f7</color>
</resources>

[Link]

<resources xmlns:tools="[Link]
<!-- Base application theme. -->
<style name="[Link]"
parent="[Link]">
<!-- Primary brand color. -->
<item name="colorPrimary">@color/lavender</item>
<item name="colorPrimaryVariant">@color/lavender</item>
<item name="colorOnPrimary">@color/white</item>
<!-- Secondary brand color. -->
<item name="colorSecondary">@color/teal_200</item>
<item name="colorSecondaryVariant">@color/teal_700</item>
<item name="colorOnSecondary">@color/black</item>
<!-- Status bar color. -->
<item
name="android:statusBarColor">?attr/colorPrimaryVariant</item>
<!-- Customize your theme here. -->
</style>
</resources>

lavender_border.xml
<?xml version="1.0" encoding="utf-8"?>
<shape xmlns:android="[Link]
android:shape="rectangle">

<corners
android:radius="20dp"/>
<stroke
android:color="@color/lavender"
android:width="2dp"/>
<solid
android:color="@color/white"/>

</shape>

Drawables

Vector Assets – email, lock, and password. (SV có thể lưu ảnh lại làm ảnh nền background)
Step 3: XML Files

activity_signup.xml

<?xml version="1.0" encoding="utf-8"?>


<ScrollView
xmlns:android="[Link]
xmlns:app="[Link]
xmlns:tools="[Link]
android:layout_width="match_parent"
android:layout_height="match_parent"
android:orientation="vertical"
android:background="@drawable/sqlsignbkg"
tools:context=".SignupActivity">

<LinearLayout
android:layout_width="match_parent"
android:layout_height="wrap_content"
android:orientation="vertical">

<LinearLayout
android:layout_width="match_parent"
android:layout_height="wrap_content"
android:orientation="vertical"
android:layout_marginTop="380dp"
android:padding="20dp">

<EditText
android:layout_width="350dp"
android:layout_height="60dp"
android:id="@+id/signup_email"
android:background="@drawable/lavender_border"
android:layout_marginTop="30dp"
android:padding="8dp"
android:hint="Email"

android:drawableLeft="@drawable/ic_baseline_email_24"
android:drawablePadding="8dp"/>

<EditText
android:layout_width="350dp"
android:layout_height="60dp"
android:id="@+id/signup_password"
android:background="@drawable/lavender_border"
android:layout_marginTop="20dp"
android:padding="8dp"
android:hint="Password"
android:inputType="textPassword"

android:drawableLeft="@drawable/ic_baseline_lock_24"
android:drawablePadding="8dp"/>

<EditText
android:layout_width="350dp"
android:layout_height="60dp"
android:id="@+id/signup_confirm"
android:background="@drawable/lavender_border"
android:layout_marginTop="20dp"
android:padding="8dp"
android:hint="Confirm Password"
android:inputType="textPassword"

android:drawableLeft="@drawable/ic_baseline_password_24"
android:drawablePadding="8dp"/>

<Button
android:layout_width="350dp"
android:layout_height="70dp"
android:text="Sign Up"
android:id="@+id/signup_button"
android:textSize="18sp"
android:layout_marginTop="30dp"
app:cornerRadius = "30dp"/>

<TextView
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:id="@+id/loginRedirectText"
android:text="Already an user? Login"
android:layout_gravity="center"
android:padding="8dp"
android:textSize="18sp"
android:layout_marginTop="8dp"
android:textColor="@color/lavender"/>

</LinearLayout>
</LinearLayout>
</ScrollView>

activity_login.xml

<?xml version="1.0" encoding="utf-8"?>


<LinearLayout
xmlns:android="[Link]
xmlns:app="[Link]
xmlns:tools="[Link]
android:layout_width="match_parent"
android:layout_height="match_parent"
android:background="@drawable/sqlogbkg"
android:orientation="vertical"
tools:context=".LoginActivity">

<ScrollView
android:layout_width="match_parent"
android:layout_height="wrap_content">
<LinearLayout
android:layout_width="match_parent"
android:layout_height="wrap_content"
android:orientation="vertical">

<LinearLayout
android:layout_width="match_parent"
android:layout_height="wrap_content"
android:layout_marginTop="500dp"
android:orientation="vertical"
android:padding="20dp">

<EditText
android:id="@+id/login_email"
android:layout_width="350dp"
android:layout_height="60dp"
android:layout_marginTop="30dp"

android:background="@drawable/lavender_border"

android:drawableLeft="@drawable/ic_baseline_email_24"
android:drawablePadding="8dp"
android:hint="Email"
android:padding="8dp"/>

<EditText
android:id="@+id/login_password"
android:layout_width="350dp"
android:layout_height="60dp"
android:layout_marginTop="20dp"

android:background="@drawable/lavender_border"

android:drawableLeft="@drawable/ic_baseline_lock_24"
android:drawablePadding="8dp"
android:hint="Password"
android:inputType="textPassword"
android:padding="8dp" />

<Button
android:id="@+id/login_button"
android:layout_width="350dp"
android:layout_height="70dp"
android:layout_marginTop="30dp"
android:text="Login"
android:textSize="18sp"
app:cornerRadius="30dp" />

<TextView
android:id="@+id/signupRedirectText"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:layout_gravity="center"
android:layout_marginTop="14dp"
android:padding="8dp"
android:text="Not yet registered? Signup"
android:textColor="@color/lavender"
android:textSize="18sp" />

</LinearLayout>
</LinearLayout>
</ScrollView>
</LinearLayout>

activity_main.xml

<?xml version="1.0" encoding="utf-8"?>


<[Link]
xmlns:android="[Link]
xmlns:app="[Link]
xmlns:tools="[Link]
android:layout_width="match_parent"
android:layout_height="match_parent"
tools:context=".MainActivity">

<TextView
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:text="Home"
android:textSize="36sp"
android:textColor="@color/lavender"
app:layout_constraintEnd_toEndOf="parent"
app:layout_constraintStart_toStartOf="parent"
app:layout_constraintTop_toTopOf="parent"
app:layout_constraintBottom_toBottomOf="parent"/>

</[Link]>

Step 4: Java Files

[Link]

package [Link];

import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];

public class DatabaseHelper extends SQLiteOpenHelper {


public static final String databaseName = "[Link]";

public DatabaseHelper(@Nullable Context context) {


super(context, "[Link]", null, 1);
}

@Override
public void onCreate(SQLiteDatabase MyDatabase) {
[Link]("create Table users(email TEXT primary
key, password TEXT)");
}

@Override
public void onUpgrade(SQLiteDatabase MyDB, int i, int i1) {
[Link]("drop Table if exists users");
}

public Boolean insertData(String email, String password){


SQLiteDatabase MyDatabase = [Link]();
ContentValues contentValues = new ContentValues();
[Link]("email", email);
[Link]("password", password);
long result = [Link]("users", null,
contentValues);

if (result == -1) {
return false;
} else {
return true;
}
}

public Boolean checkEmail(String email){


SQLiteDatabase MyDatabase = [Link]();
Cursor cursor = [Link]("Select * from users
where email = ?", new String[]{email});

if([Link]() > 0) {
return true;
}else {
return false;
}
}
public Boolean checkEmailPassword(String email, String
password){
SQLiteDatabase MyDatabase = [Link]();
Cursor cursor = [Link]("Select * from users
where email = ? and password = ?", new String[]{email,
password});

if ([Link]() > 0) {
return true;
}else {
return false;
}
}
}

[Link]

package [Link];

import [Link];

import [Link];
import [Link];
import [Link];
import [Link];

import
[Link];

public class SignupActivity extends AppCompatActivity {

ActivitySignupBinding binding;
DatabaseHelper databaseHelper;

@Override
protected void onCreate(Bundle savedInstanceState) {
[Link](savedInstanceState);
binding =
[Link](getLayoutInflater());
setContentView([Link]());

databaseHelper = new DatabaseHelper(this);

[Link](new
[Link]() {
@Override
public void onClick(View view) {
String email =
[Link]().toString();
String password =
[Link]().toString();
String confirmPassword =
[Link]().toString();

if([Link]("")||[Link]("")||[Link](
""))
[Link]([Link], "All
fields are mandatory", Toast.LENGTH_SHORT).show();
else{
if([Link](confirmPassword)){
Boolean checkUserEmail =
[Link](email);
if(checkUserEmail == false){
Boolean insert =
[Link](email, password);

if(insert == true){

[Link]([Link], "Signup Successfully!",


Toast.LENGTH_SHORT).show();
Intent intent = new
Intent(getApplicationContext(),[Link]);
startActivity(intent);
}else{

[Link]([Link], "Signup Failed!",


Toast.LENGTH_SHORT).show();
}
}
else{
[Link]([Link],
"User already exists! Please login", Toast.LENGTH_SHORT).show();
}
}else{
[Link]([Link],
"Invalid Password!", Toast.LENGTH_SHORT).show();
}
}
}
});

[Link](new
[Link]() {
@Override
public void onClick(View view) {
Intent intent = new Intent([Link],
[Link]);
startActivity(intent);
}
});

}
}

[Link]

package [Link];

import [Link];

import [Link];
import [Link];
import [Link];
import [Link];
import
[Link];

public class LoginActivity extends AppCompatActivity {

ActivityLoginBinding binding;
DatabaseHelper databaseHelper;

@Override
protected void onCreate(Bundle savedInstanceState) {
[Link](savedInstanceState);
binding =
[Link](getLayoutInflater());
setContentView([Link]());

databaseHelper = new DatabaseHelper(this);

[Link](new
[Link]() {
@Override
public void onClick(View view) {
String email =
[Link]().toString();
String password =
[Link]().toString();

if([Link]("")||[Link](""))
[Link]([Link], "All
fields are mandatory", Toast.LENGTH_SHORT).show();
else{
Boolean checkCredentials =
[Link](email, password);

if(checkCredentials == true){
[Link]([Link], "Login
Successfully!", Toast.LENGTH_SHORT).show();
Intent intent = new
Intent(getApplicationContext(), [Link]);
startActivity(intent);
}else{
[Link]([Link],
"Invalid Credentials", Toast.LENGTH_SHORT).show();
}
}
}
});

[Link](new
[Link]() {
@Override
public void onClick(View view) {
Intent intent = new Intent([Link],
[Link]);
startActivity(intent);
}
});
}
}

Kết quả chạy đầu ra

You might also like