String类型转Int类型的用法: Integer.parseInt(Val)

int newVal = Integer.parseInt(oldVal)+Integer.parseInt(value);

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
我的presto版本不支持用offset,还有别的办法吗,比如这段代码: private static QueryAndValues generateQuery(Map<String, String> parameters) { Timer time = new Timer(); StringBuilder query = new StringBuilder("SELECT * FROM " // "( SELECT temp.*, ROW_NUMBER() OVER (ORDER BY cta_onb) AS rownum FROM ( SELECT * FROM " ).append(TABLES); List<Object> paramValues = new ArrayList<>(); boolean firstCondition = true; for (String key : parameters.keySet()) { // let's assume the keys that end with "_double" should be treated as double boolean isDouble = key.endsWith("_double"); if (!"page".equals(key) && !"size".equals(key)) { String value = parameters.get(key); if (value == null || value.isEmpty()) { query.append(firstCondition ? " WHERE " : " AND ").append(key).append(" IS NULL "); firstCondition = false; } else { if (value.contains(",")) { String[] values = value.split(","); query.append(firstCondition ? " WHERE " : " AND ").append(key).append(" IN ("); for (String val : values) { query.append("?,"); paramValues.add(isDouble ? Double.parseDouble(val) : val); } query.setLength(query.length() - 1); query.append(") "); firstCondition = false; } else { query.append(firstCondition ? " WHERE " : " AND ").append(key).append(" = ? "); paramValues.add(isDouble ? Double.parseDouble(value) : value); firstCondition = false; } } } } System.out.println("QueryAndValues 消费时间:"+ time.getElapsedTims()); int size = Integer.parseInt(parameters.get("size")); int page = Integer.parseInt(parameters.get("page")); query.append(" limit 500"); // query.append(") AS temp ) AS temp2 WHERE rownum BETWEEN ? AND ?"); // paramValues.add((page - 1) * size + 1); // Start index // paramValues.add(page * size); // End index return new QueryAndValues(query.toString(), paramValues); },用hibrenate做分页可以实现吗,如果可以,代码应该怎么修改,请附上完整代码
06-13
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值