default.jsp

JSP+ORACLE网站开发实例（下）.rar

          <td width="59" height="18" bgcolor="#EBEEF3" valign="bottom">
            <p align="center">学 历   
          </td>
          <td width="177" height="18" bgcolor="#EBEEF3" valign="bottom">
            <p align="left">&nbsp;应聘职位</td>
  <center>
          <td width="71" height="18" bgcolor="#EBEEF3" valign="bottom">
            <p align="center">登录日期</p>
  </td>
        </tr>
		        <% 
sql="select * from scott.person where job is not null order by id desc"; 
rs=stmt.executeQuery(sql); 
		i=0;
		while(i<5 && rs.next()){ %>
     </center>
        <tr>
          <td width="67" height="18" bgcolor="#EBEEF3" valign="bottom">
            <p align="left">
		   &nbsp;<a href="javascript:openwin('person.jsp?uid=<%=rs.getString("uname")%>','top=10,left=80,width=460,height=420')"><%=rs.getString("iname")%></a></p>
          </td>
          <td width="45" height="18" bgcolor="#EBEEF3" valign="bottom">
            <p align="center">[<%=rs.getString("sex")%>]</p>
          </td>
  <center>
          <td width="59" height="18" bgcolor="#EBEEF3" valign="bottom">
            <p align="center">[<%=rs.getString("edu")%>]</td>
          <td width="176" height="18" bgcolor="#EBEEF3" valign="bottom">&nbsp;<%=rs.getString("job")%></td>
          <td width="71" height="18" bgcolor="#EBEEF3" valign="bottom">
            <p align="center"><%=rs.getString("idate")%></p>
          </td>
        </tr>
			    <%i++;//通过I循环设置每页的最新五条求职信息
                         }
				sql="select count(id) as ccount from scott.pmailbox"; 
rs=stmt.executeQuery(sql);
rs.next();
int pmailnum;
pmailnum=rs.getInt("ccount");


 sql="select count(id) as ccount from scott.cmailbox"; 
rs=stmt.executeQuery(sql);
rs.next();
int cmailnum;
cmailnum=rs.getInt("ccount");
%>
 </center>
        <tr>
          <td width="426" height="19" colspan="5" background="images/t-bg3.gif" valign="bottom">
            <p align="right"><a href="javascript:openwin('search.jsp?stype=person&gzdd=noxz','top=10,left=80,width=480,height=350')" ><font color="#000000">更多...</font></a></td>
        </tr>
      </table>
      </div>
      </td>
      <td width="1" height="46" valign="top" rowspan="2" bgcolor="#00006A"></td>
      <td width="150" valign="top" rowspan="2" bgcolor="#F3F3F3" height="46">
        　
        <div align="center">
          <table border="0" cellpadding="0" cellspacing="0" width="118" height="260">
            <tr>
              <td height="14" width="117" valign="top">
                <p align="center">=== 站内统计 ===</td>                         
            </tr>
            <tr>
              <td height="3" width="117" valign="top">
              </td>
            </tr>
            <tr>
      <td height="1" valign="top" bgcolor="#000000">
      </td>
            </tr>
            <tr>
              <td height="11" width="117" valign="top">
              </td>
            </tr>
            <tr>
              <td height="54" width="117" valign="top">
                &nbsp;招聘信息:<font color="#0000AA"><%=jobnum%></font>条<br>
                &nbsp;求职简历:<font color="#0000AA"><%=jlnum%></font>份<br>
                &nbsp;注册用户:<font color="#0000AA"><%=r1+r2%></font>位<br>
                &nbsp;站内信件:<font color="#0000AA"><%=pmailnum+cmailnum%></font>封</td>
            </tr>
            <tr>
      <td height="9" valign="top">
      </td>
            </tr>
            <tr>
      <td height="1" valign="top" bgcolor="#000000">
      </td>
            </tr>
            <tr>
      <td height="27" valign="top">
      </td>
            </tr>
            <tr>
      <td height="5" valign="top">
      <p align="center">=== 栏目公告 ===           
      </td>
            </tr>
            <tr>
      <td height="7" valign="top">
      </td>
            </tr>
            <tr>
      <td height="1" valign="top" bgcolor="#000000">
      </td>
            </tr>
            <tr>
      <td height="5" valign="top">
      </td>
            </tr>
            <tr>
      <td height="118" valign="top">
      to inat:<br> 
      &nbsp;&nbsp;&nbsp; 人才市场包括个人登录和单位登录！<br>
      主要功能包括站内信箱（个人用户和单位用户互发站内信件）和我的收藏夹功能！管理部分包括新闻管理和用户管理，以及群发站内信件等...      
      </td>
            </tr>
            <tr>
      <td height="7" valign="top">
      </td>
            </tr>
            <tr>
      <td height="1" valign="top" bgcolor="#000000">
      </td>
            </tr>
          </table>
        </div>
        <div align="center">
          <center>
		  <table border="0" cellpadding="0" cellspacing="0" width="118" height="230">
            <tr>
              <td width="125" height="27" valign="top"></td>
            </tr>
            <tr>
              <td width="125" height="18">
                <p align="center">=== 栏目调查 ===</td>                      
            </tr>
            <tr>
              <td width="125" height="7" valign="top">
                <p align="center"></td>
            </tr>
            <tr>
      <td height="1" valign="top" bgcolor="#000000">
      </td>
            </tr>
            <tr>
              <td width="125" height="6" valign="top"></td>
            </tr>
            <tr>
              <td width="125" height="31" valign="top">&nbsp;&nbsp;               
                您认为本栏目哪些方面急需改进?</td>
            </tr>
            <form name=research action="research.jsp" method=post target="_blank" onsubmit="return research_onsubmit()">
            <tr>
                  <td width="125" height="69" valign="top">A.个性化设计<br>
                    B.增加招聘信息<br>
                    C.丰富栏目内容<br>
                    D.改进页面设计<br>
              </td>
            </tr>
            <tr>
      <td height="1" valign="top" bgcolor="#000000">
      </td>
            </tr>
            <tr>
              <td width="125" height="14" valign="top"></td>
            </tr>
            <tr>
              <td width="125" height="25" valign="top">
                    <p align="center"> 
                  </td>
            </tr> 
           </form>
          </table>
          </center>
        </div>
      </td>
    </tr>
    <tr>
      
	 <% 
	  sql="select * from scott.jobnews order by id desc"; 
rs=stmt.executeQuery(sql);
	%>
	  <td width="446" height="28" valign="top">
      <div align="left">
        <table border="1" cellpadding="0" cellspacing="0" width="430" bordercolor="#000000" bordercolorlight="#000000" bordercolordark="#FFFFFF" height="24">
          <tr>
              <td height="18" background="images/t-bg2.gif" valign="bottom" width="426">&nbsp;新闻资讯|NEWS</td>
          </tr>
          <tr>
            
			<td bgcolor="#F0F0F0" valign="bottom">
            <% i=0;
		while(i<13 && rs.next()){ %>
            &nbsp;==&gt;&nbsp;<a href="javascript:openwin('viewnews.jsp?id=<%=rs.getString("id")%>','top=20,left=360,width=410,height=350')"><%=rs.getString("title")%></a><I> [<%=rs.getString("idate")%>]</I>&nbsp;点击<font color="#000091"><%=rs.getString("click")%></font>次<br>    
            <% 	i++;//通过I循环设置每页的页数
				} %> 
		</td>
		</tr>
          <tr>
              <td height="17" width="424" valign="bottom" background="images/t-bg3.gif"> 
                <p align="right"><a href="javascript:openwin('jobnews.jsp','top=10,left=80,width=500,height=320')"><font color="#000000">更多...</font></a> 
              </td>
          </tr>
        </table>
        </div>
      </td>
    </tr>
    <tr bgcolor="#53BEB0"> 
      <td width="778" height="1" colspan="5" valign="top"> 
        <p align="center"> 
      </td>
    </tr>
    <tr>
      <td height="4" valign="top" colspan="5" width="778">
      <p align="center">
      </td>
    </tr>
    <tr>
      <td height="14" valign="top" colspan="5" width="778">
      <p align="center"><script language="javascript" src="inc/copyright.js"></script>
      </td>
    </tr>
    <tr>
      <td height="3" valign="top" colspan="5" width="778">
      </td>
    </tr>
  </table>
</div>

</body>

</html>