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

📄 company.jsp

📁 JSP+ORACLE网站开发实例(下).rar
💻 JSP
字号:
<%@ include file="conn.jsp"%>
<%  request.setCharacterEncoding("GB2312");
String uid =request.getParameter("uid");

String sqlname;
    sqlname="select * from scott.company where uname= '"+uid+"' and job is not null order by id desc" ;
	 ResultSet rs=stmt.executeQuery(sqlname); 
if(!rs.next()){
   out.print("<SCRIPT language=JavaScript>alert('对不起,该用户不存在或已被删除!');");
   out.print("javascript:window.close();</SCRIPT>"); 
}else{ %>

<html>

<head>
<meta http-equiv="Content-Language" content="zh-cn">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<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">
<title>天天人才—&gt;<%=rs.getString("cname")%></title>
</head>
<div align="center">
  <center>
  <table border="2" cellpadding="0" cellspacing="0" width="390" height="18" bordercolor="#FFFFFF" bordercolorlight="#FFFFFF" bordercolordark="#FFFFFF">
    <tr>
      <td width="388" height="19" bgcolor="#C6CEDE" bordercolor="#000000" bordercolorlight="#000000" bordercolordark="#FFFFFF" valign="bottom">
        <p align="center">=== 公司详细资料 ===</td>                 
    </tr>
    <tr>
      <td width="388" height="19" valign="bottom">&nbsp;公司名称:<a href="job.jsp?uid=<%=rs.getString("uname")%>"><%=rs.getString("cname")%></a></td>
    </tr>
    <tr>
      <td width="388" height="19" bgcolor="#F3F3F3" valign="bottom">&nbsp;所属行业:<%=rs.getString("trade")%></td>
    </tr>
    <tr>
      <td width="388" height="19" valign="bottom">&nbsp;企业性质:<%=rs.getString("cxz")%></td>
    </tr>
    <tr>
      <td width="388" height="19" bgcolor="#F3F3F3" valign="bottom">&nbsp;所在区域:<%=rs.getString("area")%></td>
    </tr>
    <tr>
      <td width="388" height="19" valign="bottom">&nbsp;成立日期:<%=rs.getString("fdate")%></td>
    </tr>
    <tr>
      <td width="388" height="19" bgcolor="#F3F3F3" valign="bottom">&nbsp;注册资金:
		  <%String fundvalue="未知";
		  if(fundvalue.equals(rs.getString("fund"))){
		  out.print("面议");
		  }else{ 
			  out.print(rs.getString("fund")+"万人民币");
		  }%></td>
    </tr>
    <tr>
      <td width="388" height="19" valign="bottom">&nbsp;通讯地址:<%=rs.getString("address")%>&nbsp;邮编:<%=rs.getString("zip")%></td>
    </tr>
    <tr>
      <td width="388" height="19" valign="bottom" bgcolor="#F3F3F3">&nbsp;联系人:<%=rs.getString("pname")%></td>
    </tr>
    <tr>
      <td width="388" height="19" valign="bottom">&nbsp;联系电话:<%=rs.getString("phone")%></td>
    </tr>
    <tr>
      <td width="388" height="19" bgcolor="#F3F3F3" valign="bottom">&nbsp;传真号码:<%=rs.getString("fax")%></td>
    </tr>
    <tr>
      <td width="388" height="19" valign="bottom">&nbsp;电子信箱:<a href="mailto:<%=rs.getString("email")%>"><%=rs.getString("email")%></a></td>
    </tr>
    <tr>
      <td width="388" height="19" bgcolor="#F3F3F3" valign="bottom">&nbsp;公司网站:<a href="<%=rs.getString("http")%>"><%=rs.getString("http")%></a></td>
    </tr>
    <tr>
      <td width="388" height="19" valign="bottom">&nbsp;公司简介:</td>
    </tr>
    <tr>
      <td height="3" valign="top" bgcolor="#00006A">
      </td>
    </tr>
    <tr>
      <td width="388" height="19" valign="bottom" bgcolor="#F3F3F3">
        <div align="center">
          <table border="0" cellpadding="0" cellspacing="0" width="379" align="right">
            <tr>
              <td width="377">&nbsp;&nbsp;<%=rs.getString("jianj")%></td>
            </tr>
          </table>
        </div>
        </td>
    </tr>
    <tr>
      <td height="3" valign="top" bgcolor="#00006A">
      </td>
    </tr>
  </center>
    <% if(session.getValue("puid")!=null){%>
	<tr>
      <td width="388" height="24" valign="bottom">
        <p align="center">[<a href="person/addfav.jsp?fav=<%=rs.getString("uname")%>">添加到收藏夹</a>]     
		[<a href="person/sendmail.jsp?reid=<%=rs.getString("uname")%>">发送站内信件</a>]</td> 
    </tr>
	<%}%>
  </table>
</div>
<p align="center">
            【<a href="javascript:window.close()">关闭窗口</a>】</p>
<p align="center"> </p>
<%}%>

⌨️ 快捷键说明

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