public void getList(int rep, String searchText)
    {
        String tempQuery = "";
        if(rep == 0) {
            tempQuery = DEFUALT_QUERY;
        }
        else if(rep == 1) {
            tempQuery = "select * from (Select memberid,lastname,firstname,midinit,nonmember.contactno1,nonmember.contactno2,nonmember.email,compname from nonmember inner join company on nonmember.compid = company.compid order by lastname) where lastname like '"+searchText+"'";
        }
        //else
          //  tempQuery = "Select * from mydb.bookinformation where Title like '%"+bookTitle+"%';";
        
        //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) 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) { }
        
    }