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(); } ...