摘要: <s:iterator var="s" value="spList" status="sp"> <tr <s:if test="#sp.even">class="t2"</s:if> > <td><input type="checkbox" name="checkbox" id="checkbox" value="<s:property value=&qu 阅读全文
posted @ 2013-03-20 17:23 听温柔的曲 阅读(106) 评论(1) 推荐(0)
摘要: 在tomcat下搜索修改后正常,在weblogic集群下出现乱码的情况,加上encodeURI()即可。修改前:location.href="<%=basePath%>manager/user/us_showup.jcms?uname="+mz;修改后:location.href=encodeURI("<%=basePath%>manager/user/us_showup.jcms?uname="+mz); 阅读全文
posted @ 2012-12-04 17:08 听温柔的曲 阅读(143) 评论(0) 推荐(0)
摘要: 查询某一列中重复数据select username from xtgl_superusers group by username having count(username) >1更新符合条件的人在后面加‘del’update xtgl_superusers set username= CONCAT(username, 'del') where islock=1ORACLE 如何按逗号截取查询所得的表名SELECT substr(T1.COMMENTS ,0,instr(T1.COMMENTS ,',',-1,1)-1) as 列名 from USER_T 阅读全文
posted @ 2012-11-15 09:59 听温柔的曲 阅读(103) 评论(3) 推荐(0)
摘要: create or replace procedure ttttt is rs SYS_REFCURSOR; isRepart number; tempUserId number; V_username varchar2(1000); i number;begin i := 0; isRepart := 0; open rs for select s.userid from xtgl_superusers s where s.username like '%del%' and s.islock = 0; loop fetch rs into tempUserId; exit w 阅读全文
posted @ 2012-09-03 14:08 听温柔的曲 阅读(111) 评论(1) 推荐(0)