thanks a lot sir for everything you answered for my last questions now sir i just have another 3 questions that is


Q 1.
i will specify a swing code for JTable using NETBEANS so would you tell me is it correct code for JTable and is there other way of specifying it.

code:
String c=Combo.getSelectedItem().toString();
String sql;
if(c.equals("PAID"))
{
sql="SELECT * FROM Fees_Struc, Student, Fees_Pay WHERE Fees_Struc.Hostel=Student.Hostel And Student.Roll=Fees_Pay.Roll And Fees_Pay.Status=?";
}
else
{
sql="SELECT * FROM Fees_Struc, Student, Fees_Pay WHERE Fees_Struc.Hostel=Student.Hostel And Student.Roll=Fees_Pay.Roll And Fees_Pay.Status=?";
}


try
{
int row=0,columns=0;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:Stu","admin","admin");
try
{
PreparedStatement stm=con.prepareStatement(sql);
stm.setString(1, c);
ResultSet res=stm.executeQuery();
while(res.next())
{
row=res.getRow();

}
PreparedStatement stm1=con.prepareStatement(sql);
stm1.setString(1, c);
res=stm1.executeQuery();
ResultSetMetaData md = res.getMetaData();
columns = md.getColumnCount();
Object r[][]=new Object[row][columns] ;
int rindex=0;
while(res.next())
{
r[rindex][0]=res.getInt("Roll");
r[rindex][1]=res.getString("Name");
r[rindex][2]=res.getString("Add");
r[rindex][3]=res.getInt("Age");
r[rindex][4]=res.getString("Course");
r[rindex][5]=res.getString("Class");
r[rindex][6]=res.getString("Sex");
r[rindex][7]=res.getString("Hostel");
r[rindex][8]=res.getInt("Year");
r[rindex][9]=res.getString("Month");
r[rindex][10]=res.getInt("Paid");
r[rindex][11]=res.getInt("Bal");
r[rindex][12]=res.getString("Status");
rindex++;
}
jTable1.setModel(new javax.swing.table.DefaultTableModel(r, new String [] {"Roll No", "Name","Address","Age","Course","Class","Sex","Hostel","Year","Month","Paid","Bal","Status" }
));

res.close();
stm.close();
stm1.close();
con.close();
}



catch(SQLException ex)
{
javax.swing.JOptionPane.showMessageDialog(null,"Cannot display","Blank",javax.swing.JOptionPane.ERROR_MESSAGE);
}
}
catch(Exception e)
{
javax.swing.JOptionPane.showMessageDialog(null,"Cannot display","Blank",javax.swing.JOptionPane.ERROR_MESSAGE);
}
}

Q 2.
i want to transfer it to excel for printing so can u plz specify code for this above table.

Q 3.

i want to have another table like this is it possible: if it is can u give me code in NetBeans

Table Header Table Fields
_____________________________________________________
| ROll NO | Data from Database |
|______________|______________________________________|
| Name | Data from Database |
|______________|______________________________________|
| Address | Data from Database |
|______________|______________________________________|
| Age | Data from Database |
|______________|______________________________________|
| Course | Data from Database |
|______________|______________________________________|

sorry for specifying like this.....