User.java
/*实现getter和setter方法注解*/ @Data public class User { private Integer id; private String name; }
UserMapper.java
@Mapper public interface CommonUserMapper { /**查询所有*/ List<CommonUser> selectAllCommonUser(); }
UserMapper.xml
<?xml version="1.0" encoding="UTF-8" ?> <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "https://mybatis.org/dtd/mybatis-3-mapper.dtd"> <mapper namespace="com.demo.mapper.CommonUserMapper"> <select id="selectAllCommonUser" resultType="com.demo.domain.CommonUser"> SELECT * FROM common_user </select> </mapper>
UserService.java
public interface CommonUserService { /**查询所有*/ List<CommonUser> selectAllCommonUser(); }
UserServiceImpl.java
@Service public class CommonUserServiceImpl implements CommonUserService { @Autowired CommonUserMapper commonUserMapper; /**查询所有*/ @Override public List<CommonUser> selectAllCommonUser() { return commonUserMapper.selectAllCommonUser(); } }
UserController.java
@RestController public class CommonUserController { @Autowired CommonUserService commonUserService; @GetMapping("/selectAllCommonUser") public Result selectAllCommonUser(){ List<CommonUser> commonUsers = commonUserService.selectAllCommonUser(); return Result.success(commonUsers); } }
<template> <div> <el-dialog title="更新" :visible.sync="dialogFormVisible" width="40%"> <el-form :model="form"> <el-form-item label="姓名" label-width="15%"> <el-select v-model="form.name" placeholder="请选择姓名" style="width:90%"> <el-option v-for="item in names" :key="item.id" :label="item.name" :value="item.name"></el-option> </el-select> </el-form-item> </el-form> </el-dialog> </div> </template> <script> import request from '@/utils/request' export default { data() { return { dialogFormVisible:false, form:{}, names:[], } }, // 页面加载时调用 created(){ this.getName() }, methods:{ getName(){ request.get('/selectAllCommonUser').then(res=>{ if(res.code === '200'){ this.names = res.data }else{ this.$message.error('查询失败') } }) } } } </script>
JSON数据
{ "code": "200", "message": "请求成功", "data": [ { "id": 1, "name": "张三" }, { "id": 2, "name": "李四" }, { "id": 3, "name": "王五" }, { "id": 4, "name": "赵六" } ] }
效果