put in LIST Sample Data to debug, also how view SQLITE DB Data from Eclipse IDE for debug purposes

[Leonidas Savvides]

can you debug, I failed read data[emulator shows error - do not show page], well if null/NoData page will still appear? how put in List<String[]> names, Sample Data to debug, also how view SQLITE DB TABLE Data from Eclipse IDE for debug purposes? below read/write are ok?

Button5.java[read activity]

public class Button5 extends Activity {//implements OnClickListener 
	private TextView output;
	private DataManipulator dh;
	protected void onCreate(Bundle savedInstanceState){
		super.onCreate(savedInstanceState);
        setContentView(R.layout.button5);
       
        this.output = (TextView) this.findViewById(R.id.button1_label);
        
        List<String[]> names = this.dh.selectAll();
        StringBuilder sb = new StringBuilder();
        sb.append("Entries in Phone Book:\n");
        for (String[] name : names) {
           sb.append(name[0]+" - "+name[1]+ "\n"+name[2]+" - "+name[3]+ "\n");
        }
                
        this.output.setText(sb.toString()); 


DataManipulator.java


public class DataManipulator {
	private static final  String DATABASE_NAME = "mydatabase.db";
	private static final int DATABASE_VERSION = 1;
	static final String TABLE_NAME = "newtable";
	private Context context;
	SQLiteDatabase db;
		 
	private SQLiteStatement insertStmt;
	private static final String INSERT = "insert into "
	      + TABLE_NAME + " (name,number,skypeId,address) values (?,?,?,?)";
	public DataManipulator(Context context) {
			      this.context = context;
			      OpenHelper openHelper = new OpenHelper(this.context);
			      this.db = openHelper.getWritableDatabase();
			      this.insertStmt = this.db.compileStatement(INSERT);
			   }
			   public long insert(String name,String number,String skypeId,String address) {
			      this.insertStmt.bindString(1, name);
			      this.insertStmt.bindString(2, number);
			      this.insertStmt.bindString(3, skypeId);
			      this.insertStmt.bindString(4, address);
			      return this.insertStmt.executeInsert();
			   }
			 
			   public void deleteAll() {
			      this.db.delete(TABLE_NAME, null, null);
			   }
			   public List<String[]> selectAll() {
			      List<String[]> list = new ArrayList<String[]>();
			      Cursor cursor = this.db.query(TABLE_NAME, new String[] { "name","number","skypeId","address" },
			        null, null, null, null, "name asc");
			      int x=0;
			      if (cursor.moveToFirst()) {
			         do {
			        	    String[] b1=new String[]{cursor.getString(0),cursor.getString(1),cursor.getString(2),cursor.getString(3)};
			        	    
			        	    list.add(b1);
		
			                x=x+1;
			         } while (cursor.moveToNext());
			      }
			      if (cursor != null && !cursor.isClosed()) {
			         cursor.close();
			      }
		      return list;
			   }
			 
			   private static class OpenHelper extends SQLiteOpenHelper {
			 
			      OpenHelper(Context context) {
			         super(context, DATABASE_NAME, null, DATABASE_VERSION);
			      }
			 
			      @Override
			      public void onCreate(SQLiteDatabase db) {
			         db.execSQL("CREATE TABLE " + TABLE_NAME + "(id INTEGER PRIMARY KEY, name TEXT, number TEXT, skypeId TEXT, address TEXT)");
			      }
			 
			      @Override
			      public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
			         db.execSQL("DROP TABLE IF EXISTS " + TABLE_NAME);
			         onCreate(db);
			      }
			   }


}

[Leonidas Savvides]

ADD.java activity
case R.id.Button01add:
    		View editText1 = (EditText) findViewById(R.id.name);
    		View editText2 = (EditText) findViewById(R.id.number);
    		View editText3 = (EditText) findViewById(R.id.skypeId);
    		View editText4 = (EditText) findViewById(R.id.address);	
    		String myEditText1=((TextView) editText1).getText().toString();
    		String myEditText2=((TextView) editText2).getText().toString();
    		String myEditText3=((TextView) editText3).getText().toString();
    		String myEditText4=((TextView) editText4).getText().toString();
    		
    	        	        this.dh = new DataManipulator(this);
    	        	        //this.dh.deleteAll();
    	        	        this.dh.insert(myEditText1,myEditText2,myEditText3,myEditText4);

    		showDialog(DIALOG_PAUSED_ID);

    		break;

[Perry Hoekstra]

In terms of viewing SQLite data within the IDE, I posted this response last week: What you can do is install the JDBC driver for SQLite (there are a couple) and with that, use JDBC plugins such as DBEdit.

If you want more information, there is a entry on the Eclipse wiki: http://wiki.eclipse.org/Connecting_to_SQLite

Perry Hoekstra