base_info_co.jsp

JSP.net环境下开发的科技企业信息管理系统 适用于科研开发单位

<%@ page import="java.util.Date,java.text.SimpleDateFormat" %>
<%@ page contentType="text/html; charset=gb2312" %>
<%@ page language="java" import="java.sql.*"%>

<jsp:useBean id="j" scope="application" class="jdbc.jdbc"/>
<jsp:useBean id="rate" scope="application" class="rate.rate"/>

<%
SimpleDateFormat df=new SimpleDateFormat("yyyy");
String date=df.format(new Date());

String enterprise_name=(String)session.getValue("enterprise_name");
String corporation=new String(request.getParameter("corporation").getBytes("ISO8859_1"), "GBK");
String capital=new String(request.getParameter("capital").getBytes("ISO8859_1"), "GBK");
String enterprise_character=new String(request.getParameter("enterprise_character").getBytes("ISO8859_1"), "GBK");
String product_field=new String(request.getParameter("product_field").getBytes("ISO8859_1"), "GBK");
String adress=new String(request.getParameter("adress").getBytes("ISO8859_1"), "GBK");
String scope_of_operation=new String(request.getParameter("scope_of_operation").getBytes("ISO8859_1"), "GBK");
String aggregate_investment=new String(request.getParameter("aggregate_investment").getBytes("ISO8859_1"), "GBK");
String linkman=new String(request.getParameter("linkman").getBytes("ISO8859_1"), "GBK");
String tel=new String(request.getParameter("tel").getBytes("ISO8859_1"), "GBK");
String fax=new String(request.getParameter("fax").getBytes("ISO8859_1"), "GBK");
String email=new String(request.getParameter("email").getBytes("ISO8859_1"), "GBK");
String amount_of_person=new String(request.getParameter("amount_of_person").getBytes("ISO8859_1"), "GBK");
String middle_tec_post=new String(request.getParameter("middle_tec_post").getBytes("ISO8859_1"), "GBK");
String senior_tech_post=new String(request.getParameter("senior_tech_post").getBytes("ISO8859_1"), "GBK");
String researcher=new String(request.getParameter("researcher").getBytes("ISO8859_1"), "GBK");
String junior_study=new String(request.getParameter("junior_study").getBytes("ISO8859_1"), "GBK");
String undergraduate_person=new String(request.getParameter("undergraduate_person").getBytes("ISO8859_1"), "GBK");
String master_person=new String(request.getParameter("master_person").getBytes("ISO8859_1"), "GBK");
String turtle=new String(request.getParameter("turtle").getBytes("ISO8859_1"), "GBK");
String ISO9000_time=new String(request.getParameter("IS09000").getBytes("ISO8859_1"), "GBK");
String ISO14000_time=new String(request.getParameter("IS014000").getBytes("ISO8859_1"), "GBK");
String ISO18000_time=new String(request.getParameter("IS018000").getBytes("ISO8859_1"), "GBK");
String enterprise_assess=new String(request.getParameter("enterprise_assess").getBytes("ISO8859_1"), "GBK");
String enterprise_assess_time=new String(request.getParameter("enterprise_assess_time").getBytes("ISO8859_1"), "GBK");
String enterprise_software=new String(request.getParameter("enterprise_software").getBytes("ISO8859_1"), "GBK");
String enterprise_software_level=new String(request.getParameter("enterprise_software_level").getBytes("ISO8859_1"), "GBK");
String enterprise_software_time=new String(request.getParameter("enterprise_software_time").getBytes("ISO8859_1"), "GBK");
String tech_owner=new String(request.getParameter("tech_owner").getBytes("ISO8859_1"), "GBK");
String tech_extra=new String(request.getParameter("tech_extra").getBytes("ISO8859_1"), "GBK");
String year_time=date;



float damount_of_person = Float.parseFloat(amount_of_person);
float dmiddle_tec_post = Float.parseFloat(middle_tec_post);
float dsenior_tech_post = Float.parseFloat(senior_tech_post);
float dresearcher = Float.parseFloat(researcher);
float djunior_study = Float.parseFloat(junior_study);
float dundergraduate_person = Float.parseFloat(undergraduate_person);
float dmaster_person = Float.parseFloat(master_person);
float dturtle = Float.parseFloat(turtle);



int middle_percent=(int)rate.cal(dmiddle_tec_post,damount_of_person);
int senior_percent=(int)rate.cal(dsenior_tech_post,damount_of_person);
int researcher_percent=(int)rate.cal(dresearcher,damount_of_person);
int junior_percent=(int)rate.cal(djunior_study,damount_of_person);
int undergraduate_percent=(int)rate.cal(dundergraduate_person,damount_of_person);
int master_percent=(int)rate.cal(dmaster_person,damount_of_person);
int turtle_percent=(int)rate.cal(dturtle,damount_of_person);

if(enterprise_name!=null)
{
try{
Connection con=j.getConnection();

Statement statement=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);


String upsql="insert into enterprise_info (enterprise_name,corporation,capital,adress,enterprise_character,product_field,scope_of_operation,aggregate_investment,linkman,tel,email,fax,amount_of_person,middle_tec_post,middle_percent,senior_tech_post,senior_percent,researcher,researcher_percent,junior_study,junior_percent,undergraduate_person,undergraduate_percent,master_person,master_percent,turtle,turtle_percent,ISO9000_time,ISO14000_time,ISO18000_time,enterprise_assess,enterprise_assess_time,enterprise_software,enterprise_software_level,enterprise_software_time,tech_owner,tech_extra,year_time) values ('"+enterprise_name+"','"+corporation+"','"+capital+"','"+adress+"','"+enterprise_character+"','"+product_field+"','"+scope_of_operation+"','"+aggregate_investment+"','"+linkman+"','"+tel+"','"+email+"','"+fax+"','"+amount_of_person+"','"+middle_tec_post+"','"+middle_percent+"','"+senior_tech_post+"','"+senior_percent+"','"+researcher+"','"+researcher_percent+"','"+junior_study+"','"+junior_percent+"','"+undergraduate_person+"','"+undergraduate_percent+"','"+master_person+"','"+master_percent+"','"+turtle+"','"+turtle_percent+"','"+ISO9000_time+"','"+ISO14000_time+"','"+ISO18000_time+"','"+enterprise_assess+"','"+enterprise_assess_time+"','"+enterprise_software+"','"+enterprise_software_level+"','"+enterprise_software_time+"','"+tech_owner+"','"+tech_extra+"','"+year_time+"')";


statement.executeUpdate(upsql);


j.releaseConnection(con);
}


catch(SQLException ee){out.print("对不起！和以注册企业名称重复!");}

out.print("信息登记成功！");
}
%>

<SCRIPT language=javascript1.2>
function rs(){ 
parent.leftFrame.location.href="../choice_panel.jsp";
}
</SCRIPT>

<body onload=rs()>
</body>