public void getList(int rep,String searchText)
    {
        String tempQuery = "";
        if(rep == 0) {
            tempQuery = DEFAULT_QUERY;
        }
        else if(rep == 1) {
            searchText = searchText.toUpperCase();
            tempQuery = "select * from (Select compid,compname,contactperson,contactno1,contactno2,email,compvname from company order by compname) where compvname like '"+searchText+"'";
            System.out.println(tempQuery);
        }
        
	Statement stmt = null;       
	this.connect();
	conn = this.getConnection();
                
	try {
            stmt = conn.createStatement();
        }
                
	catch (SQLException e) {
            e.printStackTrace();
        }
		
	ResultSet rs;
	try
        {
            rs = stmt.executeQuery(tempQuery);
            
            try {
                tableUtils.updateTableModelData((DefaultTableModel) listCompany.getModel(), rs, 6);
            }
            
            catch (Exception ex) {
                Logger.getLogger(ViewMember.class.getName()).log(Level.SEVERE, null, ex);
            }
        }
        
        catch (SQLException e) {
            e.printStackTrace();
	}
        finally {
            this.disconnect();
        }
        try {
            listCompany.setRowSelectionInterval(0, 0);
        }
        catch(Exception e) { }
    }