Monday, 27 June 2011

NotificationAndroid

I do that

My Main Activity Class

public class MainActivity extends Activity implements OnItemClickListener {
/** Called when the activity is first created. */
ListView lstOneName;
ArrayAdapter myList;
private static final String URL = "http://192.168.0.30/newsletter.php";
static int last,update;
Boolean[] upd;
InputStream mFile;
ArrayList alist = new ArrayList();
ArrayList a_id = new ArrayList();ArrayList arraylist;
SQLDatabaseHelper mSQLdbHelper;
SQLiteDatabase mSQLiteDB;
@Override
public void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.main);
lstOneName = (ListView)findViewById(R.id.lstOne);
lstOneName.setOnItemClickListener(this);
myList = new ArrayAdapter(this, android.R.layout.simple_list_item_1);
mSQLdbHelper = new SQLDatabaseHelper(this);
mSQLiteDB = mSQLdbHelper.getWritableDatabase();
mSQLiteDB.setLockingEnabled(true);
getData();
upd = new Boolean[a_id.size()];
System.out.println("Upd "+upd.length+"Size of a_id befor :"+a_id.size());
for(int i=0;i();
cr = mSQLiteDB.query("newsupdate", null, null, null, null, null, null);
if(cr.getCount() == 0){
System.out.println("Database has no values");
getWrite();
}else{
cr.moveToFirst();
int i=1;
while(cr.isAfterLast()!=true){
arraylist.add(cr.getInt(1));
cr.moveToNext();
i++;
}cr.close();
}


}
public void onItemClick(AdapterView arg0, View arg1, int pos, long arg3) {
// TODO Auto-generated method stub
Toast.makeText(this, alist.get(pos), Toast.LENGTH_SHORT).show();
}
}

////////////////////////////////////////
BaseAdapter Class for Custome List view
public class List_BaseAdapter extends BaseAdapter{
LayoutInflater mLayout;
Context con;
ArrayList lstName;
ArrayList nId;
int update,last;
public List_BaseAdapter(Context ctx,ArrayList name,ArrayList id){
this.con = ctx;
this.lstName = name;
this.mLayout = LayoutInflater.from(ctx);
this.nId = id;
//this.update = up;
}
public int getCount() {
// TODO Auto-generated method stub
return nId.size();
}

public Object getItem(int position) {
// TODO Auto-generated method stub
return null;
}

public long getItemId(int position) {
// TODO Auto-generated method stub
return 0;
}

public View getView(int position, View convertView, ViewGroup parent) {
// TODO Auto-generated method stub
if(convertView == null){
convertView = mLayout.inflate(R.layout.cust_list, null);
}

final TextView tvName = (TextView)convertView.findViewById(R.id.txtName);
final TextView tvId = (TextView)convertView.findViewById(R.id.txtId);
tvName.setText(lstName.get(position).toString());
tvId.setText(nId.get(position).toString());
return convertView;
}

}

// SQLite Database Class
public class SQLDatabaseHelper extends SQLiteOpenHelper{
SQLiteDatabase db;
public SQLDatabaseHelper(Context context) {
super(context, "Newsletter", null, 1);
// TODO Auto-generated constructor stub
}

@Override
public void onCreate(SQLiteDatabase db) {
// TODO Auto-generated method stub
String mTblNewsletter = "Create TABLE newsupdate (_id INTEGER PRIMARY KEY AUTOINCREMENT , newID VARCHAR(5), newDisc VARCHAR(30))";
db.execSQL(mTblNewsletter);
System.out.println("Data base Created");
}

@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
// TODO Auto-generated method stub

}
}
//// My Main.xml







/// cust_list.xml file