人人权限框架练习

人人框架

使用gen_test_data表进行crud业务的熟悉

• 注释@EqualsAndHashCode(callSuper=false)
  添加链接描述
  重写equals方法和hashcode方法，

• @TableName(“gen_test_data”)
  https://www.cnblogs.com/qingmuchuanqi48/p/11878757.html

• @TableField(fill = FieldFill.INSERT_UPDATE)
  自动填充字段

DTO

• https://blog.csdn.net/weixin_34059951/article/details/92613242

easyexcel注解

@ExcelProperty

dao层处理

@Mapper·注解

• 继承BassDao

wrapper常用方法

.like
.eq
.ge
.le
https://blog.csdn.net/qq_39706515/article/details/118492589

map通过get获取值

params是map类型的容器，通过.get取值

@Service

swagger2 注解说明 ( @ApiImplicitParams )

@RequiresPermissions

controller里面的方法

• 查询所有数据并分页

    @GetMapping("page")
    @ApiOperation("分页")
    @ApiImplicitParams({
        @ApiImplicitParam(name = Constant.PAGE, value = "当前页码，从1开始", paramType = "query", required = true, dataType="int") ,
        @ApiImplicitParam(name = Constant.LIMIT, value = "每页显示记录数", paramType = "query",required = true, dataType="int") ,
        @ApiImplicitParam(name = Constant.ORDER_FIELD, value = "排序字段", paramType = "query", dataType="String") ,
        @ApiImplicitParam(name = Constant.ORDER, value = "排序方式，可选值(asc、desc)", paramType = "query", dataType="String")
    })
    @RequiresPermissions("student:sysstudent:page")
    public Result<PageData<SysStudentDTO>> page(@ApiIgnore @RequestParam Map<String, Object> params){
        PageData<SysStudentDTO> page = sysStudentService.page(params);

        return new Result<PageData<SysStudentDTO>>().ok(page);
    }

• 根据列id,返回要修改的数据（请求修改数据时，根据该数据的id显示出来）

    @GetMapping("{id}")
    @ApiOperation("信息，修改信息，根据id返回数据")
    @RequiresPermissions("student:sysstudent:info")
    public Result<SysStudentDTO> get(@PathVariable("id") Long id){
        SysStudentDTO data = sysStudentService.get(id);

        return new Result<SysStudentDTO>().ok(data);
    }

• 完成修改操作后，提交修改动作

    @PutMapping
    @ApiOperation("修改")
    @LogOperation("修改")
    @RequiresPermissions("student:sysstudent:update")
    public Result update(@RequestBody SysStudentDTO dto){
        //效验数据
        ValidatorUtils.validateEntity(dto, UpdateGroup.class, DefaultGroup.class);

        sysStudentService.update(dto);

        return new Result();
    }

• 新增操作填写数据后，提交保存走的接口

@PostMapping
    @ApiOperation("保存")
    @LogOperation("保存")
    @RequiresPermissions("student:sysstudent:save")
    public Result save(@RequestBody SysStudentDTO dto){
        //效验数据
        ValidatorUtils.validateEntity(dto, AddGroup.class, DefaultGroup.class);

        sysStudentService.save(dto);

        return new Result();
    }

• 提交删除操作

  @DeleteMapping
    @ApiOperation("删除")
    @LogOperation("删除")
    @RequiresPermissions("student:sysstudent:delete")
    public Result delete(@RequestBody Long[] ids){
        //效验数据
        AssertUtils.isArrayEmpty(ids, "id");

        sysStudentService.delete(ids);

        return new Result();
    }

• 导出数据到excel

    @GetMapping("export")
    @ApiOperation("导出")
    @LogOperation("导出")
    @RequiresPermissions("student:sysstudent:export")
    public void export(@ApiIgnore @RequestParam Map<String, Object> params, HttpServletResponse response) throws Exception {
        List<SysStudentDTO> list = sysStudentService.list(params);

        ExcelUtils.exportExcelToTarget(response, null, "学生表", list, SysStudentExcel.class);
    }

关于权限

在controller里面设置的权限，@RequiresPermissions(“student:sysstudent:delete”)
要操作该接口，必须有对应的授权

前端

<template>
  <el-card shadow="never" class="aui-card--fill">
    <div class="mod-student__sysstudent">
      <el-form :inline="true" :model="dataForm" @keyup.enter.native="getDataList()">

        <el-form-item>
          <el-input v-model="dataForm.name" placeholder="姓名" clearable></el-input>
        </el-form-item>

        <el-form-item>
          <el-button @click="getDataList()">{{ $t('query') }}</el-button>
        </el-form-item>

        <el-form-item>
          <el-button type="info" @click="exportHandle()">{{ $t('export') }}</el-button>
        </el-form-item>

        <el-form-item>
          <el-button v-if="$hasPermission('student:sysstudent:save')" type="primary" @click="addOrUpdateHandle()">{{ $t('add') }}</el-button>
        </el-form-item>

        <el-form-item>
          <el-button v-if="$hasPermission('student:sysstudent:delete')" type="danger" @click="deleteHandle()">{{ $t('deleteBatch') }}</el-button>
        </el-form-item>

      </el-form>
      <el-table v-loading="dataListLoading" :data="dataList" border @selection-change="dataListSelectionChangeHandle" style="width: 100%;">
        <el-table-column type="selection" header-align="center" align="center" width="50"></el-table-column>
        <el-table-column prop="name" label="姓名" header-align="center" align="center"></el-table-column>
        <el-table-column prop="sex" label="性别" header-align="center" align="center"></el-table-column>
        <el-table-column prop="age" label="年龄" header-align="center" align="center"></el-table-column>
        <el-table-column prop="score" label="分数" header-align="center" align="center"></el-table-column>

        <el-table-column :label="$t('handle')" fixed="right" header-align="center" align="center" width="150">
          <template slot-scope="scope">
            <el-button v-if="$hasPermission('student:sysstudent:update')" type="text" size="small" @click="addOrUpdateHandle(scope.row.id)">{{ $t('update') }}</el-button>
            <el-button v-if="$hasPermission('student:sysstudent:delete')" type="text" size="small" @click="deleteHandle(scope.row.id)">{{ $t('delete') }}</el-button>
          </template>
        </el-table-column>

      </el-table>

      <el-pagination
        :current-page="page"
        :page-sizes="[10, 20, 50, 100]"
        :page-size="limit"
        :total="total"
        layout="total, sizes, prev, pager, next, jumper"
        @size-change="pageSizeChangeHandle"
        @current-change="pageCurrentChangeHandle">
      </el-pagination>
      
      <!-- 弹窗, 新增 / 修改 -->
      <add-or-update v-if="addOrUpdateVisible" ref="addOrUpdate" @refreshDataList="getDataList"></add-or-update>
    </div>
  </el-card>
</template>

<script>
import mixinViewModule from '@/mixins/view-module'
import AddOrUpdate from './sysstudent-add-or-update'
export default {
  mixins: [mixinViewModule],
  data () {
    return {
      mixinViewModuleOptions: {
        getDataListURL: '/student/sysstudent/page',
        getDataListIsPage: true,
        exportURL: '/student/sysstudent/export',
        deleteURL: '/student/sysstudent',
        deleteIsBatch: true
      },
      dataForm: {
        name: '',
      }
    }
  },
  watch: {
  },
  components: {
    AddOrUpdate
  }
}
</script>

<template>

  <el-dialog :visible.sync="visible" :title="!dataForm.id ? $t('add') : $t('update')" :close-on-click-modal="false" :close-on-press-escape="false">

    <el-form :model="dataForm" :rules="dataRule" ref="dataForm" @keyup.enter.native="dataFormSubmitHandle()" :label-width="$i18n.locale === 'en-US' ? '120px' : '80px'">

      <el-form-item label="姓名" prop="name">
        <el-input v-model="dataForm.name" placeholder="姓名"></el-input>
      </el-form-item>

      <el-form-item label="性别" prop="sex">
        <el-input v-model="dataForm.sex" placeholder="性别"></el-input>
      </el-form-item>

      <el-form-item label="年龄" prop="age">
        <el-input v-model="dataForm.age" placeholder="年龄"></el-input>
      </el-form-item>

      <el-form-item label="分数" prop="score">
        <el-input v-model="dataForm.score" placeholder="分数"></el-input>
      </el-form-item>

    </el-form>

    <template slot="footer">
      <el-button @click="visible = false">{{ $t('cancel') }}</el-button>
      <el-button type="primary" @click="dataFormSubmitHandle()">{{ $t('confirm') }}</el-button>
    </template>
  </el-dialog>
</template>

<script>

import debounce from 'lodash/debounce'
export default {
  data () {
    return {
      visible: false,
      dataForm: {
        id: '',
        name: '',
        sex: '',
        age: '',
        score: '',
      }
    }
  },
  computed: {
    dataRule () {
      return {
        name: [
          { required: true, message: this.$t('validate.required'), trigger: 'blur' }
        ],
        sex: [
          { required: true, message: this.$t('validate.required'), trigger: 'blur' }
        ],
        age: [
          { required: true, message: this.$t('validate.required'), trigger: 'blur' }
        ],
        score: [
          { required: true, message: this.$t('validate.required'), trigger: 'blur' }
        ],
      }
    }
  },
  methods: {
    init () {
      this.visible = true
      this.$nextTick(() => {
        this.$refs['dataForm'].resetFields()
        if (this.dataForm.id) {
          this.getInfo()
        }
      })
    },
    // 获取信息
    getInfo () {
      this.$http.get('/student/sysstudent/' + this.dataForm.id).then(({ data: res }) => {
        if (res.code !== 0) {
          return this.$message.error(res.msg)
        }
        this.dataForm = {
          ...this.dataForm,
          ...res.data
        }
      }).catch(() => {})
    },
    // 表单提交
    dataFormSubmitHandle: debounce(function () {
      this.$refs['dataForm'].validate((valid) => {
        if (!valid) {
          return false
        }
        this.$http[!this.dataForm.id ? 'post' : 'put']('/student/sysstudent/', this.dataForm).then(({ data: res }) => {
          if (res.code !== 0) {
            return this.$message.error(res.msg)
          }
          this.$message({
            message: this.$t('prompt.success'),
            type: 'success',
            duration: 500,
            onClose: () => {
              this.visible = false
              this.$emit('refreshDataList')
            }
          })
        }).catch(() => {})
      })
    }, 1000, { 'leading': true, 'trailing': false })
  }
}
</script>

条件查询

  @Override
    public QueryWrapper<SysStudentEntity> getWrapper(Map<String, Object> params){
        QueryWrapper<SysStudentEntity> wrapper = new QueryWrapper<>();

        String name = (String)params.get("name");
        wrapper.eq(StringUtils.isNotBlank(name), "name", name);
        
 where条件拼接
//StirngUtils.isNotBlank(name),当name不存在时，返回false==》》wrapper.eq(false,"name",name);
有name执行where
//SELECT id,name,sex,age,score,creator,create_date FROM sys_student_test WHERE (name = ?) LIMIT ?,?
没name执行
//SELECT id,name,sex,age,score,creator,create_date FROM sys_student_test LIMIT ?,?
        return wrapper;
    }

前端

• $t(‘xxx.xx’) 是用来 取得i18n里面定义的国际化常量
• 列表查询，删除，导出用到的组件