join the table set on jtable with rs2xml.jar
try
{
Class.forName("com.mysql.jdbc.Driver");
java.sql.Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3305/commity","root","root");
String sql="select m.MemberName,m.ContactNo,m.Amount,g.Group_Number,g.Starting_Date,g.Ending_Date,g.Cost,g.Installment,g.No_of_Members from member m\n" +
" inner join group1 g on m.Group_Number=g.Group_Number";
java.sql.PreparedStatement pst=con.prepareStatement(sql);
ResultSet rs = pst.executeQuery(sql);
member.setModel(DbUtils.resultSetToTableModel(rs));
con.close();
pst.close();
}
catch(Exception e)
{
JOptionPane.showMessageDialog(null, e);
}