二级联动修改

最新推荐文章于 2023-01-05 16:06:23 发布

原创最新推荐文章于 2023-01-05 16:06:23 发布 · 384 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#修改二级联动

修改专栏收录该内容

1 篇文章

订阅专栏

现在显示界面中添加修改按钮
<
input type=“button” value=“修改” οnclick=“update(${user.eid})”

function update(eid){
	location="toupdate?eid="+eid;
}

返回到控制层去
@RequestMapping("/toupdate")

public String toupdate(Er ee,HttpServletRequest request){
	ee=mapper.getEeByEid(ee);
	List<San> slist=mapper.san();
	request.setAttribute("san", slist);
	request.setAttribute("ee", ee);
	return "update";
	
}
@RequestMapping("/update")
public String update(Er ee){
	mapper.update(ee);
	return "redirect:list";
	
}

再到操作层中实现SQL语句操作

@Select(“select * from er where eid = #{eid}”)

Er getEeByEid(Er ee);

@Update("update er set ename=#{ename},yilei=#{yilei},erlei=#{erlei},num=#{num} where eid=#{eid}")
void update(Er ee);

建立修改的jsp页面

function yiji() {

	var one=$("#one option:selected").val();
	$("#two").empty();
	$.post(
		"erji",
		{one:one},
		function(msg) {
			for ( var i in msg) {
				$("#two").append("<option value="+msg[i].sname+">"+msg[i].sname+"</option>");
			}
		},
		"json"
	);
}
$(function() {
	$("#one option[value='${ee.yilei}']").attr("selected",true);
	var one=$("#one option:selected").val();
	$("#two").empty();
	$.post(
		"erji",
		{one:one},
		function(msg) {
			for ( var i in msg) {
				$("#two").append("<option value="+msg[i].sname+">"+msg[i].sname+"</option>");
				$("#two option[value='${ee.erlei}']").attr("selected",true);
			}
		},
		"json"
	);
})

<body>
<form action="update" method="post">

<table>
  <tr>
    <td>编号:<input type="text" name="eid" value="${ee.eid }"></td>
  </tr>
  <tr>
    <td>产品名称:<input type="text" name="ename" value="${ee.ename }"></td>
  </tr>
  <tr>
    <td>商品名称:
	<select onchange="yiji()" id="one" name="yilei">
		<c:forEach items="${san}" var="u">
			<option value="${u.sname}">${u.sname }</option>
		</c:forEach>
	</select>
	</td>
</tr>
<tr>
	<td>商品二类
		<select id="two" name="erlei">
			<option>请选择</option>
		</select>
	</td>
 <tr>
    <td>数量:<input type="text" name="num" value="${ee.num }"></td>
  </tr>
  <tr>
    <td>
      <input type="submit" value="修改">
    </td>
  </tr>
</table>
</form>
</body>