摘要:
1、访问或添加request/session/application属性public String scope() throws Exception{ ActionContext ctx = ActionContext.getContext(); ctx.getApplication().put("app", "应用范围");//往ServletContext里放入app ctx.getSession().put("ses", "session范围");//往session里放入ses ctx.put(" 阅读全文
摘要:
//删除id重复的数据,适合id是手工主键delete person as a from person as a,( select *,min(id) from person group by id having count(1) > 1) as bwhere a.id = b.id//查找name重复的,并且除掉id最小的那个delete tb_person as a from tb_person as a,(select *,min(id) from tb_person group by name having count(1) > 1) as bwhere a.name = 阅读全文