past__time的博客

java数组按照指定顺序排序public static void main(String[] args) { int [] s = {2,3,5,4,1}; for (int i = 0; i < s.length; i++) { if (s[i] == 1) { int n = s[i];//先new一个n来放

sql server,mysql与oracle常见数据库的分页查询//sql server的分页查询废话不多说，直接上代码语法：select *,row_number () OVER(ORDER BY '字段') as '新列名' from tableSELECT *FROM ( SELECT *, row_number () OVER

//直接上sqlSELECT DISTINCT up.usersid, rs.NewName, el.LevelName, u.Account, ui.Name, ui.IconFROM UsersPower upLEFT JOIN RoleSet rs ON rs.Num = up.RoleIdLEFT JOIN Department

mysql的：UPDATE ops_menu AS per JOIN ops_menu AS next ON (per.menu_id = 1 AND next.menu_id = 11) OR (per.menu_id =11 AND next.menu_id = 1) SET per.order_num = next.order_num, next.order_num = per.o...