· 6 years ago · Dec 15, 2019, 05:52 AM
1MainActivity (Login)
2package com.example.database;
3
4import android.content.Intent;
5import android.os.Bundle;
6
7import com.google.android.material.floatingactionbutton.FloatingActionButton;
8import com.google.android.material.snackbar.Snackbar;
9
10import androidx.appcompat.app.AppCompatActivity;
11import androidx.appcompat.widget.Toolbar;
12
13import android.view.View;
14import android.view.Menu;
15import android.view.MenuItem;
16import android.widget.Button;
17import android.widget.EditText;
18import android.widget.TextView;
19import android.widget.Toast;
20
21public class MainActivity extends AppCompatActivity {
22
23 @Override
24 protected void onCreate(Bundle savedInstanceState) {
25 super.onCreate(savedInstanceState);
26 setContentView(R.layout.activity_main);
27 Toolbar toolbar = findViewById(R.id.toolbar);
28 setSupportActionBar(toolbar);
29 TextView reg = (TextView) findViewById(R.id.textView3);
30 Button log_btn = (Button) findViewById(R.id.button);
31 reg.setOnClickListener(new View.OnClickListener() {
32 @Override
33 public void onClick(View v) {
34 Intent in = new Intent(MainActivity.this,Registration.class);
35 startActivity(in);
36 }
37 });
38 FloatingActionButton fab = findViewById(R.id.fab);
39 fab.setOnClickListener(new View.OnClickListener() {
40 @Override
41 public void onClick(View view) {
42 Snackbar.make(view, "Replace with your own action", Snackbar.LENGTH_LONG)
43 .setAction("Action", null).show();
44 }
45 });
46 log_btn.setOnClickListener(new View.OnClickListener() {
47 @Override
48 public void onClick(View v) {
49 EditText usc = (EditText) findViewById(R.id.editText);
50 EditText pas = (EditText) findViewById(R.id.editText2);
51 DataHelper obj = new DataHelper(MainActivity.this);
52 String user = usc.getText().toString().trim();
53 String pass = pas.getText().toString().trim();
54 boolean stat = obj.checkUser(user,pass);
55 if(stat == true) {
56 //Toast.makeText(MainActivity.this, "Logged In Successfully", Toast.LENGTH_SHORT).show();
57 Intent in = new Intent(MainActivity.this, Home.class);
58 startActivity(in);
59 finish();
60 }
61 else{
62 Toast.makeText(MainActivity.this, "Wrong Username or Password", Toast.LENGTH_SHORT).show();
63 }
64 }
65 });
66 }
67
68 @Override
69 public boolean onCreateOptionsMenu(Menu menu) {
70 // Inflate the menu; this adds items to the action bar if it is present.
71 getMenuInflater().inflate(R.menu.menu_main, menu);
72 return true;
73 }
74
75 @Override
76 public boolean onOptionsItemSelected(MenuItem item) {
77 // Handle action bar item clicks here. The action bar will
78 // automatically handle clicks on the Home/Up button, so long
79 // as you specify a parent activity in AndroidManifest.xml.
80 int id = item.getItemId();
81
82 //noinspection SimplifiableIfStatement
83 if (id == R.id.action_settings) {
84 return true;
85 }
86
87 return super.onOptionsItemSelected(item);
88 }
89}
90Register
91package com.example.database;
92import androidx.appcompat.app.AppCompatActivity;
93
94import android.content.Intent;
95import android.os.Bundle;
96import android.view.View;
97import android.widget.Button;
98import android.widget.EditText;
99import android.widget.TextView;
100import android.widget.Toast;
101
102public class Registration extends AppCompatActivity {
103
104 @Override
105 protected void onCreate(Bundle savedInstanceState) {
106 super.onCreate(savedInstanceState);
107 setContentView(R.layout.activity_registration);
108 TextView log = (TextView) findViewById(R.id.textView4);
109 final Button reg_btn = (Button) findViewById(R.id.button2);
110 final DataHelper obj = new DataHelper(this);
111 log.setOnClickListener(new View.OnClickListener() {
112 @Override
113 public void onClick(View v) {
114 Intent in = new Intent(Registration.this,MainActivity.class);
115 startActivity(in);
116 }
117 });
118 reg_btn.setOnClickListener(new View.OnClickListener() {
119 @Override
120 public void onClick(View v) {
121 final EditText usc = (EditText) findViewById(R.id.editText3);
122 final EditText pas = (EditText) findViewById(R.id.editText4);
123 EditText con_pass = (EditText) findViewById(R.id.editText5);
124 if(pas.getText().toString().equals(con_pass.getText().toString())) {
125 long stat = obj.addUser(usc.getText().toString(), pas.getText().toString());
126 if (stat > 0) {
127 Toast.makeText(Registration.this, "Registered Successfully", Toast.LENGTH_SHORT).show();
128 Intent in = new Intent(Registration.this, MainActivity.class);
129 startActivity(in);
130 finish();
131 }
132 else {
133 Toast.makeText(Registration.this, "Registered Error", Toast.LENGTH_SHORT).show();
134 }
135 }
136 else {
137 Toast.makeText(Registration.this, "Password Not Match", Toast.LENGTH_SHORT).show();
138 }
139 }
140 });
141 }
142 }
143
144DataHelper
145package com.example.database;
146
147import android.database.sqlite.SQLiteOpenHelper;
148import android.content.ContentValues;
149import android.content.Context;
150import android.database.Cursor;
151import android.database.sqlite.SQLiteDatabase;
152public class DataHelper extends SQLiteOpenHelper {
153 public static final String DATABASE_NAME="register.db";
154 public static final String TABLE_NAME="registeruser";
155 public static final String COL_1="ID";
156 public static final String COL_2="username";
157 public static final String COL_3="password";
158
159 public DataHelper(Context context){
160 super(context, DATABASE_NAME,null,1);//this will create database in SQLite
161 }
162
163 public void onCreate(SQLiteDatabase sqLiteDatabase) {
164 sqLiteDatabase.execSQL("CREATE TABLE registeruser(ID INTEGER PRIMARY KEY AUTOINCREMENT, username TEXT, password TEXT)");
165 }
166
167 //above statement will create table.
168
169 public void onUpgrade(SQLiteDatabase sqLiteDatabase,int i,int i1) {
170 sqLiteDatabase.execSQL("DROP TABLE IF EXISTS "+TABLE_NAME);
171 onCreate(sqLiteDatabase);
172 }
173 // above statement will drop table
174
175 public long addUser(String user,String password) {
176 SQLiteDatabase db = this.getWritableDatabase();
177 ContentValues contentValues = new ContentValues();
178 contentValues.put("username",user);
179 contentValues.put("password",password);
180 long res = db.insert("registeruser",null,contentValues);
181 db.close();
182 return res;
183 // this will add data into database
184 }
185
186 public boolean checkUser(String username, String password){
187 String[] columns={COL_1};
188 SQLiteDatabase db = getReadableDatabase();
189 String selection = COL_2 + "=?" + " and " + COL_3 + "=?";
190 String[] selectionArgs = { username,password};
191
192 Cursor cursor = db.query(TABLE_NAME,columns,selection,selectionArgs,null,null,null);
193
194 int count = cursor.getCount();
195 cursor.close();
196 db.close();
197
198 if(count==1)
199 return true;
200 else
201 return false;
202 }
203}