Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package com.android;
- import android.content.ContentValues;
- import android.content.Context;
- import android.database.sqlite.SQLiteDatabase;
- import android.database.sqlite.SQLiteDatabase.CursorFactory;
- import android.database.sqlite.SQLiteOpenHelper;
- public class DBhandler extends SQLiteOpenHelper
- {
- private static String database_name="Users";
- private static int version = 1;
- public DBhandler(Context context, String name, CursorFactory factory, int version)
- {
- super(context, name, factory, version);
- }
- public DBhandler(Context context)
- {
- super(context, database_name, null,version);
- }
- public void onCreate(SQLiteDatabase db)
- {
- String sql = "create table user(username varchar(15)), password varchar(15)";
- db.execSQL(sql);
- //db.execSQL("insert into Points values('23',60,1)");
- }
- public void onUpgrade(SQLiteDatabase db, int arg1,int arg2)
- {
- db.execSQL("drop table if exist user");
- this.onCreate(db);
- }
- public void register(Users us)
- {
- //SQLiteDatabase db = this.getWritableDatabase();
- ContentValues values = new ContentValues();
- values.put("username", us.getUsername());
- values.put("email", us.getEmail());
- values.put("password", us.getPassword());
- values.put("firstname", us.getFname());
- values.put("lastname", us.getLname());
- }
- }
- Users
- package com.android;
- public class Users {
- private String username,password,email,fname,lname;
- public Users(){}
- public Users(String username, String email, String password, String lname, String fname)
- {
- this.username = username;
- this.email = email;
- this.password = password;
- this.lname = lname;
- this.fname = fname;
- }
- public void setUsername(String username){
- this.username = username;
- }
- public void setPassword(String password){
- this.password = password;
- }
- public void setEmail(String email){
- this.email = email;
- }
- public void setFname(String fname){
- this.fname = fname;
- }
- public void setLname(String lname){
- this.lname = lname;
- }
- public String getUsername(){
- return username;
- }
- public String getPassword(){
- return password;
- }
- public String getEmail(){
- return email;
- }
- public String getFname(){
- return fname;
- }
- public String getLname(){
- return lname;
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement