JTables and Databases

I am looking to create a Java Table (swing), and import the information from a database table. I have created the columns with:

String[] columnNames = {"First Name",
"Last Name",
"Address",
"City ",
"Country",
"Birth_Date"};

From an example I was reading I needed the following:

Object[][] data = {???};
JTable table = new JTable(data, columnNames);

I was going to put in the name of a function (getTable) in the data array which just does a select* to get the info from the table. Is that correct? If so, what arguments would I need to pass into the getTable(), and what would my sql function need to return.

Check out Rob Camick's Table from Database
Table From Database « Java Tips Weblog

db

for some reason its saying for:

ListTableModel model = ListTableModel.createModelFromResultSet( resudltSet );

"cannot find listtablemodel" and cannot find "resultSet"

Im a little confused about the idea of a method returning a value.

If I have the method that I called getData, which is a sql call to the database (select * from customers), then isnt that method "returning" the result set to the: ListTableModel model = ListTableModel.createModelFromResultSet( resudltSet ) to the resultSet field?

I know alot of methods are public void meaning they dont return anything but in this case I need to get the result of the execute statement to pass as the resultSet right? so would it just be public getData()

JTable is one of several components needed to display a table in Swing. Another key component is the TableModel. You need to create a TableModel and assign it to the JTable. The TableModel holds the data displayed by the JTable. Look at Sun's Java Tutorial under the Swing section.

@Admins Can we create a shortcut that adds a link the the tutorial? ;-)

one more question..

so I have this method:

String[][] customer = null;

private void get_fromDB() {
customer = db.getTable();
String[] l = new String[customer.length];
for (int i = 0; i < customer.length; i++) {
l[i] = customer[i][0];
}
}

and the db.getTable() is supposed to return a string array(??)

the db.getTable method looks like this:


public String getTable() {
Statement st = null;
rs = null;
try {
String sql = "Select * from customer";
rs = st.executeQuery(sql);
System.out.println("done2");
} catch (Exception e) {
System.err.println("Got an exception! ");
System.err.println(e.getMessage());
}

}

i cant figure out what type of method I need to make this, or what to return. The getTable() requires a String [][] which im guessing is the data that comes back from my query, but how do I put that as the return statement?

I tried to put return rs; but that didnt work since rs is a result set and I need a String [][]

Your getTable's never going to work, at least until you actually have a Connection to the db, which you then use to create your Statement.

That aside, you'd then cycle through your ResultSet, turning each row into an entry in the outer part of your String array, with each column becoming an entry in the inner part of the String array. Then return that String[][] object.

Quote:

---

Originally Posted by Tolls

Your getTable's never going to work, at least until you actually have a Connection to the db, which you then use to create your Statement.

That aside, you'd then cycle through your ResultSet, turning each row into an entry in the outer part of your String array, with each column becoming an entry in the inner part of the String array. Then return that String[][] object.

---

and also this one How to Use Tables (The Java™ Tutorials > Creating a GUI With JFC/Swing > Using Swing Components). if you have questions after reading these tutorials it will be much easier to answer. the concepts behind jtables and db connections are challanging enough and put altogether doesn't make it easier.

In general, I suggest avoiding using any sort of [][]. Instead, create a MyTableRow class that contains the fields that will be displayed in each row. Store the rows in a List inside the TableModel.

When you read through your result set, create MyTableRow instances and add them to the List inside the TableModel.

What he said...
Up there ^.
:)