package it372.drawdots1; import android.content.Context; import android.database.Cursor; import android.database.sqlite.SQLiteDatabase; import android.graphics.Canvas; import android.graphics.Color; import android.graphics.Paint; import android.graphics.Point; import android.view.MotionEvent; import android.view.View; import java.util.ArrayList; public class MyView extends View { private Context savedContext; public MyView(Context context) { super(context); savedContext = context; } /* this.setOnTouchListener(new View.OnTouchListener() { @Override public boolean onTouch(View v, MotionEvent e) { if (e.getAction( ) == MotionEvent.ACTION_UP) { points.add(new Point( (int) e.getX( ), (int) e.getY( ))); } invalidate( ); return true; } });*/ @Override public void onDraw(Canvas canvas) { Paint paint = new Paint( ); PointsDBHelper dbh = new PointsDBHelper(savedContext); SQLiteDatabase db = dbh.getReadableDatabase( ); Cursor c = db.query("points", new String[ ] {"id", "xposition", "yposition"}, null, null, null, null, null); c.moveToFirst( ); do { int id = c.getInt(0); double x = c.getFloat(1); double y = c.getFloat(2); System.out.println(id + " " + x + " " + y); } while (c.moveToNext( )); } }