首先是oracle： string sql = select * from ( select t.*,rownum as num from (select * from user1 where 1=1 ; setentrystring, object set = m.entryset(); iterator io = set.iterator(); while (io.hasnext()) { map.entrystring, object me = (map.en
首先是oracle：
string sql = select * from ( select t.*,rownum as num from (select * from user1  where 1=1 ;
set> set = m.entryset();
iterator io = set.iterator();
while (io.hasnext()) {
map.entry me = (map.entry) io.next();
if(username.equals(me.getkey()) && !.equals(me.getvalue())){
sql += and + me.getkey() + like '%+ me.getvalue()  +%' ;
}
if(starttime.equals(me.getkey()) && !.equals(me.getvalue())){
sql += and + me.getkey() + >= ' + me.getvalue() +';
}
if(endtime.equals(me.getkey()) && !.equals(me.getvalue())){
sql += and + me.getkey() + }
if(sort.equals(me.getkey()) && !.equals(me.getvalue())){
sql += order by + me.getvalue() ;
}
if(order.equals(me.getkey()) && !.equals(me.getvalue())){
sql += + me.getvalue();
}
}
sql += )t) ;
sql = sql + where num >= + (currentpage-1)*pagesize + and  num
接着是mysql：
string sql = select * from user  where 1=1 ;
set> set = m.entryset();
iterator io = set.iterator();
while (io.hasnext()) {
map.entry me = (map.entry) io.next();
if(username.equals(me.getkey()) && !.equals(me.getvalue())){
sql += and + me.getkey() + like '%+ me.getvalue()  +%' ;
}
if(starttime.equals(me.getkey()) && !.equals(me.getvalue())){
sql += and + me.getkey() + >= ' + me.getvalue() +';
}
if(endtime.equals(me.getkey()) && !.equals(me.getvalue())){
sql += and + me.getkey() + }
if(sort.equals(me.getkey()) && !.equals(me.getvalue())){
sql += order by + me.getvalue() ;
}
if(order.equals(me.getkey()) && !.equals(me.getvalue())){
sql += + me.getvalue();
}
}
sql = sql + limit + (currentpage-1)*pagesize + ,  + pagesize ;
pagesize 该页有多少条数据，currentpage该页码