Thread: JTable

Hi here i get all rows from from DB. I want get sss = rs.getInt(5); from DB ant set to Colheads.
or no to column but to first Row all data from column;
Exsample

now table is  table  a    me need        a  a+1   a3   a4 ....
                     1                   1   2     3     4   .....
                     2
                     3
                     4

p2 = new JPanel();
        try {
            rs = st.executeQuery("SELECT * from item");
        } catch (SQLException ex) {
            Logger.getLogger(nn.class.getName()).log(Level.SEVERE, null, ex);
        }
        try {
            while (rs.next()) {
                s = rs.getInt(1);
                a = rs.getString(2);
                ss = rs.getInt(3);
                aa = rs.getString(4);
                sss = rs.getInt(5);
                ssss = rs.getInt(6);
                rows++;
            }
            data1 = new Object[rows][6];
            Object[] Colheads = {"Isss = rs.getInt(5) here need some help !!!!!!!!!!"};
            rs = st.executeQuery("Select * from item");
            for (int i1 = 0; i1 < rows; i1++) {
                rs.next();
                for (int j1 = 0; j1 < 6; j1++) {
                    data1[i1][j1] = rs.getString(j1 + 1);
 
                }
            }

Also at java-forums.org and codecall.net

What is the error? Kindly copy the exception trace and paste here. Well, for your information, rs.getString() never works as you did here;

for (int j1 = 0; j1 < 6; j1++) {
                    data1[i1][j1] = rs.getString(j1 + 1);
 
                }

Well, if you want to set the columnHeaders, use the DefaultTableModel and then using it set the values for table headers. Moreover, What are you talkinga bout printing like box layout and what?
Kindly be precise so that we could help you in that sense.

Okay so you mean that in database data is like

name
1
2
3

and you want to display it in your application like

name1         name2               name3
1                   2                         3

Right?
If that's so, read the data from database in ResultSet and then iterate it and on every iteration, place the data in the table columns.

Okay so take it step by step.
1. You get resultset.
2. Iterate through the result Set
3. Against each iteration, set the value of table column headers.

Isn't it simple?

So i would recommend to see this: Database Programming with JDBC and Java: Chapter 4. Database Access Through JDBC