2011年3月17日
摘要: 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(" 阅读全文
posted @ 2011-03-17 21:42 Ruthless 阅读(45238) 评论(1) 推荐(3) 编辑
摘要: //删除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 = 阅读全文
posted @ 2011-03-17 16:58 Ruthless 阅读(2669) 评论(1) 推荐(1) 编辑