java 文件上传，三级连动，分页

 

package com.zhuzg.doc.service;

import java.util.List;

import com.github.pagehelper.PageInfo;
import com.zhuzg.doc.pojo.Area;
import com.zhuzg.doc.pojo.Depart;
import com.zhuzg.doc.pojo.Doc;
import com.zhuzg.doc.pojo.DocVo;
import com.zhuzg.doc.pojo.Skill;

public interface DocService {
    
    // 关于医生的增删改查
    PageInfo<Doc> list(DocVo docVo);
    int add(Doc doc);
    int update(Doc doc);
    int del(int[] ids);
    Doc getById(int id);
    
    
    // 根据父id 查询直接子节点
    List<Area> listArea(int pid);
    
    // 列出擅长
    List<Skill> listSkills();
    
    //列出科室
    List<Depart> listDepart();
    
    
    
    

}

package com.zhuzg.doc.dao;

import java.util.List;

import org.apache.ibatis.annotations.Param;

import com.zhuzg.doc.pojo.Area;
import com.zhuzg.doc.pojo.Depart;
import com.zhuzg.doc.pojo.Doc;
import com.zhuzg.doc.pojo.DocVo;
import com.zhuzg.doc.pojo.Skill;

public interface DocDao {

    List<Doc> list(DocVo docVo);

    int add(Doc doc);

    int addDocSkill(@Param("docId") int docId, @Param("skillId") int skillId);

    List<Depart> listDepart();

    Doc getById(int id);

    List<Skill> listSkills();

    int delDoc(int[] ids);

    List<Area> listAea(int pid);

    int delDocSkillByDoc(int ...ids);

    int udate(Doc doc);

}

 

package com.zhuzg.doc.service.impl;

import java.util.Iterator;
import java.util.List;

import org.apache.dubbo.config.annotation.Service;
import org.springframework.beans.factory.annotation.Autowired;

import com.github.pagehelper.PageHelper;
import com.github.pagehelper.PageInfo;
import com.zhuzg.doc.dao.DocDao;
import com.zhuzg.doc.pojo.Area;
import com.zhuzg.doc.pojo.Depart;
import com.zhuzg.doc.pojo.Doc;
import com.zhuzg.doc.pojo.DocVo;
import com.zhuzg.doc.pojo.Skill;
import com.zhuzg.doc.service.DocService;

@Service(interfaceClass =  DocService.class)
public class DocServiceImpl implements DocService {
    
    @Autowired
    DocDao docDao;
    

    @Override
    public PageInfo<Doc> list(DocVo docVo) {
        // TODO Auto-generated method stub
        PageHelper.startPage(docVo.getPage(),docVo.getPageSize());
        
        return new PageInfo<Doc>(docDao.list(docVo));
    }

    @Override
    public int add(Doc doc) {
        // TODO Auto-generated method stub
        //添加主表
        int result = docDao.add(doc);
        //添加子表
        List<Skill> skills = doc.getSkills();
        for (int i = 0; i < skills.size(); i++) {
            //插入中间表
            result+=docDao.addDocSkill(doc.getId(),skills.get(i).getId());
        }
        
        return result;
    }

    @Override
    public int update(Doc doc) {
        // TODO Auto-generated method stub
        //添加主表
        int result = docDao.udate(doc);
        
        //删除中间表    delDocSkillByDoc
        result += docDao.delDocSkillByDoc(doc.getId());
        
        //添加子表
        List<Skill> skills = doc.getSkills();
        for (int i = 0; i < skills.size(); i++) {
            //插入中间表
            result+=docDao.addDocSkill(doc.getId(),skills.get(i).getId());
        }
        
        return result;
    }

    @Override
    public int del(int[] ids) {
        // TODO Auto-generated method stub
        //删除子表
        int result = docDao.delDocSkillByDoc(ids);
        //删除主表
        result += docDao.delDoc(ids);
        return result;
    }

    @Override
    public List<Area> listArea(int pid) {
        // TODO Auto-generated method stub
        return docDao.listAea(pid);
    }

    @Override
    public List<Skill> listSkills() {
        // TODO Auto-generated method stub
        return docDao.listSkills();
    }

    @Override
    public List<Depart> listDepart() {
        // TODO Auto-generated method stub
        return docDao.listDepart();
    }

    @Override
    public Doc getById(int id) {
        // TODO Auto-generated method stub
        return docDao.getById(id);
    }
    
    

}

<?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" >
<mapper namespace="com.zhuzg.doc.dao.DocDao">

    <!-- List<Doc> list(DocVo docVo); -->
    <resultMap type="doc" id="docMapper">
        <id column="id" property="id"></id>
        <association property="province" column="provinceId" select="findAreaByid"></association>
        <association property="city" column="cityId" select="findAreaByid"></association>
        <association property="county" column="countyId" select="findAreaByid"></association>
        <association property="depart" column="departId" select="findDepartByid"></association>
        <collection property="skills" column="id"  select="findSkillsByDocId" ></collection>
    </resultMap>
    
    <select id="list" resultMap="docMapper">
        select * from tb_doc 
    </select>
    
    <select id="findAreaByid" resultType="area">
        select * from tb_area where id=#{value}
    </select>
    <select id="findDepartByid" resultType="depart">
        select * from tb_depart where id=#{value}
    </select>
    <select id="findSkillsByDocId" resultType="skill">
        SELECT s.* from tb_doc_skill ds LEFT JOIN  tb_skill s ON s.id=ds.skillId 
             WHERE ds.docId=#{value}
    </select>
    <!-- int add(Doc doc); -->
    <insert id="add" useGeneratedKeys="true" keyColumn="id" keyProperty="id">
            insert into tb_doc(name,cardno,birthday,provinceId,cityId,countyId,mobile,enterDate,img)
                values (#{name},#{cardno},#{birthday},#{provinceId},#{cityId},#{countyId},#{mobile},#{enterDate},#{img})     
    </insert>
    <!-- int addDocSkill(Integer id, Integer id2); -->
    <insert id="addDocSkill">
        insert into tb_doc_skill(docId,skillId) values(#{docId},#{skillId})
    </insert>
        
    <!-- List<Depart> listDepart(); -->
    <select id="listDepart" resultType="depart">
        select * from tb_depart
    </select>

    <!-- Doc getById(); -->
    <select id="getById" resultMap="docMapper">
    select * from tb_doc where id=#{value}
    </select>

    <!-- List<Skill> listSkills(); -->
    <select id="listSkills" resultType="skill">
        select * from tb_skill
    </select>

    <!-- int delDoc(int[] ids); -->
    <delete id="delDoc">
        delete from tb_doc where id in 
        <foreach collection="array" item="id" open="(" close=")" separator=",">
            #{id}
        </foreach>
    </delete>

    <!-- List<Area> listAea(int pid); -->
    <select id="listAea" resultType="area">
        select * from tb_area where pid=#{value}
    </select>

    <!-- int delDocSkillByDoc(int ...ids); -->
    <delete id="delDocSkillByDoc">
        delete from tb_doc_skill where  docId in
        <foreach collection="array" item="id" open="(" close=")" separator=",">
            #{id}
        </foreach>
    </delete>

    <!-- int udate(Doc doc); -->
    <update id="udate">
        update tb_doc
        set name=#{name},
            cardno=#{cardno},
            birthday=#{birthday},
            provinceId=#{provinceId},
            cityId=#{cityId},
            countyId=#{countyId},
            mobile=#{mobile},
            enterDate=#{enterDate},
            img=#{img}
        where id=#{id}
    </update>

</mapper>

 

 

package com.zhuzg.doc.controller;

import java.io.IOException;
import java.util.ArrayList;
import java.util.List;

import javax.servlet.http.HttpServletRequest;

import org.apache.dubbo.config.annotation.Reference;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;
import org.springframework.web.multipart.MultipartFile;
import com.zhuzg.doc.common.FileUtils;

import com.zhuzg.doc.pojo.Area;
import com.zhuzg.doc.pojo.Depart;
import com.zhuzg.doc.pojo.Doc;
import com.zhuzg.doc.pojo.Skill;
import com.zhuzg.doc.service.DocService;

@Controller
public class DocController {
    
    @Reference
    DocService docService;
    
    /** 
     * 
     * @return
     */
    @RequestMapping("toadd")
    public String toAdd(HttpServletRequest request) {
        // 获取所有的省份
        List<Area> listProince = docService.listArea(0);
        request.setAttribute("proinces", listProince);
        //
        List<Skill> listSkills = docService.listSkills();
        request.setAttribute("skills", listSkills);
        
        List<Depart> listDepart = docService.listDepart();
        request.setAttribute("departs", listDepart);
        
        return "add";
        
    }
    
    /** 
     * 
     * @return
     */
    @RequestMapping("toupdate")
    public String toUpdate(HttpServletRequest request,int id) {
        
        Doc doc = docService.getById(id);
        request.setAttribute("doc", doc);
        
        System.out.println("doc is " + doc);
        
        // 获取所有的省份
        List<Area> listProince = docService.listArea(0);
        request.setAttribute("proinces", listProince);
        //
        List<Skill> listSkills = docService.listSkills();
        request.setAttribute("skills", listSkills);
        
        List<Depart> listDepart = docService.listDepart();
        request.setAttribute("departs", listDepart);
        
        //获取医生的所在省的id 根据这个获取市的列表
        if(doc.getProvince()!=null) {
            List<Area> listcities = docService.listArea(doc.getProvince().getId());
            request.setAttribute("cities", listcities);
        }
        
        //获取医生的所在市的id 根据这个获取县的列表
        if(doc.getCity()!=null) {
            List<Area> listcounties = docService.listArea(doc.getCity().getId());
            request.setAttribute("counties", listcounties);
        }
        return "update";
        
    }
    
    @RequestMapping("listChild")
    @ResponseBody
    public List<Area> listChild(HttpServletRequest request,int pid) {
        List<Area> listArea = docService.listArea(pid);
        return listArea ;
    }
    
    /** 
     * 
     * @return
     */
    @RequestMapping("add")
    public String add(HttpServletRequest request,Doc doc,int[] selSkillId,MultipartFile file) {
        try {
            String path = FileUtils.processFile(file);
            doc.setImg(path);
        } catch (IllegalStateException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        } catch (IOException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
        List<Skill> skills= new ArrayList<Skill>();
        for (int i = 0; i < selSkillId.length; i++) {
            Skill skill = new Skill();
            skill.setId(selSkillId[i]);
            skills.add(skill);
        }
        doc.setSkills(skills);
        docService.add(doc);
        return "rediect:list";
    }
    
    /** 
     * 
     * @return
     */
    @RequestMapping("update")
    public String update(HttpServletRequest request,Doc doc,int[] selSkillId,MultipartFile file) {
        try {
            String path = FileUtils.processFile(file);
            doc.setImg(path);
        } catch (IllegalStateException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        } catch (IOException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
        List<Skill> skills= new ArrayList<Skill>();
        for (int i = 0; i < selSkillId.length; i++) {
            Skill skill = new Skill();
            skill.setId(selSkillId[i]);
            skills.add(skill);
        }
        doc.setSkills(skills);
        docService.update(doc);
        return "rediect:list";
    }
    
    
}

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>    
    
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
    <script type="text/javascript" src="./resource/jquery/jquery-3.4.1.js"></script>
<title>添加</title>
</head>
<body>
    <form action="./add" method="post" enctype="multipart/form-data">
    <table>
        <tr>
            <td>姓名</td>
            <td><input name="name"></td>
        </tr>
        <tr>
            <td>身份证</td>
            <td><input name="cardno"></td>
        </tr>
        <tr>
            <td>电话</td>
            <td><input name="mobile"></td>
        </tr>
        <tr>
            <td>性别</td>
            <td> <input type="radio" name="gender" value="1">男  
                    &nbsp;&nbsp;&nbsp;&nbsp;
                  <input type="radio" name="gender" value="2">女
            </td>
        </tr>
        <tr>
            <td>生日</td>
            <td><input  type="date" name="birthday"></td>
        </tr>
        <tr>
            <td>省</td>
            <td>
            <select name="provinceId" id="provinceId" onchange="changeSub('provinceId','cityId')">
                <option value="-1">---请选择---</option>     
                <c:forEach items="${proinces}" var="p">
                    <option value="${p.id}">${p.name}</option>     
                </c:forEach>
            </select> </td>
        </tr>
        <tr>
            <td>市</td>
            <td>
            <select name="cityId" id="cityId"  onchange="changeSub('cityId','countyId')">
                <option value="-1">---请选择---</option>     
            </select> </td>
        </tr>
        <tr>
            <td>县</td>
            <td>
            <select name="countyId" id="countyId">
                <option value="-1">---请选择---</option>     
            </select> </td>
        </tr>
        <tr>
            <td>科室</td>
            <td>
            <select name="departId" id="departId">
                <option value="-1">---请选择---</option>     
                <c:forEach items="${departs}" var="d">
                    <option value="${d.id}">${d.name}</option>     
                </c:forEach>
            </select> </td>
        </tr>
        
        <tr>
            <td>擅长</td>
            <td>
                <c:forEach items="${skills}" var="s">
                    <input type="checkbox" name="selSkillId" value="${s.id}">${s.name} &nbsp;&nbsp;&nbsp;&nbsp; 
                </c:forEach>
            </td>
        </tr>
        <tr>
            <td>头像</td>
            <td>
                <input type="file" name="file">
            </td>
        </tr>
        <tr>
            <td>入职日期</td>
            <td><input  type="date" name="enterDate"></td>
        </tr>
        
        <tr>
            <td></td>
            <td><button type="submit" >提交</button></td>
        </tr>
    </table>
    </form>
    <script type="text/javascript">
    
        function changeSub(parId,childId){
            var pid=$("#"+parId).val();
            //获取到被影响的下拉框的对象
            var childObj = $("#"+childId)
            $.post("./listChild",{pid,pid},function(data){
                //遍历data 
                //清空下一个级别
                childObj.empty();
                //
                childObj.append('<option value="-1">---请选择---</option> ')            
                for ( var i in data) {
                    childObj.append('<option value="'+data[i].id+'">'+data[i].name+'</option> ')    
                }
            })

        }
    </script>
</body>
</html>

package com.zhuzg.doc.common;

import java.io.File;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.IOException;
import java.io.InputStream;
import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.UUID;

import javax.servlet.http.HttpServletResponse;

import org.springframework.beans.factory.annotation.Value;
import org.springframework.context.annotation.Configuration;
import org.springframework.context.annotation.PropertySource;
import org.springframework.web.multipart.MultipartFile;

public class FileUtils {
    
    //存放图片的路径
    static String rootPath;
    
    //windows存放图片的路径
    static String winRootPath;
    
    //linux存放图片的路径
    static String linuxRootPath;
    
    //当前的操作系统
    static String currentOs="";
    
    
    static {
        String os = System.getProperty("os.name").toLowerCase();  
        
        //linux 
        if(os.indexOf("linux")>=0 ) {
            currentOs="linux";
        }
        //windows 
        if(os.indexOf("windows")>=0 ) {
            currentOs="windows";
        }
    }
    
    public static String getRootPath() {
        return rootPath;
    }


    /**
     * 保存文件的具体位置
     * @param rootPath
     */
    @Value("${win.pic.savepath}")
    public void setWinRootPath(String rootPath) {
        if(currentOs.equals("windows")) {
            winRootPath=rootPath;
            FileUtils.rootPath=rootPath;
            createPath();
        }
        
        
    }
    
    @Value("${linux.pic.savepath}")
    public void setLinuxRootPath(String rootPath) {
        if(currentOs.equals("linux")) {
            linuxRootPath=rootPath;
            FileUtils.rootPath=rootPath;
            createPath();
        }
    }
    
    /**
     * 创建目录
     */
    static private void createPath() {
        //不存在则创建该目录
            File file = new File(FileUtils.rootPath);
            if(!file.exists()) {
                file.mkdirs();
            }
    }


    /**
     * 
     * @param response
     * @param file
     * @throws FileNotFoundException 
     */
    public static void downLoad(HttpServletResponse response, String filename) throws FileNotFoundException {
         /* // 下载本地文件
        String fileName = "Operator.doc".toString(); // 文件的默认保存名
*/        // 读到流中
        InputStream inStream = new FileInputStream(rootPath+ "/"+ filename);// 文件的存放路径
        // 设置输出的格式
        response.reset();
        response.setContentType("bin");
        response.addHeader("Content-Disposition", "attachment; filename=\"" + filename + "\"");
       
        // 循环取出流中的数据
        byte[] b = new byte[1024];
        int len;
        try {
          while ((len = inStream.read(b)) > 0)
            response.getOutputStream().write(b, 0, len);
          inStream.close();
        } catch (IOException e) {
          e.printStackTrace();
        }
    
    }
    
    
    /**
     *  上传文件
     * @param file
     * @return
     * @throws IllegalStateException
     * @throws IOException
     */
    public static String processFile(MultipartFile file) throws IllegalStateException, IOException {

        // 原来的文件名称
        System.out.println("file.isEmpty() :" + file.isEmpty()  );
        System.out.println("file.name :" + file.getOriginalFilename());
        
        if(file.isEmpty()||"".equals(file.getOriginalFilename()) || file.getOriginalFilename().lastIndexOf('.')<0 ) {
            return "";
        }
            
        String originName = file.getOriginalFilename();
        String suffixName = originName.substring(originName.lastIndexOf('.'));
        SimpleDateFormat sdf=  new SimpleDateFormat("yyyyMMdd");
        String path = rootPath + "/" + sdf.format(new Date());
        File pathFile = new File(path);
        if(!pathFile.exists()) {
            pathFile.mkdir();
        }
        String destFileName =         path + "/" +  UUID.randomUUID().toString() + suffixName;
        File distFile = new File( destFileName);
        file.transferTo(distFile);//文件另存到这个目录下边
        return destFileName.substring(rootPath.length()+1);
        
        
    }

}

 

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>    
<%@ taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt" %>
    
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
    <script type="text/javascript" src="./resource/jquery/jquery-3.4.1.js"></script>
<title>修改</title>
</head>
<body>
    <form action="./update" method="post" enctype="multipart/form-data">
    <table>
        <tr>
            <td>姓名</td>
        
            <td>
                <input type="hidden" name="id" value="${doc.id}">
            <input name="name" value="${doc.name}"></td>
        </tr>
        <tr>
            <td>身份证</td>
            <td><input name="cardno" value="${doc.cardno}"></td>
        </tr>
        <tr>
            <td>电话</td>
            <td><input name="mobile" value="${doc.mobile}"></td>
        </tr>
        <tr>
            <td>性别</td>
            <td> <input type="radio" name="gender" value="1">男  
                    &nbsp;&nbsp;&nbsp;&nbsp;
                  <input type="radio" name="gender" value="2">女
            </td>
        </tr>
        <tr>
            <td>生日</td>
            <td><input  type="date" name="birthday" value='<fmt:formatDate value="${doc.birthday}" pattern="yyyy-MM-dd"/>'></td>
        </tr>
        <tr>
            <td>省</td>
            <td>
            <select name="provinceId" id="provinceId" onchange="changeSub('provinceId','cityId')">
                <option value="-1">---请选择---</option>     
                <c:forEach items="${proinces}" var="p">
                    <option value="${p.id}" ${doc.province.id==p.id?'selected':''}>${p.name}</option>     
                </c:forEach>
            </select> </td>
        </tr>
        <tr>
            <td>市</td>
            <td>
            <select name="cityId" id="cityId"  onchange="changeSub('cityId','countyId')">
                <option value="-1">---请选择---</option>     
                <c:forEach items="${cities}" var="c">
                    <option value="${c.id}" ${doc.city.id==c.id?'selected':''}>${c.name}</option>     
                </c:forEach>
            </select> </td>
        </tr>
        <tr>
            <td>县</td>
            <td>
            <select name="countyId" id="countyId">
                <option value="-1">---请选择---</option>     
                <c:forEach items="${counties}" var="c">
                    <option value="${c.id}" ${doc.county.id==c.id?'selected':''}>${c.name}</option>     
                </c:forEach>
            </select> </td>
        </tr>
        <tr>
            <td>科室</td>
            <td>
            <select name="departId" id="departId">
                <option value="-1">---请选择---</option>     
                <c:forEach items="${departs}" var="d">
                    <option value="${d.id}">${d.name}</option>     
                </c:forEach>
            </select> </td>
        </tr>
        
        <tr>
            <td>擅长</td>
            <td>
                <c:forEach items="${skills}" var="s">
                    <input type="checkbox" name="selSkillId" 
                        <c:forEach items="${doc.skills}" var="selSkill">
                            <c:if test="${selSkill.id==s.id}">checked</c:if>
                        </c:forEach>
                    value="${s.id}">${s.name} &nbsp;&nbsp;&nbsp;&nbsp; 
                </c:forEach>
            </td>
        </tr>
        <tr>
            <td>头像</td>
            <td>
                <input type="file" name="file">
                <img src="/pic/${doc.img}" width="150" height="150">
            </td>
        </tr>
        <tr>
            <td>入职日期</td>
            
            <td><input  type="date" name="enterDate"  value='<fmt:formatDate value="${doc.enterDate}" pattern="yyyy-MM-dd"/>'></td>
        </tr>
        
        <tr>
            <td></td>
            <td><button type="submit" >提交</button></td>
        </tr>
    </table>
    </form>
    <script type="text/javascript">
    
        function changeSub(parId,childId){
            var pid=$("#"+parId).val();
            //获取到被影响的下拉框的对象
            var childObj = $("#"+childId)
            $.post("./listChild",{pid,pid},function(data){
                //遍历data 
                //清空下一个级别
                childObj.empty();
                //
                childObj.append('<option value="-1">---请选择---</option> ')            
                for ( var i in data) {
                    childObj.append('<option value="'+data[i].id+'">'+data[i].name+'</option> ')    
                }
            })
        }
    </script>
</body>
</html>

 

 

 

 

 

 

 

 

 

 

 

 

 

 

后补

<?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" >
<mapper namespace="com.wls.dao.DoctorDao">

     <select id="selects" resultMap="doctorMapper">
        SELECT d.*,k.kname,datediff(now(), rutime)as ageWork  FROM `doctor` d   
        LEFT JOIN   keshi k on d.kid = k.kid
         
         <where>
            <if test="dname!=null and dname!=''">
              and d.dname like concat('%',#{dname},'%')
            </if>
            <if test="sex!=null and sex!=''">
              and d.sex =#{sex}
            </if>
            <if test="shengfen!=null and shengfen!=0">
              and d.shengfen =#{shengfen}
            </if>
            <if test="shi!=null and shi!=0">
              and d.shi =#{shi}
            </if>
            <if test="xian!=null and xian!=0">
              and d.xian =#{xian}
            </if>
             <if test="kid!=null and kid!=0">
              and d.kid =#{kid}
            </if>
            <if test="age1!=null ">
              and d.age &gt;=#{age1}
            </if>
            <if test="age2!=null ">
              and d.age &lt;=#{age2}
            </if>
         </where>  
     </select>
     <resultMap type="Doctor" id="doctorMapper">
          <id property="did" column="did"/>
          <result property="dname" column="dname"/>
          <result property="dbianhao" column="dbianhao"/>
          <result property="sex" column="sex"/>
          <result property="createtime" column="createtime"/>
          <result property="kid" column="kid"/>  
          <result property="telephone" column="telephone"/>
          <result property="rutime" column="rutime"/>
          <result property="pic" column="pic"/>
          <result property="age" column="age"/>
          <result property="ageWork" column="ageWork"/>
          <association property="sf" column="shengfen" select="findDiQuByid"></association>
          <association property="si" column="shi" select="findDiQuByid"></association>
          <association property="xia" column="xian" select="findDiQuByid"></association>
          
          <association property="ks" javaType="KeShi">
               <id property="kid" column="kid"/>
                <result property="kname" column="kname"/>
          </association>
          <collection property="sc" column="did" select="selectBySid" >
             
          </collection>
     </resultMap>
      <select id="selectBySid" resultType="ShanChang">
           SELECT sc.* from  sss LEFT JOIN shanchang sc  on sss.ssid =  sc.sid where sss.ddid =#{did}
      </select>
      
      <select id="findDiQuByid" resultType="DiQu">
         select * from diqu where id=#{value}
         
          
      </select>
      
      <select id="selectOne" resultType="DiQu">
        select * from diqu where zid=#{zid}
      </select>
      
      <select id="selectSc" resultType="ShanChang">
        select * from shanchang
      </select>
      
      
      <insert id="add" useGeneratedKeys="true" keyProperty="did">
         insert into doctor values(null,#{dname},#{dbianhao},
         #{sex},#{createtime},#{shengfen},#{shi},#{xian},
         #{kid},#{telephone},#{rutime},#{pic},#{age})
      </insert>
      
      <insert id="addSss"> 
          insert into sss values
          <foreach collection="ssids" item="sid" separator=",">
            (#{did},#{sid})
          </foreach>
      </insert>
      
      <select id="selectByDid" resultMap="doctorMapper">
              SELECT * from doctor where did=#{value}
      </select>
      
      <update id="update">
         update doctor set dname=#{dname},dbianhao=#{dbianhao},sex=#{sex},createtime=#{createtime},
         shengfen=#{shengfen},shi=#{shi},xian=#{xian},kid=#{kid},telephone=#{telephone},
         rutime=#{rutime},pic=#{pic},age=#{age} where did =#{did}
      </update>
      
      <delete id="delSss">
          delete from sss where ddid=#{did}
      </delete>
</mapper>

package com.wls.controller;

import java.io.File;
import java.io.IOException;
import java.util.List;
import java.util.UUID;

import org.apache.dubbo.config.annotation.Reference;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.ResponseBody;
import org.springframework.web.multipart.MultipartFile;

import com.github.pagehelper.PageInfo;
import com.wls.pojo.DiQu;
import com.wls.pojo.Doctor;
import com.wls.pojo.ShanChang;
import com.wls.pojo.Vo;
import com.wls.service.DoctorService;


@Controller
public class DoctorController {
  
    @Reference
    DoctorService doctorService;

    @RequestMapping("selects")
    public String selects(Model m,Vo vo,@RequestParam(defaultValue="1")Integer pageNum,@RequestParam(defaultValue="2")Integer pageSize){
        
        PageInfo<Doctor> info = doctorService.selects(vo, pageNum, pageSize);
        m.addAttribute("info", info);
        m.addAttribute("vo", vo);
        return "selects";
    }
    
    @RequestMapping("selectOne")
    @ResponseBody
    public Object selects(Integer zid){
        List<DiQu>  list=doctorService.selectOne(zid);
        return list;
    }
    
    
    @RequestMapping("toAdd")
    public String toAdd(Model m){
        List<ShanChang> sc = doctorService.selectSc();
        m.addAttribute("sc", sc);
        return "add";
    }
    
    
    
    @RequestMapping("add")
    @ResponseBody
    public boolean add(Doctor doc,MultipartFile file){
        
        System.err.println(doc);
        if(file!=null && !file.isEmpty()){
            String path="d:/pic/";
            String oldFilename = file.getOriginalFilename();
            String fileName=UUID.randomUUID()+oldFilename.substring(oldFilename.lastIndexOf("."));
            try {
                file.transferTo(new File(path,fileName));
            } catch (IllegalStateException e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            } catch (IOException e) {
                e.printStackTrace();
            }
            doc.setPic(fileName);
        }
        
        int i = doctorService.add(doc);
        return i>0;
    }
    
    
    @RequestMapping("toUpdate")
    public String toUpdate(Model m,Integer did){
        List<ShanChang> sc = doctorService.selectSc();
        m.addAttribute("sc", sc);
        
        Doctor doc=doctorService.selectByDid(did);
        m.addAttribute("doc", doc);
        System.err.println(doc);
        return "update";
    }
    
    
    
    @RequestMapping("update")
    @ResponseBody
    public boolean update(Doctor doc,MultipartFile file){
        
        System.err.println(doc);
        if(file!=null && !file.isEmpty()){
            String path="d:/pic/";
            String oldFilename = file.getOriginalFilename();
            String fileName=UUID.randomUUID()+oldFilename.substring(oldFilename.lastIndexOf("."));
            try {
                file.transferTo(new File(path,fileName));
            } catch (IllegalStateException e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            } catch (IOException e) {
                e.printStackTrace();
            }
            doc.setPic(fileName);
        }
        
        int i = doctorService.update(doc);
        return i>0;
    }
    
    
    
    
    
}

 

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<!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">
<link href="/resource/index3.css" rel="stylesheet">\
<script type="text/javascript" src="/resource/jquery-3.2.1.js"></script>
<script type="text/javascript">
   function goPage(pageNum){
        location.href="/selects?pageNum="+pageNum;  
   } 
   $(function(){
       $.post("/selectOne",{zid:55},function(arr){
             for ( var i in arr) {
                 $("#s1").append("<option value='"+arr[i].id+"'>"+arr[i].zname+"</option>")
            }
             
       })
   })
   
   function sj(val){
        $("#s2").text("")
       $.post("/selectOne",{zid:val},function(arr){
             for ( var i in arr) {
                 $("#s2").append("<option value='"+arr[i].id+"'>"+arr[i].zname+"</option>")
            }
             
       })
   }
   function sj3(val){
       $("#s3").text("")
       $.post("/selectOne",{zid:val},function(arr){
             for ( var i in arr) {
                 $("#s3").append("<option value='"+arr[i].id+"'>"+arr[i].zname+"</option>")
            }
             
       })
   }
   
   function toAdd(){
       location.href="/toAdd";
   }
</script>
<title>页面</title>

</head>
<body>
<button onclick="toAdd()">添加</button>
<form action="/selects" method="get">
      姓名:<input type="text" name="dname" value="${vo.dname }">
      性别:<select name="sex">
        <option ></option>
        <option value="男" ${vo.sex=='男'?"selected":"" }>男</option>
        <option value="女" ${vo.sex=='女'?"selected":"" }>女</option>
      </select>   
   省：<select id="s1" onchange="sj(this.value)" name="shengfen"><option value="0">请选择</option></select>
   市：<select id="s2" onchange="sj3(this.value)" name="shi"></select> 
   县：<select id="s3" name="xian"></select>
     科室:<select name="kid">
        <option value="0" ${vo.kid==0?"selected":"" }>请选择</option>
        <option value="1" ${vo.kid==1?"selected":"" }>内科</option>
        <option value="2" ${vo.kid==2?"selected":"" }>外科</option>
        <option value="3" ${vo.kid==3?"selected":"" }>骨科</option>
      </select>   
   年龄:<input type="text" name="age1" value="${vo.age1 }">到<input type="text" name="age2" value="${vo.age2 }"> 
   <button>查看</button>
</form>
 <table>
   <tr>
     <td>姓名</td>
     <td>性别</td>
     <td>生日</td>
     <td>年龄</td>
     <td>省</td>
     <td>市</td>
     <td>县</td>
     <td>科室</td>
     <td>擅长</td>
     <td>工龄</td>
     <td>头像</td>
     <td>操作</td>
   </tr>
     <c:forEach items="${info.list }" var="li">
         <tr>
         <td>${li.dname }</td>
         <td>${li.sex }</td>
         <td>${li.createtime }</td>
         <td>${li.age }</td>
          <td>${li.sf.zname }</td>
          <td>${li.si.zname }</td>
          <td>${li.xia.zname }</td>
         <td>${li.ks.kname }</td>
         <td>
           <c:forEach items="${li.sc }" var="s">
             ${s.sname }
           </c:forEach>
         </td>
         <td>${li.ageWork }</td>
         <td>
           <img alt="" src="/pic/${li.pic }" style="width: 50px;height: 50v">
         </td>
          <td>
                 <a href="/toUpdate?did=${li.did }">修改</a>
         </td>
   </tr>
     </c:forEach>
 </table>
 <jsp:include page="/WEB-INF/view/pages.jsp"></jsp:include>
</body>
</html>

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>

<input type="button" onclick="goPage(1)"
    value="首页">
<input type="button"
    onclick="goPage(${info.prePage==0?1:info.prePage })" value="上一页">
<input type="button"
    onclick="goPage(${info.nextPage ==0?info.pages:info.nextPage})"
    value="下一页">
<input type="button" onclick="goPage(${info.pages})"
    value="尾页">
    ${info.pageNum}/${info.pages}