发表于: 2025-06-11 20:42:35
0 30
今天完成的事情:(一定要写非常细致的内容,比如说学会了盒子模型,了解了Margin)
修改分页功能
UserController
@Autowired
private UserMapper userMapper;
@Override
public int addUser(User user) {
try {
int affectedRows = userMapper.addUser(user);
if (affectedRows > 0) {
return affectedRows;
}
else{
System.err.println("添加用户失败影响行数为0");
return 0;
}
}catch(DataAccessException e){
System.err.println("数据库连接发生异常: " + e.getMessage());
e.printStackTrace();
// 返回 0 表示操作失败
return 0;
}
}
ApiResponsePage
package org.example.model;
import java.util.List;
public class ApiResponsePage<T> {
private int code; // 状态码(200表示成功)
private String msg; // 修改点:message -> msg
private final List<T> list;
private final long total;
private final int pageNum;
private final int pageSize;
private final int pages;
// 成功构造方法
public ApiResponsePage(List<T> list) {
this(200, "success", list);
}
// 构造方法(适配PageHelper分页结果)
public ApiResponsePage(int code, String msg, List<T> list) {
this.code = code;
this.msg = msg;
this.list = list;
this.total = list.size();
this.pageNum = 1;
this.pageSize = list.size();
this.pages = 1;
}
public ApiResponsePage(List<T> list, int pageNum, int pageSize, long total, int pages) {
this.code = 200;
this.msg = "success";
this.list = list;
this.total = total;
this.pageNum = pageNum;
this.pageSize = pageSize;
this.pages = pages;
}
// Getter方法修改
public int getCode() {
return code;
}
public String getMsg() { // 修改点:getMessage -> getMsg
return msg;
}
// 其他Getter保持不变
public List<T> getList() {
return list;
}
public long getTotal() {
return total;
}
public int getPageNum() {
return pageNum;
}
public int getPageSize() {
return pageSize;
}
public int getPages() {
return pages;
}
}
UserMapper.xml
<select id="selectByPage" resultType="org.example.model.User">
SELECT id, name, qq, type, graduated_school,
number, wish, link, brother, comprehent_plave,
create_at, update_at
FROM ye
LIMIT #{offset}, #{pageSize}
</select>
<!-- 总数查询保持不变 -->
<select id="selectTotalCount" resultType="long">
SELECT COUNT(*) FROM ye
</select>
UserMapper
package org.example.mapper;
import org.apache.ibatis.annotations.Options;
import org.example.model.User;
import java.util.List;
public interface UserMapper {
@Options(useGeneratedKeys = true, keyProperty = "id")
int addUser(User user);
int updateUser(User user);
int deleteUser(int id);
List<User> queryAllUsers();
User getUserById(int id);
}
明天计划的事情:(一定要写非常细致的内容)
遇到的问题:(遇到什么困难,怎么解决的)
收获:(通过今天的学习,学到了什么知识)
评论