i want display all details in list view from sqlite database. and how to set custom adopter in main activity please help me. my code is here....
public class MainActivity extends Activity {
EditText eid,ename;
Button add;
public DatabaseClass mdb=null;
public Cursor c=null;
public SQLiteDatabase db=null;
public static final String DATABASE_NAME="Sample.db";
public static final int DATABASE_VERSION=1;
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
eid=(EditText)findViewById(R.id.rid);
ename=(EditText)findViewById(R.id.rname);
add=(Button)findViewById(R.id.radd);
mdb=new DatabaseClass(getApplicationContext(), DATABASE_NAME, null, DATABASE_VERSION);
add.setOnClickListener(new View.OnClickListener() {
@Override
public void onClick(View arg0) {
// TODO Auto-generated method stub
db = mdb.getWritableDatabase();
ContentValues cv=new ContentValues();
int id=Integer.parseInt(eid.getText().toString());
String name=ename.getText().toString();
cv.put("ID",id );
cv.put("NAME",name );
db.insert("DEMO", null, cv);
}
});
}
}
database class
public class DatabaseClass extends SQLiteOpenHelper{
public DatabaseClass(Context context, String name, CursorFactory factory,
int version) {
super(context, name, factory, version);
// TODO Auto-generated constructor stub
}
@Override
public void onCreate(SQLiteDatabase db) {
// TODO Auto-generated method stub
db.execSQL("CREATE TABLE DEMO(ID INTEGER,NAME VARCHAR);");
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion)
{
// TODO Auto-generated method stub
}
}
Aucun commentaire:
Enregistrer un commentaire