xforinfo.jsp

来自「一款采用java技术编写的OA办公软件系统」· JSP 代码 · 共 37 行

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@include file="check.jsp" %>
<%
	
	String title = request.getParameter("title");
	String scale = request.getParameter("scale");
	String brief = request.getParameter("brief");
	String content = request.getParameter("content");
	String wholeprice = request.getParameter("wholeprice");
	String type = request.getParameter("type");
	String unit = request.getParameter("unit");
	String tel = request.getParameter("tel");
	String fax = request.getParameter("fax");
	String email = request.getParameter("email");
	
	String user = (String)session.getAttribute("user");
	String part = (String)session.getAttribute("part");
	String pubtime = dateformat.getStringDate();
	//out.println(name);
	if((title==null)||(title.length()<1)){
		response.sendRedirect("../forinfo.jsp?t=1");
	}
	else{
		dbc.getConnection();
		String sql="";
		{	 
			sql = "insert into  forinfo(title,scale,brief,content,wholeprice,type,unit,tel,fax,email,recorduser,part,pubtime) values('"+title+"','"+scale+"','"+brief+"','"+content+"','"+wholeprice+"','"+type+"','"+unit+"','"+tel+"','"+fax+"','"+email+"','"+user+"','"+part+"','"+pubtime+"')";
			//out.println(charset.ISO_2_GBK(sql)+"<br>");
			dbc.update(charset.ISO_2_GBK(sql));
			dbc.close();

			response.sendRedirect("../forinfo.jsp?t=0");
		}
	}


%>