select * from tablename where 1= 1 order by convert(需要的字段类型,字段名)
String sql=" SELECT * FROM JJKJ_ASMProcess WHERE 1 = 1 and CLJCRLSH='"+cljcrlsh+"' and JCCS='"+jccs+"' ORDER BY convert(int,CYSX)";
select * from tablename where 1= 1 order by convert(需要的字段类型,字段名)
String sql=" SELECT * FROM JJKJ_ASMProcess WHERE 1 = 1 and CLJCRLSH='"+cljcrlsh+"' and JCCS='"+jccs+"' ORDER BY convert(int,CYSX)";