Major： Software Engineering
Class： 3rd Year
Name：AFSAN MD RUBAYET
Student number： 189076015
Instructor： 陶陶
School of computer science and technology
May 29, 2021
GROUP LEADER : EDMUND OFORI 189076014
CHAPTER 1 OVERALL DESIGN
APPLICATION ARCHITECTURE
APPLICATION CONFIGURATION
Operating System: Windows 10
Environment: Android Studio.
Database: MySQL
This is the project file :
These are the codes for the signup and Login application :
register.java :
package com.example.ofori;
import android.content.ContentValues;
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 androidx.appcompat.app.AppCompatActivity;
import com.example.ofori.MainActivity;
public class register extends AppCompatActivity {
protected void onCreate(Bundle savedInstanceState){
try{
super.onCreate( savedInstanceState );
setContentView( R.layout.activity_register );
DatabaseHelper dbHelper;
dbHelper = new DatabaseHelper( this, "User",null,1);
Button addData = (Button) findViewById( R.id.btn_register);
EditText username=(EditText)findViewById(R.id.et_1);
EditText password=(EditText)findViewById(R.id.et_2);
EditText rpassword=(EditText)findViewById(R.id.et_3);
addData.setOnClickListener( new View.OnClickListener(){
@Override
public void onClick(View v){
try {
if(!(password.getText().toString().equals(rpassword.getText().toString())))
{
Toast.makeText(register.this,"please repeat the same
password",Toast.LENGTH_LONG).show();
return;
}
SQLiteDatabase db = dbHelper.getWritableDatabase();
Cursor cursor = db.query("User",null,null,null,null,null,"name DESC");
boolean flag=true;
while(cursor.moveToNext()){
String name = cursor.getString(cursor.getColumnIndex("name"));
if(name.equals(username.getText().toString())) {
flag=false;
Toast.makeText(register.this,"the username has been
registered",Toast.LENGTH_LONG).show();
break;
}
}
if(flag) {
dbHelper.add(username.getText().toString(), password.getText().toString());
Toast.makeText(register.this,"register success!!!",Toast.LENGTH_LONG).show();
Intent intent = new Intent(register.this, MainActivity.class);
startActivity(intent);
}
}
catch (Exception e)
{
System.out.println("错误如下:"+e);
}
}
});}
catch(Exception e)
{
System.out.println("error"+e);
}
}
}
DatabaseHelper.java :
package com.example.ofori;
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.widget.Toast;
public class DatabaseHelper extends SQLiteOpenHelper {
public static final String CREATE_User = "create table User (name text primary key,password text);";
private Context mContext;
private SQLiteDatabase db;
public DatabaseHelper(Context context, String name, SQLiteDatabase.CursorFactory factory, int
version) {
super(context, name, factory, version);
mContext = context;
try {
db = getReadableDatabase();
}
catch (Exception e)
{
System.out.println("错误如下:"+e);
}
}
public void add(String name,String password ){
db.execSQL("INSERT INTO User(name,password)VALUES(?,?)",new Object[]{name,password});
}
public void onCreate(SQLiteDatabase db) {
Toast.makeText(mContext, "Create succeeded.", Toast.LENGTH_LONG).show();
//调用 SQLiteDatabase 的 execSQL()方法执行建表语句
db.execSQL(CREATE_User);
//弹出一个 Toast 提示创建成
}
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
}
}
activity_register :
<?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=".register">
<EditText
android:id="@+id/et_1"
android:layout_width="match_parent"
android:layout_height="50dp"
android:textSize="16sp"
android:textColor="#FFAD33"
android:hint="username"
/>
<EditText
android:id="@+id/et_2"
android:layout_width="match_parent"
android:layout_height="50dp"
android:textSize="16sp"
android:textColor="#FFAD33"
android:hint="password"
android:layout_marginTop="15dp"
android:layout_below="@id/et_1"
/>
<EditText
android:id="@+id/et_3"
android:layout_width="match_parent"
android:layout_height="50dp"
android:textSize="16sp"
android:textColor="#FFAD33"
android:hint="Repeat password"
android:layout_marginTop="15dp"
android:layout_below="@id/et_2"
/>
<Button
android:id="@+id/btn_register"
android:layout_width="match_parent"
android:layout_height="50dp"
android:layout_below="@id/et_3"
android:text="Register"
android:layout_marginTop="50dp"
/>
</RelativeLayout>
Success.java :
package com.example.ofori;
import android.os.Bundle;
import com.google.android.material.floatingactionbutton.FloatingActionButton;
import com.google.android.material.snackbar.Snackbar;
import androidx.appcompat.app.AppCompatActivity;
import androidx.appcompat.widget.Toolbar;
import android.view.View;
public class Success extends AppCompatActivity {
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_success);
}
}
activity_success :
<?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=".Success">
<TextView
android:layout_width="match_parent"
android:layout_height="40dp"
android:text="success!!!"
></TextView>
</RelativeLayout>
activity_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=".MainActivity">
<EditText
android:id="@+id/et_1"
android:layout_width="match_parent"
android:layout_height="50dp"
android:textSize="16sp"
android:textColor="#FFAD33"
android:hint="username"
/>
<EditText
android:id="@+id/et_2"
android:layout_width="match_parent"
android:layout_height="50dp"
android:textSize="16sp"
android:textColor="#FFAD33"
android:hint="password"
android:layout_marginTop="15dp"
android:inputType="textPassword"
android:layout_below="@id/et_1"
/>
<Button
android:id="@+id/btn_login"
android:layout_width="match_parent"
android:layout_height="50dp"
android:layout_below="@id/et_2"
android:text="Login"
android:layout_marginTop="50dp"
/>
<Button
android:id="@+id/btn_register"
android:layout_width="match_parent"
android:layout_height="50dp"
android:layout_below="@id/btn_login"
android:text="Register"
android:layout_marginTop="50dp"
/>
</RelativeLayout>
AndroidManifest :
<?xml version="1.0" encoding="utf-8"?>
<manifest xmlns:android="http://schemas.android.com/apk/res/android"
package="com.example.ofori">
<application
android:allowBackup="true"
android:icon="@mipmap/ic_launcher"
android:label="@string/app_name"
android:roundIcon="@mipmap/ic_launcher_round"
android:supportsRtl="true"
android:theme="@style/Theme.Ofori">
<activity
android:name=".register"
android:label="@string/title_activity_register"
android:theme="@style/Theme.Ofori.NoActionBar" />
<activity
android:name=".Success"
android:label="@string/title_activity_success"
android:theme="@style/Theme.Ofori.NoActionBar" />
<activity
android:name=".MainActivity"
android:label="@string/app_name"
android:theme="@style/Theme.Ofori.NoActionBar">
<intent-filter>
<action android:name="android.intent.action.MAIN" />
<category android:name="android.intent.category.LAUNCHER" />
</intent-filter>
</activity>
</application>
</manifest>
MainActivity.java :
package com.example.ofori;
import android.content.Intent;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.os.PersistableBundle;
import android.text.Editable;
import android.text.TextWatcher;
import android.view.View;
import android.widget.Button;
import android.widget.EditText;
import android.widget.Toast;
import androidx.annotation.Nullable;
import androidx.appcompat.app.AppCompatActivity;
public class MainActivity extends AppCompatActivity {
private Button mBtnLogin,mBtnRegister;
private EditText username,password;
@Override
public void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
final String[] user = {null};
final String[] pwd = {null};
username=(EditText)findViewById(R.id.et_1);
password=(EditText)findViewById(R.id.et_2);
mBtnLogin=(Button)findViewById(R.id.btn_login);
mBtnRegister=(Button)findViewById(R.id.btn_register);
DatabaseHelper dbHelper = new DatabaseHelper( this, "User",null,1);
SQLiteDatabase db = dbHelper.getWritableDatabase();
mBtnLogin.setOnClickListener(new View.OnClickListener() {
@Override
public void onClick(View v) {
Cursor cursor = db.query("User",null,null,null,null,null,"name DESC");
boolean flag=true;
while(cursor.moveToNext()){
String name = cursor.getString(cursor.getColumnIndex("name"));
String pwd= cursor.getString(cursor.getColumnIndex("password"));
if(name.equals(username.getText().toString())&&pwd.equals(password.getText().toString())) {
flag=false;
Toast.makeText(MainActivity.this,"login
success!!!",Toast.LENGTH_LONG).show();
Intent intent = new Intent(MainActivity.this, Success.class);
startActivity(intent);
}
}
if(flag)
Toast.makeText(MainActivity.this,"user or password is
wrong",Toast.LENGTH_LONG).show();
}
}
);
mBtnRegister.setOnClickListener(new View.OnClickListener() {
@Override
public void onClick(View v) {
Intent intent = new Intent(MainActivity.this,register.class);
startActivity(intent);
}
});
username.addTextChangedListener(new TextWatcher() {
@Override
public void beforeTextChanged(CharSequence s, int start, int count, int after) {
}
@Override
public void onTextChanged(CharSequence s, int start, int before, int count) {
user[0] =s.toString();
}
@Override
public void afterTextChanged(Editable s) {
}
});
password.addTextChangedListener(new TextWatcher() {
@Override
public void beforeTextChanged(CharSequence s, int start, int count, int after) {
@Override
public void onTextChanged(CharSequence s, int start, int before, int count) {
pwd[0]=s.toString();
}
@Override
public void afterTextChanged(Editable s) {
}
});
}
}
