DataBase Add_Delete_Update in SQLite3

MainActivity

1. public class MainActivity extends Activity {

   private EditText ed;
   private Button add;
   ContentValues values;
   DataB dataB;
   @Override
   protected void onCreate(Bundle savedInstanceState) {
   super.onCreate(savedInstanceState);
   setContentView(R.layout.activity_main);
   ed=(EditText)findViewById(R.id.addEdit);
   add=(Button)findViewById(R.id.addBtn);
   values=new ContentValues();
   dataB=new DataB(MainActivity.this, “DB”, null, 1);

   add.setOnClickListener(new OnClickListener() {

   @Override
   public void onClick(View arg0) {
   String n=ed.getText().toString();

   values.put(“name”, n);
   dataB.ins(values);

   Intent i=new Intent(MainActivity.this,ListV.class);
   startActivity(i);
   }
   });
   }
   }

   DATABASE Class

2. public class DataB extends SQLiteOpenHelper {

   public DataB(Context context, String name, CursorFactory factory,
   int version) {
   super(context, name, factory, version);
   }

   @Override
   public void onCreate(SQLiteDatabase arg0) {
   String qry=”create table N(name varchar2)”;
   arg0.execSQL(qry);
   }

   @Override
   public void onUpgrade(SQLiteDatabase arg0, int arg1, int arg2) {

   }

   public void ins(ContentValues values) {
   SQLiteDatabase database=this.getWritableDatabase();
   database.insert(“N”, null, values);

   }

   public ArrayList<HashMap<String, String>> getdatas() {
   SQLiteDatabase database=this.getReadableDatabase();
   Cursor cr=database.rawQuery(“select * from N”, null);
   ArrayList<HashMap<String, String>> arrayList=new ArrayList<HashMap<String,String>>();
   if (cr!=null) {
   cr.moveToFirst();
   do {
   String ns=cr.getString(cr.getColumnIndex(“name”));
   HashMap<String, String> hashMap=new HashMap<String, String>();
   hashMap.put(“n”, ns);
   arrayList.add(hashMap);
   } while (cr.moveToNext());
   }
   return arrayList;
   }

   public void dele(String string) {
   SQLiteDatabase database=this.getWritableDatabase();
   database.delete(“N”, “name=?”, new String[]{string});
   Log.d(“QQQQQQQQQQQQQQQ”, string);
   }

   public void upd(ContentValues values, String nnn) {
   SQLiteDatabase database=this.getWritableDatabase();
   database.update(“N”, values, “name=?”, new String[]{nnn});
   Log.d(“WWWWWWWWWWWWWWWW”,nnn);

   }
   }

   SHOW_ListView Class

3. public class ListV extends Activity {
   ListView lv;
   DataB dataB;
   @Override
   protected void onCreate(Bundle savedInstanceState) {
   // TODO Auto-generated method stub
   super.onCreate(savedInstanceState);
   setContentView(R.layout.listv);
   lv=(ListView)findViewById(R.id.listView1);
   dataB =new DataB(ListV.this, “DB”, null, 1);
   ArrayList<HashMap<String, String>> aL=dataB.getdatas();

   CustomAdapter ca=new CustomAdapter(ListV.this,aL);
   lv.setAdapter(ca);
   }
   }

Adapter Class

1. public class CustomAdapter extends BaseAdapter {

   private ListV main;
   private ArrayList<HashMap<String, String>> lst;
   LayoutInflater inflater;

   TextView tv;

   String str,nsa;

   public CustomAdapter(ListV listV,
   ArrayList<HashMap<String, String>> aL) {
   this.main=listV;
   this.lst=aL;

   }

   @Override
   public int getCount() {

   return lst.size();
   }

   @Override
   public Object getItem(int arg0) {

   return null;
   }

   @Override
   public long getItemId(int arg0) {

   return 0;
   }

   @Override
   public View getView(final int arg0, View arg1, ViewGroup arg2) {
   inflater=(LayoutInflater)main.getSystemService(Context.LAYOUT_INFLATER_SERVICE);
   arg1=inflater.inflate(R.layout.listshow, null);

   final TextView tv=(TextView)arg1.findViewById(R.id.View1);
   Button delete=(Button)arg1.findViewById(R.id.deteteBtn);
   Button update=(Button)arg1.findViewById(R.id.updateBtn);

   final DataB dataB =new DataB(main, “DB”, null, 1);

   tv.setText(“” + lst.get(arg0).get(“n”));

   delete.setOnClickListener(new OnClickListener() {

   @Override
   public void onClick(View arg) {

   str=tv.getText().toString();
   dataB.dele(str);

   lst.remove(arg0);
   notifyDataSetChanged();

   }
   });
   update.setOnClickListener(new OnClickListener() {

   @Override
   public void onClick(View arg0) {

   nsa=tv.getText().toString();
   Intent i=new Intent(main, Eits.class);
   i.putExtra(“n”, nsa);
   main.startActivity(i);
   }
   });
   return arg1;
   }

   }

2. UPDATE Class

public class Eits extends Activity {
EditText e;
Button b;
DataB dataB;
ContentValues values;
String nnn;

@Override
protected void onCreate(Bundle savedInstanceState) {
// TODO Auto-generated method stub
super.onCreate(savedInstanceState);
setContentView(R.layout.ed);

e = (EditText) findViewById(R.id.upText);
b = (Button) findViewById(R.id.updateBtn);

dataB = new DataB(Eits.this, “DB”, null, 1);
values = new ContentValues();

Intent ii = getIntent();
String nn = ii.getStringExtra(“n”);

e.setText(nn);

nnn = e.getText().toString();

b.setOnClickListener(new OnClickListener() {

@Override
public void onClick(View arg0) {
String nss = e.getText().toString();

values.put(“name”, nss);

dataB.upd(values, nnn);

Intent ilview=new Intent(Eits.this,ListV.class);
startActivity(ilview);
}
});
}
}