⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 default.jsp

📁 JSP+ORACLE网站开发实例(下).rar
💻 JSP
📖 第 1 页 / 共 2 页
字号:
<%@ include file="conn.jsp"%>
<% 
int r1,jobnum;
String sql="select count(id) as ccount from scott.company"; 
ResultSet rs=stmt.executeQuery(sql); 
rs.next();
r1=rs.getInt("ccount");

//r1=rs.recordcount
String sql2="select count(id) as ccount from scott.company where job is not null order by id desc"; 
ResultSet rs2=stmt.executeQuery(sql2); 
rs2.next();
jobnum=rs2.getInt("ccount");

//jobnum=rs.recordcount %> 

<html>
<title>天天人才—&gt;首页</title>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<meta http-equiv="Content-Language" content="zh-cn">
<link rel="stylesheet" href="inc/index.css" type="text/css">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">

</head>

<body topmargin="0" leftmargin="0">
<%@ include file="inc/top.htm"%>
<SCRIPT language=JavaScript src="inc/f-index.js"></SCRIPT>
<div align="center">
  <center>
  <table border="0" cellpadding="0" cellspacing="0" width="780" height="120">
    <tr bgcolor="#53BEB0"> 
      <td width="778" height="18" colspan="5" valign="top">   </td>
    </tr>
    <tr>
      <td height="46" valign="top" bgcolor="#53BEB0" rowspan="2" width="152"> 
        <div align="center"> <center> 
          <table border="0" cellpadding="0" cellspacing="0" width="140" height="142" background="images/loginbg.GIF">
            <tr>
              <td width="136" height="19" valign="top"> </td>
            </tr>
            <form name=login action=login.jsp method=post>
			<tr>
              <td width="136" height="47" valign="top">&nbsp;&nbsp;&nbsp;&nbsp; 用户名:<input type="text" name="uname" size="7" maxLength=20 style="font-family: 宋体; font-size: 9pt; background-color: #EBEBEB; color: #00006A"><br>                                                                                                     
                &nbsp;&nbsp;&nbsp;&nbsp; 密&nbsp; 码:<input type="password" name="pwd" maxLength=20 size="7" style="font-family: 宋体; font-size: 9pt; background-color: #EBEBEB; color: #00006A"></td>                                                                                                      
            </tr>
            <tr>
              <td width="136" height="14" valign="top">&nbsp;&nbsp;&nbsp; <input type="radio" value="person" checked name="usertype">个人                                                                                                      
                <input type="radio" name="usertype" value="company">单位</td>
            </tr>
          </center>
  </center>
            <tr>
              <td width="136" height="71" valign="top">
                <p align="center"><br>
                <input type="button" value="登 录" name="B1" style="position: relative; color: #00006A; font-family: 宋体; font-size: 9pt; height: 19" onClick="check()"><br>
                <br>
                <a href="addnew.jsp"><font color="#00006A">新用户注册</font></a></td>
            </tr>
          </table>
  <center>
          <center></form>
            </center>
        </div>
        <div align="center">
          <center>
          <form name=search action=search.jsp method=post target="_blank">
		  <table border="0" cellpadding="0" cellspacing="0" width="138" height="168" background="images/search-bg.GIF">
            <tr>
                      <td width="136" height="167">
                        <p align="center"><font color="#0000FF"><br>
                        </font><font color="#000055">=== 站内搜索 ===</font><font color="#000000"><br>                              
                        <br>
                        </font><SELECT 
                  size=1 name=stype style="background-color: #EBEBEB; color: #00006A; font-family: 宋体; font-size: 9pt">
                  <OPTION value="" selected>请选择搜索类别</option>
				  <option value="company">职位搜索</option>
                  <option value="person">人才搜索</option>
                </SELECT>
                        <p align="center"><SELECT size=1 name=gzdd style="color: #00006A; font-family: 宋体; font-size: 9pt; background-color: #EBEBEB"> 
              <OPTION selected>请选择所在地区</OPTION>
			  <OPTION value=noxz>不&nbsp; 限
			  <OPTION value=北京市>北京市
              <OPTION value=天津市>天津市
              <OPTION value=上海市>上海市
			  <OPTION value=重庆市>重庆市
              <OPTION value=安徽省>安徽省
              <OPTION value=福建省>福建省
              <OPTION value=甘肃省>甘肃省
              <OPTION value=广东省>广东省
			  <OPTION value=四川省>四川省
              <OPTION value=贵州省>贵州省
              <OPTION value=湖北省>湖北省
              <OPTION value=湖南省>湖南省
			  <OPTION value=吉林省>吉林省
              <OPTION value=江苏省>江苏省
              <OPTION value=江西省>江西省
              <OPTION value=辽宁省>辽宁省
              <OPTION value=青海省>青海省
			  <OPTION value=山东省>山东省
              <OPTION value=山西省>山西省
			  <OPTION value=陕西省>陕西省
              <OPTION value=云南省>云南省
			  <OPTION value=浙江省>浙江省
			  <OPTION value=黑龙江省>黑龙江省
			 </SELECT></p>
            <p align="center"><INPUT 
            maxLength=20 size=16 name=key style="color: #00006A; font-family: 宋体; font-size: 9pt; background-color: #EBEBEB" value="请输入关键字" onclick="Javascript:this.value='';"><br>
             <br>
             <input type="button" value="搜 索" style="font-family: 宋体; font-size: 9pt; color: #00006A; position: relative; height: 20" onclick="s_check()">
             <br>
             <br>
			</td>
            </tr>
          </table>
          </form>
          </center>
        </div>
        <FORM name=select action="" method=post>
        <p align="center"><SELECT class=p2 onchange=go(document.select.site) 
            size=1 name=site style="font-family: 宋体; font-size: 9pt; color: #00006A; background-color: #EBEEF3">
              <option>相关求职招聘站点</option>
              <option value="http://www.tiaocao.com">跳槽网</option>
              <option value="http://www.wannet.com.cn" >万佳网络</option>
              <option value="http://www.topjobway.com">浩竹猎头</option>
              <option value="http://www.jobcn.com">卓博人才网</option>
              <option value="http://ssrc.cool8.net">石狮人才网</option>
              <option value="http://www.sxonline.com.cn">山西人才网</option>
              <option value="http://www.nb360.com/DEFAULT.htm">南北人才网</option>
              <option value="http://www.hxyc.com/index.htm ">华夏英才网</option>
              <option value="http://www.dayujob.com/">大禹人才网</option>
              <option value="http://www.chinamanagers.com/">网上经理中心</option>
              <option value="http://career.tyfo.com">天虎人才网点</option>
              <option value="http://www.pconline.com.cn/pcjob">IT专业人才网</option>
              <option value="http://www.bjol.com">北京职业在线</option>
              <option value="http://www.fesco.com.cn">外企人才在线</option>
              <option value="http://www.cyol.net/ ">中青在线人才</option>
              <option value="http://www.100fun.net/">百分百人才网</option>
              <option value="http://careers.etang.com">亿唐职业直通车</option>
              <option value="http://www.zxjob.com/">南京智信人才网</option>
              <option value="http://www.cc-jobs.com/">赛博韦尔人才网</option>
              <option value="http://www.528.com.cn">中国招聘求职网</option>
              <option value="http://www.365hr.com.cn">晟辉人力资源网</option>
              <option value="http://www.jobproxy.com">大亚湾人才热线</option>
              <option value="http://www.xasrc.com/">西安市人才市场</option>
              <option value="http://www.96000.com/zhaopin">中日在线人才网</option>
              <option value="http://www.5156job.com">无忧无虑工作网</option>
              <option value="http://jobs.dayoo.com/ ">大洋网求职广场</option>
              <option value="http://www.zgc.com.cn/hr/">中关村人才热线</option>
              <option value="http://channel.163.net/live/job.shtml">163职业人生频道</option>
              <option value="http://jobs.263.net/">首都在线求职频道</option>
              <option value="http://job.eastchina.com/">华东视窗人才频道</option>
              <option value="http://www.rc114.com/">中国成都人才市场</option>
              <option value="http://www.sobao.com/Channel/Career/index.phtml">搜豹人才交流频道</option>
              <option value="http://www.ujob.com.cn/">珠三角联合人才网</option>
              <option value="http://www.swifthorse.com">千里马人才资讯网</option>
            </SELECT></p>
        <p align="center"><SELECT class=p2 onchange=go(document.select.link) 
            size=1 name=link style="font-family: 宋体; font-size: 9pt; color: #00006A; background-color: #EBEEF3"> <OPTION selected>====合作网站====</OPTION> 
          <option>诚征合作</option>
          <option>诚征合作</option>
 <OPTION>====友情链接====</OPTION> 
          <option value="http://www.epchina.net/">中国易聘网</option>
          <option value="http://career.tyfo.com">天虎人才网</option>
          <option value="http://www.job21st.com/">二十一世纪人才网</option>
 </SELECT></p>
              </form>
        <p align="center">&nbsp;</p>
        <p> 
      </center>
      </td>
      <td width="22" height="46" valign="top" rowspan="2"><img border="0" src="images/selfk.GIF"></td>
      <td width="446" height="18" valign="top">
      <table border="1" cellpadding="0" cellspacing="0" width="430" height="51" bordercolor="#FFFFFF" bordercolorlight="#FFFFFF" bordercolordark="#FFFFFF">
        <tr>
          <td width="176" height="1"></td>
          <td width="248" height="10" colspan="2"></td>
        </tr>
        <tr>
            <td width="424" height="20" colspan="3" valign="bottom" background="images/t-bg2.gif"><font color="#000000">&nbsp;<font color="#FFFFFF"> 
              最新五条招聘信息</font></font></td>
        </tr>
        <tr>
          <td width="174" height="18" bgcolor="#EBEEF3" valign="bottom">&nbsp;公司名称</td>
          <td width="177" height="18" bgcolor="#EBEEF3" valign="bottom">&nbsp;招聘职位</td>
          <td height="18" bgcolor="#EBEEF3" valign="bottom" width="72">
            <p align="center">发布日期</p>
          </td>
        </tr>
        <% String sql3="select * from scott.company where job is not null order by id desc"; 
rs=stmt.executeQuery(sql3); 
		int i=0;
		while(i<5 && rs.next()){ %>
        <tr>
  <td width="174" height="18" bgcolor="#EBEEF3" valign="bottom">&nbsp;<a href="javascript:openwin('company.jsp?uid=<%=rs.getString("uname")%>','top=10,left=80,width=460,height=420')"><%=rs.getString("cname")%></a></td>    
  <td width="172" height="18" bgcolor="#EBEEF3" valign="bottom">&nbsp;<a href="javascript:openwin('job.jsp?uid=<%=rs.getString("uname")%>','top=10,left=80,width=460,height=420')"><%=rs.getString("job")%></a></td>
  <td width="72" height="18" bgcolor="#EBEEF3" valign="bottom">
            <p align="center"><%=rs.getString("idate")%></p>
          </td>
        </tr>
     <% i++;//通过I循环设置最新五条招聘信息
				} %>  
          <tr background="images/t-bg3.gif"> 
            <td width="424" height="19" colspan="3" valign="bottom"> 
              <p align="right"><a href="javascript:openwin('search.jsp?stype=company&gzdd=noxz','top=10,left=80,width=480,height=350')"><font color="#000000">更多...</font></a>
            </td>
        </tr>
      </table>
  <center>
      <% int r2, jlnum;
sql="select count(id) as ccount from scott.person"; 
rs=stmt.executeQuery(sql);
rs.next();
r2=rs.getInt("ccount");

sql="select count(id) as ccount from scott.person where job is not null order by id desc"; 
rs=stmt.executeQuery(sql); 
rs.next();
jlnum=rs.getInt("ccount");
%>

      <div align="left">
      <table border="1" cellpadding="0" cellspacing="0" width="430" bordercolor="#FFFFFF" bordercolorlight="#FFFFFF" bordercolordark="#FFFFFF">
        <tr>
              <td height="20" colspan="5" valign="bottom" background="images/t-bg2.gif" width="426">&nbsp;<font color="#FFFFFF"> 
                最新五条求职信息</font></td>
        </tr>
  </center>
        <tr>
          <td width="67" height="18" bgcolor="#EBEEF3" valign="bottom">
            <p align="left">&nbsp;姓名</p>   
          </td>
          <td width="45" height="18" bgcolor="#EBEEF3" valign="bottom">
            <p align="center">性别</p>  
          </td>

⌨️ 快捷键说明

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