product_info_co.jsp

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

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

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


<%
String enterprise_name=(String)session.getValue("enterprise_name");
String production_name=new String(request.getParameter("production_name").getBytes("ISO8859_1"), "GBK");
String production_tech=new String(request.getParameter("production_tech").getBytes("ISO8859_1"), "GBK");
String appraisal_unit=new String(request.getParameter("appraisal_unit").getBytes("ISO8859_1"), "GBK");
String appraisal_corporation=new String(request.getParameter("appraisal_corporation").getBytes("ISO8859_1"), "GBK");
String appraisal_time=new String(request.getParameter("appraisal_time").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_production (enterprise_name,production_name,production_tech,appraisal_unit,appraisal_corporation,appraisal_time) values ('"+enterprise_name+"','"+production_name+"','"+production_tech+"','"+appraisal_unit+"','"+appraisal_corporation+"','"+appraisal_time+"')";


statement.executeUpdate(upsql);


j.releaseConnection(con);
}


catch(SQLException ee){out.print("数据库连接失败！");}
out.print("信息登记成功！");
%>