contactsave.jsp

来自「JSP+ORACLE网站开发实例（下）.rar」· JSP 代码 · 共 26 行

<% String toptitle="留言咨询"; %>
<%@ include file="rscoon.jsp"%>
<%@ include file="mztop.jsp"%>
<%request.setCharacterEncoding("GB2312");
String guestname=request.getParameter("guestname");
String from1=request.getParameter("from");
String homeaddr=request.getParameter("homeaddr");
String tel=request.getParameter("tel");
String handset=request.getParameter("handset");
String guestcontent=request.getParameter("guestcontent");

if(!guestname.equals("")&&!from1.equals("")&&!homeaddr.equals("")&&!tel.equals("")&&!handset.equals("")&&!guestcontent.equals("")){
stmt.executeUpdate("INSERT INTO scott.contact(id,guestname,form1,homeaddr,tel,handset,guestcontent) VALUES(scott.id.nextval,'"+guestname+"','"+from1+"','"+homeaddr+"','"+tel+"','"+handset+"','"+guestcontent+"')");
 
 stmt.close();
 conn.close(); 
out.print( " <table width=776 height=126 border=0 align=center><tr><td align=center bgcolor=#f1f1eb> 留言成功</td></tr><tr><td align='center' bgcolor=#f1f1eb> <strong>您的申诉我们已受理,我们会尽快给您答复.</strong></td></tr><tr><td align='center' bgcolor='#f1f1eb'> <a href='discontact.jsp'>返回查看留言</a></td></tr></table>");

}else{
out.print("<script language='javascript'>window.confirm('对不起，所有选项都为必填！！');</script>");
		out.print("<script language='javascript'>parent.window.history.go(-1);</script>");
}

%>