Google Android - это несложно

Код: Выделить всё

 //some code 
private List<Movies> movieses;
    private QuotesDataSource qDataSource;
//some code
 @Override
    public void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.quotes_list_iew);
          Log.d(TAG, "after open");
         (this.qDataSource= new QuotesDataSource((Context)this)).open();
           movieses = this.qDataSource.getAllMovies();
           this.setListAdapter(new ArrayAdapter(this, android.R.layout.simple_list_item_1, this.movieses));
//some code

Код: Выделить всё

dataSource :
public class QuotesDataSource {
   //some code
    private String[] allMoviesColumns;
    private SQLiteDatabase database;
    private DbHelper dbHelper;
    private String TAG;
    public QuotesDataSource(final Context context) {
        super();
       
        this.allMoviesColumns = new String[] { "_id", "name" };
        this.dbHelper = new DbHelper(context);
    }
// тут беру все записи из таблицы :

 public List<Movies> getAllMovies() {
        final ArrayList<Movies> list = new ArrayList<Movies>();
        final Cursor query = this.database.query("movies", this.allMoviesColumns, (String)null, (String[])null, (String)null, (String)null, (String)null);
        query.moveToFirst();
        while (!query.isAfterLast()) {
            list.add(this.cursorToMovie(query));
            query.moveToNext();
        }
        query.close();
        return list;
    }

Код: Выделить всё

public class QuotesAdapter extends BaseAdapter {
    private final Context context;
    private ArrayList<Movies> objects;
    LayoutInflater lInflater;
public QuotesAdapter (Context context, ArrayList<Movies> objects){
    super();
    this.context = context;
    this.objects = objects;
    lInflater = (LayoutInflater) context
            .getSystemService(Context.LAYOUT_INFLATER_SERVICE);
}
    @Override
    public int getCount() {
        return this.objects.size();
    }

    @Override
    public Object getItem(int position) {
        return  this.objects.get(position);
    }

    @Override
    public long getItemId(int position) {
        return position;
    }

    @Override
    public View getView(int position, View convertView, ViewGroup parent) {
        View view = convertView;
        if (view == null) {
            view = lInflater.inflate(R.layout.quotes_list_iew, parent, false);
        }
        final Movies quote = this.objects.get(position);

        final TextView textView = new TextView(this.context);
    //     view.findViewById(R.id.quotesListView).setText(quote.getName().toString()); 
       
        return (View)textView;
    }
}