📄 info_co.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" %>
<%@ page language="java" import="java.sql.*"%>
<%@ page import="java.util.Date,java.text.SimpleDateFormat" %>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
</head>
<style TYPE="text/css">
<!--
body {font-size:10pt;color:#415161}
td {font-size:10pt;color:#415161}
th {font-size:10pt;color:#415161}
</style>
<jsp:useBean id="j" scope="application" class="jdbc.jdbc"/>
<%
SimpleDateFormat df=new SimpleDateFormat("yyyy");
String date=df.format(new Date());
String enterprise_name=(String)session.getValue("e_d");
String year_time=date;
try{
Connection con=j.getConnection();
Statement statement=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select * from enterprise_info where enterprise_name='"+enterprise_name+"' and year_time='"+year_time+"'";
ResultSet r=statement.executeQuery(sql);
if(!r.first())
response.sendRedirect("../nomessage.htm");
r.beforeFirst();
while(r.next())
{
%>
<table width="100%" border="0" >
<tr>
<td background="../img/bt.jpg"> <strong><font color="#FFFFFF"><%=year_time%>年度企业基本信息表</font>
</strong> </td>
</tr>
<tr>
<td>
<table width="100%" border="1" cellspacing="0" bordercolor="#CCCCFF">
<tr>
<td><strong>企业名称</strong> </td>
<td colspan="5"><%=r.getString(1)%></td>
<td><strong>法人代表</strong> </td>
<td><%=r.getString(2)%></td>
</tr>
<tr>
<td width="8%"><strong>注册资本</strong> </td>
<td width="13%"><%=r.getString(3)%><strong>万元</strong></td>
<td width="8%"><strong>企业性质</strong> </td>
<td width="17%"><%=r.getString(5)%></td>
<td><strong>企业产品领域</strong> </td>
<td colspan="3"><%=r.getString(6)%></td>
</tr>
<tr>
<td><strong>注册地址</strong> </td>
<td colspan="7"><%=r.getString(4)%></td>
</tr>
<tr>
<td ><strong>经营范围</strong> </td>
<td colspan="7"><%=r.getString(7)%></td>
</tr>
<tr>
<td><strong>投资总额</strong> </td>
<td colspan="7"><%=r.getString(8)%>万元</td>
</tr>
<tr>
<td><strong>联系人</strong> </td>
<td><%=r.getString(9)%></td>
<td><strong>联系电话</strong> </td>
<td><%=r.getString(10)%></td>
<td width="12%"><strong>传真 </strong></td>
<td width="18%"><%=r.getString(12)%></td>
<td width="8%"><strong>E-mail</strong> </td>
<td width="16%"><%=r.getString(11)%></td>
</tr>
<tr>
<td><strong>人员总数</strong> </td>
<td colspan="7"><%=r.getString(13)%> <strong>人</strong></td>
</tr>
<tr>
<td colspan="2"><strong>中级职称</strong>: <%=r.getString(14)%> <strong>人</strong>
占<%=r.getString(15)%>%</td>
<td colspan="2"><strong>高级职称</strong>: <%=r.getString(16)%> <strong>人</strong>
占<%=r.getString(17)%>%</td>
<td colspan="2"><strong>研发人员</strong>: <%=r.getString(18)%> <strong>人</strong>
占<%=r.getString(19)%>%</td>
<td colspan="2"><strong>大专学历:</strong> <%=r.getString(20)%> <strong>人</strong>
占<%=r.getString(21)%>%</td>
</tr>
<tr>
<td colspan="4"><strong>本科学历专业技术人员</strong>: <%=r.getString(22)%> <strong>人</strong>
占<%=r.getString(23)%>%</td>
<td colspan="4"><strong>硕士学位以上专业技术人员</strong>: <%=r.getString(24)%> <strong>人</strong>
占<%=r.getString(25)%>%</td>
</tr>
<tr>
<td colspan="8"><strong>留学归国人员</strong>: <%=r.getString(26)%> <strong>人</strong>
占<%=r.getString(27)%>%</td>
</tr>
<tr>
<td colspan="8"><strong>IS09000质量体系认证时间</strong>: <%=r.getString(28)%></td>
</tr>
<tr>
<td colspan="8"><strong>IS014000环境体系认证时间</strong>: <%=r.getString(29)%></td>
</tr>
<tr>
<td colspan="8"><strong>IS018000劳动体系认证时间</strong>: <%=r.getString(30)%></td>
</tr>
<tr>
<td colspan="4"> <%=r.getString(31)%> <strong>级高新技术企业评定 评定时间</strong>: <%=r.getString(32)%></td>
<td colspan="4"><strong>企业</strong><%=r.getString(33)%> <strong>软件企业 评定级别</strong>:
<%=r.getString(34)%> <strong>评定时间</strong>: <%=r.getString(35)%> </td>
</tr>
<tr>
<td colspan="8"> <strong>企业生产技术来源:自有</strong>: <%=r.getString(36)%> <strong>个外有:</strong>
<%=r.getString(37)%> <strong>个</strong> </td>
</tr>
</table>
</td>
</tr>
</table>
<%
}
}catch(SQLException ee){out.print("数据库连接失败！");}
%>
<div align="right">
<input type=button name=button_fh value="返回" onclick="javascript:history.go(-1);">
<input type=button name=print value="打印" onclick="javascript:window.print();">
</div>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -