Display data from a MS Access database

[jamesg]

Hey guys I'm doing a project for school and I'm wondering how you display data from an MS Access database in a JFrame. It's a list of animals or plants with different attributes in an access table and I want to be able to display all the values and I want to be able to do a search for a specific entry and display all it's information. I've searched everywhere and the only information I've found regarding displaying data in NetBeans from a database is populating a JTable which is not what I'm looking for. Keep in mind that I'm still in school so we haven't dealt with any "intricate" code.

I would really appreciate some help

cheers

[bolsover]

Using Access is actually a little more difficult (IMHO) that some other database - but that said, not too difficult.

Before you start attempting to get the data into a JFrame or JTable, the first thing you need to do is establish a connection to the database and make sure you can retrieve data into your Java program.

I've not tested any of this but this looks like a good primer:

http://www.codeproject.com/Articles/35018/Access-MS-Access-Databases-from-Java

Once you have learned how to connect to and retrieve data from the database, create a JFrame with a TextArea and get the retrieved data to display in the TextArea.

db

[seanh123]

Hey "james" lol. ima show u this at school