To display data other than JTable in Java Swing

First Import sql.Dbutils(download from Internet) in java program as below

import net.proteanit.sql.DbUtils;

When user clicks Load Data button ,sql query executes sql statement which fetch data as per user needs

or search criteria as below...

 JButton btnNewButton = new JButton("Load Data");

btnNewButton.setFont(new Font("Verdana", Font.PLAIN, 12));

btnNewButton.addMouseListener(new MouseAdapter() {

public void mouseClicked(MouseEvent e) {

try {

Connection conn = getConnection();

String query="select cast(staff_code as unsigned)Id,F_name Name,case sex when 'M' Then 'Male' when 'F' then 'Female'  end Gender,Post,grade_code Grade from sch_db.staff_master order by id";

PreparedStatement stat = conn.prepareStatement(query);

ResultSet res=stat.executeQuery();

table.setModel(DbUtils.resultSetToTableModel(res));

} 

catch (Exception e1) {

e1.printStackTrace();

}

}

});