How To Fetch Data From SQLite Database in Android Studio | tutorial-6

[@foxhound34]

But how do you display the data in a listView?

[@finegap]

Create a Layout for Each Row: First, create an XML layout for each row in the ListView. This layout defines how each item in the list will look. You can customize it with TextViews, ImageViews, or other widgets to display your data. Save this layout in the res/layout directory.
Create an Adapter: You need to create a custom adapter class that extends BaseAdapter or another adapter class like ArrayAdapter if you're working with simple data structures. In your custom adapter, you'll implement methods to populate the ListView with data.
Bind Data to ListView: In your activity or fragment, create an instance of the ListView and set its adapter to the custom adapter you created in step 2. This binds your data to the ListView.
java
public class MyAdapter extends BaseAdapter {
private Context context;
private List data; // Replace with your data type
public MyAdapter(Context context, List data) {
this.context = context;
this.data = data;
}
@Override
public int getCount() {
return data.size();
}
@Override
public Object getItem(int position) {
return data.get(position);
}
@Override
public long getItemId(int position) {
return position;
}
@Override
public View getView(int position, View convertView, ViewGroup parent) {
// Inflate the row layout for each item
if (convertView == null) {
LayoutInflater inflater = (LayoutInflater) context.getSystemService(Context.LAYOUT_INFLATER_SERVICE);
convertView = inflater.inflate(R.layout.list_item_layout, null);
}
// Get references to the views within the row layout
TextView textView = convertView.findViewById(R.id.textView);
// Set the data for the current item
String item = data.get(position);
textView.setText(item);
return convertView;
}
}
Use the Adapter in Your Activity: In your activity, instantiate the custom adapter and set it as the adapter for your ListView.
public class MainActivity extends AppCompatActivity {
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
// Sample data
List dataList = new ArrayList();
dataList.add("Item 1");
dataList.add("Item 2");
dataList.add("Item 3");
// Create the custom adapter and set it to the ListView
ListView listView = findViewById(R.id.listView);
MyAdapter adapter = new MyAdapter(this, dataList);
listView.setAdapter(adapter);
}
}

[@foxhound34]

@finegap thank you for the quick response. I'll look at the code you provided and more into making the listView and Adapter Class