String sql="select test,to_char(date,'yyyy_mm_dd') as AAA,id,usetimes from userlist where test=" + "'" + strTest + "'" + " order by AAA"; 试试
String sql="select test,to_char(date,'yyyy_mm_dd') as AAA,id,usetimes from userlist where test=" + "'" + strTest + "'" + " order by AAA desc";String sql="select test,to_char(date,'yyyy_mm_dd') as AAA,id,usetimes from userlist where test=" + "'" + strTest + "'" + " order by AAA asc";试试,哈哈哈
是不是少了个空格?
String sql="select test,to_char(date,'yyyy_mm_dd'),id,usetimes from userlist where test=" + "'" + strTest + "'" + " order by date";
^^^
应该加个空格吧?
试试