Facebook
From Miguel, 3 Years ago, written in Plain Text.
Embed
Download Paste or View Raw
Hits: 59
  1. import android.content.Context;
  2. import android.database.Cursor;
  3. import android.database.SQLException;
  4. import android.database.sqlite.SQLiteDatabase;
  5.  
  6. import XXXX.User;
  7.  
  8. import java.util.ArrayList;
  9. import java.util.List;
  10.  
  11. public class DBManager {
  12.  
  13.     private DBHelper dbHelper;
  14.  
  15.     private final Context context;
  16.  
  17.     private SQLiteDatabase db;
  18.  
  19.     public DBManager(Context c) {
  20.         context = c;
  21.     }
  22.  
  23.     public void open() throws SQLException {
  24.         dbHelper = new DBHelper(context);
  25.         db = dbHelper.getWritableDatabase();
  26.     }
  27.  
  28.     public void close() {
  29.         dbHelper.close();
  30.     }
  31.  
  32.     // ------------------------ "users" table methods ----------------//
  33.  
  34.     public long insertUser(User user){
  35.         return db.insert(DBHelper.TABLE_USERS, null, user.getContentOfValues());
  36.     }
  37.  
  38.     /*
  39.     public Integer deleteUser (Integer id){
  40.         return db.delete(DBHelper.TABLE_USERS, DBHelper.USERS_COLUMN_USERS_ID + " = ? ",
  41.                 new String[] { Integer.toString(id) });
  42.     }
  43.     */
  44.  
  45.     public boolean updateUser (User user) {
  46.         return db.update(DBHelper.TABLE_USERS, user.getContentOfValues(), "user_id=" + user.getUser_id(), null ) > 0;
  47.     }
  48.  
  49.     public boolean userExists(String email) {
  50.  
  51.         //String sql = "SELECT * FROM " + DBHelper.TABLE_USERS + " WHERE " + DBHelper.USERS_COLUMN_EMAIL +" = " + email + " AND " + DBHelper.USERS_COLUMN_PASSWORD + " = " + User.sha256(password) + "'";
  52.  
  53.         Cursor rs = db.rawQuery( "SELECT * FROM " + "\"" + DBHelper.TABLE_USERS + "\"" +" WHERE "
  54.                 + "\"" + DBHelper.USERS_COLUMN_EMAIL + "\"" + "=" + "\"" + email + "\"", null );
  55.  
  56.         User user = null;
  57.  
  58.         if(rs.moveToFirst()){
  59.             user = new User(
  60.                     rs.getLong(rs.getColumnIndex(DBHelper.USERS_COLUMN_USERS_ID)),
  61.                     rs.getString(rs.getColumnIndex(DBHelper.USERS_COLUMN_NAME)),
  62.                     rs.getString(rs.getColumnIndex(DBHelper.USERS_COLUMN_EMAIL)),
  63.                     rs.getString(rs.getColumnIndex(DBHelper.USERS_COLUMN_PASSWORD)),
  64.                     rs.getString(rs.getColumnIndex(DBHelper.USERS_COLUMN_CURRENCY)),
  65.                     rs.getString(rs.getColumnIndex(DBHelper.USERS_COLUMN_COUNTRY)));
  66.         }
  67.  
  68.         if (!rs.isClosed())  {
  69.             rs.close();
  70.         }
  71.         return user != null;
  72.     }
  73.  
  74.     public User getUser(String email, String password) {
  75.  
  76.         //String sql = "SELECT * FROM " + DBHelper.TABLE_USERS + " WHERE " + DBHelper.USERS_COLUMN_EMAIL +" = " + email + " AND " + DBHelper.USERS_COLUMN_PASSWORD + " = " + User.sha256(password) + "'";
  77.  
  78.         Cursor rs = db.rawQuery( "SELECT * FROM " + "\"" + DBHelper.TABLE_USERS + "\"" +" WHERE "
  79.                 + "\"" + DBHelper.USERS_COLUMN_EMAIL + "\"" + "=" + "\"" + email + "\"" + " AND " +
  80.                 "\"" + DBHelper.USERS_COLUMN_PASSWORD + "\"" + "=" + "\"" + password + "\"", null );
  81.  
  82.         User user = null;
  83.  
  84.         if(rs.moveToFirst()){
  85.             user = new User(
  86.                     rs.getLong(rs.getColumnIndex(DBHelper.USERS_COLUMN_USERS_ID)),
  87.                     rs.getString(rs.getColumnIndex(DBHelper.USERS_COLUMN_NAME)),
  88.                     rs.getString(rs.getColumnIndex(DBHelper.USERS_COLUMN_EMAIL)),
  89.                     rs.getString(rs.getColumnIndex(DBHelper.USERS_COLUMN_PASSWORD)),
  90.                     rs.getString(rs.getColumnIndex(DBHelper.USERS_COLUMN_CURRENCY)),
  91.                     rs.getString(rs.getColumnIndex(DBHelper.USERS_COLUMN_COUNTRY)));
  92.         }
  93.  
  94.         if (!rs.isClosed())  {
  95.             rs.close();
  96.         }
  97.         return user;
  98.     }
  99.  
  100.     public User getUserInfo(String email) {
  101.         Cursor rs = db.rawQuery( "SELECT * FROM " + "\"" + DBHelper.TABLE_USERS + "\"" +" WHERE "
  102.                 + "\"" + DBHelper.USERS_COLUMN_EMAIL + "\"" + "=" + "\"" + email + "\"", null );
  103.  
  104.         User user = null;
  105.  
  106.         if(rs.moveToFirst()){
  107.             user = new User(
  108.                     rs.getLong(rs.getColumnIndex(DBHelper.USERS_COLUMN_USERS_ID)),
  109.                     rs.getString(rs.getColumnIndex(DBHelper.USERS_COLUMN_NAME)),
  110.                     rs.getString(rs.getColumnIndex(DBHelper.USERS_COLUMN_EMAIL)),
  111.                     rs.getString(rs.getColumnIndex(DBHelper.USERS_COLUMN_PASSWORD)),
  112.         }
  113.  
  114.         if (!rs.isClosed())  {
  115.             rs.close();
  116.         }
  117.         return user;
  118.     }
  119. }