economy_login_co.jsp

来自「JSP科技企业信息管理系统[Eclipse]版.rarjsp+javabean」· JSP 代码 · 共 57 行

JSP
57
字号

<%@ 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="insert into enterprise_economy (enterprise_name,this_year,this_year_GDP,this_year_high_tech_income,this_year_export,this_year_tax,this_year_profit,this_year_research_fee,next_year,next_year_GDP,next_year_high_tech_income,next_year_export,next_year_tax,next_year_profit,next_year_research_fee) values ('"+enterprise_name+"','"+this_year+"','"+this_year_GDP+"','"+this_year_high_tech_income+"','"+this_year_export+"','"+this_year_tax+"','"+this_year_profit+"','"+this_year_research_fee+"','"+next_year+"','"+next_year_GDP+"','"+next_year_high_tech_income+"','"+next_year_export+"','"+next_year_tax+"','"+next_year_profit+"','"+next_year_research_fee+"')";


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>

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?