?? 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 + -