JPA规范
- 查询条件要以get, find, read开头, 条件查询属性用相关字连接
- 条件查询要字段的首字母大写
通常字段都是小写的public User findByName(String name);
- 使用Query注解 写HQL语句(nativeQuery = true,用sql查)
@Query("from User where name=:name") public User xx(@Param("name") String name);
Jpa分页
Pageable 的实现类有PageRequest;
@param 1.基0 页数
@param 2.当前页数显示条数
异常页面
@ControllerAdvice
public class xxxHandler {
@ExceptionHandler
@ResponseBody
private String exceptionHandler(HttpServletRequest request,Exception e){
return "网站炸了";
}
}
mybatis混合
导jar生成mapper,在启动类加@MapperScan(“com.xx.dao”)
mybatis分页
@Configuration
public class PageConfig {
@Bean
public PageHelper mybatisPage() {
PageHelper pageHelper = new PageHelper();
Properties p= new Properties();
p.setProperty("offsetAsPageNum", "true");
p.setProperty("rowBoundsWithCount", "true");
p.setProperty("reasonable", "true");
pageHelper.setProperties(p);
return pageHelper;
}
}