📄 visitor_checkresult.jsp

📁 多功能学生宿舍管理系统分布式体系结构
💻 JSP
📖 第 1 页 / 共 2 页
字号:
12 下一页
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@page import="myweb.bean.Visitor,myweb.DBContent.DBContent" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml"><!-- InstanceBegin template="/Templates/st_template.dwt.jsp" codeOutsideHTMLIsLocked="false" -->
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<%
response.setHeader("Cache-Control","no-store"); 
response.setHeader("Pragrma","no-cache"); 
response.setDateHeader("Expires",0); 
//session.invalidate();
%>
<!-- InstanceBeginEditable name="doctitle" -->
<title>高校公寓综合管理平台</title>
<!-- InstanceEndEditable -->
<!-- InstanceBeginEditable name="head" -->
<style type="text/css">
<!--
.STYLE4 {color: #660000}
.STYLE7 {font-size: 12px}
.STYLE8 {color: #333333}
-->
</style>
<link href="css.css" rel="stylesheet" type="text/css" />
<style type="text/css">
<!--
.STYLE5 {	color: #333333;
	font-weight: bold;
	font-family: "新宋体";
	font-size: 20px;
}
.STYLE9 {font-family: "新宋体"; color: #333333;}
a:link {
	color: #000000;
	text-decoration: none;
}
a:visited {
	text-decoration: none;
	color: #000000;
}
a:hover {
	text-decoration: underline;
}
a:active {
	text-decoration: none;
	color: #CCCC33;
}
-->
</style>
<link href="../admin/css.css" rel="stylesheet" type="text/css" />
<!-- InstanceEndEditable -->
<style type="text/css">
<!--
body {
	margin-top: 0px;
	margin-bottom: 0px;
}
#Layer3 {	position:absolute;
	left:798px;
	top:109px;
	width:222px;
	height:15px;
	z-index:2;
}
.STYLE2 {
	font-size: 14px;
	color: #000066;
}
-->
</style></head>
<%@ page import="java.util.Date,java.util.*,java.text.*"%>
<%@page import="myweb.DBContent.DBContent" %>
<body>
<%
if(session.getAttribute("user")==null)
{
 out.print("<script>alert('请先登录！');window.open('../index.jsp','_self')</script>");	 
 }
%>
<jsp:useBean id="db" class="myweb.DBContent.DBContent"></jsp:useBean>
<%
	String dd;
	Date nowdate=new Date();
	int hour=nowdate.getHours();
	if(hour>8&&hour<12)
	{
	dd="上午好,欢迎登陆高校公寓综合管理平台!";
	}
	else
	{
	dd="下午好,欢迎登陆高校公寓综合管理平台!";
	}
	%>
	 <%
String ddate=new SimpleDateFormat("yyyy-MM-dd").format(Calendar.getInstance().getTime());
%>
<table width="1024" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td colspan="2" align="center" background="../Templates/image/index_01.jpg"><!-- InstanceBeginEditable name="EditRegion6" -->
      <object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=7,0,19,0" width="776" height="120">
        <param name="movie" value="image/xuanjuan1.swf" />
        <param name="quality" value="high" />
        <param name="wmode" value="transparent" />
        <embed src="image/xuanjuan1.swf" width="776" height="120" quality="high" pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash" wmode="transparent"></embed>
      </object>
    <!-- InstanceEndEditable -->
      <div class="STYLE2" id="Layer3">今天是：
        <%out.println(ddate);%>
    </div></td>
  </tr>
  <tr>
    <td colspan="2"><img src="../Templates/image/index_02.jpg" width="227" height="47" /><img src="../Templates/image/lijianxue11_03.jpg" width="797" height="47" /></td>
  </tr>
  <tr>
    <td width="227" align="left" valign="middle"><span class="STYLE2">
      <marquee scrollAmount=2 onmouseover=stop() onmouseout=start() >
      <%=dd%>
      </marquee>
    </span> </td>
    <td width="797"><!-- InstanceBeginEditable name="EditRegion7" -->
      <table width="100%" border="0" cellpadding="0" cellspacing="0">
        <tr>
          <td><img src="../Templates/image/index_056.jpg" width="797" height="25" /></td>
        </tr>
      </table>
    <!-- InstanceEndEditable --></td>
  </tr>
  <tr>
    <td width="227" height="49" background="../Templates/image/index_04.gif">&nbsp;</td>
    <td height="35" rowspan="3" align="center" valign="top"><!-- InstanceBeginEditable name="EditRegion5" -->
      <table width="100%" border="0" cellpadding="0" cellspacing="0">
        <tr valign="bottom">
          <td>&nbsp;</td>
        </tr>
        <tr valign="top">
          <td>
	  
		  <table width="100%" border="0" cellpadding="0" cellspacing="0">
            <tr>
              <td align="center"><strong><font size="5">查 询 结 果</font></strong></td>
            </tr>
            <tr valign="top">
              <td>
<jsp:useBean id="v" class="myweb.bean.Visitor" scope="session">
  </jsp:useBean>
  <jsp:setProperty name="v" property="*" />
  <%
  	String su=request.getParameter("sub")!=null?request.getParameter("sub"):"";
	//out.println(v.getVisittime());
	int rowcount=0;
	int introw;
	int row;
	String strrow=request.getParameter("row");
	if(strrow==null)
	{
		introw=1;
	}
	else
	{
		introw=Integer.parseInt(strrow);
		if(introw<1)
			introw=1;
	}
	String sql="select * from visitor where visittime='"+v.getVisittime()+"'";
	ResultSet rs=db.select(sql);
	if(rs.next()){
	rs.last();
	rowcount=rs.getRow();
	if(introw>rowcount)
		introw=rowcount;
	if(rowcount>0)
	{
		rs.absolute(introw);
	}
	
%>   
			  
			  <table width="70%" border="1" align="center" bgcolor="#D7E8F2">

                <tr>
                  <td align="center"><span class="STYLE8">楼号</span></td>
                  <td width="32%" align="left"><input name="buildingid" type="text" class="titlebar" id="buildingid" size="20" maxlength="2"  value="<%=rs.getString("buildingid") %>"/></td>
                  <td width="18%" align="center"><span class="STYLE8">房号</span></td>
                  <td width="33%" align="left"><input name="houseid2" type="text" class="titlebar" id="houseid" size="20" maxlength="4" / value="<%=rs.getString("houseid") %>"></td>
                </tr>
                <tr>
                  <td align="center"><span class="STYLE8">被访人姓名</span></td>
                  <td align="left"><input name="visitedn" type="text" class="titlebar" id="visitedn" size="20" maxlength="10" value="<%=rs.getString("visitedn") %>" /></td>
                  <td align="center"><span class="STYLE8">来访人姓名</span></td>
                  <td align="left"><input name="visitorn" type="text" class="titlebar" id="visitorn" size="20" maxlength="10" value="<%=rs.getString("visitorn") %>" /></td>
                </tr>
                <tr>
                  <td width="17%" align="center"><span class="STYLE8">所属关系</span></td>
                  <td align="left"><input name="relation" type="text" class="titlebar" id="relation" size="20" value="<%=rs.getString("relation") %>" />
                    </td>
                  <td align="center"><span class="STYLE8">来访时间</span></td>
                  <td align="left"><input name="visittime2" type="text" class="titlebar" id="visittime" size="20" maxlength="20" value="<%=rs.getString("visittime") %>" /></td>
                </tr>
                <tr>
                  <td align="center"><span class="STYLE8">证件号码</span></td>
                  <td align="left"><input name="zjhm" type="text" class="titlebar" id="zjhm" size="20" maxlength="20" value="<%=rs.getString("zjhm") %>" /></td>
                  <td align="center"><span class="STYLE8">证件名称</span></td>
                  <td align="left"><span class="STYLE4">
                    <input name="zjmc" type="text" class="titlebar" id="zjmc" size="20" maxlength="20"  value="<%=rs.getString("zjmc")%>"/>
12 下一页
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -