การทำระบบ Login ด้วย SQLite

1
git clone https://github.com/Devahoy/android-login-example.git
2
git checkout part1

1
git clone git@github.com:Devahoy/android-login-example.git
2
git checkout part1

1
package com.devahoy.sample.login;
2

3
public interface UserManagerHelper {
4

5
    public static final String DATABASE_NAME = "ahoy_login";
6
    public static final int DATABASE_VERSION = 1;
7

8
    /**
9
     * ทำการเซฟข้อมูล User ลงฐานข้อมูล
10
     * @param user
11
     * @return หากบันทึกสำเร็จจะส่งค่า row ID กลับมา ถ้ามี error จะส่ง -1
12
     */
13
    public long registerUser(User user);
14

15
    /**
16
     * ทำการเช็ค User ว่าล็อคอินด้วย username และ password <br />
17
     * ถูกต้องตรงกับในฐานข้อมูลหรือไม่ (มันก็คือการ query sqlite นั่นเอง) <br />
18
     * หาก query ด้วย username, password แล้วมีข้อมูล แสดงว่า ล็อคอินถูกต้อง
19
     * @param user
20
     * @return - หากตรง ก็ส่งค่าเป็น user นั้นๆกลับไป หากไม่ตรงก็ส่ง null
21
     */
22
    public User checkUserLogin(User user);
23

24
    /**
25
     * สำหรับเปลี่ยน password โดยทำการ query หาข้อมูล username, password ก่อน <br />
26
     * จากนั้นถึง update โดยเปลี่ยน password ใหม่แทน
27
     * @param user
28
     * @return - ส่งค่า จำนวนแถวที่มีการ update
29
     */
30
    public int changePassword(User user);
31

32
}

1
package com.devahoy.sample.login.model;
2

3
import android.provider.BaseColumns;
4

5
public class User {
6

7
    public static final String TABLE = "user";
8

9
    public class Column {
10
        public static final String ID = BaseColumns._ID;
11
        public static final String USERNAME = "username";
12
        public static final String PASSWORD = "password";
13
    }
14

15
    private int id;
16
    private String username;
17
    private String password;
18

19
    // Constructor
20
    public User(String username, String password) {
21
        this.username = username;
22
        this.password = password;
23
    }
24

25
    public User() {
26

27
    }
28

29
    public int getId() {
30
        return id;
31
    }
32

33
    public void setId(int id) {
34
        this.id = id;
35
    }
36
    public String getUsername() {
37
        return username;
38
    }
39

40
    public void setUsername(String username) {
41
        this.username = username;
42
    }
43

44
    public String getPassword() {
45
        return password;
46
    }
47

48
    public void setPassword(String password) {
49
        this.password = password;
50
    }
51
}

1
package com.devahoy.sample.login;
2

3
import android.content.Context;
4
import android.database.sqlite.SQLiteDatabase;
5
import android.database.sqlite.SQLiteOpenHelper;
6

7
public class UserManager extends SQLiteOpenHelper implements UserManagerHelper {
8

9
    public UserManager(Context context) {
10
        super(context, UserManagerHelper.DATABASE_NAME, null, UserManagerHelper.DATABASE_VERSION);
11
    }
12

13
    @Override
14
    public void onCreate(SQLiteDatabase db) {
15

16
    }
17

18
    @Override
19
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
20

21
    }
22

23
    @Override
24
    public long registerUser(User user) {
25
        return 0;
26
    }
27

28
    @Override
29
    public User checkUserLogin(User user) {
30
        return null;
31
    }
32

33
    @Override
34
    public int changePassword(User user) {
35
        return 0;
36
    }
37
}

1
public class UserManager extends SQLiteOpenHelper implements UserManagerHelper {
2
    public static final String TAG = UserManager.class.getSimpleName();
3
    private SQLiteDatabase mDatabase;
4

5
...
6
}

1
@Override
2
public void onCreate(SQLiteDatabase db) {
3
    String CREATE_TABLE_USER = String.format("CREATE TABLE %s " +
4
                    "(%s INTEGER PRIMARY KEY AUTOINCREMENT, %s TEXT, %s TEXT)" ,
5
            User.TABLE,
6
            User.Column.ID,
7
            User.Column.USERNAME,
8
            User.Column.PASSWORD
9
    );
10

11
    db.execSQL(CREATE_TABLE_USER);
12

13
    Log.i(TAG, CREATE_TABLE_USER);
14
}

1
@Override
2
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
3
    String DROP_USER = "DROP TABLE IF EXISTS " + UserManagerHelper.DATABASE_VERSION;
4

5
    db.execSQL(DROP_USER);
6

7
    Log.i(TAG, DROP_USER);
8
    onCreate(mDatabase);
9
}

1
@Override
2
public long registerUser(User user) {
3

4
    mDatabase = this.getWritableDatabase();
5

6
    ContentValues values = new ContentValues();
7
    values.put(User.Column.USERNAME, user.getUsername());
8
    values.put(User.Column.PASSWORD, user.getPassword());
9

10
    long result = mDatabase.insert(User.TABLE, null, values);
11
    mDatabase.close();
12

13
    return result;
14
}

1
@Override
2
public User checkUserLogin(User user) {
3

4
    mDatabase = this.getReadableDatabase();
5

6
    Cursor cursor = mDatabase.query(User.TABLE,
7
            null,
8
            User.Column.USERNAME + " = ? AND " +
9
                    User.Column.PASSWORD + " = ?",
10
            new String[]{user.getUsername(), user.getPassword()},
11
            null,
12
            null,
13
            null);
14

15
    User currentUser = new User();
16

17
    if (cursor != null) {
18
        if (cursor.moveToFirst()) {
19
            currentUser.setId((int) cursor.getLong(0));
20
            currentUser.setUsername(cursor.getString(1));
21
            currentUser.setPassword(cursor.getString(2));
22
            mDatabase.close();
23
            return currentUser;
24
        }
25
    }
26

27
    return null;
28
}

1
@Override
2
public int changePassword(User user) {
3

4
    mDatabase = this.getWritableDatabase();
5

6
    ContentValues values = new ContentValues();
7
    values.put(User.Column.USERNAME, user.getUsername());
8
    values.put(User.Column.PASSWORD, user.getPassword());
9

10
    int row = mDatabase.update(User.TABLE,
11
            values,
12
            User.Column.ID + " = ?",
13
            new String[] {String.valueOf(user.getId())});
14

15
    mDatabase.close();
16
    return row;
17
}

1
package com.devahoy.sample.login;
2

3
import android.content.Context;
4
import android.content.Intent;
5
import android.os.Bundle;
6
import android.support.v7.app.ActionBarActivity;
7
import android.view.View;
8
import android.widget.Button;
9
import android.widget.EditText;
10
import android.widget.TextView;
11
import android.widget.Toast;
12

13
import com.devahoy.sample.login.model.User;
14
import com.devahoy.sample.login.utils.UserManager;
15

16

17
public class LoginActivity extends ActionBarActivity {
18

19
    private Button mLogin;
20
    private EditText mUsername;
21
    private EditText mPassword;
22
    private TextView mRegister;
23
    private Context mContext;
24

25
    private UserManager mManager;
26

27
    @Override
28
    protected void onCreate(Bundle savedInstanceState) {
29
        super.onCreate(savedInstanceState);
30

31
        setContentView(R.layout.activity_login);
32

33
        mManager = new UserManager(this);
34

35
        mContext = this;
36

37
        mLogin = (Button) findViewById(R.id.button_login);
38
        mUsername = (EditText) findViewById(R.id.username);
39
        mPassword = (EditText) findViewById(R.id.password);
40
        mRegister = (TextView) findViewById(R.id.register);
41

42
        mLogin.setOnClickListener(new View.OnClickListener() {
43
            @Override
44
            public void onClick(View v) {
45
                checkLogin();
46
            }
47
        });
48

49
        mRegister.setOnClickListener(new View.OnClickListener() {
50
            @Override
51
            public void onClick(View v) {
52
                Intent intent = new Intent(mContext, RegisterActivity.class);
53
                startActivity(intent);
54
            }
55
        });
56
    }
57

58
    private void checkLogin() {
59
        String username = mUsername.getText().toString().trim().toLowerCase();
60
        String password = mPassword.getText().toString().trim();
61

62
        User user = new User(username, password);
63

64
        User validateUser = mManager.checkUserLogin(user);
65

66
        if (null == validateUser) {
67
            String message = getString(R.string.login_error_message);
68
            Toast.makeText(mContext, message, Toast.LENGTH_SHORT).show();
69
        } else {
70
            Intent intent = new Intent(mContext, MainActivity.class);
71
            intent.putExtra(User.Column.USERNAME, validateUser.getUsername());
72
            intent.putExtra(User.Column.ID, validateUser.getId());
73
            startActivity(intent);
74
            finish();
75
        }
76
    }
77
}

1
User user = new User(username, password);
2
long rowId = mManager.registerUser(user);
3

4
if (rowId == -1) {
5

6
} else {
7

8
}

1
package com.devahoy.sample.login;
2

3
import android.content.Context;
4
import android.os.Bundle;
5
import android.support.v7.app.ActionBarActivity;
6
import android.view.View;
7
import android.widget.Button;
8
import android.widget.EditText;
9
import android.widget.Toast;
10

11
import com.devahoy.sample.login.model.User;
12
import com.devahoy.sample.login.utils.UserManager;
13

14
public class RegisterActivity extends ActionBarActivity {
15

16
    private EditText mUsername;
17
    private EditText mPassword;
18
    private EditText mConfirmPassword;
19
    private Button mRegister;
20

21
    private Context mContext;
22
    private UserManager mManager;
23

24
    @Override
25
    protected void onCreate(Bundle savedInstanceState) {
26
        super.onCreate(savedInstanceState);
27
        setContentView(R.layout.activity_register);
28

29
        mManager = new UserManager(this);
30
        mContext = this;
31

32
        mUsername = (EditText) findViewById(R.id.username);
33
        mPassword = (EditText) findViewById(R.id.password);
34
        mConfirmPassword = (EditText) findViewById(R.id.confirm_password);
35
        mRegister = (Button) findViewById(R.id.button_register);
36

37
        mRegister.setOnClickListener(new View.OnClickListener() {
38
            @Override
39
            public void onClick(View v) {
40

41
                String username = mUsername.getText().toString().trim().toLowerCase();
42
                String password = mPassword.getText().toString();
43
                String confirmPassword = mConfirmPassword.getText().toString();
44

45
                if (password.equals(confirmPassword)) {
46
                    User user = new User(username, password);
47
                    long rowId = mManager.registerUser(user);
48

49
                    if (rowId == -1) {
50
                        String message = getString(R.string.register_error_message);
51
                        Toast.makeText(mContext, message, Toast.LENGTH_SHORT).show();
52
                    } else {
53
                        String message = getString(R.string.register_success);
54
                        Toast.makeText(mContext, message, Toast.LENGTH_SHORT).show();
55
                        finish();
56
                    }
57

58
                } else {
59
                    String message = getString(R.string.register_password_error);
60
                    Toast.makeText(mContext, message, Toast.LENGTH_SHORT).show();
61
                }
62

63
            }
64
        });
65
    }
66
}

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

3
<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
4
              android:orientation="vertical"
5
              android:layout_width="match_parent"
6
              android:layout_height="match_parent"
7
              android:gravity="center">
8

9
    <ImageView
10
        android:layout_width="150dp"
11
        android:layout_height="150dp"
12
        android:src="@drawable/ic_launcher"
13
        android:id="@+id/logo"
14
        android:layout_gravity="center"/>
15

16
    <TextView
17
        android:layout_width="wrap_content"
18
        android:layout_height="wrap_content"
19
        android:id="@+id/say_hi"
20
        android:textSize="24sp"
21
        android:layout_marginTop="16dp"
22
        android:layout_gravity="center"/>
23
    <TextView
24
        android:layout_width="wrap_content"
25
        android:layout_height="wrap_content"
26
        android:text="@string/welcome_message"
27
        android:id="@+id/welcome"
28
        android:textSize="32sp"
29
        android:layout_gravity="center"/>
30

31
    <Button
32
        android:layout_width="wrap_content"
33
        android:layout_height="wrap_content"
34
        android:text="@string/change_password"
35
        android:id="@+id/change_password"
36
        android:layout_marginTop="32dp"
37
        android:layout_gravity="center"/>
38
</LinearLayout>

1
package com.devahoy.sample.login;
2

3
import android.app.AlertDialog;
4
import android.content.DialogInterface;
5
import android.content.Intent;
6
import android.os.Bundle;
7
import android.support.v7.app.ActionBarActivity;
8
import android.text.TextUtils;
9
import android.view.LayoutInflater;
10
import android.view.View;
11
import android.widget.Button;
12
import android.widget.EditText;
13
import android.widget.TextView;
14
import android.widget.Toast;
15

16
import com.devahoy.sample.login.model.User;
17
import com.devahoy.sample.login.utils.UserManager;
18

19
public class MainActivity extends ActionBarActivity {
20

21
    Button mChangePassword;
22
    TextView mUsername;
23
    private UserManager mManager;
24
    User mUser;
25

26
    @Override
27
    protected void onCreate(Bundle savedInstanceState) {
28
        super.onCreate(savedInstanceState);
29
        setContentView(R.layout.activity_main);
30

31
        mManager = new UserManager(this);
32
        mUser = new User();
33

34
        mChangePassword = (Button) findViewById(R.id.change_password);
35
        mUsername = (TextView) findViewById(R.id.say_hi);
36

37
        Bundle args = getIntent().getExtras();
38

39
        if (null == args) {
40
            Toast.makeText(this, getString(R.string.welcome_error_message),
41
                    Toast.LENGTH_SHORT).show();
42
            finish();
43
        } else {
44
            mUsername.setText(getString(R.string.say_hi) + " " +
45
                    args.getString(User.Column.USERNAME));
46

47
            mUser.setId(args.getInt(User.Column.ID));
48
            mUser.setUsername(args.getString(User.Column.USERNAME));
49
        }
50

51
        mChangePassword.setOnClickListener(new View.OnClickListener() {
52
            @Override
53
            public void onClick(View v) {
54
                showDialogPassword();
55
            }
56
        });
57
    }
58

59
    private void showDialogPassword() {
60

61
    }
62

63
    private void goToLogin() {
64
        Intent intent = new Intent(this, LoginActivity.class);
65
        startActivity(intent);
66
        finish();
67
    }
68
}

1
<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
2
              android:orientation="vertical"
3
              android:layout_width="match_parent"
4
              android:layout_height="match_parent">
5
    <EditText
6
        android:id="@+id/password"
7
        android:inputType="textPassword"
8
        android:layout_width="match_parent"
9
        android:layout_height="wrap_content"
10
        android:layout_marginTop="4dp"
11
        android:layout_marginLeft="4dp"
12
        android:layout_marginRight="4dp"
13
        android:layout_marginBottom="16dp"
14
        android:hint="@string/new_password"/>
15
</LinearLayout>

1
    AlertDialog.Builder builder =
2
            new AlertDialog.Builder(MainActivity.this);
3
    LayoutInflater inflater = getLayoutInflater();
4
    View view = inflater.inflate(R.layout.dialog, null);
5

6
    final EditText newPassword = (EditText) view.findViewById(R.id.password);
7
    builder.setView(view);
8

9
    builder.setPositiveButton(getString(android.R.string.ok),
10
            new DialogInterface.OnClickListener() {
11
        @Override
12
        public void onClick(DialogInterface dialog, int which) {
13
            String password = newPassword.getText().toString();
14
            if(!TextUtils.isEmpty(password)) {
15
                mUser.setPassword(password);
16
                mManager.changePassword(mUser);
17
                Toast.makeText(getApplicationContext(),
18
                        getString(R.string.change_password_message),
19
                        Toast.LENGTH_SHORT).show();
20
                goToLogin();
21
            }
22
        }
23
    });
24
    builder.setNegativeButton(getString(android.R.string.cancel), null);
25
    builder.show();