newtech_plan_info_co.jsp

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

<%@ 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"/>


<%
SimpleDateFormat df=new SimpleDateFormat("yyyy");
String date=df.format(new Date());
SimpleDateFormat key=new SimpleDateFormat("yyyy年MM月dd日hh时mm分ss秒");
String key_time=key.format(new Date());
String enterprise_name=(String)session.getValue("enterprise_name");
String plan_context=new String(request.getParameter("plan_context").getBytes("ISO8859_1"), "GBK");
String plan_time=date;

try{
Connection con=j.getConnection();

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


String upsql="insert into enterprise_newtech_plan (enterprise_name,plan_context,plan_time,key_time) values ('"+enterprise_name+"','"+plan_context+"','"+date+"','"+key_time+"')";


statement.executeUpdate(upsql);


j.releaseConnection(con);
}


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