JAVA下拉菜单调用数据库实现

WEB层

<script type="text/javascript">  
//显示下拉菜单  显示所属这个流程的节点
//初始化
 $(document).ready(function() {   
        $.ajax({  
            url: "showNodesByFlowNameOption",//调用方法  
            type: "GET",  
            data: {flowid:$("#flowid").val()},//参数  
            dataType: "json",//类型  
  
            success: function(data) {  
              var tbHtml = "";//定义HTML  
              tbHtml += "<option></option>";  
              $.each(data, function(key, value) {//循环  
                  tbHtml+="<option value="+value.nid+">"+value.label+"</option>"//显示查询出来的结果内容  
              });  
                
              $('#endid').html(tbHtml);//显示HTML  
          }  
            
           });
		   
  
  

     });  
  
   
  
  
</script> 

<select name="endid" id="endid">  
      </select>

JAVA实现方法

	//显示通过流程名查询所属节点的下拉菜单
	    @RequestMapping(value="/showNodesByFlowNameOption", method=RequestMethod.GET)  
	    public @ResponseBody Object showNodesByFlowNameOption(HttpServletRequest request,HttpServletResponse response) {  
	      
	    	Long fid=Long.valueOf(request.getParameter("flowid")).longValue();

	        //Object... obj   
	        
	          
	        List<Nodes> queryResult=null;  
	          

	        queryResult=nodesService.query("from Nodes where belong=?",fid);  


	          
	        return queryResult;  
	    }