addkehugok.jsp

JSP+MYSQL能飞网络办公OA系统

<%@ page contentType="text/html;charset=gb2312" %>
<%@ include file="../conn/conn.jsp"%>
<%@ include file="../conn/time.jsp"%>
<%@ include file="checksession.jsp"%>

<%
String company=request.getParameter("company");
String mem=request.getParameter("mem");
String tel=request.getParameter("tel");
String fax=request.getParameter("fax");
String email=request.getParameter("email");
String address=request.getParameter("address");
String comtext=request.getParameter("comtext");
String post=request.getParameter("post");
String lei=request.getParameter("lei");
String yvyue=request.getParameter("yvyue");
String addtime=time;
String text=request.getParameter("text");
String who=(String) session.getAttribute("username");%>


<%
String sql="insert into kehu(company,mem,tel,fax,email,address,comtext,post,lei,yvyue,addtime,text,who) values('"+company+"','"+mem+"','"+tel+"','"+fax+"','"+email+"','"+address+"','"+comtext+"','"+post+"','"+lei+"','"+yvyue+"','"+addtime+"','"+text+"','"+who+"')";
stmt.executeUpdate(sql);
response.sendRedirect("mykehu.jsp?space=3.1");
%>