- 博客(137)
- 收藏
- 关注
转载 Oracle 字段值按逗号拆分,变为多行数据
转载:https://blog.csdn.net/weixin_42403127/article/details/104295906?
2023-07-11 18:25:28 1178
原创 mybitis oracle批量修改 。oracle 和mysql 注意 foreache 有区别
【代码】mybitis oracle批量修改。oracle 和mysql 注意 foreache 有区别。
2023-03-24 14:53:27 152 1
原创 Load balancer does not have available server for client: wr-fac
ZUUL eureka 找不到服务
2022-06-14 16:52:32 467
原创 easypoi 大数据量的导出
@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 1824 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 1013 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 190
原创 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 608
原创 【无标题】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 1290
原创 java 实体与实体相互转换
import org.apache.commons.beanutils.BeanUtils; Test test= new Test (); BeanUtils.copyProperties(test,被转的实体);
2021-11-08 15:07:33 2333
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人