package spravochnik;
 
import DBConnect.DataConnect;
import java.sql.*;
import java.io.Serializable;
import java.util.ArrayList;
import java.util.List;
import javax.faces.bean.ManagedBean;
import javax.faces.bean.SessionScoped;
import javax.faces.model.SelectItem;
 
@ManagedBean(name = "filials")
@SessionScoped
public class Filials implements Serializable {

    private static final long serialVersionUID = 1L;
    private String filialname;
    private int filialId;

    public int getFilialId() {
        return filialId;
    }

    public void setFilialId(int filialId) {
        this.filialId = filialId;
    }
 
    public String getFilialname() {
        return filialname;
    }
 
    public void setFilialname(String filialname) {
        this.filialname = filialname;
    }
  
    public List<SelectItem> getCategoryName() {
        List<SelectItem> cat = new ArrayList<SelectItem>();
        try {
            Connection con = DataConnect.getConnection();
            Statement st = con.createStatement();
            ResultSet rs = null;
            String myQuery = "select id, name from complat.filial";
            rs = st.executeQuery(myQuery);
            
             while (rs.next()) 
            {
                cat.add(new SelectItem(rs.getInt("id"), rs.getString("name")));
            }
            
             
         } catch (Exception ex) {
            ex.printStackTrace();
        }
         return cat;
    }
 }

<h:selectOneMenu value="#{testMB.instance.region}" id="regionList" converter="#{regionConverterBean}">
                            <f:selectItems value="#{regionMB.entityList}" var="region"
                                           itemLabel="#{region.name}" itemValue="#{region}"/>
</h:selectOneMenu>