savemsg.jsp

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

<%@ 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_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("insert into icefish_msg(msg_to,msg_topic,msg_words,msg_belong,msg_from,msg_time) values(?,?,?,'false','longlong',now())");
		pstmt1.setString(1, msg_to);
	pstmt1.setString(2, msg_topic);
		pstmt1.setString(3, msg_words);
		pstmt1.executeUpdate();
	
		ResultSet rs=stmt.executeQuery("select @@identity as 'msg_id'");
while(rs.next()){
						}
		rs.close();
		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>");
%>