/** * 获取指定数据的分页数据sql语句 * @param sql * @return */ public PagineSql getDBPagineSql(String sql, long offset, int maxsize,boolean prepared,String orderBy) { // return new StringBuilder(sql).append(" limit ").append(offset).append(",").append(maxsize).toString(); StringBuilder newsql = null; if(prepared) newsql = new StringBuilder().append(sql).append(" ").append(orderBy).append(" limit ?,?"); else newsql = new StringBuilder().append(sql).append(" ").append(orderBy).append(" limit ").append(offset).append(",").append(maxsize); return new PagineSql(newsql.toString(),offset,(long)maxsize,offset, maxsize, prepared).setRebuilded(true); }
/** * 获取指定数据的分页数据sql语句 * @param sql * @return */ public PagineSql getDBPagineSql(String sql, long offset, int maxsize,boolean prepared,String orderBy) { // return new StringBuilder(sql).append(" limit ").append(offset).append(",").append(maxsize).toString(); StringBuilder newsql = null; if(prepared) newsql = new StringBuilder().append(sql).append(" ").append(orderBy).append(" limit ?,?"); else newsql = new StringBuilder().append(sql).append(" ").append(orderBy).append(" limit ").append(offset).append(",").append(maxsize); return new PagineSql(newsql.toString(),offset,(long)maxsize,offset, maxsize, prepared).setRebuilded(true); }
/** * 获取指定数据的分页数据sql语句 * @param sql * @return */ public PagineSql getDBPagineSql(String sql, long offset, int maxsize,boolean prepared,String orderBy) { // return new StringBuilder(sql).append(" limit ").append(offset).append(",").append(maxsize).toString(); StringBuilder newsql = null; if(prepared) newsql = new StringBuilder().append(sql).append(" ").append(orderBy).append(" limit ?,?"); else newsql = new StringBuilder().append(sql).append(" ").append(orderBy).append(" limit ").append(offset).append(",").append(maxsize); return new PagineSql(newsql.toString(),offset,(long)maxsize,offset, maxsize, prepared).setRebuilded(true); }
") tt1 where rownum <= ").append((offset + maxsize)).append(") ss1 where ss1.rowno_ >= ").append( (offset + 1)); return new PagineSql(ret.toString(),offset + maxsize,offset + 1,offset, maxsize, prepared).setRebuilded(true);
return new PagineSql(ret.toString(),offset + maxsize,offset + 1,offset, maxsize, prepared).setRebuilded(true);
return new PagineSql(ret.toString(),offset + maxsize,offset + 1,offset, maxsize, prepared).setRebuilded(true);
/** * 获取高效的oracle分页语句,sql中已经写好ROW_NUMBER() OVER ( ORDER BY cjrq ) rownum * 否则不能调用本方法生成oralce的分页语句 */ public PagineSql getOracleDBPagineSql(String sql, long offset, int maxsize, String rownum, boolean prepared) { StringBuilder ret = null; if (prepared) ret = new StringBuilder().append("select * from (") .append(sql) .append(") where ").append(rownum).append(" between ? and ?"); else ret = new StringBuilder("select * from (") .append(sql) .append(") where ").append(rownum).append(" between ") .append((offset + 1) + "") .append(" and ") .append((offset + maxsize) + ""); return new PagineSql(ret.toString(), offset + 1, offset + maxsize, offset, maxsize, prepared); }
/** * 获取高效的oracle分页语句,sql中已经写好ROW_NUMBER() OVER ( ORDER BY cjrq ) rownum * 否则不能调用本方法生成oralce的分页语句 */ public PagineSql getOracleDBPagineSql(String sql, long offset, int maxsize, String rownum,boolean prepared) { StringBuilder ret = null; if(prepared) ret = new StringBuilder().append("select * from (").append(sql).append(") where ").append(rownum).append( " between ? and ?"); else { ret = new StringBuilder().append("select * from (").append(sql).append(") where ").append(rownum).append( " between ").append(offset + 1).append(" and ").append(offset + maxsize); } return new PagineSql(ret.toString(),offset + 1,offset + maxsize,offset, maxsize, prepared); }
/** * 获取指定数据的分页数据sql语句 * @param sql * @return */ public PagineSql getDBPagineSql(String sql, long offset, int maxsize,boolean prepared) { // return new StringBuilder(sql).append(" limit ").append(offset).append(",").append(maxsize).toString(); StringBuilder newsql = null; if(prepared) newsql = new StringBuilder().append(sql).append(" limit ?,?"); else newsql = new StringBuilder().append(sql).append(" limit ").append(offset).append(",").append(maxsize); return new PagineSql(newsql.toString(),offset,(long)maxsize,offset, maxsize, prepared).setRebuilded(true); }
/** * 获取指定数据的分页数据sql语句 * @param sql * @return */ public PagineSql getDBPagineSql(String sql, long offset, int maxsize,boolean prepared) { // return new StringBuilder(sql).append(" limit ").append(offset).append(",").append(maxsize).toString(); StringBuilder newsql = null; if(prepared) newsql = new StringBuilder().append(sql).append(" limit ?,?"); else newsql = new StringBuilder().append(sql).append(" limit ").append(offset).append(",").append(maxsize); return new PagineSql(newsql.toString(),offset,(long)maxsize,offset, maxsize, prepared).setRebuilded(true); }
/** * 获取指定数据的分页数据sql语句 * @param sql * @return */ public PagineSql getDBPagineSql(String sql, long offset, int maxsize,boolean prepared) { // return new StringBuilder(sql).append(" limit ").append(offset).append(",").append(maxsize).toString(); StringBuilder newsql = null; if(prepared) newsql = new StringBuilder().append(sql).append(" limit ?,?"); else newsql = new StringBuilder().append(sql).append(" limit ").append(offset).append(",").append(maxsize); return new PagineSql(newsql.toString(),offset,(long)maxsize,offset, maxsize, prepared).setRebuilded(true); }
public PagineSql getDBPagineSql(String sql, long offset, int maxsize, boolean prepared, String orderby) { return new PagineSql(sql, -1L, -1L, offset, maxsize, prepared); }
public PagineSql paginesql(boolean prepared) { if (paginesql == null) { if (this.rownum == null) { if (isRobotquery()) paginesql = getDBPagineSql(prepared); else paginesql = new PagineSql(getSql(),prepared); } else { paginesql = getDBPagineSqlForOracle(prepared); } } return paginesql; }
public PreparedStatement preparePagineStatement(boolean showsql) throws SQLException { paginesql = new PagineSql(this.sql,true); if (this.rownum == null) { // if (this.isRobotQuery(prepareDBName)) paginesql = getDBPagineSql(true); if(log.isInfoEnabled() && showsql && paginesql != null) { log.info("Execute JDBC prepared pagine query statement:{}",paginesql.getSql()); } } else { paginesql = getDBPagineSqlForOracle(true); } return _prepareStatement(paginesql.getSql(),true); }
/** * 获取指定数据的分页数据sql语句 * * @param sql * @return */ public PagineSql getDBPagineSql(String sql, long offset, int maxsize, boolean prepared) { return new PagineSql(sql, -1L, -1L, offset, maxsize, prepared); }