JTable output from db query

[Aron Jhed Amiscosa]

hi there...

i would like to ask, is it possible to make a JTable show DB columns through query only?

i mean, like i would execute

select * from some_table

then the table would show up the contents..

just like how the mySQL query browser table works.. is it possible on a JTable?

because i've been using JTable with a custom model, but its contents are programmatically made. (built within the program)

i would like the table to be sort of a dynamic one that depends on queries. is there a possibility to make something like that?

i would like to get some knowledge and some ideas. (if it is possible)

thanks in advance..

[Darryl Burke]

Check out camickr's http://tips4java.wordpress.com/2009/03/12/table-from-database/

[Aron Jhed Amiscosa]

 

Darryl Burke wrote:Check out camickr's http://tips4java.wordpress.com/2009/03/12/table-from-database/

hi. thanks for the reply.

i tried to use mr. camick's work.

here's my usage..

try
{
Statement s = con.createStatement();
ResultSet rs = s.getResultSet();
s.execute(query); // select * from my_table
System.out.println("Query Executed");
ListTableModel model = ListTableModel.createModelFromResultSet(rs);
JTable SQLTable = new JTable(model);
tableScroll.add(SQLTable);
tableScroll.repaint();
rs.close();
s.close();
con.close();
} catch (Exception e)
{
e.printStackTrace();
} 

my code somewhat gives me a NullPointerException that points to this line of the ListTableModel

ResultSetMetaData metaData = resultSet.getMetaData();

which part did i messed up? :O help.

[Rob Spoor]

 

Jhedzkie Skies wrote:

 ResultSet rs = s.getResultSet();
s.execute(query); // select * from my_table

Try switching these two statements. You must first execute the query before you can get the results.

[Aron Jhed Amiscosa]

 

Rob Prime wrote:

Jhedzkie Skies wrote:

 ResultSet rs = s.getResultSet();
s.execute(query); // select * from my_table

Try switching these two statements. You must first execute the query before you can get the results.

right. my bad. :|

now i need to put the table on my frame. but its not repainting.

ListTableModel model = ListTableModel.createModelFromResultSet(rs);
JTable SQLTable = new JTable(model);
JScrollPane tableScroll = new JScrollPane();
tableScroll.setViewportView(SQLTable);
tablePanel.add(tableScroll);
tablePanel.repaint();
tablePanel.validate();

am i doing it right? please help.

[Maneesh Godbole]

table.revalidate();
table.repaint();

[Aron Jhed Amiscosa]

 

Maneesh Godbole wrote:

table.revalidate();
table.repaint();

did. just showing only table column headers.

not showing table contents. :|

[Maneesh Godbole]

Does tablePanel have BorderLayout?
Is there any row data coming from the DB after you invoke createModelFromResultset()?

[Aron Jhed Amiscosa]

 

Maneesh Godbole wrote:Does tablePanel have BorderLayout?
Is there any row data coming from the DB after you invoke createModelFromResultset()?

i put

tablePanel.setLayout(new BorderLayout());
tablePanel.add(tableScroll);
tablePanel.revalidate();
tablePanel.repaint();

and yes, there are row data from the db (i believe) because the db is not empty..

my current code for the whole method is this

public void executeMyQuery() throws SQLException
{
String query = tp.getText(); // gets the query input
try
{
Connection con = DriverManager.getConnection("jdbc:mysql://"+host+":"+port+"/"+schema+"",username,password);
Statement s = con.createStatement();
s.execute(query);
ResultSet rs = s.getResultSet();
System.out.println(query);
System.out.println("Query Executed");
System.out.println("[ResultSet]");
while(rs.next())
{
System.out.print(rs.getString(1)+"\t");
System.out.print(rs.getString(2)+"\t");
System.out.print(rs.getString(3)+"\t");
System.out.print(rs.getString(4)+"\t");
System.out.print(rs.getString(5)+"\n");'
//just to see if there is something that could be fetched from the DB
}
ListTableModel model = ListTableModel.createModelFromResultSet(rs);
JTable SQLTable = new JTable(model);
JScrollPane tableScroll = new JScrollPane();
tableScroll.setViewportView(SQLTable);
tablePanel.setLayout(new BorderLayout());
tablePanel.add(tableScroll,BorderLayout.CENTER);
tablePanel.revalidate();
tablePanel.repaint();
SQLTable.setModel(model);
SQLTable.getTableHeader().setReorderingAllowed(false);
SQLTable.revalidate();
SQLTable.repaint();
rs.close();
s.close();
con.close();
} catch (Exception e)
{
e.printStackTrace();
}
} 

[Rob Spoor]

 

Jhedzkie Skies wrote:

 while(rs.next())
{
System.out.print(rs.getString(1)+"\t");
System.out.print(rs.getString(2)+"\t");
System.out.print(rs.getString(3)+"\t");
System.out.print(rs.getString(4)+"\t");
System.out.print(rs.getString(5)+"\n");'
//just to see if there is something that could be fetched from the DB
}
ListTableModel model = ListTableModel.createModelFromResultSet(rs);

The loop skips past all records, so when you call ListTableModel.createModelFromResultSet(rs) the result set is already at the end and nothing will be put into the model.

[Paul Clapham]

//just to see if there is something that could be fetched from the DB

Actually that comment is not accurate. What the code in that loop actually does is to really, really fetch the data from the database. So once it's finished, the result set cursor is at the end of the result set and there is no data left to be displayed in the table. Just don't do that.

[Aron Jhed Amiscosa]

 

Rob Prime wrote:

Jhedzkie Skies wrote:

 while(rs.next())
{
System.out.print(rs.getString(1)+"\t");
System.out.print(rs.getString(2)+"\t");
System.out.print(rs.getString(3)+"\t");
System.out.print(rs.getString(4)+"\t");
System.out.print(rs.getString(5)+"\n");'
//just to see if there is something that could be fetched from the DB
}
ListTableModel model = ListTableModel.createModelFromResultSet(rs);

The loop skips past all records, so when you call ListTableModel.createModelFromResultSet(rs) the result set is already at the end and nothing will be put into the model.

i see. that's why... im such a newbie on this. thanks you guys. its working cool right now. many many thanks.