下拉框，循环输出option

<select onclick="selectData(this)">
　　<option value="" >--参考名称--</option>
　　<c:forEach items="${allSimpleLineName }" var="name">
　　　　<option value="${name}" >${name}</option>
　　</c:forEach>
</select>

 相关js

<script type="text/javascript">
　　function selectData(obj){
　　　　var targetV = $(obj).val();
　　　　$("input[name='czzd']").val(targetV);
　　}
</script>

 相关sql

    <select id="getAllSimpleLineName"  resultType="String">
              select f_simplelinename from W_EC_ELECTRIC_CURRENT t  group by f_simplelinename
    </select>

java方法

dao

public List<String> getAllSimpleLineName(){
           return this.getBySqlKeyGenericity("getAllSimpleLineName",null);
        }

service

    public List<String> getAllSimpleLineName(){
        return dao.getAllSimpleLineName();
    }

controller

    @RequestMapping("edit")
    @Action(description="编辑珠数据管理")
    public ModelAndView edit(HttpServletRequest request) throws Exception
    {
        Long id=RequestUtil.getLong(request,"id");
        
        String returnUrl=RequestUtil.getPrePage(request);
        ZhDlbSjgl zhdlbsjgl=zhdlbsjglService.getById(id);
        
        
        List<String> allSimpleLineName = zhdlbsjglService.getAllSimpleLineName();
        
        return getAutoView().addObject("zhdlbsjgl",zhdlbsjgl).addObject("allSimpleLineName",allSimpleLineName)
                            .addObject("returnUrl",returnUrl);
    }

 

最近一实例（输入框和下拉框并存，下拉选择后赋值给输入框，并自动提交form）

            <form id="searchForm" method="post" action="list.ht" style="display: block;">
                    <div class="row">
                        <span class="label">厂站名:</span><input type="text" name="Q_bdzmc_S"  class="inputText"  id="stationName"  value="${param['Q_bdzmc_S']}"/> 
                        <select onChange="selectData(this)">
                            <option value="">-请选择-</option>
                            <option value="">-全部-</option>
                            <c:forEach items="${zmcs }" var="e">
                                <option value="${e.czm}">${e.czm}</option>
                            </c:forEach>
                        </select>
    
                    </div>
                </form>

 

function selectData(obj){
　　　　var targetV = $(obj).val();
             //alert(targetV);
　　　　$("input[id='stationName']").val(targetV);
             $("form[id='searchForm']").submit();
　　}

 

        String sql="select distinct(F_BDZMC) as bdzmc from W_YTDYJYKCZB";
        RowMapper<Ytdyjykczb> rowMapper=new BeanPropertyRowMapper<Ytdyjykczb>(Ytdyjykczb.class);
        JdbcTemplate jdbcTemplate=(JdbcTemplate) AppUtil.getBean("jdbcTemplate") ;
        List<Ytdyjykczb> list2= jdbcTemplate.query(sql, rowMapper);
        
        ModelAndView mv=this.getAutoView().addObject("ytdyjykdbjgbList",list).addObject("zmcs",list2);