Getting ONLY database table values, while skipping column names

[iNko]

Got this method to populate a table from database:

private void Update_Table(){
    try{
     String sql = "SELECT * FROM Users WHERE Login='Admin'"; 
     pst = conn.prepareStatement(sql);
     rs = pst.executeQuery(sql);
     jTable1.setModel(DbUtils.resultSetToTableModel(rs));
    } 
    catch (Exception e){
        JOptionPane.showMessageDialog(null, e);
    }
}

Currently, it gets all values that i need, but it also displays the column names (for example user_name, user_id, user_passwordetc..). I want to make custom Titles for my table (for example instead of user_id, i want the title to be just ID). What do i do to skip the column names from database and just take the values?


Also ran into another problem, how do i display more than 1 table?

private void EsamiPranesimaiTableMethod(){

    try{
     String sql = "SELECT Message_name FROM Messages_group WHERE group_name='Testgroup'";
     pst = conn.prepareStatement(sql);
     rs = pst.executeQuery(sql);
     String sql2 = "SELECT Message_name FROM Messages_single WHERE Username='Testname'";
     pst = conn.prepareStatement(sql2);
     rs2 = pst.executeQuery(sql2);
     Table_EsamiPranesimai.setModel(DbUtils.resultSetToTableModel(rs));
     Table_EsamiPranesimai.setModel(DbUtils.resultSetToTableModel(rs2));
    } 
    catch (Exception e){
        JOptionPane.showMessageDialog(null, e);
    }
}

Currently 'Table_EsamiPranesimai.setModel(DbUtils.resultSetT oTableModel(rs2));' overwrites 'Table_EsamiPranesimai.setModel(DbUtils.resultSetT oTableModel(rs));' , so i get only 1 result.. how do i make it so it would display both?

Edit: i think the 2nd problem can be solved with a proper SQL code, something like this:

String sql = "SELECT Message_name  FROM Messages_group WHERE group_name='Testgroup' UNION SELECT Message_name FROM Messages_single WHERE Username='Testname'";

Still didnt find an answer to the first problem tho..

[Tolls]

For the first part, what does DbUtils.resultSetToTableModel return?
What sort of TableModel?
If that is your own utility class then simply change the model.

[iNko]

For the first part, what does DbUtils.resultSetToTableModel return?
What sort of TableModel?
If that is your own utility class then simply change the model.

SQL code that describes witch data to take, also where

String sql = "SELECT * FROM Users WHERE Login='Admin'";

prepares the SQL code

pst = conn.prepareStatement(sql);

executes the SQL code

rs = pst.executeQuery(sql);

'DbUtils.resultSetToTableModel' i think checks the executed SQL code and then fills the 'jTable1' with that data

jTable1.setModel(DbUtils.resultSetToTableModel(rs));

This is how i understand my code..

[Tolls]

So, what is DbUtils?
Where is it from?
That's where you want to make the changes.

[iNko]

DbUtils is this - import net.proteanit.sql.DbUtils;
its not used anywhere else

[iNko]

ok got it figured out, it all depends on the SQL code..

String sql = "SELECT Message_name FROM Messages_group WHERE group_name='Testgroup'";

if i add

String sql = "SELECT Message_name as RandomTitleName FROM Messages_group WHERE group_name='Testgroup'";

The title will be RandomTitleName, instead of the one in the database table