【Mybatis找不到字段】 | IT修真院·坑乎

Mybatis找不到字段

我也踩过这个坑( 1 )

已统计您的踩坑,无需重复点击

回答(0)

详细描述

错误截图

源码

package cn.wzy.controller;

import cn.wzy.exception.BusinessRuntimeException;
import cn.wzy.exception.ResultCode;
import cn.wzy.model.User;
import cn.wzy.model.WorkCollection;
import cn.wzy.service.WorkCollectionService;
import cn.wzy.util.CodeMessageData;
import com.alibaba.fastjson.JSONObject;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.RestController;

import java.util.List;


@RestController
public class WorkCollectionController {
    @Autowired
    WorkCollectionService workCollectionService;

    //作品集-查询-名称+状态
    @RequestMapping(value = "/SelectWorkCollection", method = RequestMethod.POST)
    public CodeMessageData selectWorkCollectionName(WorkCollection workCollectionReceive, Integer pn, Integer num){
        if(null!=workCollectionReceive.getWorkCollectionStatus()&&(workCollectionReceive.getWorkCollectionStatus()!=0&&workCollectionReceive.getWorkCollectionStatus()!=1)){
            throw new BusinessRuntimeException(ResultCode.WORK_COLLECTION_STATUS_ERROR);
        }else if (null==pn||pn<=0||null==num||num<=0) {
            throw new BusinessRuntimeException(ResultCode.PAGE_ERROR);
        }else{
            return workCollectionService.selectWorkCollection(workCollectionReceive,pn,num);
        }
    }

    //作品集-新增
    @RequestMapping(value = "/InsertWorkCollection", method = RequestMethod.POST)
    public CodeMessageData insertWorkCollection(WorkCollection workCollectionReceive,User userReceive){
        if (null==userReceive.getUserId()||userReceive.getUserId()<=0){
            throw new BusinessRuntimeException(ResultCode.USER_ID_ERROR);
        }else if (null==workCollectionReceive.getWorkCollectionName()||workCollectionReceive.getWorkCollectionName().equals("")) {
            throw new BusinessRuntimeException(ResultCode.WORK_COLLECTION_STATUS_ERROR);
        }else{
            return workCollectionService.insertWorkCollection(workCollectionReceive,userReceive);
        }
    }

    //作品集-保存排序
    @RequestMapping(value = "/UpdateWorkCollectionOrderBy",method = RequestMethod.POST)
    public CodeMessageData updateWorkCollectionOrderBy(@RequestBody JSONObject jsonObject){
        List<WorkCollection> workCollectionReceive = jsonObject.getJSONArray("workCollectionReceive").toJavaList(WorkCollection.class);
        User userReceive = jsonObject.getJSONObject("userReceive").toJavaObject(User.class);
        if(null==workCollectionReceive||workCollectionReceive.size()==0){
            throw new BusinessRuntimeException(ResultCode.INCOMING_DATA_NOT_FOUND);
        }else if(null==userReceive.getUserId()||userReceive.getUserId()<=0){
            throw new BusinessRuntimeException(ResultCode.USER_ID_ERROR);
        }else{
            return workCollectionService.updateWorkCollectionOrderBy(workCollectionReceive,userReceive);
        }
    }

    //作品集-上or下架
    @RequestMapping(value = "/UpdateWorkCollectionStatus",method = RequestMethod.POST)
    public CodeMessageData updateWorkCollectionStatus(WorkCollection workCollectionReceive,User userReceive) {
        if(null==userReceive.getUserId()||userReceive.getUserId()<=0){
            throw new BusinessRuntimeException(ResultCode.USER_ID_ERROR);
        }else if(null==workCollectionReceive.getWorkCollectionId()||workCollectionReceive.getWorkCollectionId()<=0){
            throw new BusinessRuntimeException(ResultCode.WORK_COLLECTION_ID_ERROR);
        }else if(null==workCollectionReceive.getWorkCollectionStatus()||(workCollectionReceive.getWorkCollectionStatus()!=0&&workCollectionReceive.getWorkCollectionStatus()!=1)){
            throw new BusinessRuntimeException(ResultCode.WORK_COLLECTION_STATUS_ERROR);
        }else{
            return workCollectionService.updateWorkCollectionStatus(workCollectionReceive,userReceive);
        }
    }

    //作品集-编辑
    @RequestMapping(value = "/UpdateWorkCollectionName",method = RequestMethod.POST)
    public CodeMessageData updateWorkCollectionName(WorkCollection workCollectionReceive,User userReceive){
        if(null==userReceive.getUserId()||userReceive.getUserId()<=0){
            throw new BusinessRuntimeException(ResultCode.USER_ID_ERROR);
        }else if(null==workCollectionReceive.getWorkCollectionId()||workCollectionReceive.getWorkCollectionId()<=0){
            throw new BusinessRuntimeException(ResultCode.WORK_COLLECTION_ID_ERROR);
        }else if(null==workCollectionReceive.getWorkCollectionName()||workCollectionReceive.getWorkCollectionName().equals("")){
            throw new BusinessRuntimeException(ResultCode.WORK_COLLECTION_NAME_ERROR);
        }else{
            return workCollectionService.updateWorkCollectionName(workCollectionReceive,userReceive);
        }
    }

    //作品集-删除
    @RequestMapping(value = "/DeleteWorkCollection",method = RequestMethod.POST)
    public CodeMessageData deleteWorkCollection(WorkCollection workCollectionReceive){
        if (null==workCollectionReceive.getWorkCollectionId()||workCollectionReceive.getWorkCollectionId()<=0){
            throw new BusinessRuntimeException(ResultCode.WORK_COLLECTION_ID_ERROR);
        }else{
            return workCollectionService.deleteWorkCollection(workCollectionReceive);
        }
    }
}

package cn.wzy.service;

import cn.wzy.model.SecondaryTittle;
import cn.wzy.dao.SecondaryTittleMapper;
import cn.wzy.dao.UserMapper;
import cn.wzy.dao.WorkCollectionMapper;
import cn.wzy.exception.BusinessRuntimeException;
import cn.wzy.exception.ResultCode;
import cn.wzy.model.User;
import cn.wzy.model.WorkCollection;
import cn.wzy.util.CodeMessageData;
import com.github.pagehelper.PageHelper;
import com.github.pagehelper.PageInfo;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.sql.Timestamp;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

@Service
public class WorkCollectionServiceImpl implements WorkCollectionService {
    @Autowired
    WorkCollectionMapper workCollectionMapper;
    @Autowired
    UserMapper userMapper;
    @Autowired
    SecondaryTittleMapper secondaryTittleMapper;

    //作品集-查询-名称+状态
    public CodeMessageData selectWorkCollection(WorkCollection workCollectionReceive, Integer pn, Integer num){
        PageHelper.startPage(pn,num);
        WorkCollection workCollection = new WorkCollection();
        workCollection.setWorkCollectionName(workCollectionReceive.getWorkCollectionName());
        workCollection.setWorkCollectionStatus(workCollectionReceive.getWorkCollectionStatus());
        List<WorkCollection> list = workCollectionMapper.selectWorkCollection(workCollection);
        if(null==list||list.size()==0){
            return new CodeMessageData(0,"未找到作品集");
        }else{
            return new CodeMessageData(1,"查询成功",  new PageInfo<WorkCollection>(list));
        }
    }

    //作品集-新增
    public CodeMessageData insertWorkCollection(WorkCollection workCollectionReceive,User userReceive){
        Timestamp now = new Timestamp(new Date().getTime());
        Integer order;
        int countCollection =workCollectionMapper.countWorkCollection();
        if(countCollection>=7){
            return new CodeMessageData(0,"作品集达到上限,无法新增");
        }else{
            User user = new User();
            user.setUserId(userReceive.getUserId());
            List<User> users=userMapper.selectUser(user);
            if(users==null||users.size()==0) {
                throw new BusinessRuntimeException(ResultCode.USER_ID_NOT_EXIST);
            }else{
                List<WorkCollection> list=workCollectionMapper.selectWorkCollection(new WorkCollection());
                if(null==list||list.size()==0){
                    order =1;
                }else{
                    order=list.get(0).getWorkCollectionOrderBy()+1;
                }
                WorkCollection workCollection = new WorkCollection();
                workCollection.setWorkCollectionName(workCollectionReceive.getWorkCollectionName());
                workCollection.setWorkCollectionStatus(0);
                workCollection.setWorkCollectionCreateAt(now);
                workCollection.setWorkCollectionUpdateAt(now);
                workCollection.setWorkCollectionCreateBy(users.get(0).getUserNickname());
                workCollection.setWorkCollectionUpdateBy(users.get(0).getUserNickname());
                workCollection.setWorkCollectionOrderBy(order);
                workCollectionMapper.insertWorkCollection(workCollection);
                return new CodeMessageData(1,"新增作品集成功",workCollection);
            }
        }
    }

    //作品集-保存排序
    public CodeMessageData updateWorkCollectionOrderBy(List<WorkCollection> workCollectionsReceive,User userReceive) {
        Timestamp now = new Timestamp(new Date().getTime());
        List<WorkCollection> listBackup = new ArrayList<>();
        List<WorkCollection> list = new ArrayList<>();
        User user = new User();
        user.setUserId(userReceive.getUserId());
        List<User> users=userMapper.selectUser(user);
        if(users==null||users.size()==0) {
            throw new BusinessRuntimeException(ResultCode.USER_ID_NOT_EXIST);
        }else {
            //遍历接到的数据，并备份对应的原数据
            for (WorkCollection workCollectionReceive : workCollectionsReceive) {
                WorkCollection workCollectionBackup = new WorkCollection();
                WorkCollection workCollection = new WorkCollection();
                workCollection.setWorkCollectionId(workCollectionReceive.getWorkCollectionId());
                List<WorkCollection> testList = workCollectionMapper.selectWorkCollection(workCollection);
                if (null == testList||testList.size()==0) {
                    throw new BusinessRuntimeException(ResultCode.WORK_COLLECTION_ID_NOT_EXIST);
                } else if (null == workCollectionReceive.getWorkCollectionOrderBy() || workCollectionReceive.getWorkCollectionOrderBy() <= 0) {
                    throw new BusinessRuntimeException(ResultCode.WORK_COLLECTION_ORDER_BY_ERROR);
                } else {
                    workCollectionBackup.setWorkCollectionId(testList.get(0).getWorkCollectionId());
                    workCollectionBackup.setWorkCollectionOrderBy(testList.get(0).getWorkCollectionOrderBy());
                    workCollectionBackup.setWorkCollectionUpdateBy(testList.get(0).getWorkCollectionUpdateBy());
                    workCollectionBackup.setWorkCollectionUpdateAt(testList.get(0).getWorkCollectionUpdateAt());
                    listBackup.add(workCollectionBackup);
                    workCollection.setWorkCollectionUpdateBy(users.get(0).getUserNickname());
                    workCollection.setWorkCollectionUpdateAt(now);
                    workCollection.setWorkCollectionOrderBy(workCollectionReceive.getWorkCollectionOrderBy());
                    list.add(workCollection);
                }
            }
            //保存排序
            workCollectionMapper.updateWorkCollectionOrderBy(list);
            //校验排序是否正确
            if (null == workCollectionMapper.selectWorkCollectionOrderBy() || workCollectionMapper.selectWorkCollectionOrderBy().size() == 0) {
                return new CodeMessageData(1, "保存排序成功");
            } else {
                workCollectionMapper.updateWorkCollectionOrderBy(listBackup);
                return new CodeMessageData(0, "排序数据错误，操作已回退");
            }
        }
    }

    //作品集-上or下架
    public CodeMessageData updateWorkCollectionStatus(WorkCollection workCollectionReceive,User userReceive){
        Timestamp now = new Timestamp(new Date().getTime());
        User user = new User();
        user.setUserId(userReceive.getUserId());
        List<User> userList =userMapper.selectUser(user);
        WorkCollection workCollection = new WorkCollection();
        workCollection.setWorkCollectionId(workCollectionReceive.getWorkCollectionId());
        List<WorkCollection> workCollectionList=workCollectionMapper.selectWorkCollection(workCollection);
        SecondaryTittle secondaryTittle = new SecondaryTittle();
        secondaryTittle.setWorkCollectionId(workCollectionReceive.getWorkCollectionId());
        List<SecondaryTittle> secondaryTittleList = secondaryTittleMapper.selectSecondaryTittle(secondaryTittle);
        if(null==userList||userList.size()==0){
            throw new BusinessRuntimeException(ResultCode.USER_ID_NOT_EXIST);
        }else if(null==workCollectionList||workCollectionList.size()==0){
            throw new BusinessRuntimeException(ResultCode.WORK_COLLECTION_ID_NOT_EXIST);
        }else if(0==workCollectionReceive.getWorkCollectionStatus()&&secondaryTittleList.size()>0) {
            Integer count = 0;
            for (SecondaryTittle secondaryTittleCount : secondaryTittleList) {
                if (secondaryTittleCount.getSecondaryTittleStatus() == 1) {
                    count = count+1;
                }
            }
            if (count > 0) {
                return new CodeMessageData(0, "作品集下有已上架的二级标题，不可下架");
            }
        }
        WorkCollection workCollectionUpdate = new WorkCollection();
        workCollectionUpdate.setWorkCollectionId(workCollectionReceive.getWorkCollectionId());
        workCollectionUpdate.setWorkCollectionStatus(workCollectionReceive.getWorkCollectionStatus());
        workCollectionUpdate.setWorkCollectionUpdateAt(now);
        workCollectionUpdate.setWorkCollectionUpdateBy(userList.get(0).getUserNickname());
        workCollectionMapper.updateWorkCollection(workCollectionUpdate);
        return new CodeMessageData(1, "作品集状态更新成功");
    }

    //作品集-编辑
    public CodeMessageData updateWorkCollectionName(WorkCollection workCollectionReceive,User userReceive){
        Timestamp now = new Timestamp(new Date().getTime());
        User user = new User();
        user.setUserId(userReceive.getUserId());
        List<User> userList =userMapper.selectUser(user);
        WorkCollection workCollection = new WorkCollection();
        workCollection.setWorkCollectionId(workCollectionReceive.getWorkCollectionId());
        List<WorkCollection> workCollectionsList=workCollectionMapper.selectWorkCollection(workCollection);
        if(null==userList||userList.size()==0){
            throw new BusinessRuntimeException(ResultCode.USER_ID_NOT_EXIST);
        }else if(null==workCollectionsList||workCollectionsList.size()==0){
            throw new BusinessRuntimeException(ResultCode.WORK_COLLECTION_ID_NOT_EXIST);
        }else{
            WorkCollection workCollectionUpdate = new WorkCollection();
            workCollectionUpdate.setWorkCollectionId(workCollectionReceive.getWorkCollectionId());
            workCollectionUpdate.setWorkCollectionName(workCollectionReceive.getWorkCollectionName());
            workCollectionUpdate.setWorkCollectionUpdateAt(now);
            workCollectionUpdate.setWorkCollectionUpdateBy(userList.get(0).getUserNickname());
            workCollectionMapper.updateWorkCollection(workCollectionUpdate);
            return new CodeMessageData(1,"编辑作品集名称成功");
        }
    }

    //作品集-删除
    public CodeMessageData deleteWorkCollection(WorkCollection workCollectionReceive) {
        WorkCollection workCollection = new WorkCollection();
        workCollection.setWorkCollectionId(workCollectionReceive.getWorkCollectionId());
        List<WorkCollection> workCollectionList = workCollectionMapper.selectWorkCollection(workCollection);
        SecondaryTittle secondaryTittle = new SecondaryTittle();
        secondaryTittle.setWorkCollectionId(workCollectionReceive.getWorkCollectionId());
        List<SecondaryTittle> secondaryTittleList = secondaryTittleMapper.selectSecondaryTittle(secondaryTittle);
        if(null == workCollectionList||workCollectionList.size()==0) {
            throw new BusinessRuntimeException(ResultCode.WORK_COLLECTION_ID_NOT_EXIST);
        }else if(1 == workCollectionList.get(0).getWorkCollectionStatus()) {
            return new CodeMessageData(0, "作品集为上架状态，不可删除");
        }else if(null!=secondaryTittleList&&secondaryTittleList.size()>0){
            return new CodeMessageData(0, "作品集下有二级标题，不可删除");
        }else{
            workCollectionMapper.deleteWorkCollection(workCollection);
            return new CodeMessageData(1, "作品集已删除");
        }
    }
}

<?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="cn.wzy.dao.WorkCollectionMapper">
    <!--防止实体类与数据库命名不一致-->
    <resultMap id="workCollectionMap" type="cn.wzy.model.WorkCollection">
        <id column="work_collection_id" property="workCollectionId"/>
        <result column="work_collection_name" property="workCollectionName"/>
        <result column="work_collection_status" property="workCollectionStatus"/>
        <result column="work_collection_create_at" property="workCollectionCreateAt"/>
        <result column="work_collection_update_at" property="workCollectionUpdateAt"/>
        <result column="work_collection_create_by" property="workCollectionCreateBy"/>
        <result column="work_collection_update_by" property="workCollectionUpdateBy"/>
        <result column="work_collection_order_by" property="workCollectionOrderBy"/>
    </resultMap>
    <!--根据作品集名或作品集状态或作品集id查询作品集-->
    <select id="selectWorkCollection" resultMap="workCollectionMap">
        SELECT * FROM work_collection
        <where>
            <if test="workCollectionName!=''and workCollectionName!=null">
                work_collection_name LIKE "%"#{workCollectionName}"%"
            </if>
            <if test="workCollectionStatus ==0 or workCollectionStatus == 1">
                AND work_collection_status=#{workCollectionStatus}
            </if>
            <if test="workCollectionId !='' and workCollectionId !=null">
                AND work_collection_id=#{workCollectionId}
            </if>
        </where>
        ORDER BY work_collection_order_by DESC
    </select>
    <!--计算作品集表中数据条数-->
    <select id="countWorkCollection" resultType="Integer">
                SELECT COUNT(*) FROM work_collection
    </select>
    <!--作品集插入一条数据-->
    <insert id="insertWorkCollection" parameterType="cn.wzy.model.WorkCollection">
                INSERT INTO work_collection(
                work_collection_name,
                work_collection_status,
                work_collection_create_at,
                work_collection_update_at,
                work_collection_create_by,
                work_collection_update_by,
                work_collection_order_by)
                VALUES (
                #{workCollectionName},
                #{workCollectionStatus},
                #{workCollectionCreateAt},
                #{workCollectionUpdateAt},
                #{workCollectionCreateBy},
                #{workCollectionUpdateBy},
                #{workCollectionOrderBy})
    </insert>
    <!--根据作品集id批量更新作品集排序-->
    <update id="updateWorkCollectionOrderBy" parameterType="java.util.List">
        <foreach collection="list" item="workCollection" separator=";">
            update work_collection set
            work_collection_order_by=#{workCollection.workCollectionOrderBy},
            work_collection_update_at=#{workCollection.workCollectionUpdateAt},
            work_collection_update_by=#{workCollection.workCollectionUpdateBy}
            where work_collection_id=#{workCollection.workCollectionId}
        </foreach>
    </update>
    <!--查询order_by字段是否有重复-->
    <select id="selectWorkCollectionOrderBy" resultMap="workCollectionMap">
        select work_collection_order_by from work_collection group by work_collection_order_by having count(*)>1
    </select>
    <!--通过作品集id更新作品集状态或名称-->
    <update id="updateWorkCollection" parameterType="cn.wzy.model.WorkCollection">
        UPDATE work_collection set
        <if test="workCollectionStatus == 0 or workCollectionStatus == 1">
            work_collection_status=#{workCollectionStatus},
        </if>
        <if test="workCollectionName != null and workCollectionName !=''">
            work_collection_name=#{workCollectionName},
        </if>
        work_collection_update_at=#{workCollectionUpdateAt},
        work_collection_update_by=#{workCollectionUpdateBy}
        where work_collection_id=#{workCollectionId}
    </update>
    <!--通过作品集id删除作品集-->
    <delete id="deleteCollection">
        DELETE FROM work_collection WHERE work_collection_id=#{workCollectionId}
    </delete>
</mapper>

编辑于2024-11-23