📄 choice_panel.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" %>
<%@ page language="java" import="java.sql.*"%>
<%@ page import="java.util.Date,java.text.SimpleDateFormat" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>管理导航</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<style TYPE="text/css">
<!--
body {font-size:10pt}
td {font-size:10pt}
th {font-size:10pt}
A:link{text-decoration:none}
A:visited{text-decoration:none}
A:hover {color: #000000;text-decoration:none}
-->#000000
</style>
<jsp:useBean id="j" scope="application" class="jdbc.jdbc"/>
<%
SimpleDateFormat df=new SimpleDateFormat("yyyy");
String date=df.format(new Date());
int this_year=Integer.parseInt(date);
int next_year=this_year+1;
int a=0;
int b=0;
String enterprise_name=(String)session.getValue("enterprise_name");
try{
Connection con=j.getConnection();
Statement statement=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sqla="select * from enterprise_info where enterprise_name='"+enterprise_name+"' and year_time='"+date+"'";
String sqlb="select * from enterprise_economy where enterprise_name='"+enterprise_name+"' and this_year='"+this_year+"'";
ResultSet ra=statement.executeQuery(sqla);
while(ra.next())
{++a;
if(a>=1)
{
break;
}
}
ResultSet rb=statement.executeQuery(sqlb);
while(rb.next())
{++b;
if(b>=1)
{
break;
}
}
j.releaseConnection(con);
}catch(SQLException ee){out.print("数据库连接失败！");}
%>
<body bgcolor="#f0f8ff" style="margin:0;" leftmargin="0" topmargin="20" marginheight="0" marginwidth="0">
<br>
<table width="140" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#0099FF">
<tr>
<td>
<table width="140" height="172" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#f0f8ff">
<tr>
<td height="21" bgcolor="#0099FF" >
<div align="center" ><strong>科技企业信息登记</strong></div></td>
</tr>
<%
if(a!=1)
{
%>
<tr>
<td height="18" style="cursor: hand; color: 00000"
onmouseover="this.bgColor='#00FFF';"
onmouseout="this.bgColor='#f0f8ff';"
><div align="left"><a href="enterprise_info_login\base_info.jsp" target="mainFrame"><img src="/img/point.gif" width="12" height="12" border="0">
<font color="#000000">企业基本情况登记</font></a></div></td>
</tr>
<%
}
else
{
%>
<tr>
<td height="18" style="cursor: hand; color: 00000"
onmouseover="this.bgColor='#00FFF';"
onmouseout="this.bgColor='#f0f8ff';"
><div align="left"><img src="/img/point.gif" width="12" height="12" border="0">
<font color="#FF3300">企业基本情况已登记</font></div></td>
</tr>
<%
}
%>
<tr>
<td height="19" style="cursor: hand; color: 00000"
onmouseover="this.bgColor='#00FFF';"
onmouseout="this.bgColor='#f0f8ff';"
><div align="left"><a href="enterprise_info_login\patent_info.jsp" target="mainFrame"><img src="/img/point.gif" width="12" height="12" border="0">
<font color="#000000">企业专利信息登记</font></a></font></div></td>
</tr>
<tr>
<td height="20" style="cursor: hand; color: 00000"
onmouseover="this.bgColor='#00FFF';"
onmouseout="this.bgColor='#f0f8ff';"
><div align="left"><a href="enterprise_info_login\brand_info.jsp" target="mainFrame"><img src="/img/point.gif" width="12" height="12" border="0">
<font color="#000000">企业商标信息登记</font></a></div></td>
</tr>
<tr>
<td height="20" style="cursor: hand; color: 00000"
onmouseover="this.bgColor='#00FFF';"
onmouseout="this.bgColor='#f0f8ff';"
><div align="left"><a href="enterprise_info_login\captial_info.jsp" target="mainFrame"><img src="/img/point.gif" width="12" height="12" border="0">
<font color="#000000">企业资金扶持登记</font></a></div></td>
</tr>
<tr>
<td height="19" style="cursor: hand; color: 00000"
onmouseover="this.bgColor='#00FFF';"
onmouseout="this.bgColor='#f0f8ff';"
><div align="left"><a href="enterprise_info_login\loan_info.jsp" target="mainFrame"><img src="/img/point.gif" width="12" height="12" border="0">
<font color="#000000">企业贷款情况登记</font></a></div></td>
</tr>
<%
if(b!=1)
{
%>
<tr>
<td height="18" style="cursor: hand; color: 00000"
onmouseover="this.bgColor='#00FFF';"
onmouseout="this.bgColor='#f0f8ff';"
><div align="left"><a href="enterprise_info_login\economy_login.jsp" target="mainFrame"><img src="/img/point.gif" width="12" height="12" border="0">
<font color="#000000">企业经营情况登记</font></a></div></td>
</tr>
<%
}
else
{
%>
<tr>
<td height="18" style="cursor: hand; color: 00000"
onmouseover="this.bgColor='#00FFF';"
onmouseout="this.bgColor='#f0f8ff';"
><div align="left"><img src="/img/point.gif" width="12" height="12" border="0">
<font color="#FF3300">企业经营情况已登记</font></div></td>
</tr>
<%
}
%>
<tr>
<td height="18" style="cursor: hand; color: 00000"
onmouseover="this.bgColor='#00FFF';"
onmouseout="this.bgColor='#f0f8ff';"
><div align="left"><a href="enterprise_info_login\patent_plan_info.jsp" target="mainFrame"><img src="/img/point.gif" width="12" height="12" border="0">
<font color="#000000">企业专利计划登记</font></a></div></td>
</tr>
<tr>
<td height="18" style="cursor: hand; color: 00000"
onmouseover="this.bgColor='#00FFF';"
onmouseout="this.bgColor='#f0f8ff';"
><div align="left"><a href="enterprise_info_login\new_tech_plan_info.jsp" target="mainFrame"><img src="/img/point.gif" width="12" height="12" border="0">
<font color="#000000">企业产品计划登记</font></a></div></td>
</tr>
<tr>
<td height="18" style="cursor: hand; color: 00000"
onmouseover="this.bgColor='#00FFF';"
onmouseout="this.bgColor='#f0f8ff';"
><div align="left"><a href="enterprise_info_login\product_info.jsp" target="mainFrame"><img src="/img/point.gif" width="12" height="12" border="0">
<font color="#000000">企业成果情况登记</font></a></div></td>
</tr>
<tr>
<td height="18" style="cursor: hand; color: 00000"
onmouseover="this.bgColor='#00FFF';"
onmouseout="this.bgColor='#f0f8ff';"
><div align="left"><a href="enterprise_info_login\tech_info.jsp" target="mainFrame"><img src="/img/point.gif" width="12" height="12" border="0">
<font color="#000000">企业技术情况登记</font></a></div></td>
</tr>
</table>
</td>
</tr>
</table>
<br>
<table width="140" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#0099FF">
<tr>
<td>
<table width="140" height="172" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#f0f8ff">
<tr>
<td height="21" bgcolor="#0099FF" >
<div align="center" ><strong>科技企业信息查询</strong></div></td>
</tr>
<tr>
<td height="18" style="cursor: hand; color: 00000"
onmouseover="this.bgColor='#00FFF';"
onmouseout="this.bgColor='#f0f8ff';"
><div align="left"><a href="enterprise_info_amend\base_info.jsp" target="mainFrame"><img src="/img/point.gif" width="12" height="12" border="0">
<font color="#000000">企业基本情况查询</font></a></div></td>
</tr>
<tr>
<td height="19" style="cursor: hand; color: 00000"
onmouseover="this.bgColor='#00FFF';"
onmouseout="this.bgColor='#f0f8ff';"
><div align="left"><a href="enterprise_info_amend\patent_info.jsp" target="mainFrame"><img src="/img/point.gif" width="12" height="12" border="0">
<font color="#000000">企业专利信息查询</font></a></font></div></td>
</tr>
<tr>
<td height="20" style="cursor: hand; color: 00000"
onmouseover="this.bgColor='#00FFF';"
onmouseout="this.bgColor='#f0f8ff';"
><div align="left"><a href="enterprise_info_amend\brand_info.jsp" target="mainFrame"><img src="/img/point.gif" width="12" height="12" border="0">
<font color="#000000">企业商标信息查询</font></a></div></td>
</tr>
<tr>
<td height="20" style="cursor: hand; color: 00000"
onmouseover="this.bgColor='#00FFF';"
onmouseout="this.bgColor='#f0f8ff';"
><div align="left"><a href="enterprise_info_amend\captial_info.jsp" target="mainFrame"><img src="/img/point.gif" width="12" height="12" border="0">
<font color="#000000">企业资金扶持查询</font></a></div></td>
</tr>
<tr>
<td height="19" style="cursor: hand; color: 00000"
onmouseover="this.bgColor='#00FFF';"
onmouseout="this.bgColor='#f0f8ff';"
><div align="left"><a href="enterprise_info_amend\loan_info.jsp" target="mainFrame"><img src="/img/point.gif" width="12" height="12" border="0">
<font color="#000000">企业贷款情况查询</font></a></div></td>
</tr>
<tr>
<td height="18" style="cursor: hand; color: 00000"
onmouseover="this.bgColor='#00FFF';"
onmouseout="this.bgColor='#f0f8ff';"
><div align="left"><a href="enterprise_info_amend\economy_login.jsp" target="mainFrame"><img src="/img/point.gif" width="12" height="12" border="0">
<font color="#000000">企业经营情况查询</font></a></div></td>
</tr>
<tr>
<td height="18" style="cursor: hand; color: 00000"
onmouseover="this.bgColor='#00FFF';"
onmouseout="this.bgColor='#f0f8ff';"
><div align="left"><a href="enterprise_info_amend\tech_plan_info.jsp" target="mainFrame"><img src="/img/point.gif" width="12" height="12" border="0">
<font color="#000000">企业产品计划查询</font></a></div></td>
</tr>
<tr>
<td height="18" style="cursor: hand; color: 00000"
onmouseover="this.bgColor='#00FFF';"
onmouseout="this.bgColor='#f0f8ff';"
><div align="left"><a href="enterprise_info_amend\patent_plan_info.jsp" target="mainFrame"><img src="/img/point.gif" width="12" height="12" border="0">
<font color="#000000">企业专利计划查询</font></a></div></td>
</tr>
<tr>
<td height="18" style="cursor: hand; color: 00000"
onmouseover="this.bgColor='#00FFF';"
onmouseout="this.bgColor='#f0f8ff';"
><div align="left"><a href="enterprise_info_amend\product_info.jsp" target="mainFrame"><img src="/img/point.gif" width="12" height="12" border="0">
<font color="#000000">企业成果情况查询</font></a></div></td>
</tr>
<tr>
<td height="18" style="cursor: hand; color: 00000"
onmouseover="this.bgColor='#00FFF';"
onmouseout="this.bgColor='#f0f8ff';"
><div align="left"><a href="enterprise_info_amend\tech_info.jsp" target="mainFrame"><img src="/img/point.gif" width="12" height="12" border="0">
<font color="#000000">企业技术情况查询</font></a></div></td>
</tr>
</table>
</td>
</tr>
</table>
<br>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -