ssm+layui 实现增删改查

目录展示

TblQuestionFpaDao.java

package com.aaa.dao;
import com.aaa.entity.TblQuestionFpa;
import org.apache.ibatis.annotations.Param;
import java.util.List;

/**
 * @Author qiu
 * @Date 2022/9/13 9:58
 * @description:some description
 */
public interface TblQuestionFpaDao {
    //分页查询
    List<TblQuestionFpa> selectPage();
    public List<TblQuestionFpa> findAll(@Param("page") int page, @Param("limit") int limit,@Param("question") String question, @Param("create_by") String create_by);
    //删除数据
    int deleteUserInfoById(List<Integer> ids);
    //添加数据
    int Insert(TblQuestionFpa tblQuestionFpa);
    //修改数据
    int update(TblQuestionFpa tblQuestionFpa);
}

 TblQuestionFpa.java

package com.aaa.entity;

/**
 * @Author qiu
 * @Date 2022/9/15 16:55
 * @description:some description
 */
public class TblQuestionFpa {
    private Integer id;
    private String question;
    private String option_a;
    private String option_b;
    private String option_c;
    private String option_d;
    private Integer type;
    private Integer status;
    private String create_time;
    private String create_by;
    private String update_time;
    private String update_by;
    private Integer flag;
//生成构造函数
//get set 方法
//tostring

   }

TblQuestionFpaServiceImpl.java

package com.aaa.service.impl;

import com.aaa.dao.TblQuestionFpaDao;
import com.aaa.entity.GetIds;
import com.aaa.entity.TblQuestionFpa;
import com.aaa.service.TblQuestionFpaService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;
import java.util.Map;

/**
 * @Author qiu
 * @Date 2022/9/13 10:33
 * @description:some description
 */
@Service
public class TblQuestionFpaServiceImpl implements TblQuestionFpaService {
    @Autowired
    private TblQuestionFpaDao tblQuestionFpaDao;
    //模糊查询及分页
    @Override
    public List<TblQuestionFpa> findAll( int page, int limit, String question, String create_by) {
        return tblQuestionFpaDao.findAll(page,limit,question,create_by);
    }
    @Override
    public List<TblQuestionFpa> selectPage() {
        return tblQuestionFpaDao.selectPage();
    }
//批量删除
    @Override
    public int deleteUserInfoById(GetIds<Integer> ids) {
        List<Integer> gets = ids.getIds();
        return  tblQuestionFpaDao.deleteUserInfoById(gets);
    }
//添加

    @Override
    public int Insert(TblQuestionFpa tblQuestionFpa) {
        return tblQuestionFpaDao.Insert(tblQuestionFpa);
    }
//修改

    @Override
    public int update(TblQuestionFpa tblQuestionFpa) {
        return tblQuestionFpaDao.update(tblQuestionFpa);
    }


}

 TblQuestionFpaService.java

package com.aaa.service;
import com.aaa.entity.GetIds;
import com.aaa.entity.TblQuestionFpa;
import java.util.List;

/**
 * @Author qiu
 * @Date 2022/9/13 10:32
 * @description:some description
 */
public interface TblQuestionFpaService {
//模糊查询及分页
   
 public List<TblQuestionFpa> findAll(int page, int limit,String question,String create_by);
    List<TblQuestionFpa> selectPage();

//批量删除
    int deleteUserInfoById(GetIds<Integer> ids);


    //添加数据
    int Insert(TblQuestionFpa tblQuestionFpa);
    //修改数据
    int update(TblQuestionFpa tblQuestionFpa);
}

 TblQuestionFpaController.java

package com.aaa.controller;

import com.aaa.entity.GetIds;
import com.aaa.entity.ResultDateVo;
import com.aaa.entity.TblQuestionFpa;
import com.aaa.service.TblQuestionFpaService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.RestController;

import java.util.Collections;
import java.util.List;
import java.util.Map;

/**
 * @Author qiu
 * @Date 2022/9/13 18:42
 * @description:some description
 */
@RestController
@RequestMapping("/account")
public class TblQuestionFpaController {
    @Autowired
    private TblQuestionFpaService tblQuestionFpaService;
//模糊查询及分页
    @RequestMapping("/findAll")
    public ResultDateVo<TblQuestionFpa> findAll(Map<String ,Object> map ,
                                                @RequestParam(value = "page") int page , @RequestParam(value = "limit") int limit,
                                                @RequestParam(value = "question",defaultValue = "") String question ,
                                                @RequestParam(value = "create_by" ,defaultValue = "") String create_by){
        int num=(page-1)*limit;
        List<TblQuestionFpa> tblQuestionFpas =tblQuestionFpaService.findAll(num,limit,question,create_by);
        return new ResultDateVo<>(0, "",tblQuestionFpaService.selectPage().size(), tblQuestionFpas);
    }
//批量删除
    @RequestMapping("/deleteUserInfoById")
    public ResultDateVo deleteUserInfoById(GetIds<Integer> ids) {
        int integers = tblQuestionFpaService.deleteUserInfoById(ids);
        return new ResultDateVo(0,"",1, Collections.singletonList(integers));
    }
//添加数据
    @RequestMapping("/insert")
    public ResultDateVo insert(TblQuestionFpa tblQuestionFpa) {
        int b = tblQuestionFpaService.Insert(tblQuestionFpa);
        return new ResultDateVo(0, "", 0, Collections.singletonList(b));
    }
//修改数据
    @RequestMapping("/update")
    public ResultDateVo update(TblQuestionFpa tblQuestionFpa) {
        int b = tblQuestionFpaService.update(tblQuestionFpa);
        return new ResultDateVo(0, "", 0, Collections.singletonList(b));
    }
}

GetIds.java

package com.aaa.entity;

import java.io.Serializable;
import java.util.List;

/**
 * @Author qiu
 * @Date 2022/9/17 10:02
 * @description:some description
 */
public class GetIds <T> implements Serializable {
     private List<T> ids;

    public List<T> getIds() {
        return ids;
    }

    public void setIds(List<T> ids) {
        this.ids = ids;
    }
}

ResultDateVo.java

package com.aaa.entity;

import java.util.List;

/**
 * @Author qiu
 * @Date 2022/9/13 18:53
 * @description:some description
 */
public class ResultDateVo<T> {
    private int code;
    private String msg;
    private int count;
    List<T> data;
//构造参数
//get set 方法
//tostring
   }

TblQuestionFpaDao.xml

   <?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.aaa.dao.TblQuestionFpaDao">
    <insert id="Insert" parameterType="tblQuestionFpa">
        insert into tbl_question_fpa  (question,option_a,option_b,option_c,option_d,type,status,create_by, update_by)
        values (#{question},#{option_a},#{option_b},#{option_c},#{option_d},#{ type},#{status},#{create_by},#{update_by})
    </insert>
    <update id="update" parameterType="TblQuestionFpa">
      update  tbl_question_fpa  set
          question=#{question},
          option_a=#{option_a},
          option_b=#{option_b},
          op