patent_info_co.jsp

来自「JSP科技企业信息管理系统源码(MSSQL数据库)」· JSP 代码 · 共 36 行

<%@ 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 patent_kind=new String(request.getParameter("patent_kind").getBytes("ISO8859_1"), "GBK");
String enterprise_patent_level=new String(request.getParameter("enterprise_patent_level").getBytes("ISO8859_1"), "GBK");
String patent_name=new String(request.getParameter("patent_name").getBytes("ISO8859_1"), "GBK");
String enterprise_app_time=new String(request.getParameter("enterprise_app_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_patent (enterprise_name,enterprise_patent_level,patent_kind,patent_name,patent_app_time) values ('"+enterprise_name+"','"+enterprise_patent_level+"','"+patent_kind+"','"+patent_name+"','"+enterprise_app_time+"')";


statement.executeUpdate(upsql);


j.releaseConnection(con);
}


catch(SQLException ee){out.print("专利名称重复！");}
out.print("信息登记成功！");
%>