springmvc更改

接口中的方法

@Override
public void updateProject(int Id, String name, String belong, String type, String starttime, String submittime,
String checktime, String onlinetime, String currentprogress, String PM, String RD, String QA, int bug,
int onlinebug) {


String sql="update projectlisttable set name='"+name+"',belong='"+belong+"',type='"+type+"',starttime='"+starttime+"',submittime='"+submittime+"',checktime='"+checktime+"',onlinetime='"+onlinetime+"',currentprogress='"+currentprogress+"',PM='"+PM+"',RD='"+RD+"',QA='"+QA+"',bug='"+bug+"',onlinebug='"+onlinebug+"'where Id="+Id;
jdbcTemplate.update(sql);
System.out.println("更改成功");

}

控制层的方法：

// 编辑数据
@RequestMapping(value = "/updatedata", method = RequestMethod.POST)
public String updatedata(ModelMap map, HttpServletRequest request) {
int id = Integer.parseInt(request.getParameter("Id"));
String name = request.getParameter("name");
String belong = request.getParameter("belong");
String type = request.getParameter("type");
String starttime = request.getParameter("starttime");
String submittime = request.getParameter("submittime");
String checktime = request.getParameter("checktime");
String onlinetime = request.getParameter("onlinetime");
String currentprogress = request.getParameter("currentprogress");
String PM = request.getParameter("PM");
String RD = request.getParameter("RD");
String QA = request.getParameter("QA");
int bug = Integer.parseInt(request.getParameter("bug"));
int onlinebug = Integer.parseInt(request.getParameter("onlinebug"));


System.out.println(id);
projectFindAllList.updateProject(id,name,belong,type,starttime,submittime,checktime,onlinetime,currentprogress,PM,RD,QA,bug,onlinebug);
List<ProjectAll> listall = projectFindAllList.findAll();
map.put("listall", listall);
return "table";

}

编辑页面传参：

<a class="btn btn-info" href="edlist.html?id=${list.id}&name=${list.name}&belong=${list.belong}&type=${list.type}

&starttime=${list.starttime}&submittime=${list.submittime}
&checktime=${list.checktime}&onlinetime=${list.onlinetime}
&currentprogress=${list.currentprogress}&PM=${list.PM}
&RD=${list.RD}&QA=${list.QA}&bug=${list.bug}&onlinebug=${list.onlinebug}" type="hidden">编辑 <i class="fa fa-edit "></i>

</a>

编辑页面获得参数方式列举：

value = "${param.QA}