1 分页sql语句
SELECT * FROM (SELECT ROWNUM AS myrow , a.* FROM (SELECT * FROM "+tab+" ORDER BY "+order+" DESC) a) where myrow BETWEEN ? and ?
2 获得一个maxvalue - minvalue 之间的一个随机整数
(int)Math.round(Math.random() * (MAX_VALUE - MIN_VLAUE)) + MIN_VLAUE;
1 分页sql语句
SELECT * FROM (SELECT ROWNUM AS myrow , a.* FROM (SELECT * FROM "+tab+" ORDER BY "+order+" DESC) a) where myrow BETWEEN ? and ?
2 获得一个maxvalue - minvalue 之间的一个随机整数
(int)Math.round(Math.random() * (MAX_VALUE - MIN_VLAUE)) + MIN_VLAUE;