心寒的博客

Mybatis使用Oracle数据库主键自增

Mybatis批次处理数据

Springboot+MYbaits框架下，使用以下注解操作oracle插入数据时报错 @Insert("insert into student (stuid,name)values(#{stuid},#{name})") @Options(useGeneratedKeys = true,keyProperty = "stuid") public int insertStu(Student student); 查了下useGeneratedKeys 要求数据库本身具备主键.

controller package com.excel.demo.controller; import com.alibaba.excel.EasyExcel; import com.alibaba.excel.write.builder.ExcelWriterBuilder; import com.excel.demo.service.LedgerRealFeeService; import com.excel.demo.utils.EasyExcelUtils; import org.spr.

依赖： <dependency> <groupId>com.github.pagehelper</groupId> <artifactId>pagehelper-spring-boot-starter</artifactId> <version>1.2.5</version> </dependency> Service public List<Ledgerre

学生对应分数表为一对多，实体类： package com.excel.demo.entity; /** * @author :Hj * @date 2021/2/25 10:19 */ public class Grade { private long stuid; private int math ; private int english; private int chinese; private int sum; public lo...