oracle中的分页

最新推荐文章于 2025-09-09 20:40:49 发布

weixin_30485799

最新推荐文章于 2025-09-09 20:40:49 发布

阅读量58

点赞数

CC 4.0 BY-SA版权

文章标签：数据库

原文链接：http://www.cnblogs.com/flyrain/archive/2009/12/17/oracle2.html

            string strSql = "select * from table where 1=1 ";
            string sql_count = "select count(1) from table where 1=1 ";
            string sql_where = "";
            string sql_order = " order by col desc ";
            if (paras.Length > 0)
            {
                if (paras[0] != null && paras[0] != "")
                {
                    sql_where = " and col2 like '" + paras[0] + "%'";
                }
                if (paras[1] != null && paras[1] != "")
                {
                    sql_where += " and col3 > to_date('" + paras[1] + "','yyyy-mm-dd hh24:mi:ss') ";
                }
            }

            strSql = strSql + sql_where + sql_order;
            sql_count = sql_count + sql_where;
            int from = 0, to = 0;
            from = 1 + pageSize * (currentPage - 1);
            to = pageSize * currentPage;

string sqlSelect = string.Format("SELECT * FROM (SELECT ROWNUM RN, A.* from ({0}) A WHERE ROWNUM <= {1}) A WHERE RN >= {2}",
strSql, to, from);

转载于:https://www.cnblogs.com/flyrain/archive/2009/12/17/oracle2.html