Guest User

Untitled

a guest
Jul 2nd, 2018
114
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 5.73 KB | None | 0 0
  1. import android.support.v7.app.AppCompatActivity;
  2. import android.os.Bundle;
  3. import android.view.Menu;
  4. import android.view.MenuItem;
  5. import android.view.View;
  6. import android.widget.AdapterView;
  7. import android.widget.ArrayAdapter;
  8. import android.widget.Button;
  9. import android.widget.EditText;
  10. import android.widget.Spinner;
  11. import android.widget.Toast;
  12. import java.util.ArrayList;
  13. import java.util.List;
  14. public class MainActivity extends AppCompatActivity {
  15. Spinner allusers;
  16. List<String> users=new ArrayList<>();
  17. EditText uname,upassword;
  18. Button adduser;
  19. ArrayAdapter<String> adapter;
  20. DbHandler db;
  21. TextView myTextView;
  22. @Override
  23. protected void onCreate(Bundle savedInstanceState) {
  24. super.onCreate(savedInstanceState);
  25. setContentView(R.layout.activity_main);
  26. allusers=(Spinner)findViewById(R.id.selectuser);
  27. uname=(EditText)findViewById(R.id.username);
  28. upassword=(EditText)findViewById(R.id.password);
  29. adduser=(Button)findViewById(R.id.adduser);
  30. db=new DbHandler(MainActivity.this);
  31. adduser.setOnClickListener(new View.OnClickListener() {
  32. @Override
  33. public void onClick(View v) {
  34. String username=uname.getText().toString();
  35. String password=upassword.getText().toString();
  36. if(username.equalsIgnoreCase("")||password.equalsIgnoreCase(""))
  37. {
  38. Toast.makeText(MainActivity.this,"Please Enter Username and Password",Toast.LENGTH_SHORT).show();
  39. }
  40. else
  41. {
  42. db.addUser(new User(username,password));
  43. prepareData();
  44. Toast.makeText(MainActivity.this,"User was Successfully added to Database",Toast.LENGTH_SHORT).show();
  45. }
  46. }
  47. });
  48. myTextView = (TextView) findViewById(R.id.mPassword);
  49. prepareData();
  50. allusers.setOnItemSelectedListener(new AdapterView.OnItemSelectedListener() {
  51. @Override
  52. public void onItemSelected(AdapterView<?> parent, View view, int position, long id) {
  53. public void onItemSelected(AdapterView<?> parent, View view, int position, long id) {
  54.  
  55. //AA
  56. User selected = (User) parent.getItemAtPosition(position);
  57. myTextView.setText(selected.getPassword());
  58. Toast.makeText(getApplicationContext(), "" + parent.getItemAtPosition(position).toString(), Toast.LENGTH_SHORT).show();
  59. }
  60.  
  61. @Override
  62. public void onNothingSelected(AdapterView<?> parent) {
  63. }
  64. });
  65. }
  66.  
  67. public void prepareData() {
  68. users = db.getAllUsers();
  69. adapter = new ArrayAdapter<String>(Main2Activity.this, android.R.layout.simple_spinner_dropdown_item, android.R.id.text1, users);
  70. allusers.setAdapter(adapter);
  71. }
  72. }
  73.  
  74. public class User {
  75. int id;
  76. String name;
  77. String password;
  78. public User(String name, String password)
  79. {
  80. this.name=name;
  81. this.password=password;
  82. }
  83. public User(int id, String name, String psd)
  84. {
  85. this.id=id;
  86. this.name=name;
  87. this.password=psd;
  88. }
  89. public int getId() {
  90. return id;
  91. }
  92. public void setId(int id) {
  93. this.id = id;
  94. }
  95. public String getName() {
  96. return name;
  97. }
  98. public void setName(String name) {
  99. this.name = name;
  100. }
  101. public String getPassword() {
  102. return password;
  103. }
  104. public void setPassword(String password) {
  105. this.password = password;
  106. }
  107. }
  108.  
  109. import android.content.ContentValues;
  110. import android.content.Context;
  111. import android.database.Cursor;
  112. import android.database.sqlite.SQLiteDatabase;
  113. import android.database.sqlite.SQLiteOpenHelper;
  114. import java.util.ArrayList;
  115. import java.util.List;
  116. public class DbHandler extends SQLiteOpenHelper {
  117. private static final int Db_Version=1;
  118. private static final String Db_Name="users";
  119. private static final String Table_Name="user";
  120. private static final String User_id="id";
  121. private static final String User_name="name";
  122. private static final String User_password="password";
  123. public DbHandler(Context context)
  124. {
  125. super(context,Db_Name,null,Db_Version);
  126. }
  127. @Override
  128. public void onCreate(SQLiteDatabase db) {
  129. String Create_Table="CREATE TABLE " + Table_Name + "(" + User_id
  130. + " INTEGER PRIMARY KEY," + User_name + " TEXT," + User_password + " TEXT" + ")";
  131. db.execSQL(Create_Table);
  132. }
  133. @Override
  134. public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
  135. db.execSQL("DROP TABLE IF EXISTS " + Table_Name);
  136. onCreate(db);
  137. }
  138. public void addUser(User usr)
  139. {
  140. SQLiteDatabase db=this.getWritableDatabase();
  141. ContentValues cv=new ContentValues();
  142. cv.put(User_name,usr.getName());
  143. cv.put(User_password,usr.getPassword());
  144. db.insert(Table_Name, null, cv);
  145. db.close();
  146. }
  147. public int checkUser(User us)
  148. {
  149. int id=-1;
  150. SQLiteDatabase db=this.getReadableDatabase();
  151. Cursor cursor=db.rawQuery("SELECT id FROM user WHERE name=? AND password=?",new String[]{us.getName(),us.getPassword()});
  152. if(cursor.getCount()>0) {
  153. cursor.moveToFirst();
  154. id=cursor.getInt(0);
  155. cursor.close();
  156. }
  157. return id;
  158. }
  159.  
  160. public List<String> getAllUsers()
  161. {
  162. List<String> userlist=new ArrayList<>();
  163. SQLiteDatabase db=this.getReadableDatabase();
  164. Cursor cursor=db.rawQuery("SELECT name FROM user",null);
  165. if(cursor.moveToFirst())
  166. {
  167. do {
  168. userlist.add(cursor.getString(0));
  169. }while (cursor.moveToNext());
  170. }
  171. cursor.close();
  172. db.close();
  173. return userlist;
  174. }
  175. }
  176.  
  177. myTextView.setText(selected.getPassword().toString());
Add Comment
Please, Sign In to add comment