Lumbes Finalproject

LUMBES,AARON JOHN M.
FINAL PROJECT
JAVA CODES(MAIN):
package com.example.myapplication;
import androidx.appcompat.app.AlertDialog;
import androidx.appcompat.app.AppCompatActivity;
import android.content.Intent;
import android.os.Bundle;
import android.view.View;
import android.widget.Button;
import android.widget.EditText;
import android.widget.Toast;
public class main extends AppCompatActivity {

Button buttonLogin;
EditText usernameOutside, passwordOutside;
AlertDialog.Builder alert;
private myDbAdapter mynewdbAdapter;
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
buttonLogin = (Button) findViewById(R.id.buttonLogin);

usernameOutside = (EditText) findViewById(R.id.usernameOutside);
passwordOutside = (EditText) findViewById(R.id.passwordOutside);
alert = new AlertDialog.Builder(this);
mynewdbAdapter = new myDbAdapter(this);
buttonLogin.setOnClickListener(new View.OnClickListener() {
@Override
public void onClick(View view) {
String usernameLog = usernameOutside.getText().toString();
String passwordLog = passwordOutside.getText().toString();
if((usernameLog.equals("admin"))&&
(passwordLog.equals("admin") )) {
Intent intent = new Intent(main.this,
main2.class);
startActivity(intent);
}else{
Boolean checkUserPass =
mynewdbAdapter.checkusernamepassword(usernameLog, passwordLog);
if(checkUserPass) {
Boolean checkUserType =
mynewdbAdapter.checkuserType(usernameLog);
if(checkUserType) {
main3.class);
}else{
main4.class);
}
} else{
Toast.makeText(main.this, "Account doesn't exist.",
Toast.LENGTH_SHORT).show();
}
}
}
});
}
}
MAIN2:
import android.app.AlertDialog;
import android.widget.RadioButton;
import android.widget.RadioGroup;
public class main2 extends AppCompatActivity {
private EditText usernameInside, passwordInside, new1, new2, Editdelete;

private RadioGroup radios;
private Button buttonAdd, buttonView, buttonDelete, buttonUpdate,
buttonSubmitUpdate, logout, buttonSubmitdelete;
AlertDialog.Builder builder;
@Override
setContentView(R.layout.activity_main2);
usernameInside = findViewById(R.id.usernameInside);
passwordInside = findViewById(R.id.passwordInside);
radios = findViewById(R.id.radios);
buttonAdd = findViewById(R.id.buttonAdd);
buttonView = findViewById(R.id.buttonView);
buttonDelete = findViewById(R.id.buttonDelete);
buttonUpdate = findViewById(R.id.buttonUpdate);
mynewdbAdapter.insertData("admin","admin","Super Admin");
new1 = findViewById(R.id.new1);
buttonSubmitUpdate = findViewById(R.id.buttonSubmit);
logout = findViewById(R.id.logout);
buttonSubmitdelete = findViewById(R.id.buttonSubmitdelete);
Editdelete = findViewById(R.id.Editdelete);
buttonAdd.setOnClickListener(new View.OnClickListener() {
@Override
AJ.users = usernameInside.getText().toString();
String password = passwordInside.getText().toString();
String usertype =
((RadioButton)findViewById(radios.getCheckedRadioButtonId())).getText().toStr
ing();
Boolean checkUser = mynewdbAdapter.checkusername(AJ.users);
if ((AJ.users.isEmpty()) || (password.isEmpty())){
Toast.makeText(main2.this, "Please fill in all the
required fields.", Toast.LENGTH_SHORT).show();
} else{
if(!checkUser){//not true or not existing
Boolean insertData =
mynewdbAdapter.insertData(AJ.users,password,usertype);
if(insertData) {
Toast.makeText(main2.this, "User has been
added.", Toast.LENGTH_SHORT).show();
usernameInside.setText("");
passwordInside.setText("");
}
} else {
Toast.makeText(main2.this, "User already exist.",
}
}
}
});
buttonView.setOnClickListener(new View.OnClickListener() {
@Override
String data = mynewdbAdapter.getData();
Toast.makeText(getApplicationContext(), data,
Toast.LENGTH_LONG).show();
});
buttonDelete.setOnClickListener(new View.OnClickListener() {
@Override
Editdelete.setVisibility(View.VISIBLE);
buttonSubmitdelete.setVisibility(View.VISIBLE);
}
});
buttonUpdate.setOnClickListener(new View.OnClickListener() {
@Override
new1.setVisibility(View.VISIBLE);
buttonSubmitUpdate.setVisibility(View.VISIBLE);
}
});
buttonSubmitUpdate.setOnClickListener(new View.OnClickListener() {
@Override
AJ.users = new1.getText().toString();
String userNew = new2.getText().toString();
if(AJ.users.isEmpty() || userNew.isEmpty())
{
}
else
{
Boolean checkUser =
mynewdbAdapter.checkusername(AJ.users);
if(checkUser){
int b = mynewdbAdapter.updateUsername(AJ.users,
userNew);
Toast.makeText(main2.this, "User Updated.",
} else {
Toast.makeText(main2.this, "User doesn't exist.",
new1.setText("");
new2.setText("");
}
}
}
});
logout.setOnClickListener(new View.OnClickListener() {
@Override
Intent intent = new Intent(main2.this,
main.class);
}
});
buttonSubmitdelete.setOnClickListener(new View.OnClickListener() {
@Override
AJ.users = Editdelete.getText().toString();
if(AJ.users.isEmpty())
{
required fields..", Toast.LENGTH_SHORT).show();
}
else
{ Boolean checkUser =
if(checkUser) {
int a = mynewdbAdapter.delete(AJ.users);
Toast.makeText(main2.this, "User deleted.",
}
else {
} usernameInside.setText("");
}
}
});
MAIN3:
import android.app.AlertDialog;
import android.widget.RadioButton;
import android.widget.RadioGroup;
private EditText usernameInside, passwordInside, new1, new2, Editdelete;

private RadioGroup radios;
private Button buttonAdd, buttonView, buttonDelete, buttonUpdate,
buttonSubmitUpdate, logout, buttonSubmitdelete;
AlertDialog.Builder builder;
@Override
usernameInside = findViewById(R.id.usernameInside);
passwordInside = findViewById(R.id.passwordInside);
radios = findViewById(R.id.radios);
buttonAdd = findViewById(R.id.buttonAdd);
buttonView = findViewById(R.id.buttonView);
buttonDelete = findViewById(R.id.buttonDelete);
buttonUpdate = findViewById(R.id.buttonUpdate);
mynewdbAdapter.insertData("admin","admin","Super Admin");
buttonSubmitUpdate = findViewById(R.id.buttonSubmit);
buttonSubmitdelete = findViewById(R.id.buttonSubmitdelete);
Editdelete = findViewById(R.id.Editdelete);
buttonAdd.setOnClickListener(new View.OnClickListener() {
@Override
AJ.users = usernameInside.getText().toString();
String password = passwordInside.getText().toString();
String usertype =
((RadioButton)findViewById(radios.getCheckedRadioButtonId())).getText().toStr
ing();
Boolean checkUser = mynewdbAdapter.checkusername(AJ.users);
if ((AJ.users.isEmpty()) || (password.isEmpty())){
} else{
if(!checkUser){//not true or not existing
Boolean insertData =
mynewdbAdapter.insertData(AJ.users,password,usertype);
if(insertData) {
Toast.makeText(main3.this, "User has been
added.", Toast.LENGTH_SHORT).show();
passwordInside.setText("");
}
} else {
Toast.makeText(main3.this, "User already exist.",
}
}
}
});
buttonView.setOnClickListener(new View.OnClickListener() {
@Override
String data = mynewdbAdapter.getData();
Toast.makeText(getApplicationContext(), data,
});
buttonDelete.setOnClickListener(new View.OnClickListener() {
@Override
Editdelete.setVisibility(View.VISIBLE);
buttonSubmitdelete.setVisibility(View.VISIBLE);
}
});
buttonUpdate.setOnClickListener(new View.OnClickListener() {
@Override
buttonSubmitUpdate.setVisibility(View.VISIBLE);
}
});
buttonSubmitUpdate.setOnClickListener(new View.OnClickListener() {
@Override
AJ.users = new1.getText().toString();
String userNew = new2.getText().toString();
if(AJ.users.isEmpty() || userNew.isEmpty())
{
}
else
{
Boolean checkUser =
if(checkUser){
int b = mynewdbAdapter.updateUsername(AJ.users,
userNew);
Toast.makeText(main3.this, "User Updated.",
} else {
new1.setText("");
new2.setText("");
}
}
}
});
@Override
main.class);
}
});
buttonSubmitdelete.setOnClickListener(new View.OnClickListener() {
@Override
AJ.users = Editdelete.getText().toString();
if(AJ.users.isEmpty())
{
required fields..", Toast.LENGTH_SHORT).show();
}
else
{ Boolean checkUser =
mynewdbAdapter.checkuserType(AJ.users);
if(checkUser) {
Toast.makeText(main3.this, "You can't delete Admin.",
} else {
int a = mynewdbAdapter.delete(AJ.users);
Toast.makeText(main3.this, "User deleted.",
}
}
});
}
MAIN4:
import android.widget.TextView;
TextView view1, view2;

Button logout;
@Override
view1= (TextView) findViewById(R.id.view1);

view2= (TextView) findViewById(R.id.view2);
view2.setText("Username:\n"+ AJ.users);
@Override
main.class);
}
});
}
}
Message:
import android.content.Context;
public class Message {

public static void message(Context context, String message){
Toast.makeText(context,message,Toast.LENGTH_LONG).show();
}
}
myDbAdapter:
import android.annotation.SuppressLint;
import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
public class myDbAdapter {
myDbHelper myhelper;
public myDbAdapter(Context context)
{
myhelper = new myDbHelper(context);
}
static class myDbHelper extends SQLiteOpenHelper

{
private static final String DATABASE_NAME = "LoginSystem_db";
private static final String TABLE_NAME = "LoginSystem_tb";
private static final int DATABASE_Version = 1;
private static final String USERID="Id";
private static final String USERNAME = "Username";
private static final String USERPASSWORD= "Password";
private static final String ACCOUNTTYPE= "Usertype";
private static final String CREATE_TABLE = "CREATE TABLE
"+TABLE_NAME+
" ("+USERID+" INTEGER PRIMARY KEY AUTOINCREMENT, "+USERNAME+"
VARCHAR(255) UNIQUE ,"+ USERPASSWORD+" VARCHAR(225),"+ACCOUNTTYPE+"
VARCHAR(225));";
private static final String DROP_TABLE ="DROP TABLE IF EXISTS
"+TABLE_NAME;
private Context context;
public myDbHelper(Context context) {

super(context, DATABASE_NAME, null, DATABASE_Version);
this.context=context;
}
public void onCreate(SQLiteDatabase db) {

try {
db.execSQL(CREATE_TABLE);
} catch (Exception e) {
Message.message(context,""+e);
}
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int
newVersion) {
db.execSQL("DROP TABLE IF EXISTS " + TABLE_NAME);
onCreate(db);
}
}
public Boolean insertData(String name, String pass, String type)

{
SQLiteDatabase db = myhelper.getWritableDatabase();
ContentValues contentValues = new ContentValues();
contentValues.put(myDbHelper.USERNAME, name);
contentValues.put(myDbHelper.USERPASSWORD, pass);
contentValues.put(myDbHelper.ACCOUNTTYPE, type);
long dData = db.insert(myDbHelper.TABLE_NAME, null , contentValues);
if(dData==-1)
return false;
else
return true;
}
public String getData() {
String[] columns =
{myDbHelper.USERID,myDbHelper.USERNAME,myDbHelper.USERPASSWORD,myDbHelper.ACC
OUNTTYPE};
Cursor cursor
=db.query(myDbHelper.TABLE_NAME,columns,null,null,null,null,null);
StringBuffer buffer= new StringBuffer();
while (cursor.moveToNext()) {
@SuppressLint("Range") int cid
=cursor.getInt(cursor.getColumnIndex(myDbHelper.USERID));
@SuppressLint("Range") String username
=cursor.getString(cursor.getColumnIndex(myDbHelper.USERNAME));
@SuppressLint("Range") String password
=cursor.getString(cursor.getColumnIndex(myDbHelper.USERPASSWORD));
@SuppressLint("Range") String usertype
=cursor.getString(cursor.getColumnIndex(myDbHelper.ACCOUNTTYPE));
buffer.append(cid+ " " + username + " " + password +" " +
usertype +" \n");
}
return buffer.toString();
}
public Boolean checkusername(String users) {
SQLiteDatabase MyDB = myhelper.getWritableDatabase();
Cursor cursor = MyDB.rawQuery("Select * from LoginSystem_tb where
USERNAME = ?", new String[]{AJ.users});
if (cursor.getCount() > 0)
return true;
else
return false;
}
public Boolean checkusernamepassword(String username, String password) {
USERNAME = ? and PASSWORD = ?", new String[]{username,password});
return true;
else
return false;
}
public Boolean checkuserType(String username) {
String args = "Admin";
USERNAME = ? and USERTYPE = ?", new String[]{username,args});
return true;
else
return false;
}
public int updateUsername(String oldName , String newName)
{
ContentValues contentValues = new ContentValues();
contentValues.put(myDbHelper.USERNAME,newName);
String[] whereArgs= {AJ.users};
int count =db.update(myDbHelper.TABLE_NAME,contentValues,
myDbHelper.USERNAME+" = ?",whereArgs );
return count;
}
public int delete(String username)
{
String[] whereArgs ={AJ.users};
int count =db.delete(myDbHelper.TABLE_NAME ,myDbHelper.USERNAME+" =

?",whereArgs);
return count;
}
AJ:
public class AJ {
public static String users;
}
XML CODES(MAIN):
<?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:layout_width="match_parent"
android:layout_height="match_parent"
tools:context=".main">
<TextView
android:id="@+id/textview"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:layout_marginTop="100dp"
android:layout_marginBottom="70dp"
android:text="Final Project
Login System"
android:textSize="40dp"
android:gravity="center"
/>
<EditText
android:id="@+id/usernameOutside"
android:layout_width="287dp"
android:layout_height="60dp"
android:layout_below="@id/textview"
android:layout_centerHorizontal="true"
android:hint="Username"
android:inputType="text"
android:textAlignment="center"
android:textStyle="italic"
/>
<EditText
android:id="@+id/passwordOutside"
android:inputType="textPassword"
android:layout_below="@id/usernameOutside"
android:hint="Password"
android:textStyle="italic"
/>
<Button
android:id="@+id/buttonLogin"
android:layout_below="@id/passwordOutside"
android:text="Login"
android:textColor="@color/black" />
</RelativeLayout>
MAIN2:
<ScrollView xmlns:android="http://schemas.android.com/apk/res/android"
tools:context=".main2"
>
<RelativeLayout
>
<EditText
android:id="@+id/usernameInside"
android:textColor="@color/black"
android:textStyle="italic" />
<EditText
android:id="@+id/passwordInside"
android:layout_below="@id/usernameInside"
<RadioGroup
android:id="@+id/radios"
android:layout_below="@id/passwordInside"
android:orientation="horizontal"
>
<RadioButton
android:id="@+id/radio1"
android:text="Admin"
/>
<RadioButton
android:checked="true"
android:text="User" />
</RadioGroup>
<Button
android:id="@+id/buttonAdd"
android:layout_below="@id/radios"
android:layout_alignParentStart="true"
android:layout_marginStart="63dp"
android:text="add"
<Button
android:id="@+id/buttonDelete"
android:layout_marginLeft="300dp"
android:text="delete"
android:visibility="gone"
/>
<EditText
android:id="@+id/Editdelete"
<Button
android:id="@+id/buttonSubmitdelete"
android:text="Delete"
/>
<Button
android:id="@+id/buttonUpdate"
android:text="update"
/>
<Button
android:id="@+id/buttonView"
android:layout_alignParentEnd="true"
android:layout_marginEnd="61dp"
android:text="View Data"
<EditText
android:id="@+id/new1"
android:hint="Old username"
<EditText
android:hint="New Username"
<Button
android:id="@+id/buttonSubmit"
android:text="Update"
<Button
android:id="@+id/logout"
android:layout_below="@id/new2"
android:text="Logout"
</RelativeLayout>
</ScrollView>
MAIN3:
<ScrollView xmlns:android="http://schemas.android.com/apk/res/android"
tools:context=".main3"
>
<RelativeLayout
>
<EditText
android:id="@+id/usernameInside"
<EditText
android:id="@+id/passwordInside"
android:layout_below="@id/usernameInside"
<RadioGroup
android:id="@+id/radios"
android:layout_below="@id/passwordInside"
android:orientation="horizontal"
>
<RadioButton
android:text="Admin"
/>
<RadioButton
android:checked="true"
android:text="admin" />
</RadioGroup>
<Button
android:id="@+id/buttonAdd"
android:layout_alignParentStart="true"
android:layout_marginStart="63dp"
android:text="add"
<Button
android:id="@+id/buttonDelete"
android:text="delete"
/>
<EditText
android:id="@+id/Editdelete"
<Button
android:id="@+id/buttonSubmitdelete"
android:text="Delete"
/>
<Button
android:id="@+id/buttonUpdate"
android:text="update"
/>
<Button
android:id="@+id/buttonView"
android:layout_alignParentEnd="true"
android:layout_marginEnd="61dp"
android:text="View Data"
<EditText
android:hint="Old username"
<EditText
android:hint="New Username"
<Button
android:id="@+id/buttonSubmit"
android:text="Update"
<Button
android:layout_below="@id/new2"
android:text="Logout"
</RelativeLayout>
</ScrollView>
MAIN4:
<RelativeLayout xmlns:android="http://schemas.android.com/apk/res/android"
tools:context=".main4">
<TextView
android:id="@+id/view1"
android:text="Welcome User!"
android:textStyle="bold" />
<TextView
android:id="@+id/view2"
android:layout_width="wrap_content"
android:layout_below="@id/view1"
/>
<Button
android:layout_below="@id/view2"
android:text="SignOut"
</RelativeLayout>
OUTPUTS:
Input user , user as user and pass
Adding admin1 as admin
User and admin toast
Deleted newUser
Logged in as admin
Admin can’t be deleted

Lumbes Finalproject

Uploaded by

Copyright:

Available Formats

Lumbes Finalproject

Uploaded by

Document Information

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Lumbes Finalproject

Uploaded by

Copyright:

Available Formats

LUMBES,AARON JOHN M.

public class main extends AppCompatActivity {

buttonLogin = (Button) findViewById(R.id.buttonLogin);

public class main2 extends AppCompatActivity {

private EditText usernameInside, passwordInside, new1, new2, Editdelete;

public class main3 extends AppCompatActivity {

private EditText usernameInside, passwordInside, new1, new2, Editdelete;

public class main4 extends AppCompatActivity {

TextView view1, view2;

view1= (TextView) findViewById(R.id.view1);

public class Message {

public class myDbAdapter {

static class myDbHelper extends SQLiteOpenHelper

public myDbHelper(Context context) {

public void onCreate(SQLiteDatabase db) {

public Boolean insertData(String name, String pass, String type)

public String getData() {

int count =db.delete(myDbHelper.TABLE_NAME ,myDbHelper.USERNAME+" =

You might also like