车字辕-CSDN博客

@ApiOperation(value = "导出")@RequestMapping(value = "/Export", method = {RequestMethod.POST})public void Export(HttpServletResponse response, @ApiParam(name = "baseInfo", value = "baseInfo", required = true) @RequestBody baseParam param) throws Exception

2022-03-25 10:13:06 1817 2

原创 easypoi 百万数据导出

List<EcBWaterEngExport> listAll = ecBaseInfoService.manageEngExport(param); Workbook workbook = null; Date start = new Date(); ExportParams params = new ExportParams("取水工程导出", "取水工程"); int talpage=(li

2022-03-23 10:16:31 997 1

原创 oracle 根据时间段查询日期

select level,to_char(to_date('2020-12-31','yyyy-mm-dd')+level-1,'yyyy-mm-dd') as dat from dualconnect by level <=to_date('2022-02-03','yyyy-mm-dd')-to_date('2020-12-31','yyyy-mm-dd')+1

2022-03-09 10:37:03 186

原创 Error committing transaction. Cause 错误

“message”:" Error committing transaction. Cause: java.sql.SQLException:Error\r(nt Cause:java.sql.SQLException:Error",“throwable”: “org.apache.ibatis.exceptions.PersistenceException”mybatis 批量修改时报的这个错，找同事看了下说是事务原因。把service代码放到controller 中，就可以了...

2022-01-20 09:37:12 581

原创【无标题】oracle 查询最新一条数据

select * from (SELECTr.*FROM( SELECT r.* , row_number () over ( partition BY r.std_bk_measure_id ORDER BY r.this_time DESC ) px FROM WI_MEASURE_RCD_R r where r.FLAG_VALID = ‘1’ ) rWHERE r.px = 1ORDER BYr.this_time DESC)

2022-01-06 17:42:25 1285

原创 java 实体与实体相互转换

import org.apache.commons.beanutils.BeanUtils; Test test= new Test (); BeanUtils.copyProperties(test,被转的实体);

2021-11-08 15:07:33 2316

空空如也

空空如也