base_info.jsp

jsp+sql2000数据库搭建的科技企业信息网站

if(form1.product_field.value.length>50)
   {sign="0"
    alert("企业产品领域 字数太多!")
   }
if(form1.scope_of_operation.value.length>100)
   {sign="0"
    alert("经营范围字数太多!")
   }
if(form1.aggregate_investment.value.length>10)
   {sign="0"
    alert("投资总额字数太多!")
   }
if(form1.linkman.value.length>25)
   {sign="0"
    alert("联系人字数太多!")
   }
if(form1.tel.value.length>20)
   {sign="0"
    alert("电话字数太多!")
   }
if(form1.email.value.length>25)
   {sign="0"
    alert("E-mail字数太多!")
   }
if(form1.fax.value.length>20)
   {sign="0"
    alert("传真字数太多!")
   }
if(form1.amount_of_person.value.length>10)
   {sign="0"
    alert("人员总数超出范围!")
   }
if(form1.middle_tec_post.value.length>10)
   {sign="0"
    alert("中级职称人员总数超出范围!")
   }
if(form1.senior_tech_post.value.length>10)
   {sign="0"
    alert("高级职称人员总数超出范围!")
   }
if(form1.researcher.value.length>10)
   {sign="0"
    alert("研发人员总数超出范围!")
   }
if(form1.junior_study.value.length>10)
   {sign="0"
    alert("大专学历人员总数超出范围!")
   }
if(form1.undergraduate_person.value.length>10)
   {sign="0"
    alert("本科学历人员总数超出范围!")
   }
if(form1.master_person.value.length>10)
   {sign="0"
    alert("硕士学位以上专业技术人员人员总数超出范围!")
   }
if(form1.turtle.value.length>10)
   {sign="0"
    alert("留学人员总数超出范围!")
   }
if(parseInt(form1.turtle.value)+parseInt(form1.master_person.value)+parseInt(form1.undergraduate_person.value)+parseInt(form1.junior_study.value)+parseInt(form1.researcher.value)+parseInt(form1.senior_tech_post.value)+parseInt(form1.middle_tec_post.value)>parseInt(form1.amount_of_person.value))
   {sign="0"
    alert("各层次人员总数超出总人数!")
   }
if(form1.IS09000.value.length>20)
   {sign="0"
    alert("IS09000认证时间无效!")
   }
if(form1.IS014000.value.length>20)
   {sign="0"
    alert("IS014000认证时间无效!")
   }
if(form1.IS018000.value.length>20)
   {sign="0"
    alert("IS018000认证时间无效!")
   }
if(form1.enterprise_assess.value.length>5)
   {sign="0"
    alert("高新技术企业评定级别无效!")
   }
if(form1.enterprise_assess_time.value.length>20)
   {sign="0"
    alert("高新技术企业评定时间无效!")
   }
if(form1.enterprise_software.value.length>5)
   {sign="0"
    alert("是否软件企业无效!")
   }
if(form1.enterprise_software_level.value.length>50)
   {sign="0"
    alert("软件企业评定级别无效!")
   }
if(form1.enterprise_software_time.value.length>20)
   {sign="0"
    alert("软件企业评定时间无效!")
   }
if(form1.tech_owner.value.length>10)
   {sign="0"
    alert("企业生产技术外来源超出范围!")
   }
if(form1.tech_extra.value.length>10)
   {sign="0"
    alert("企业生产技术内来源超出户范围!")
   }
if(sign==1)
{
  form1.submit();
}
}

//-->
</script>

<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"/>

<%

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 sql="select * from enterprise_info where enterprise_name='"+enterprise_name+"'";
ResultSet r=statement.executeQuery(sql);

if(!r.first())
response.sendRedirect("../nomessage.htm");

r.beforeFirst();

while(r.next())
{
%>

<form name="form1" method="post" action="base_info_co.jsp">
  <table width="100%" border="1"  cellspacing="0" bordercolor="#CCCCFF">
    <tr> 
      <td colspan="3"><strong>企业名称 <%=(String)session.getValue("enterprise_name")%></strong></td>
      <td width="24%"><strong>法人代表</strong> 
        <input name="corporation" type="text" size="8" value=<%=r.getString(2)%>></td>
    </tr>
    <tr> 
      <td width="26%"><strong>注册资本</strong> 
        <input name="capital" type="text" size="8" value=<%=r.getString(3)%>>
        <strong>万元</strong></td>
      <td width="25%"><strong>企业性质</strong> 
        <input name="enterprise_character" type="text" size="10" value=<%=r.getString(5)%>></td>
      <td colspan="2"><strong>企业产品领域</strong> 
        <input name="product_field" type="text" size="30" value=<%=r.getString(6)%>></td>
    </tr>
    <tr> 
      <td colspan="4"><strong>注册地址</strong> 
        <input name="adress" type="text" size="100" value=<%=r.getString(4)%>></td>
    </tr>
    <tr> 
      <td colspan="4"><strong>经营范围</strong> 
        <input name="scope_of_operation" type="text" size="100" value=<%=r.getString(7)%>></td>
    </tr>
    <tr> 
      <td><strong>投资总额</strong> 
        <input name="aggregate_investment" type="text" size="8" value=<%=r.getString(8)%>>
        <strong>万元</strong></td>
      <td colspan="3">&nbsp;</td>
    </tr>
    <tr> 
      <td><strong>联系人</strong> 
        <input name="linkman" type="text" size="8" value=<%=r.getString(9)%>> </td>
      <td><strong>联系电话</strong> 
        <input name="tel" type="text" size="12" value=<%=r.getString(10)%>></td>
      <td width="25%"><strong>传真</strong> 
        <input name="fax" type="text" size="15" value=<%=r.getString(12)%>></td>
      <td><strong>E-mail</strong> 
        <input name="email" type="text" size="10" value=<%=r.getString(11)%>></td>
    </tr>
    <tr> 
      <td><strong>从业人员总数</strong> 
        <input name="amount_of_person" type="text" size="6" value=<%=r.getString(13)%>>
        <strong>人</strong></td>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
    </tr>
    <tr> 
      <td><strong>中级职称</strong> 
        <input name="middle_tec_post" type="text" size="6" value=<%=r.getString(14)%>>
        <strong>人 占<%=r.getString(15)%>%</strong></td>
      <td><strong>高级职称</strong>
<input name="senior_tech_post" type="text" size="6" value=<%=r.getString(16)%>>
        <strong>人 占<%=r.getString(17)%>%</strong></td>
      <td><strong>研发人员</strong> 
        <input name="researcher" type="text" size="6" value=<%=r.getString(18)%>>
        <strong>人 占<%=r.getString(19)%>%</strong></td>
      <td><strong>大专学历</strong>
<input name="junior_study" type="text" size="6" value=<%=r.getString(20)%>>
        <strong>人 占<%=r.getString(21)%>%</strong></td>
    </tr>
    <tr> 
      <td colspan="2"><strong>本科学历专业技术人员:</strong> 
        <input name="undergraduate_person" type="text" size="6" value=<%=r.getString(22)%>>
        <strong>人 占<%=r.getString(23)%>%</strong></td>
      <td colspan="2"><strong>硕士学位以上专业技术人员</strong>
<input name="master_person" type="text" size="6" value=<%=r.getString(24)%>>
        <strong>人 占<%=r.getString(25)%>%</strong></td>
    </tr>
    <tr> 
      <td><strong>留学人员</strong> 
        <input name="turtle" type="text" size="6" value=<%=r.getString(26)%>>
        <strong>人 占<%=r.getString(27)%>%</strong></td>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
    </tr>
    <tr> 
      <td colspan="4"><strong>IS09000质量体系认证时间:</strong> 
        <input name="IS09000" type="text" onfocus="calendar()" size="10" value=<%=r.getString(28)%>></td>
    </tr>
    <tr> 
      <td colspan="4"><strong>IS014000环境体系认证时间:</strong> 
        <input name="IS014000" type="text" onfocus="calendar()" size="10" value=<%=r.getString(29)%>></td>
    </tr>
    <tr> 
      <td colspan="4"><strong>IS018000劳动体系认证时间:</strong> 
        <input name="IS018000" type="text" onfocus="calendar()" size="10" value=<%=r.getString(30)%>></td>
    </tr>
    <tr> 
      <td colspan="2"> <input name="enterprise_assess" type="text" size="6" value=<%=r.getString(31)%>>
        <strong> 级高新技术企业评定 评定时间:</strong> 
        <input name="enterprise_assess_time" type="text" size="10" value=<%=r.getString(32)%> onfocus="calendar()"></td>
      <td colspan="2"><strong>企业</strong> 
        <input name="enterprise_software" type="text" size="2" value=<%=r.getString(33)%>>
        <strong>软件企业 评定级别</strong>
<input name="enterprise_software_level" type="text" size="4" value=<%=r.getString(34)%>>
        <strong>评定时间</strong> 
       <input name="enterprise_software_time" type="text" size="10" value=<%=r.getString(35)%>  onfocus="calendar()"></td>
    </tr>
    
	<tr> 
      <td colspan="4"> <strong>企业生产技术来源:自有:</strong> 
        <input name="tech_owner" type="text" size="3" value=<%=r.getString(36)%>>
        <strong>个外有:</strong> 
        <input name="tech_extra" type="text" size="3" value=<%=r.getString(37)%>>
        <strong>个</strong> </td>
    </tr>
    <tr> 
      <td colspan="4"><div align="right"> 
          <input type="button" name="Submit" value="提交" onclick="check()">
        </div></td>
    </tr>
  </table>
</form>

<%
}
}catch(SQLException ee){out.print("数据库连接失败！");}
%>

</html>