摘要:
public class JudgeChinese { public static void main(String[] args) { String s = "中文1"; String regex = "[\u4E00-\u9FA5]+"; if (s.matches(regex)) { System.out.pr... 阅读全文
摘要:
select '全部' AS `organ_category`, COUNT(*) AS amount FROM `organ_new` WHERE `city_code` ='SZ0755' AND `organ_type` ='P' AND `state` ='1' union all select `organ_category` ,COUNT(1) AS `amount` ... 阅读全文
摘要:
select * FROM organ_new where city_code = 'SZ0755' and organ_type = 'H' and state = '1' ORDER BY FIELD(organ_category,'三级','二级','一级') ,#自定义排序 CONVERT(organ_... 阅读全文