First, Oracle: Stringsqlselect * from (selectt. *, rownumasnumfrom (select * fromuser1where11; SetEntryString, Objectsetm. entrySet (); Iteratorioset. iterator (); while (io. hasNext () {Map. entryString, Objectme (Map. en
First, 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
First, 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 () + "<= '" + me. getValue () + "'";
}
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 <=" + currentPage * pageSize + "";
Followed by 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 () + "<= '" + me. getValue () + "'";
}
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: the number of data records on the page. currentPage: the page number.