base_info_co.jsp

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

<meta http-equiv="refresh" content="1;url=base_info.jsp">
<%@ 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);

try{
Connection con=j.getConnection();

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


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


statement.executeUpdate(upsql);



j.releaseConnection(con);
}


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

out.print("信息修改成功！");

%>