心寒的博客

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 要求数据库本身具备主键.

controllerpackage 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...