How to populate options of h:selectOneMenu from database? JAVA JSF

The Project Structure in netbeans is shown Mysql Table Structure CREATE TABLE `categories` ( `sl_no` INT(11) NOT NULL AUTO_INCREMENT, `category_name` VARCHAR(50) NOT NULL DEFAULT ‘0’, PRIMARY KEY (`sl_no`) ) MySql Table Data index.xhtml <?xml version=’1.0′ encoding=’UTF-8′ ?> <!DOCTYPE html PUBLIC “-//W3C//DTD XHTML 1.0 Transitional//EN” “http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd”> <html xmlns=”http://www.w3.org/1999/xhtml” xmlns:h=”http://xmlns.jcp.org/jsf/html” xmlns:f=”http://xmlns.jcp.org/jsf/core”> <h:head> <title>Facelet Title</title> </h:head> <h:body> <h:form> …

Continue reading