听温柔的曲

摘要： <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 阅读全文

摘要： 在tomcat下搜索修改后正常，在weblogic集群下出现乱码的情况，加上encodeURI()即可。修改前：location.href="<%=basePath%>manager/user/us_showup.jcms?uname="+mz;修改后：location.href=encodeURI("<%=basePath%>manager/user/us_showup.jcms?uname="+mz); 阅读全文

摘要： 查询某一列中重复数据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 阅读全文

摘要： 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 阅读全文