首先我们先建立add.jsp界面
<form action="add" method="post">
<table>
<tr>
<td>编号:<input type="text" name="eid"></td>
</tr>
<tr>
<td>产品名称:<input type="text" name="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"></td>
</tr>
<tr>
<td>
<input type="submit" value="添加">
</td>
</tr>
</table>
</form>
一般二级联动对用到ajax来实现
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"
);
}
接着我们到 控制层去写我们要控制的表格(数据库)
@RequestMapping(“toadd”)
public String toadd(HttpServletRequest request) {
List slist=mapper.san();
request.setAttribute(“san”, slist);
return “add”;
}
@RequestMapping("erji")
@ResponseBody
public List<San> erji(HttpServletRequest request,String one) {
San s = mapper.erji(one);
List<San> sslist = mapper.sslist(s.getSid());
return sslist;
}
@RequestMapping("add")
public String add(Er ee){
mapper.add(ee);
return "redirect:list";
}
接着我们到操作层去书写操作的SQL语句
@Select(“select * from san where pid=0”)
List san();
@Insert(“insert into er(eid,ename,yilei,erlei,num) values(#{eid},#{ename},#{yilei},#{erlei},#{num})”)
void add(Er ee);
@Select(“select * from san where sname=#{one}”)
San erji(String one);
@Select(“select * from san where pid=#{sid}”)
List sslist(int sid);
返回list.jsp页面在列表进行添加 功能
<input type="button" value="新增" onclick="add()">
function add(){
location="toadd";
}
这样的一个二级联动添加就做好了