Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public class DBHandler extends SQLiteOpenHelper {
- private final static String DATABASE_NAME ="GCCDatabase";
- private final String TABLE_LOGIN = "Login";
- // private final String COL_USERNAME= "Username";
- // private final String COL_PASSWORD= "Password";
- private final String LOGIN_USERNAME= "Username";
- private final String LOGIN_PASSWORD= "Password";
- private final String TABLE_USER = "User";
- private final String USER_LOGINDETAILS= "Username";
- private final String USER_FIRSTNAME= "FirstName";
- private final String USER_LASTNAME= "LastName";
- private final String USER_EMAILADDRESS ="EmailAddress";
- private final String TABLE_ARTICLE = "Article";
- private final String ARTICLE_ARTICLENAME = "ArticleName";
- private final String ARTICLE_ARTICLECONTENTS = "ArticleContents";
- private final String TABLE_COMMENT = "Comment";
- private final String COMMENT_USERCOMMENT = "UserComment";
- private final String COMMENT_USERRATING = "UsersRating";
- private final String COMMENT_USERNAME = "Username";
- private final String COMMENT_ARTICLENAME = "ArticleName";
- public DBHandler(Context context)
- {
- super(context, DATABASE_NAME, null, 1);
- }
- @Override
- public void onCreate(SQLiteDatabase db)
- {
- //LOGIN
- String CREATE_LOGIN_TABLE = "CREATE TABLE " + TABLE_LOGIN + " (" +
- LOGIN_USERNAME + " TEXT PRIMARY KEY, " +
- LOGIN_PASSWORD + " TEXT)";
- db.execSQL(CREATE_LOGIN_TABLE);
- //SIGN UP
- String CREATE_USER_TABLE = "CREATE TABLE " + TABLE_USER + " (" +
- USER_LOGINDETAILS + " TEXT PRIMARY KEY, " +
- USER_FIRSTNAME + " TEXT, " +
- USER_LASTNAME + " TEXT, " +
- USER_EMAILADDRESS + " TEXT)";
- db.execSQL(CREATE_USER_TABLE);
- //ARTICLE
- String CREATE_ARTICLE_TABLE = "CREATE TABLE " + TABLE_ARTICLE + " (" +
- ARTICLE_ARTICLENAME + " TEXT PRIMARY KEY, " +
- ARTICLE_ARTICLECONTENTS + " TEXT,)";
- db.execSQL(CREATE_ARTICLE_TABLE);
- //COMMENT
- String CREATE_COMMENT_TABLE = "CREATE TABLE " + TABLE_COMMENT + " (" +
- COMMENT_USERCOMMENT + " TEXT PRIMARY KEY, " +
- COMMENT_USERRATING + " TEXT, " +
- COMMENT_USERNAME + " TEXT, " +
- COMMENT_ARTICLENAME + " TEXT, " +
- "PRIMARY_KEY (Username, ArticleName))";
- db.execSQL(CREATE_COMMENT_TABLE);
- }
- public void addLogin(Login login, SQLiteDatabase database)
- {
- ContentValues values = new ContentValues();
- values.put(LOGIN_USERNAME, login.getUsername());
- values.put(LOGIN_PASSWORD, login.getPassword());
- database.insert(TABLE_LOGIN, null, values);
- }
- public void addUser(User user, SQLiteDatabase database)
- {
- ContentValues values = new ContentValues();
- values.put(USER_LOGINDETAILS, user.getLoginDetails().getUsername());
- values.put(USER_FIRSTNAME, user.getFirstame());
- values.put(USER_LASTNAME, user.getLastName());
- values.put(USER_EMAILADDRESS, user.getEmailAddress());
- database.insert(TABLE_USER, null, values);
- }
- public void addComment(Comment comment, SQLiteDatabase database)
- {
- ContentValues values = new ContentValues();
- values.put(COMMENT_USERCOMMENT, comment.getUserComment());
- values.put(COMMENT_USERRATING, comment.getUserScore());
- values.put(COMMENT_USERNAME, comment.getUsername());
- values.put(COMMENT_ARTICLENAME, comment.getArticleName());
- database.insert(TABLE_COMMENT, null, values);
- }
- public boolean validateLogin(String username, String password)
- {
- SQLiteDatabase db = this.getReadableDatabase();
- Cursor cursor = db.rawQuery("SELECT * FROM Login WHERE Username='" + username + "' AND Paswword= '" +password "'", null);
- if (cursor.getCount() != 0)
- {
- return true;
- }
- else
- {
- return false;
- }
- }
- public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion)
- {
- String deleteTable = "DROP TABLE IF EXISTS " + TABLE_LOGIN;
- db.execSQL(deleteTable);
- onCreate(db);
- }
- // public void addLogin(Login login)
- // {
- // SQLiteDatabase db = this.getWritableDatabase();
- // ContentValues values = new ContentValues();
- // values.put(LOGIN_USERNAME, login.getUsername());
- // values.put(LOGIN_PASSWORD, login.getPassword());
- // db.insert(TABLE_LOGIN, null, values);
- //
- // }
- //
- // public Login getLogin(String username)
- // {
- // SQLiteDatabase db = this.getReadableDatabase();
- // Cursor cursor = db.rawQuery("SELECT * FROM" + TABLE_LOGIN + " WHERE " + LOGIN_USERNAME + " = " + username, null);
- //
- // if(cursor != null) {
- // cursor.moveToFirst();
- // Login newLogin = new Login(cursor.getString(0), cursor.getString(1));
- //
- // return newLogin;
- // }
- // else
- // {
- // return null;
- // }
- //
- // }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement