Friday, November 21, 2008

DropDownList from DB to JSP

/////form.jsp

<bean:define id="listCompanyType" name="RegForm" property="LISTCOMPANYTYPE"/>
<html:select property="companyType">
<html:options collection="listCompanyType" property="value" labelProperty="label"/>
</html:select>


//// or use this method

<html:select property="companyType">
<html:optionsCollection property="LISTCOMPANYTYPE" label="label" value="value"/>
</html:select>


/// beanForm.java

public List getLISTCOMPANYTYPE(){
RegManager oRegManager = new RegManager();
try {
PropertyFileReader oSQLReader = new PropertyFileReader("properties.registration.reg-sql");
String sCompanySQL = oSQLReader.getKey("companytype.sql.query.getlist");

LISTCOMPANYTYPE = oRegManager.getDropList(sCompanySQL);
} catch (Exception ex) {
ex.printStackTrace();
}
return LISTCOMPANYTYPE;
}

No comments: