xexpertreg.jsp

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

<%@ 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 grad = request.getParameter("grad");
	String age = request.getParameter("age");
	String field = request.getParameter("field");
	String unit = request.getParameter("unit");
	String sex = request.getParameter("sex");
	String address = request.getParameter("address");
	String tel = request.getParameter("tel");
	
	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("../expertreg.jsp?t=1");
	}
	else{
		dbc.getConnection();
		String sql="";
		
		{	 
			sql = "insert into  experts(name,grad,age,field,unit,sex,address,tel,comment,recorduser,part,pubtime,cid) values('"+name+"','"+grad+"','"+age+"','"+field+"','"+unit+"','"+sex+"','"+address+"','"+tel+"','"+comment+"','"+user+"','"+part+"','"+pubtime+"','"+scid+"')";
			//out.println(charset.ISO_2_GBK(sql)+"<br>");
			dbc.update(charset.ISO_2_GBK(sql));

			dbc.close();

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


%>