毕业设计回顾

2020-04-03

service

package com.ahpu.service.impl;

import com.ahpu.mapper.UserMapper;
import com.ahpu.pojo.User;
import com.ahpu.pojo.UserExample;
import com.ahpu.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;

@Service
public class UserServiceImpl implements UserService {
    @Autowired
    UserMapper userMapper;

    @Override
    public void add(User u) {
        userMapper.insert(u);
    }

    @Override
    public void delete(Integer number) {
        userMapper.deleteByPrimaryKey(number);
    }

    @Override
    public void update(User u) {
        userMapper.updateByPrimaryKey(u);
    }

    @Override
    public User get(Integer number, String password) {
        System.out.println(userMapper.selectByPrimaryKey(number));

        for(int i=0;i<10;i++) System.out.println(i);

        return userMapper.selectByPrimaryKey(number);

//     
    }

}

　　Mapper

package com.ahpu.mapper;

import com.ahpu.pojo.User;
import com.ahpu.pojo.UserExample;

import java.util.List;

public interface UserMapper {
    int deleteByPrimaryKey(Integer number);

    int insert(User record);


    User selectByPrimaryKey(Integer number);


    int updateByPrimaryKey(User record);
}

　　Controller

@RequestMapping("loginForm")
    public String login(@RequestParam("number") int number, @RequestParam("password") String password, Model model, HttpSession session) {
      //  number = HtmlUtils.htmlEscape(number);

        User user = userService.get(number,password);
        if(null==password){
            model.addAttribute("msg", "账号密码错误");
            return "/signUp";
        }
        session.setAttribute("user", user);
        return "redirect:loginsuccess";
    }

　Mapper.xml

<select id="selectByPrimaryKey" parameterType="java.lang.Integer" resultType="com.ahpu.pojo.User">
        select
        *
        from user
        where number = #{number,jdbcType=INTEGER}
    </select>

　　error

消息 Request processing failed; nested exception is java.lang.IllegalArgumentException: Mapped Statements collection does not contain value for com.ahpu.mapper.UserMapper.selectByPrimaryKey

已解决：

mapper.xml

路径写错：

<mapper namespace="com.ahpu.mapper.UserMapper">

修改之后迎来下一个错误：

消息 Request processing failed; nested exception is org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.builder.BuilderException: Error resolving JdbcType. Cause: java.lang.IllegalArgumentException: No enum constant org.apache.ibatis.type.JdbcType.String

已解决：

mybatis下的JdbcType只能为：

BIT FLOAT CHAR TIMESTAMP OTHER UNDEFINED

TINYINT REAL VARCHAR BINARY BLOB NVARCHAR

SMALLINT DOUBLE LONGVARCHAR VARBINARY CLOB NCHAR

INTEGER NUMERIC DATE LONGVARBINARY BOOLEAN NCLOB

BIGINT DECIMAL TIME NULL CURSOR

2020-4-4

在对所有的jsp页面进行重构之后发现除了主页之外访问任何页面都会404，包括静态图片。经检查有以下几个问题：

SpringMVC.xml文件下的路径没有及时更改

但是修改之后情况还是没有变化，看网上说的大概是在web.xml文件中对所有的静态文件进行了拦截，但是按照网上的步骤还是无法进行更改，于是仿照Controller的写法，写了个转换

package com.ahpu.controller;

import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;

@Controller
@RequestMapping("")
public class PageController {
    @RequestMapping("signUp")
    public String signUp() {
        return "fore/signUp";
    }
    @RequestMapping("zxxx")
    public String zxxx() {
        return "fore/zxxx";
    }
    @RequestMapping("xyxw")
    public String zyxw() {
        return "fore/xyxw";
    }
    @RequestMapping("dyfc")
    public String dyfc(){
        return "fore/dyfc";
    }
    @RequestMapping("loginsuccess")
    public String loginsuccess(){
        return "fore/loginsuccess";
    }

}

　　但是应该注意，在herf和Controller中都不要出现.jsp

我就是一个只知道cv大法的小菜鸡

完成了editormd的功能按钮拓展以及预览页面

就是抄https://www.jianshu.com/p/9d245837aa4c大佬的

form表单提交到controller获取不到内容，是因为提交时要保证提交的文字区名（不是表单名！！！！！！）要和controller对应

这里就应该是content而不是editormd或者mdEditorForm

controller

@RequestMapping("contentCommit")
    public ModelAndView contentCommit(@RequestParam("content") String  content){
        System.out.println("提交的内容为：" + content);
        ModelAndView modelAndView = new ModelAndView("admin/preview");
        //将内容发送至前台预览
        modelAndView.addObject("viewContent" , content);
        System.out.println("跳转至内容显示页面");
        return modelAndView;
    }

5-22

org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'roomController': Injection of autowired dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Could not autowire field: com.ahpu.service.RoomService com.ahpu.controller.RoomController.roomService; nested exception is org.springframework.beans.factory.NoSuchBeanDefinitionException: No qualifying bean of type [com.ahpu.service.RoomService] found for dependency: expected at least 1 bean which qualifies as autowire candidate for this dependency. Dependency annotations: {@org.springframework.beans.factory.annotation.Autowired(required=true)}

ServiceImpl没加@service注释

Caused by: java.lang.IllegalStateException: Ambiguous mapping found. Cannot map ‘myCockpitMgrController’ bean method

控制层同一请求映射到两个方法,检查@RequestMapping(value = “请求方法名”)是否重复

5-24

Mapped Statements collection does not contain value for

<mapper namespace="mapper.TopicMapper" >    -》      <mapper namespace="com.ahpu.mapper.TopicMapper" >