宁波正规网站建设使用方法,如何写一个微信小程序,苏州网络公司排名一览,泰安高新区建设局网站目录 1、编写模板
2、发请求调接口
3、后端返回数据
1.编写实体类
2、UserController
3、Userservice接口
4、#xff08;mapper接口#xff09;UserMapper
5、xml 1、编写模板 !-- 搜素框 --el-input placeholder请输入姓名 v-modelke…目录 1、编写模板
2、发请求调接口
3、后端返回数据
1.编写实体类
2、UserController
3、Userservice接口
4、mapper接口UserMapper
5、xml 1、编写模板 !-- 搜素框 --el-input placeholder请输入姓名 v-modelkeyWord stylewidth: 400pxel-button slotappend iconel-icon-search clicksearchByKeyword()/el-button/el-input!-- 列表 --el-table :datatableData border stylewidth: 50%;margin: 0 auto; selection- changehandleSelectionChangeel-table-column typeselection width55/el-table-columnel-table-column propuserId label账号 width180/el-table-columnel-table-column propuserName label姓名 width180/el-table-columnel-table-column proppassword label密码/el-table-columnel-table-column propsex label性别/el-table-columnel-table-column propage label年龄/el-table-columnel-table-column proplocation label地址/el-table-columnel-table-column propname label操作 aligncentertemplate slot-scopescope!-- (scope.row.userId)用于获取当前行数据对象中的用户ID或其他字段 --el-button sizemini typetext clickopenDialog(scope.row)编辑/el-buttonel-button sizemini typetext clickdeleteUser(scope.row.userId)删除/el-button/template/el-table-column/el-table!-- 分页 --divel-pagination size-changehandleSizeChange prev-clickprevClick next-clicknextClickcurrent-changehandleCurrentChange background layouttotal,sizes,prev, pager, next,jumper :totaltotal:page-sizes[10, 20, 50, 100, 500, 2000]/el-pagination/div
2、发请求调接口
export default {data() {tableData: [], // 数据列表keyWord: ,//搜素框的值total: 0, // 数据总数pageNum: 0,//当前页码pageSize: 10,//每页显示的条数},//生命周期钩子函数在组件挂载后被调用它会执行 selectUser(1, 10, ) 方法用于初始化数据并展示第一页的用户数据。mounted() {this.selectUser(1, 10, );},methods: {//分页方法、当页码发生变化是被调用handleCurrentChange(pageNum) {this.pageNum pageNumthis.selectUser();},//上一页prevClick(pageNum) {this.pageNum pageNumthis.selectUser();},//下一页nextClick(pageNum) {this.pageNum pageNumthis.selectUser();},//当改变每页显示条数时被调用handleSizeChange(pageSize) {this.pageSize pageSizethis.selectUser();},//查询用户数据的方法selectUser() {this.$axios({method: post,url: http://localhost:8080/api/user/selectUser,data: {pageNum: this.pageNum,pageSize: this.pageSize,keyWord: this.keyWord,}}).then((res) {let result res.data.data;this.tableData result.list;this.total result.total;})},
}
3、后端返回数据
1.编写实体类
Page实体类
package com.example.goods_admin.entity;public class Page {private int pageNum;private int pageSize;private String keyWord;public Page() {}public String getKeyWord() {return keyWord;}public void setKeyWord(String keyWord) {this.keyWord keyWord;}public Page(int pageNum, int pageSize, String keyWord) {this.pageNum pageNum;this.pageSize pageSize;this.keyWord keyWord;}public int getPageNum() {return pageNum;}public void setPageNum(int pageNum) {this.pageNum pageNum;}public int getPageSize() {return pageSize;}public void setPageSize(int pageSize) {this.pageSize pageSize;}
}user实体类继承page
package com.example.goods_admin.entity;public class User extends Page {private String id;private String userId;private String userName;private String password;private String sex;private int age;private String location;public User() {super();}public User(int pageNum, int pageSize, String keyWord) {super(pageNum, pageSize, keyWord);}public User(int pageNum, int pageSize, String keyWord, String id, String userId, String userName, String password, String sex, int age, String location) {super(pageNum, pageSize, keyWord);this.id id;this.userId userId;this.userName userName;this.password password;this.sex sex;this.age age;this.location location;}public String getId() {return id;}public void setId(String id) {this.id id;}public String getUserId() {return userId;}public void setUserId(String userId) {this.userId userId;}public String getUserName() {return userName;}public void setUserName(String userName) {this.userName userName;}public String getPassword() {return password;}public void setPassword(String password) {this.password password;}public String getSex() {return sex;}public void setSex(String sex) {this.sex sex;}public int getAge() {return age;}public void setAge(int age) {this.age age;}public String getLocation() {return location;}public void setLocation(String location) {this.location location;}}2、UserController
RestController
//RequestMapping用于将 HTTP 请求映射到控制器方法上
RequestMapping(/user)
public class UserController {AutowiredUserservice userservice;PostMapping(/selectUser)// RequestBody 用于将 HTTP 请求的内容或者请求体绑定到方法的参数上。public Result selectUser(RequestBody User user) {return userservice.selectUser(user);}
}
3、Userservice接口
public interface Userservice {Result selectUser(User user);}
4、Service层UserserviceImpl
Service
public class UserserviceImpl implements Userservice {AutowiredUserMapper userMapper;Overridepublic Result selectUser(User user) {int pageNum user.getPageNum()0?1:user.getPageNum();int pageSize user.getPageSize()0?10:user.getPageSize();//1、开启分页查询PageHelper.startPage(pageNum,pageSize);//2、查询结果ListUser userList userMapper.seleteUser(user);//3、封装结果PageInfoUser userPageInfo new PageInfo(userList);//4、返回return Result.succeed(查询成功,userPageInfo);}}
4、mapper接口UserMapper
Mapper
public interface UserMapper {ListUser seleteUser(User user);
}
5、xml
?xml version1.0 encodingUTF-8?
!DOCTYPE mapper PUBLIC -//mybatis.org//DTD Mapper 3.0//EN http://mybatis.org/dtd/mybatis-3-mapper.dtd
mapper namespacecom.example.goods_admin.mapper.UserMapper
!-- 结果映射数据库字段与实体类字段的映射关系--resultMap idBaseResultMap typecom.example.goods_admin.entity.Userid columnid jdbcTypeVARCHAR propertyid /result columnuserId jdbcTypeVARCHAR propertyuserId /result columnuserName jdbcTypeVARCHAR propertyuserName /result columnpassword jdbcTypeVARCHAR propertypassword /result columnsex jdbcTypeVARCHAR propertysex /result columnage jdbcTypeINTEGER propertyage /result columnlocation jdbcTypeVARCHAR propertylocation //resultMapselect idseleteUser resultTypecom.example.goods_admin.entity.Userselect * from userwhereif testkeyWord !null and keyWord!userName like concat(%, #{keyWord}, %)/if/where/select/mapper
