Android Open Source - Swinedroid Server Db Adapter

• Back to Timer/monitor  ↑

From Project

Back to project page Swinedroid.

License

The source code is released under:

GNU General Public License

Java Source Code

package com.legind.sqlite;
/*from  w w  w .j a v  a2s.c  o m*/
import android.content.ContentValues;
import android.content.Context;

public class ServerDbAdapter extends DbAdapter{
  
  public static final String KEY_HOST = "host";
  public static final String KEY_PORT = "port";
  public static final String KEY_USERNAME = "username";
  public static final String KEY_PASSWORD = "password";
  public static final String KEY_MD5 = "md5";
  public static final String KEY_SHA1 = "sha1";
  
  private static final String DATABASE_TABLE = "servers";
  private static final String[] FIELDS_STRING = {KEY_HOST, KEY_PORT, KEY_USERNAME, KEY_PASSWORD, KEY_MD5, KEY_SHA1};
  
  /**
   * Constructor - takes the context to allow the database to be
   * opened/created
   * 
   * @param ctx the Context within which to work
   */
  public ServerDbAdapter(Context ctx) {
    super(ctx, DATABASE_TABLE, FIELDS_STRING);
  }
  
  
  /**
   * Create a new server using the host, port, username, and password provided. If the server is
   * successfully created return the new rowId for that server, otherwise return
   * a -1 to indicate failure.
   * 
   * @param host the hostname of the server
   * @param port the port for which the swinedroid server is connected
   * @param username the username for the swinedroid server
   * @param password the password for the swinedroid server
   * @return rowId or -1 if failed
   */
  public long createServer(String host, int port, String username, String password) {
      ContentValues initialValues = new ContentValues();
      if(host.length() > 128)
        host = host.substring(0,127);
      if(port > 65535 || port < 1)
        port = 65535;
      if(username.length() > 128)
        username = username.substring(0,127);
      if(password.length() > 128)
        password = password.substring(0,127);
      initialValues.put(KEY_HOST, host);
      initialValues.put(KEY_PORT, port);
      initialValues.put(KEY_USERNAME, username);
      initialValues.put(KEY_PASSWORD, password);
      return super.mDb.insert(DATABASE_TABLE, null, initialValues);
  }
  
  /**
   * Update the server using the details provided. The server to be updated is
   * specified using the rowId, and it is altered to use the host, port,
   * username, and password values passed in
   * 
   * @param rowId id of server to update
   * @param host value to set server host to
   * @param port value to set server port to
   * @param username value to set server username to
   * @param password value to set server password to
   * @param md5 value to set server md5 to
   * @param sha1 value to set server sha1 to
   * @return true if the server was successfully updated, false otherwise
   */
  public boolean updateServer(long rowId, String host, int port, String username, String password, String md5, String sha1) {
      ContentValues args = new ContentValues();
      args.put(KEY_MD5, md5);
      args.put(KEY_SHA1, sha1);
      return updateServerHelper(args, rowId, host, port, username, password);
  }
  
  /**
   * Update the server using the details provided. The server to be updated is
   * specified using the rowId, and it is altered to use the host, port,
   * username, and password values passed in
   * 
   * @param rowId id of server to update
   * @param host value to set server host to
   * @param port value to set server port to
   * @param username value to set server username to
   * @param password value to set server password to
   * @return true if the server was successfully updated, false otherwise
   */
  public boolean updateServer(long rowId, String host, int port, String username, String password) {
      ContentValues args = new ContentValues();
      return updateServerHelper(args, rowId, host, port, username, password);
  }
  
  /*
   * Helper function for updateServer
   */
  private boolean updateServerHelper(ContentValues args, long rowId, String host, int port, String username, String password){
      if(host.length() > 128)
        host = host.substring(0,127);
      if(port > 65535 || port < 1)
        port = 65535;
      if(username.length() > 128)
        username = username.substring(0,127);
      if(password.length() > 128)
        password = password.substring(0,127);
      args.put(KEY_HOST, host);
      args.put(KEY_PORT, port);
      args.put(KEY_USERNAME, username);
      args.put(KEY_PASSWORD, password);
      return mDb.update(DATABASE_TABLE, args, KEY_ROWID + "=" + rowId, null) > 0;
  }
  
  /*
   * Update server md5 and sha1 hashes
   * 
   * @param rowId id of server to update
   * @param md5 value to set server md5 to
   * @param sha1 value to set server sha1 to
   * @return true if the server was successfully updated, false otherwise 
   */
  public boolean updateServerHashes(long rowId, String md5, String sha1){
      ContentValues args = new ContentValues();
      args.put(KEY_MD5, md5);
      args.put(KEY_SHA1, sha1);
      return mDb.update(DATABASE_TABLE, args, KEY_ROWID + "=" + rowId, null) > 0;
  }
}

Java Source Code List

• Back to Timer/monitor  ↑