首页 > 学术百科

Oracle分页查询sql语句

SELECT *

FROM (SELECT A.*, ROWNUM RN

寄生嗜育FROM (SELECT * FROM TABLE_NAME) A

WHERE ROWNUM <= 40)

WHERE RN > 20

其中的SELECT * FROM TABLE_NAME 表⽰没有进⾏分页时的sql查询语句，⽽ROWNUM 和RN 限定了查询数据的范围。

2.使⽤时的代码如下所⽰：

/** 查询码号相关信息的sql语句 **/

String sql_query = "SELECT * FROM (SELECT a.*, ROWNUM rn FROM (dename, case when (c.isopen = 0) then'不可⽤'"

+ "when (c.isopen = 1) then ((case when (c.codestatus = 0) then'空闲'"

+ "when (c.codestatus = 1) then'预占'when (c.codestatus = 2) then'占⽤'"

+ "when (c.enddate > sysdate) then'保留期'end)) end as status,t.name,( select p."

+ " party_name from CRM.PARTY p"

挠脚心论坛+ "where p.party_id=c.custid) as partyname, c.deviceid,(select l.name FROM"

+ " lgc_codetoclass_tbl l)as codeFeature,(SELECT g.name FROM LGC_CODEGRADE_TBL g"

+ "WHERE g.adeid) as gradename,(select g.value"

+ "from LGC_CODEGRADE_TBL g where g.id = c.gradeid) as codePrice, cments"

+ "FROM LGC_CODESEG_TBL t, LGC_CODENUMBER_TBL c WHERE t.ID = c.CODESEGID dename=?"

+ " ) a WHERE ROWNUM <= ?) WHERE rn > ?";

/** ⽤来查询码号查询页⾯数据的⽅法的实现 **/

public NumberRsp queryRecords(NumberEvt evt,int pageNo,int pageSize) {

Map<String, Object> map = jdbcTemplate.queryForMap(sql_count);

List<NumberVo> list = jdbcTemplate.query(sql_query, new Object[] { Code(),pageNo*pageSize,(pageNo-1)*pageSize}, new RowMapper<Numb public NumberVo mapRow(ResultSet rs, int rowNum) throws SQLException {

中国产品质量法// TODO Auto-generated method stub

NumberVo numberVo = new NumberVo();

numberVo.String(1));

numberVo.String(2));

numberVo.String(3));

numberVo.String(4));

numberVo.String(5));

numberVo.String(6));

numberVo.String(7));

numberVo.Short(8));

numberVo.String(9));

return numberVo;

}

});

NumberRsp numberRsp = new NumberRsp();

if (("total") != null) {

numberRsp.setTotal(Integer.("total").toString()));

特别的爱电影}

if (("ky") != null) {

numberRsp.setUsableNum(Integer.("ky").toString()));

}

if (("bky") != null) {

numberRsp.setUnUsableNum(Integer.("bky").toString()));

}

if (("youhao") != null) {

中国古典园林史numberRsp.setYouhaoNum(Integer.("youhao").toString()));移动彩信平台

}

if (("puhao") != null) {

numberRsp.setPuhaoNum(Integer.("puhao").toString()));

}

if (list != null) {

numberRsp.setRecords(list);

}

return numberRsp;

}

本文发布于:2024-09-20 20:38:55，感谢您对本站的认可！

本文链接：https://www.17tex.com/xueshu/648685.html

上一篇：ECharts从后端调用数据后,给ECharts重新渲染数据

下一篇：SpringSecurityOAuth2.0自定义token生成方式

标签：查询中国语句

留言与评论（共有 0 条评论）