jsp动态查询并赋值

后台获取字规文件列表赋值到前台

前台

<tr class="odd">
<td class="searchHeader1" >字规：</td>
<td class="searchHeader2" >
<select  id="select" " style="width:300px;"  οnchange="javascript:changevalue();return false;" >
<c:forEach var="wordset"  items="<%=wordsetList%>" >
<option  name="oa_wordset" value="${wordset.oa_wordset_id}">${wordset.oa_wordset }</option>
</c:forEach>
</select>


</td>
</tr>
<tr class="odd">
<td class="searchHeader1"  >年度：</td>
<td class="searchHeader2" >
<jbfs:codeselect id="year" property="year"   keyVals="2012_2012,2013_2013,2014_2014,2015_2015,2016_2016,2017_2017,2018_2018,2019_2019"
οnchange="javascript:changevalue();return false;"
/>
</td>
</tr>


<tr class="odd">
<td class="searchHeader1">起始编号：</td>
<td class="searchHeader2">
<jbfs:text id="count" size="40px" property="count"  mask="number"  styleClass="write_needli" required="true" οnchange="javascript:changecount();return false;" />

</td>
</tr>

前台字规 年度都触发changevalue方法

function changevalue(){


    var select = $("#select").val();
  var year = $("#year").val();
  if(select&&year){
    var url = "<%=webapp%>/A0902/selectMaxnumber.act?";
    $.ajax({
    type:"post",
    url:url,
    dataType:"json",
    data:{oa_wordset_id:select,year:year},
    async:false,
    success:function(number){
    var json = eval(number);//后台返回的数据
    $("#count").val(json);
    $("#dcount").val(json);
   
    },
    error:function(){
    alert("失败！");
    }
    });
  }

@RequestMapping(value = "/selectMaxnumber")
@ResponseBody
public String selectMaxnumber(HttpServletRequest request,
String oa_wordset, String year, Oa_wordnumber_infoModel model,
String pars) throws Exception {
String oa_wordset2 = request.getParameter("pars");
String oa_wordset_id = model.getOa_wordset_id();
String year1 = model.getYear();


/** 根据字规查询序号count**/
String count = a0902Service.getMaxcount(oa_wordset_id, year1);
if (count == null || count.equals("")) {
count = "0";
}
int count1 = Integer.parseInt(count);
count1++;
String number = Integer.toString(count1);
return number;
}

    public String getMaxcount(String wordset_id , String year) throws Exception{
    //查询序列
    StringBuffer sql1 = new StringBuffer();
sql1.append("select  XULIE from OA_WORDSET_INFO where OA_WORDSET_ID ='").append(wordset_id).append("'");
String xulie = commonDao.getjBaseDao().queryForString(sql1.toString());
//根据序列查询最大count
    StringBuffer sql = new StringBuffer();
    sql.append("select max( count ) from oa_wordnumber_info where xulie='").append(xulie).append("' ");
    sql.append("and year = '").append(year).append("' ");
    String count = commonDao.getjBaseDao().queryForString(sql.toString());
    return count;
   
    }