receiver.jsp

一个简易的留言版（jsp+mysql）。

<%@ page import="demo.chat.bean.*,java.util.*,java.io.*,java.sql.*" %>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%
request.setCharacterEncoding("GBK");
String words = request.getParameter("words");
words = new String(words.getBytes("iso-8859-1"),"gbk");

String conDriver="com.mysql.jdbc.Driver";
  String constr="jdbc:mysql://localhost:3306/liaotian";
  String username="fan";
  String pass="fan";
 Class.forName(conDriver);
 Connection cons=DriverManager.getConnection(constr,username,pass);
 Statement stem=cons.createStatement();
String sql="insert into jilu(words) values('"+words+"')";
stem.executeUpdate(sql);

Message m = new Message();
m.setTime(new java.util.Date().toLocaleString());
m.setWords(words);
ArrayList messages = (ArrayList)application.getAttribute("messages");
if(messages==null){
	messages = new ArrayList();

}
messages.add(0,m);
%>
<jsp:forward page="liao.jsp"/>