SSM一对多

List<Goods> listGoods(Condition con);

    List<Gtype> gtypes();

    int add(Goods g);

    Goods toUpdate(Integer gid);

    int update(Goods g);

    boolean delete(String gids);

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<!-- 映射文件中标签的id值要和dao层接口中的方法名相同 -->
<mapper namespace="com.xwx.dao.GoodsDao">
    <!-- 列表展示 -->
    <select id="listGoods" resultMap="goodsMap">
        select * from  goods join gtype on goods.tid = gtype.tid
        <where>
            <if test="gname!=null  and gname!=''">  and gname like concat('%',#{gname},'%') </if>
            <if test="price1!=null and price1!=0">  and price &gt;=#{price1} </if>
            <if test="price2!=null and price2!=0">  and price &lt;=#{price2} </if>
        </where>
    </select>
    <!-- 配置映射关系 -->
    <resultMap type="Goods" id="goodsMap">
        <id       property="gid"      column="gid"/>
        <result   property="gname"    column="gname"/>
        <result   property="price"    column="price"/>
        <result   property="base_num" column="base_num"/>
        <result   property="address"  column="address"/>
        <association property="gtype" javaType="Gtype">
            <id       property="tid"      column="tid"/>
            <result   property="tname"    column="tname"/>
        </association>
    </resultMap>
    
    <!-- 查询所有商品类型 -->
    <select id="gtypes" resultType="Gtype">
        select * from gtype
    </select>
    <!-- 添加 -->
    <insert id="add">
        insert into goods values(null,#{gname},#{price},#{base_num},#{address},#{gtype.tid})
    </insert>
    <!-- 回显 -->
    <select id="toUpdate" resultMap="goodsMap">
        select * from  goods join gtype on goods.tid = gtype.tid   where gid=#{gid}
    </select>
    
    <!-- 修改 -->
    <update id="update">
        update goods set gname=#{gname},price=#{price},base_num=#{base_num},address=#{address},tid=#{gtype.tid} where gid=#{gid}
    </update>
    <!-- 删除 -->
    <delete id="delete">
        delete from goods where gid in(${value})

package com.xwx.controller;

import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;

import com.github.pagehelper.PageHelper;
import com.github.pagehelper.PageInfo;
import com.xwx.entity.Condition;
import com.xwx.entity.Goods;
import com.xwx.entity.Gtype;
import com.xwx.service.GoodsService;

@Controller
public class GoodsController {

    
    @Autowired
    private GoodsService service;
    
    
    @RequestMapping("listGoods.do")
    public String  listGoods(Model m,Condition con) {
        //当前页处理
        if(con.getPageNum()==null) {
            con.setPageNum(1);
        }
        //使用分页工具
        PageHelper.startPage(con.getPageNum(),4);
        //列表查询
        List<Goods> list = service.listGoods(con);
        //将集合使用pageInfo封装，得到分页要用的数据
        PageInfo<Goods> page = new PageInfo<Goods>(list);
        
        //将数据存储到model中
        m.addAttribute("page", page);
        m.addAttribute("list", list);
        m.addAttribute("con", con);
        
        return "list";
    }
    @ResponseBody
    @RequestMapping("gtypes.do")
    public Object  gtypes() {
        //获取所有商品类型
        List<Gtype> list = service.gtypes();
        
        return list;
    }
    @ResponseBody
    @RequestMapping("add.do")
    public Object  add(Goods g) {
        //执行添加，获取添加结果
        boolean flag = service.add(g);
        
        return flag;
    }
    @ResponseBody
    @RequestMapping("toUpdate.do")
    public Object  toUpdate(Integer gid) {
        //查询商品
        Goods g  = service.toUpdate(gid);
        
        return g;
    }
    @ResponseBody
    @RequestMapping("update.do")
    public Object  update(Goods g) {
        //执行添加，获取添加结果
        boolean flag = service.update(g);
        
        return flag;
    }
    @ResponseBody
    @RequestMapping("delete.do")
    public Object  delete(String gids) {
        //执行添加，获取添加结果
        boolean flag = service.delete(gids);
        
        return flag;
    }
}

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core"  prefix="c"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
<link rel="stylesheet"  href="css/index3.css">
<script type="text/javascript" src="js/jquery-1.8.3.js"></script>
<script type="text/javascript">
function fenye(pageNum){
    //将当前页赋给form保单中隐藏标签
    $("[name=pageNum]").val(pageNum);
    //提交form表单
    $("form").submit(); 
    
}
//全选，全不选
function choose(own){
    $("[name=check]").attr("checked",own.checked);
}
//添加
function add(){
    location="add.jsp";
}
//修改
function upd(gid){
    location="update.jsp?gid="+gid;
}
//批量删除
function deleteBatch(){
    
    /* var gids ="";
    $("[name=check]:checked").each(function(){
        gids+=","+this.value;
    })
    
    alert(gids.substring(1)); */
    
    //map:将jquery集合转换成其他数组
    //get()：将其他数组转换成js数组
    //join()：将数组中的元素拼接成字符串，如果不传值默认用逗号拼接
    
    if(confirm("确定删除？")){
        //拼接字符串
        var gids = $("[name=check]:checked").map(function(){
            return this.value;
        }).get().join(); 
        //将拼接好的gid字符串传到后台
        $.post("delete.do",{gids:gids},function(flag){
            
            if(flag){
                alert("删除成功！");
                location="listGoods.do";
            }else{
                alert("删失败！");
            }
        },"json")
    }
    
}
//单删
function del(gids){
    $.post("delete.do",{gids:gids},function(flag){
        if(flag){
            alert("删除成功！");
            location="listGoods.do";
        }else{
            alert("删失败！");
        }
    },"json")
}
</script>
</head>
<body>
<form action="listGoods.do" method="post">
    <input type="hidden" name="pageNum"/>
    商品:<input type="text" name="gname"  value="${con.gname}"/>
    价格:<input type="text" name="price1" value="${con.price1}"/>--
        <input type="text" name="price2" value="${con.price2}"/>
        <button>查看</button>
</form>
<table>
    <tr>
        <td>
            <input type="checkbox" onclick="choose(this)"/>
        </td>
        <td>编号</td>
        <td>商品</td>
        <td>价格</td>
        <td>库存</td>
        <td>地址</td>
        <td>类型</td>
        <td>操作
            <button onclick="add()">添加</button>
        </td>
    </tr>
    <c:forEach items="${list}" var="g" varStatus="count">
        <tr>
            <td>
                <input type="checkbox"name="check" value="${g.gid}"/>
            </td>
            <td>${count.count+page.startRow-1}</td>
            <td>${g.gname}</td>
            <td>${g.price}</td>
            <td>${g.base_num}</td>
            <td>${g.address}</td>
            <td>${g.gtype.tname}</td>
            <td>
                <button>查看</button>
                <button onclick="upd('${g.gid}')">编辑</button>
                <button onclick="del('${g.gid}')">删除</button>
            </td>
        </tr>
    </c:forEach>
    <tr>
        <td colspan="10">
            <button onclick="fenye(1)">首页</button>
            <button onclick="fenye(${page.prePage==0?'1':page.prePage})">上一页</button>
            <button onclick="fenye(${page.nextPage==0?page.pages:page.nextPage})">下一页</button>
            <button onclick="fenye(${page.pages})">尾页</button>&nbsp;&nbsp;
            当前${page.pageNum}/${page.pages}页,共${page.total}条
            
            &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
            <button onclick="deleteBatch()">批量删除</button>
        </td>
    <tr>
</table>

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
<link rel="stylesheet"  href="css/index3.css">
<script type="text/javascript" src="js/jquery-1.8.3.js"></script>
<script type="text/javascript">
//文档就绪函数
$(function(){
    //使用ajax动态查询商品类型，然后追加到页面的下拉框中
    $.post("gtypes.do",function(arr){
        for ( var i in arr) {
            $("select").append("<option value='"+arr[i].tid+"'>"+arr[i].tname+"</option>");
        }
    },"json")
})

//添加
function tj(){
    //使用表单序列化方法获取表单中数据
    var param = $("form").serialize();
    
    $.post("add.do",param,function(flag){
        
        if(flag){
            alert("添加成功！");
            location="listGoods.do";
        }else{
            alert("添加失败！");
        }
    },"json")
}
</script>
</head>
<body>
<form>
    <Table>
        <tr>
            <Td>商品：</Td>
            <Td>
                <input type="text" name="gname"/>
            </Td>
        </tr>
        <tr>
            <Td>价格：</Td>
            <Td>
                <input type="text" name="price"/>
            </Td>
        </tr>
        <tr>
            <Td>库存：</Td>
            <Td>
                <input type="text" name="base_num"/>
            </Td>
        </tr>
        <tr>
            <Td>地址：</Td>
            <Td>
                <input type="text" name="address"/>
            </Td>
        </tr>
        <tr>
            <Td>商品类型：</Td>
            <Td>
                <select name="gtype.tid">
                    <option value="-1">请选择</option>
                </select>
            </Td>
        </tr>
        <tr>
            <Td></Td>
            <Td>
                <input type="button" value="提交" onclick="tj()"/>
            </Td>
        </tr>
    </Table>

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
<link rel="stylesheet"  href="css/index3.css">
<script type="text/javascript" src="js/jquery-1.8.3.js"></script>
<%-- <%=request.getParameter("gid")%> == ${param.gid} --%>
<script type="text/javascript">
//文档就绪函数
$(function(){
    
    //接收要回显数据的gid 
    var gid = "${param.gid}";
    //使用ajax传gid，查询这条记录
    $.post("toUpdate.do",{gid:gid},function(obj){
        //查询到的数据给标签赋值
        $("[name=gname]").val(obj.gname);
        $("[name=price]").val(obj.price);
        $("[name=base_num]").val(obj.base_num);
        $("[name=address]").val(obj.address);
        
        //使用ajax动态查询商品类型，然后追加到页面的下拉框中
        $.post("gtypes.do",function(arr){
            for ( var i in arr) {
                if(arr[i].tid==obj.gtype.tid){
                    
                    $("select").append("<option selected value='"+arr[i].tid+"'>"+arr[i].tname+"</option>");
                }else{
                    $("select").append("<option value='"+arr[i].tid+"'>"+arr[i].tname+"</option>");
                }
            }
        },"json")
        
    },"json")
    
    
})

//修改
function tj(){
    //使用表单序列化方法获取表单中数据
    var param = $("form").serialize();
    
    $.post("update.do",param,function(flag){
        
        if(flag){
            alert("修改成功！");
            location="listGoods.do";
        }else{
            alert("修改失败！");
        }
    },"json")
}
</script>
</head>
<body>
<form>
    <Table>
        <tr>
            <Td>商品：</Td>
            <Td>
                <input type="hidden" name="gid" value="${param.gid}"/>
                <input type="text" name="gname"/>
            </Td>
        </tr>
        <tr>
            <Td>价格：</Td>
            <Td>
                <input type="text" name="price"/>
            </Td>
        </tr>
        <tr>
            <Td>库存：</Td>
            <Td>
                <input type="text" name="base_num"/>
            </Td>
        </tr>
        <tr>
            <Td>地址：</Td>
            <Td>
                <input type="text" name="address"/>
            </Td>
        </tr>
        <tr>
            <Td>商品类型：</Td>
            <Td>
                <select name="gtype.tid">
                    <option value="-1">请选择</option>
                </select>
            </Td>
        </tr>
        <tr>
            <Td></Td>
            <Td>
                <input type="button" value="提交" onclick="tj()"/>
            </Td>
        </tr>
    </Table>
    
</form>
</body>
</html>

 

    
</form>
</body>
</html>

 

</body>
</html>

 

    </delete>
</mapper>