Create DataBase in Android using SQL Lite

public class DatabaseHandler extends SQLiteOpenHelper {       // All Static variables     // Database Version     private static final int DATABASE_VERSION = 1;       // Database Name     private static final String DATABASE_NAME = "contactsManager";       // Contacts table name     private static final String TABLE_CONTACTS = "contacts";       // Contacts Table Columns names     private static final String KEY_ID = "id";     private static final String KEY_NAME = "name";     private static final String KEY_PH_NO = "phone_number";       public DatabaseHandler(Context context) {         super(context, DATABASE_NAME, null, DATABASE_VERSION);     }       // Creating Tables     @Override     public void onCreate(SQLiteDatabase db) {         String CREATE_CONTACTS_TABLE = "CREATE TABLE " + TABLE_CONTACTS + "("                 + KEY_ID + " INTEGER PRIMARY KEY," + KEY_NAME + " TEXT,"                 + KEY_PH_NO + " TEXT" + ")";         db.execSQL(CREATE_CONTACTS_TABLE);     }       // Upgrading database     @Override     public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {         // Drop older table if existed         db.execSQL("DROP TABLE IF EXISTS " + TABLE_CONTACTS);           // Create tables again         onCreate(db);     }       /**      * All CRUD(Create, Read, Update, Delete) Operations      */       // Adding new contact     void addContact(Contact contact) {         SQLiteDatabase db = this.getWritableDatabase();           ContentValues values = new ContentValues();         values.put(KEY_NAME, contact.getName()); // Contact Name         values.put(KEY_PH_NO, contact.getPhoneNumber()); // Contact Phone           // Inserting Row         db.insert(TABLE_CONTACTS, null, values);         db.close(); // Closing database connection     }       // Getting single contact     Contact getContact(int id) {         SQLiteDatabase db = this.getReadableDatabase();           Cursor cursor = db.query(TABLE_CONTACTS, new String[] { KEY_ID,                 KEY_NAME, KEY_PH_NO }, KEY_ID + "=?",                 new String[] { String.valueOf(id) }, null, null, null, null);         if (cursor != null)             cursor.moveToFirst();           Contact contact = new Contact(Integer.parseInt(cursor.getString(0)),                 cursor.getString(1), cursor.getString(2));         // return contact         return contact;     }       // Getting All Contacts     public List getAllContacts() {         List contactList = new ArrayList();         // Select All Query         String selectQuery = "SELECT  * FROM " + TABLE_CONTACTS;           SQLiteDatabase db = this.getWritableDatabase();         Cursor cursor = db.rawQuery(selectQuery, null);           // looping through all rows and adding to list         if (cursor.moveToFirst()) {             do {                 Contact contact = new Contact();                 contact.setID(Integer.parseInt(cursor.getString(0)));                 contact.setName(cursor.getString(1));                 contact.setPhoneNumber(cursor.getString(2));                 // Adding contact to list                 contactList.add(contact);             } while (cursor.moveToNext());         }           // return contact list         return contactList;     }       // Updating single contact     public int updateContact(Contact contact) {         SQLiteDatabase db = this.getWritableDatabase();           ContentValues values = new ContentValues();         values.put(KEY_NAME, contact.getName());         values.put(KEY_PH_NO, contact.getPhoneNumber());           // updating row         return db.update(TABLE_CONTACTS, values, KEY_ID + " = ?",                 new String[] { String.valueOf(contact.getID()) });     }       // Deleting single contact     public void deleteContact(Contact contact) {         SQLiteDatabase db = this.getWritableDatabase();         db.delete(TABLE_CONTACTS, KEY_ID + " = ?",                 new String[] { String.valueOf(contact.getID()) });         db.close();     }       // Getting contacts Count     public int getContactsCount() {         String countQuery = "SELECT  * FROM " + TABLE_CONTACTS;         SQLiteDatabase db = this.getReadableDatabase();         Cursor cursor = db.rawQuery(countQuery, null);         cursor.close();           // return count         return cursor.getCount();     }   }

Install and Uninstall Application using intent

Install APK using Intent:-

Intent intent = new Intent(Intent.ACTION_VIEW);
intent.setDataAndType(apkUri, "application/vnd.android.package-archive");
startActivity(intent);

 

Uninstall APK using Intent:

 

Intent intent = new Intent(Intent.ACTION_DELETE, Uri.fromParts("package",
getPackageManager().getPackageArchiveInfo(apkUri.getPath(), 0).packageName,null));
startActivity(intent);

Find All Circle point in android

 for (int d = 0; d < 360; d++)
     {
            for(int r = 0; r < (int)(diameter/2); r++)
            {
            double x = r * Math.cos(Math.toRadians(d));
            double y = r * Math.sin(Math.toRadians(d));
              }
         }

Set Height,Width and weight of view In Android

    LinearLayout.LayoutParams= new LinearLayout.LayoutParams(
                        LayoutParams.MATCH_PARENT,
                        LayoutParams.MATCH_PARENT, 0.5f);

Draw Transprent Bitmap on Android Canvas

Bitmap bitmap2 =Bitmap.createBitmap(bmp.getWidth(), bmp.getHeight(), Bitmap.Config.ARGB_8888);
        int width = bmp.getWidth();
        int height = bmp.getHeight();
        for(int x = 0; x < width; x++)
        {
            for(int y = 0; y < height; y++)
            {
              
                    bitmap2.setPixel(x, y, Color.TRANSPARENT);
             }
        }
        canvas.drawBitmap( bitmap2, 10, 10, p);

Draw And Move watch Needle on android canvas

import android.content.Context;
import android.graphics.Canvas;
import android.graphics.Color;
import android.graphics.Paint;

public class MeterInAndroid {
    private int height;
    private int width;  
    int y=0;
    private int radius=100;
    public MeterInAndroid(Context context,int h,int w)
    {
        height=h;
        width=w;
    }
    public void Draw(Canvas canvas)
    {
        Paint p=new Paint();
        p.setColor(Color.WHITE);  
        double Number = Math.PI * 2 / 10;
        double Number2=Number*y;
        y++;
        float endX = (float) (width/2+(radius*(Math.cos(Number2))));
        float  endY = (float) (height/2+(radius*(Math.sin(Number2))));
        canvas.drawLine(width/2, height/2, endX, endY, p);
    }

}

PHP Page for create and generate XML and JSON Object from DataBase

<?php
/* require the user as the parameter */
if(isset($_GET['user']) && intval($_GET['user'])) {

  /* soak in the passed variable or set our own */
  $number_of_posts = isset($_GET['num']) ? intval($_GET['num']) : 10; //10 is the default
  $format = strtolower($_GET['format']) == 'json' ? 'json' : 'xml'; //xml is the default
  $user_id = intval($_GET['user']); //no default

  /* connect to the db */
  $link = mysql_connect('localhost','root','') or die('Cannot connect to the DB');
  mysql_select_db('test',$link) or die('Cannot select the DB');

  /* grab the posts from the db */
  $query = "SELECT post_title, guid FROM wp_posts ";
  $result = mysql_query($query,$link) or die('Errant query:  '.$query);

  /* create one master array of the records */
  $posts = array();
  if(mysql_num_rows($result)) {
    while($post = mysql_fetch_assoc($result)) {
      $posts[] = array('post'=>$post);
    }
  }

  /* output in necessary format */
  if($format == 'json') {
    header('Content-type: application/json');
    echo json_encode(array('posts'=>$posts));
  }
  else {
    header('Content-type: text/xml');
    echo '<posts>';
    foreach($posts as $index => $post) {
      if(is_array($post)) {
        foreach($post as $key => $value) {
          echo '<',$key,'>';
          if(is_array($value)) {
            foreach($value as $tag => $val) {
              echo '<',$tag,'>',htmlentities($val),'</',$tag,'>';
            }
          }
          echo '</',$key,'>';
        }
      }
    }
    echo '</posts>';
  }

  /* disconnect from the db */
  @mysql_close($link);
}

?>