SSM整合之CRUD(ajax提交、pagehelper)——基于测试驱动开发
测试驱动开发:
写一步,测一步
先逻辑,后实现
pagehelper简介
简单来说就是一款开源的Mybatis第三方物理分页插件
为什么说是mybatis呢?
因为其原理就是设置拦截器拦截sql语句,当sql语句执行时在其尾部加上limit startNum, endNum
,这里就得注意dao.xml的sql语句结尾不要加上;
不然执行结果就变成了select * from department; limit startNum, endNum
,很显然会报sql语法错误
1、为什么使用ajax
不用刷新界面就能更新数据,对前台界面的拼接展示效果好
2、准备工作
-
数据库创建
department表
3、开始
目录结构
后台
bean
department
public class Department {
private Integer did;
private String dname;
}
Result
//ajax请求返回的对象
public class Result {
private int code;//200正确、404错误
private String msg;//成功、失败
private Object data;//sql查询数据
private PageInfo<?> pageInfo;//分页插件对象
}
service
interface
public interface DepartmentService {
List<Department> findAllDepartments();
void insertDepartment(Department department);
void deleteDepartmentById(int did);
void updateDepartmentById(Department department);
Department findDepartmentById(int did);
}
implement
@Service
public class DepartmentServiceImpl implements DepartmentService {
@Autowired
private DepartmentDao dao;
@Override
public List<Department> findAllDepartments() {
return dao.findAllDepartments();
}
@Override
public void insertDepartment(Department department) {
dao.insertDepartment(department);
}
@Override
public void deleteDepartmentById(int did) {
dao.deleteDepartmentById(did);
}
@Override
public void updateDepartmentById(Department department) {
dao.updateDepartmentById(department);
}
@Override
public Department findDepartmentById(int did) {
return dao.findDepartmentById