public void getList(int rep,String searchText)
    {
        String tempQuery = "";
        if(rep==0) {
            tempQuery = DEFAULT_QUERY;
        }
        else if(rep==1) {
            tempQuery = "Select memberid,lastname,firstname,midinit,member.contactno1,member.contactno2,member.email,compname from member inner join company on member.compid = company.compid order by lastname where lastname like '"+searchText+"'";
        }
        
	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) listMember.getModel(), rs, 8);
            } catch (Exception ex) {
                Logger.getLogger(ViewMember.class.getName()).log(Level.SEVERE, null, ex);
            }
            
        }
        
        catch (SQLException e)
        {
            e.printStackTrace();
	}
        finally{
            this.disconnect();
        }
        try{
            listMember.setRowSelectionInterval(0, 0);
        }
        catch(Exception e)
        {
            
        }
        
    }