springboot+mybatis+easyui 前台实现数据库信息的增删改操作

前台展示详细信息的增删改操作

        本次的内容承接上次博客的后续。前驱博客链接：
http://blog.csdn.net/wilson_m/article/details/78864579

        因为信息在前台进行显示的时候，显示的数据是从数据库中的视图中获取到的数据信息，而不是在数据库中的表进行获取到的。通过创建视图实现了几张表的拼接。

        在前台进行页面按钮显示增删改操作的时候，操作的对象将不再试数据库中的视图，数据库中的支持信息的修改，但是不支持在视图中进行删除和添加的操作（支持更新操作）。问题便转移到了对原有表格的增删操作。

所要实现的页面功能如下图所示：

mapper代码

//获取默认添加信息时候的第一个教学评价编号
@Select("select evaluate_no from teaching_evaluate limit 1")
    public String getTeachingEvaluateFirstTrainNo();

@Update("update teaching_evaluate set evaluate_name=#{evaluate_name},start_time=#{start_time},end_time=#{end_time},state=#{state},url=#{url},remarks=#{remarks} where evaluate_no=#{evaluate_no}")
    public void saveevaluateinfo(@Param("evaluate_no") String evaluate_no,@Param("evaluate_name") String evaluate_name ,@Param("start_time") String start_time,
                              @Param("end_time") String end_time,@Param("state") String state,@Param("url") String url,@Param("remarks") String remarks);


    @Delete("delete from teaching_evaluate where evaluate_no=#{evaluate_no}")
    public void removeevaluateinfo(@Param("evaluate_no") String evaluate_no);

    @Insert("insert into teaching_evaluate(evaluate_no,evaluate_name,start_time,end_time,state,url,remarks) values(#{evaluate_no},#{evaluate_name},#{start_time},#{end_time},#{state},#{url},#{remarks})")
    public void addevaluateinfo(@Param("evaluate_no") String evaluate_no,@Param("evaluate_name") String evaluate_name ,@Param("start_time") String start_time,
                             @Param("end_time") String end_time,@Param("state") String state,@Param("url") String url,@Param("remarks") String remarks);

    @Update("update teachingevaluate set teacherName=#{teacherName},teacherGender=#{teacherGender},workUnit=#{workUnit},teacherAge=#{teacherAge},promotedTitle=#{promotedTitle},teacherTitle=#{teacherTitle},teacherEducationBG=#{teacherEducationBG},teacherAge=#{teacherAge},teacherDegree=#{teacherDegree},teacherGrade=#{teacherGrade},teacherState=#{teacherState} where teacherNo=#{teacherNo}")
    public void saveevaluateteacherinfo(@Param("teacherNo") String teacherNo,@Param("teacherName") String teacherName ,@Param("teacherGender") String teacherGender,@Param("workUnit") String workUnit,@Param("teacherAge") String teacherAge,@Param("promotedTitle") String promotedTitle,@Param("teacherTitle") String teacherTitle,@Param("teacherEducationBG") String teacherEducationBG,
                                        @Param("teacherDegree") String teacherDegree,@Param("teacherGrade") String teacherGrade,@Param("teacherState") String teacherState);


    @Delete("delete from teachingevalute_teacher where tno=#{tno} and evaluate_no=#{evaluate_no}")
    public void removeevaluateteacherinfo(@Param("tno") String tno,@Param("evaluate_no") String evaluate_no);

    @Select("select * from teachingevaluate  where evaluateNo=#{evaluateNo}")
    public TeachingEvaluate getTeachingEvaluateListByTnoByPage1(@Param("evaluateNo") String evaluateNo);

    @Insert("insert into teachingevalute_teacher (tno,evaluate_no, tname, gender, work_unit,promoted_title,age, title, education_background, degree, grade, state) values (#{tno},#{evaluate_no},#{tname},#{gender},#{work_unit},#{promoted_title},#{age},#{title},#{education_background},#{degree},#{grade},#{state})")
    public void addevaluateteacher(@Param("tno") String tno,@Param("evaluate_no") String evaluate_no ,@Param("tname") String tname,@Param("gender") String gender ,@Param("work_unit") String work_unit,@Param("promoted_title") String promoted_title,@Param("age") String age,@Param("title") String title,@Param("education_background") String education_background,@Param("degree") String degree,
                                   @Param("grade") String grade,@Param("state") String state);

service代码

 public String getTeachingEvaluateFirstTrainNo(){
        return managemapper.getTeachingEvaluateFirstTrainNo();
    }

public void saveevaluateinfo(String evaluate_no,String evaluate_name ,String start_time, String end_time,String state, String url,String remarks){
        managemapper.saveevaluateinfo(evaluate_no, evaluate_name, start_time, end_time, state, url, remarks);
    }

    public void removeevaluateinfo(String evaluate_no){
        managemapper.removeevaluateinfo(evaluate_no);
    }

    public void addevaluateinfo(String evaluate_no,String evaluate_name ,String start_time,String end_time,String state, String url,String remarks){
        managemapper.addevaluateinfo(evaluate_no, evaluate_name, start_time, end_time, state, url, remarks);
    }

    public TeachingEvaluate getTeachingEvaluateListByTnoByPage1(String evaluateNo){
        return managemapper.getTeachingEvaluateListByTnoByPage1(evaluateNo);
    }

    public void addevaluateteacher(String tno,String evaluate_no ,String tname,String gender ,String work_unit,String promoted_title,String age,String title,String education_background, String degree,
                                   String grade,String state){
        managemapper.addevaluateteacher(tno, evaluate_no, tname, gender, work_unit, promoted_title, age, title, education_background, degree, grade, state);
    }

    public void saveevaluateteacherinfo(String teacherNo,String teacherName ,String teacherGender,String workUnit,String teacherAge,String promotedTitle, String teacherTitle,String teacherEducationBG,
                                        String teacherDegree,String teacherGrade, String teacherState){
        managemapper.saveevaluateteacherinfo(teacherNo, teacherName, teacherGender, workUnit, teacherAge, promotedTitle, teacherTitle, teacherEducationBG, teacherDegree, teacherGrade, teacherState);
    }

    public void removeevaluateteacherinfo(String tno,String evaluate_no){
        managemapper.removeevaluateteacherinfo(tno, evaluate_no);
    }

controller代码

 /**
     * 保存修改的教学评价信息
     * @param request
     * @return
     */

    @RequestMapping(value = "/save_evaluateinfo", method = {RequestMethod.GET, RequestMethod.POST})
    @ResponseBody
    public Map<String,String> save_evaluateinfo(HttpServletRequest request,
                                             @RequestParam("evaluate_no") String evaluate_no,
                                             @RequestParam("evaluate_name") String evaluate_name,
                                             @RequestParam("start_time") String start_time,
                                             @RequestParam("end_time") String end_time,
                                             @RequestParam("state") String state,
                                             @RequestParam("url") String url,
                                             @RequestParam("remarks") String remarks){

        manageservice.saveevaluateinfo(evaluate_no,evaluate_name,start_time,end_time,state,url,remarks);
        Map<String,String> map=new HashMap<>();
        map.put("success","true");
        return map;
    }

    /**
     * 添加教学评价信息
     * @param request
     * @return
     */
    @RequestMapping(value = "/add_evaluateinfo", method = {RequestMethod.GET, RequestMethod.POST})
    @ResponseBody
    public Map<String,String> add_evaluateinfo(HttpServletRequest request,
                                               @RequestParam("evaluate_no") String evaluate_no,
                                               @RequestParam("evaluate_name") String evaluate_name,
                                               @RequestParam("start_time") String start_time,
                                               @RequestParam("end_time") String end_time,
                                               @RequestParam("state") String state,
                                               @RequestParam("url") String url,
                                               @RequestParam("remarks") String remarks){
//
        manageservice.addevaluateinfo(evaluate_no,evaluate_name,start_time,end_time,state,url,remarks);
        Map<String,String> map=new HashMap<>();
        map.put("success","true");
        return map;
    }

    /**
     * 删除教学评价项目
     * @param request
     * @return
     */
    @RequestMapping(value = "/remove_evaluateinfo", method = {RequestMethod.GET, RequestMethod.POST})
    @ResponseBody
    public Map<String,String> remove_evaluateinfo(HttpServletRequest request){

        String train_no=request.getParameter("evaluate_no");
        manageservice.removeevaluateinfo(train_no);
        Map<String,String> map=new HashMap<>();
        map.put("success","true");
        return map;
    }

    /**
     * 添加参加某一个教学评价中的教师信息
     * @param request
     * @return
     */
    @RequestMapping(value = "/addevaluateteacherinformation", method = {RequestMethod.GET, RequestMethod.POST})
    @ResponseBody
    public Map<String,String> addevaluateteacher(HttpServletRequest request,HttpSession session,
                                                 @RequestParam("teacherNo") String teacherNo,
                                                 @RequestParam("teacherName") String teacherName,
                                                 @RequestParam("teacherGender") String teacherGender,
                                                 @RequestParam("workUnit") String workUnit,
                                                 @RequestParam("teacherAge") String teacherAge,
                                                 @RequestParam("promotedTitle") String promotedTitle,
                                                 @RequestParam("teacherTitle") String teacherTitle,
                                                 @RequestParam("teacherEducationBG") String teacherEducationBG,
                                                 @RequestParam("teacherDegree") String teacherDegree,
                                                 @RequestParam("teacherGrade") String teacherGrade,
                                                 @RequestParam("teacherState") String teacherState){
        String evaluateNoinfo;
        evaluateNoinfo=(String) session.getAttribute("evaluateNoinfo");
        //这里的if语句用来判断用户是否双击左边一栏，如果双击则获得改行的教学编号
        //如果没双击，则通过session绑定获取左边第一栏中的评价编号
        if(evaluateNoinfo==null){
            evaluateNoinfo=(String) session.getAttribute(