savedraftmsg.jsp

来自「采用j2ee架构做的bbs」· JSP 代码 · 共 32 行

<%@ page contentType="text/html;charset=gb2312" language="java"  errorPage="" %>
<%@ page import="java.sql.*,java.lang.String.*"%>
<%@include file="conn.jsp" %>
<%
request.setCharacterEncoding("gb2312");
String msg_id = request.getParameter("msg_id");
String msg_to = request.getParameter("msg_to");
String msg_topic = request.getParameter("msg_topic");
String msg_words = request.getParameter("msg_words");
Statement stmt=null;
PreparedStatement pstmt1=null;

try{
stmt=conn.createStatement();
		pstmt1=conn.prepareStatement("update icefish_msg set msg_to=?,msg_topic=?,msg_words=?,msg_time=now() where msg_id="+msg_id);
		pstmt1.setString(1, msg_to);
	pstmt1.setString(2, msg_topic);
		pstmt1.setString(3, msg_words);
		pstmt1.executeUpdate();

		stmt.close();
		pstmt1.close();
	}
	catch(Exception e){
	out.print(e.toString()); 
	}
		finally{
		conn.close();
	}
	out.println("<script language=javascript> alert('       修改成功！'); location.href='draftbin.jsp';</script>");
%>