public void getList(int rep)
    {
        String tempQuery = "";
        
        if(rep == 0) {
            tempQuery = DEFAULT_QUERY;
        }
        
        else if(rep == 1) {
            String searchText = searchBox.getText().toUpperCase();
            tempQuery = "select * from member where lastname like '"+searchText+"'";
        }
        
        
        listModel.clear();
        arrayLastName.clear();
        arrayFirstName.clear();
        arrayMidName.clear();
        arrayMemberid.clear();
        
        Statement stmt = null;       
        this.connect();
        conn = this.getConnection();
        
        try
        {
            stmt = conn.createStatement();
        }
                
        catch (SQLException e)
        {
            e.printStackTrace();
        }
		
        ResultSet rs;
        try
        {
            String firstname = "";
            String lastname = "";
            String midinit = "";
            rs = stmt.executeQuery(tempQuery);
            while(rs.next())
            {                
                nameTemp += rs.getString("lastname");
                nameTemp += ", " + rs.getString("firstname");
                nameTemp += " " + rs.getString("midinit");
                firstname = rs.getString("firstname");
                lastname = rs.getString("lastname");
                midinit = rs.getString("midinit");
                arrayFirstName.add(firstname);
                arrayLastName.add(lastname);
                arrayMidName.add(midinit);
                
                arrayMemberid .add(rs.getString("memberid"));
                listModel.addElement(nameTemp);
                nameTemp = "";
                //System.out.println(nameTemp);
            }
        
        }
        catch (SQLException e)
        {
        
        }
        finally{
            this.disconnect();      
        }
        listMember.setSelectedIndex(0);
    }