addkehugok.jsp

来自「database connection, database connection」· JSP 代码 · 共 42 行

<%@ 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");
company = new String(company.getBytes("ISO-8859-1"),"gbk");
mem = new String(mem.getBytes("ISO-8859-1"),"gbk");
tel = new String(tel.getBytes("ISO-8859-1"),"gbk");
fax = new String(fax.getBytes("ISO-8859-1"),"gbk");
email = new String(email.getBytes("ISO-8859-1"),"gbk");
address = new String(address.getBytes("ISO-8859-1"),"gbk");
comtext = new String(comtext.getBytes("ISO-8859-1"),"gbk");
post = new String(post.getBytes("ISO-8859-1"),"gbk");
lei = new String(lei.getBytes("ISO-8859-1"),"gbk");
yvyue = new String(yvyue.getBytes("ISO-8859-1"),"gbk");
addtime = new String(addtime.getBytes("ISO-8859-1"),"gbk");
text = new String(text.getBytes("ISO-8859-1"),"gbk");
who = new String(who.getBytes("ISO-8859-1"),"gbk");


%>


<%
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");
%>