动态 SELECT 读取数据库 组建SELECT

package com.suypower.djbxt.czxs.method;

import java.sql.Connection;
import java.sql.ResultSet;

import org.apache.log4j.Logger;

import com.suypower.djbxt.sysmanger.DBconnect;

public class getSelectName {
	static Logger logger = Logger.getLogger(getSelectName.class.getName());
	public String getEnterpriseNameTag() {

			Connection connect = null;
			try
			{
				DBconnect con = null;
				con = new DBconnect();
				connect = con.getConection();
				java.sql.Statement state = connect.createStatement();					
	            String sql="SELECT enterpriseName,djbNo FROM DB2ADMIN.TB_CZXS_ENTERPRISEINFO  where enterpriseName is not null   and djbno  is  not null  order by djbNo ";

	        	 ResultSet res = state.executeQuery(sql);
	            // System.out.println(sql);	  
	             String html = "\n<option selected value='0'>---------全省企业--------</option>";
	           while(res.next())
	           {
	        	   if(!res.getString("enterpriseName").equals(null)&&!res.getString("enterpriseName").equals(""))
	        	   {
	                 html += "\n<option value="+res.getString("djbNo")+" >" +res.getString("djbNo")+ res.getString("enterpriseName") + "</option>";

	        	   }

	           }

	           return html;
	       }catch(Exception e)
	       {
	    	   logger.error(e.getMessage());
	           return e.getMessage();
	       }
	       finally
	       {
	           try{
	               if(connect!=null)
	               {
	            	   connect.close();
	               }

	           }catch(Exception e)
	           {
	               return e.getMessage();
	           }
	       }
	   } 
}

标签化页面

<!-- 专家列表 -->
         	<select name="expertQuery.questionExpert" id="questionExpert">
         		<option value="allExpert">-------------全部专家-------------</option>
         		<optgroup label="本期专家"></optgroup>
         		<ww:iterator value="#session['EXPERT_LIST_BQ']">
         			<option value=<ww:property value="expertName" /> ><ww:property value="expertName" /></option>
         		</ww:iterator>
         		<optgroup label="不在线专家"></optgroup>
         		<ww:iterator value="#session['EXPERT_LIST_NO']">
         			<option value=<ww:property value="expertId" /> ><ww:property value="expertName" /></option>
         		</ww:iterator>
         	</select>