如歌的编程杂学

最新推荐文章于 2022-12-20 09:26:01 发布

嘿丷如歌

最新推荐文章于 2022-12-20 09:26:01 发布

阅读量273

点赞数 1

分类专栏：学习

本文链接：https://blog.csdn.net/qq_35776392/article/details/65439009

版权

学习专栏收录该内容

34 篇文章 0 订阅

订阅专栏

request.getParameter() 和request.getAttribute()

request.getParameterValues与request.getParameter

如歌回家后会进行代码测试 20170323 打卡

kill session

select session_id from v$locked_object;
SELECT sid, serial#, username, osuser FROM v$session where sid = 198;
ALTER SYSTEM KILL SESSION '198,376';

jsp查询条件清空及对于查询条件位数的限制

var str=document.getElementById('gfrsfzh').value;
           if(str.length<18){
               alert('身份证号码小于十八位,请重新输入');
               document.getElementById('gfrsfzh').value="";

如图所示添加超链接并且带参数传值

 <td style="width:170px"><a οnclick="window.open('<%=request.getContextPath() %>/jsp/kstd/ysCxXmlpKXmxxLdxx.jsp?xmmc=<%=vo.getXmmc() %>&xmsid=<%=vo.getSid()%>')"><%=XMSid %></a></td>

 <td ><a οnclick="window.open('<%=request.getContextPath() %>/jsp/kstd/ysCxXmlpKXmxxCk.jsp?xmmc=<%=vo.getXmmc() %>&kfdw=<%=vo.getKfSid()%>&xmzl=<%=vo.getXmzl() %>&ds=<%=vo.getDs() %>&kpsj=<%=vo.getKpsj() %>')">查看</a></td>

文件的下载

<table id="tabList01" pagecontrol="page01" class="ume-tablist" queryfilter="FBSJ" queryorder="desc">
						<tr class="ume-tablist-title" align="center">
							<th type="single"></th>
							<TH fieldname="SID" enableorder="1" style="display:none;">主键</TH>
							<TH fieldname="BT" enableorder="1" style="width:400px;" maxlength="20">主题</TH>
							<TH fieldname="WJM" enableorder="1" style="width:400px;" maxlength="64">文件名</TH>
							<TH fieldname="FBSJ" enableorder="1" style="width:200px;">发布时间</TH>
							<th type="link" value="编辑" action="doEdit(event);" style="width:80px;">编辑</th>
							<th type="link" value="删除" action="doDelete(event);" style="width:80px;">删除</th> 
							<th type="link" value="下载" action="doDownload(event);" style="width:80px;">下载</th> 
						</tr>
					</table>

function doDownload(event){
	event = Event.extend(event || window.event || arguments.callee.caller.arguments[0]);
	var row = event.element();
	while(row && row.tagName.toLowerCase() != 'tr')
		row = row.parentElement;
	if(row)
	{
	var sid = row.getAttribute('SID');
	downloadAttachment(sid);
	}
}

function downloadAttachment(sid)
{
	if(!sid)
	{
		alert("未指定附件！");
		return;
	}
	var str = strAction+"?method=download&sid="+sid;
		if(window.opener)
		{
			if(!!window.parent.top.frames.length && window.parent.top.frames.length==3)
				window.opener.top.frames[0].document.getElementById("download").src = str;
			else
				document.getElementById("download").src = str;
		}
		else if(window.parent)
		{
			
			if(!!window.parent.top.frames.length && window.parent.top.frames.length==3){
				document.getElementById("download").src = str;
			}else{
				document.getElementById("download").src = str;
			}
		}
		else
		{
			top.frames[0].document.getElementById("download").src = str;
		}
}

var strAction="<%=request.getContextPath()%>/YsZwXzbgAction.do";

public ActionForward download(ActionMapping mapping, ActionForm form,
			  HttpServletRequest request, HttpServletResponse response)
			throws Exception
			{
			
			User user = (User) request.getSession().getAttribute(
			com.ume.framework.Globals.USER_KEY);
			String sid = request.getParameter("sid");
			if (Pub.empty(sid))
			return mapping.findForward("error");
			Connection conn = DBUtil.getConnection();
			OutputStream os = null;
			try
			{
			conn.setAutoCommit(false);
			YsZwXzbgVO vo = new YsZwXzbgVO();
			vo.setSid(sid);
			vo = (YsZwXzbgVO) DAOFactory.getInstance().createDAO(conn).getVOByPrimaryKey(vo);
			conn.commit();
			response.setContentType("application/octet-stream");
			response.setHeader("Content-type", "application/octet-stream");
			response.setHeader("Accept-Ranges", "bytes");
			response.setHeader("Content-Disposition", "attachment; filename="
					   + new String(vo.getWjm().replaceAll(" ", "_").getBytes(), "ISO8859_1"));
			os = response.getOutputStream();
			
			if(vo.getUrl()!=null){
				os.write(vo.getUrl());
			}
			os.flush();
			os.close();
			os = null;
			}
			catch (Exception e)
			{
			conn.rollback();
			e.printStackTrace(System.out);
			Pub.writeXmlErrorMessage(response, this.handleError(e));
			}
			finally
			{
			if (conn != null)
			conn.close();
			if (os != null)
			os.close();
			}
			return null;
			}

jsp当值为空给别名

     						  <td><%if(vo.getLdmc()==null) out.println("无"); else out.println(vo.getLdmc()); %></td>

     						 <td><%if(vo.getZzmj()==0) out.println("无"); else out.println(vo.getZzmj()); %></td>

字典多选

                     <INPUT type="text" class="ume-edit" id="WGLX" label="L5" name="WGLX" type="text" kind="dic" hasCode="false" src="T#WGLX:ID:DIC_VALUE:PARENT_ID=9527" multi="true" fieldname="WGLX" maxlength="3" must="true" style="width:185px"/>