xfactoryadd.jsp

oa系统 JAVA 办公管理系统 含有多项功能 快快下载

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@include file="check.jsp" %>
<%@page import="com.jspsmart.upload.*" %>

<%
	SmartUpload su = new SmartUpload();
	su.initialize(pageContext);
	su.upload();
	com.jspsmart.upload.Request req = su.getRequest();
	
	String name = charset.GBK_2_ISO(req.getParameter("name")); 
	String type = charset.GBK_2_ISO(req.getParameter("type")); 
	String address = charset.GBK_2_ISO(req.getParameter("address")); 
	String profit = charset.GBK_2_ISO(req.getParameter("profit")); 
	String title = charset.GBK_2_ISO(req.getParameter("title")); 
	String website = charset.GBK_2_ISO(req.getParameter("website")); 
	String tel = charset.GBK_2_ISO(req.getParameter("tel")); 
	String mail = charset.GBK_2_ISO(req.getParameter("mail")); 
	String honor = charset.GBK_2_ISO(req.getParameter("honor")); 
	String line = charset.GBK_2_ISO(req.getParameter("line")); 
	String connman = charset.GBK_2_ISO(req.getParameter("connman")); 
	String hy = charset.GBK_2_ISO(req.getParameter("hy")); 
	String number = charset.GBK_2_ISO(req.getParameter("number")); 
	String abstractx = charset.GBK_2_ISO(req.getParameter("fckeditor")); 
	String sum = charset.GBK_2_ISO(req.getParameter("sum")); 
	String scopex = charset.GBK_2_ISO(req.getParameter("scopex")); 
	String qq = charset.GBK_2_ISO(req.getParameter("qq")); 






	
	String filename = "";
	com.jspsmart.upload.File file=null;
 	title=title.replaceAll("'","&quot;");
	title=title.replaceAll("\"","&quot;");
	abstractx =abstractx.replaceAll("'","&quot;");
	abstractx=abstractx.replaceAll("\"","&quot;");
	String user =(String) session.getAttribute("user");
	String part =(String) session.getAttribute("part");
	String pubtime = dateformat.getStringDate();
	if( (part==null)||(title==null)||(title.length()<2)){
		response.sendRedirect("../factoryadd.jsp?t=1");	
	}
	else{
		try{
			for (int i=0;i<su.getFiles().getCount();i++){
				file = su.getFiles().getFile(i);
					filename=file.getFileName();//+"."+file.getFileExt();
					file.saveAs(java.io.File.separator+"factorypic"+java.io.File.separator+filename);
			}
		}
		catch(Exception e){
			filename="";
		}
	dbc.getConnection();
	String sql="";
	sql = "insert into  factories(name,type,address,profit,website,tel,mail,qq,hy,title,number,abstract,sum,scope,logo,recorduser,part,pubtime,cid) values('"+name+"','"+type+"','"+address+"','"+profit+"','"+website+"','"+tel+"','"+mail+"','"+qq+"','"+hy+"','"+title+"','"+number+"','"+abstractx+"','"+sum+"','"+scopex+"','"+filename+"','"+user+"','"+part+"','"+pubtime+"','"+scid+"')";
	//out.println(charset.ISO_2_GBK(sql));
	dbc.update(charset.ISO_2_GBK(sql)); 
	dbc.close();

	response.sendRedirect("../factoryadd.jsp?t=0");	
	}
%>