Advertisement
Guest User

Untitled

a guest
May 20th, 2019
136
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.40 KB | None | 0 0
  1. package com.android;
  2.  
  3. import android.content.ContentValues;
  4. import android.content.Context;
  5. import android.database.sqlite.SQLiteDatabase;
  6. import android.database.sqlite.SQLiteDatabase.CursorFactory;
  7. import android.database.sqlite.SQLiteOpenHelper;
  8.  
  9. public class DBhandler extends SQLiteOpenHelper
  10. {
  11. private static String database_name="Users";
  12. private static int version = 1;
  13.  
  14. public DBhandler(Context context, String name, CursorFactory factory, int version)
  15. {
  16. super(context, name, factory, version);
  17. }
  18.  
  19. public DBhandler(Context context)
  20. {
  21. super(context, database_name, null,version);
  22. }
  23.  
  24. public void onCreate(SQLiteDatabase db)
  25. {
  26. String sql = "create table user(username varchar(15)), password varchar(15)";
  27. db.execSQL(sql);
  28. //db.execSQL("insert into Points values('23',60,1)");
  29. }
  30.  
  31. public void onUpgrade(SQLiteDatabase db, int arg1,int arg2)
  32. {
  33. db.execSQL("drop table if exist user");
  34. this.onCreate(db);
  35. }
  36. public void register(Users us)
  37. {
  38. //SQLiteDatabase db = this.getWritableDatabase();
  39. ContentValues values = new ContentValues();
  40. values.put("username", us.getUsername());
  41. values.put("email", us.getEmail());
  42. values.put("password", us.getPassword());
  43. values.put("firstname", us.getFname());
  44. values.put("lastname", us.getLname());
  45.  
  46. }
  47. }
  48.  
  49.  
  50.  
  51.  
  52.  
  53. Users
  54.  
  55.  
  56.  
  57.  
  58. package com.android;
  59.  
  60. public class Users {
  61. private String username,password,email,fname,lname;
  62.  
  63.  
  64. public Users(){}
  65. public Users(String username, String email, String password, String lname, String fname)
  66. {
  67. this.username = username;
  68. this.email = email;
  69. this.password = password;
  70. this.lname = lname;
  71. this.fname = fname;
  72. }
  73. public void setUsername(String username){
  74. this.username = username;
  75. }
  76. public void setPassword(String password){
  77. this.password = password;
  78. }
  79. public void setEmail(String email){
  80. this.email = email;
  81. }
  82. public void setFname(String fname){
  83. this.fname = fname;
  84. }
  85. public void setLname(String lname){
  86. this.lname = lname;
  87. }
  88. public String getUsername(){
  89. return username;
  90. }
  91. public String getPassword(){
  92. return password;
  93. }
  94. public String getEmail(){
  95. return email;
  96. }
  97.  
  98. public String getFname(){
  99. return fname;
  100. }
  101.  
  102. public String getLname(){
  103. return lname;
  104. }
  105.  
  106.  
  107. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement