economy_login_co.jsp

Eclipse开发的JSP科技企业信息管理系统源码

<meta http-equiv="refresh" content="1;url=economy_login.jsp">
<%@ page contentType="text/html; charset=gb2312" %>
<%@ page language="java" import="java.sql.*"%>
<%@ page import="java.util.Date,java.text.SimpleDateFormat" %>
<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; 
String enterprise_name=(String)session.getValue("enterprise_name");
String this_year_GDP=new String(request.getParameter("this_year_GDP").getBytes("ISO8859_1"), "GBK");
String this_year_high_tech_income=new String(request.getParameter("this_year_high_tech_income").getBytes("ISO8859_1"), "GBK");
String this_year_export=new String(request.getParameter("this_year_export").getBytes("ISO8859_1"), "GBK");
String this_year_tax=new String(request.getParameter("this_year_tax").getBytes("ISO8859_1"), "GBK");
String this_year_profit=new String(request.getParameter("this_year_profit").getBytes("ISO8859_1"), "GBK");
String this_year_research_fee=new String(request.getParameter("this_year_research_fee").getBytes("ISO8859_1"), "GBK");
String next_year_GDP=new String(request.getParameter("next_year_GDP").getBytes("ISO8859_1"), "GBK");
String next_year_high_tech_income=new String(request.getParameter("next_year_high_tech_income").getBytes("ISO8859_1"), "GBK");
String next_year_export=new String(request.getParameter("next_year_export").getBytes("ISO8859_1"), "GBK");
String next_year_tax=new String(request.getParameter("next_year_tax").getBytes("ISO8859_1"), "GBK");
String next_year_profit=new String(request.getParameter("next_year_profit").getBytes("ISO8859_1"), "GBK");
String next_year_research_fee=new String(request.getParameter("next_year_research_fee").getBytes("ISO8859_1"), "GBK");


try{
Connection con=j.getConnection();

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


String upsql="update enterprise_economy set enterprise_name='"+enterprise_name+"',this_year='"+this_year+"',this_year_GDP='"+this_year_GDP+"',this_year_high_tech_income='"+this_year_high_tech_income+"',this_year_export='"+this_year_export+"',this_year_tax='"+this_year_tax+"',this_year_profit='"+this_year_profit+"',this_year_research_fee='"+this_year_research_fee+"',next_year='"+next_year+"',next_year_GDP='"+next_year_GDP+"',next_year_high_tech_income='"+next_year_high_tech_income+"',next_year_export='"+next_year_export+"',next_year_tax='"+next_year_tax+"',next_year_profit='"+next_year_profit+"',next_year_research_fee='"+next_year_research_fee+"' where enterprise_name='"+enterprise_name+"'";


statement.executeUpdate(upsql);


j.releaseConnection(con);
}


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

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

%>