xinstituteadd.jsp

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

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@include file="check.jsp" %>
<%
	String comment = request.getParameter("fckeditor");
	if(comment!=null){
		comment = comment.replaceAll("\"","&quot;");
		comment = comment.replaceAll("'","&quot;");
	}
	
	String name = request.getParameter("name");
	String manuser = request.getParameter("manuser");
	String tel = request.getParameter("tel");
	String connuser = request.getParameter("connuser");
	String address = request.getParameter("address");
	
	String user = (String)session.getAttribute("user");
	String part = (String)session.getAttribute("part");
	String pubtime = dateformat.getStringDate();
	//out.println(name);
	if((name==null)||(name.length()<1)){
			response.sendRedirect("../instituteadd.jsp?t=1");
	}
	else{
		dbc.getConnection();
		String sql="";
		if(dbc.getCount("select count(*) from  institutes where part ='"+part+"' and name='"+name+"'  and  cid='"+scid+"'")>0){
			response.sendRedirect("../instituteadd.jsp?t=2");
		}
		else
		{	 
			sql = "insert into  institutes(name,comment,manuser,address,tel,connuser,recorduser,part,pubtime,cid) values('"+name+"','"+comment+"','"+manuser+"','"+address+"','"+tel+"','"+connuser+"','"+user+"','"+part+"','"+pubtime+"' ,'"+scid+"')";
			//out.println(charset.ISO_2_GBK(sql)+"<br>");
			dbc.update(charset.ISO_2_GBK(sql));

			response.sendRedirect("../instituteadd.jsp?t=0");
		}
	dbc.close();
	}


%>