这条语句高效在那里？如何用它来构造查询分页语句。

Question

高效個屁!
還是下面的高效!

Answer 1

   private String Iff(String LEFT,String RIGHT,String STRWHERE)
        {
            String DL = "";
            String SQLWHERE = "";
            if (LEFT.CompareTo(RIGHT)>=0)
            {
                DL = RIGHT;
                RIGHT = LEFT;
                LEFT = DL;
            }
            if (!LEFT.Equals(""))
            {
                SQLWHERE = SQLWHERE + "  AND  " + STRWHERE + ">='" + LEFT + "'";
            }
            if (!RIGHT.Equals(""))
            {
                SQLWHERE = SQLWHERE + "  AND  " + STRWHERE + "<='" + RIGHT + "'";
            }
            return SQLWHERE;
                      
        }