<%@ page contentType="text/html; charset=gb2312" language="java"%>
<%@ page import="java.sql.*,java.util.*"%>
<jsp:useBean scope="page" id="Ex" class="com.chat.Execute_DB" />
<%
//设置编码格式
request.setCharacterEncoding("gb2312");
//获取登录用户名和聊天室名,并保存到session对象中
String str_UserName = request.getParameter("UserName");
String str_ChatRoom = request.getParameter("ChatRoom");
session.setAttribute("UserName",str_UserName);
session.setAttribute("ChatRoom",str_ChatRoom);
//更新用户活动情况
java.util.Date NowDate = new java.util.Date();
long l_ChatTime = NowDate.getTime();
String strSql = "select ID from userlist where UserName like '"+str_UserName+"'";
//out.println(strSql);
ResultSet rs = Ex.exeSqlQuery(strSql);
if(rs.next())
{
//用户换房间的情况
strSql = "update userlist set CharTime = '"+l_ChatTime+"',ChatRoom = '"+str_ChatRoom+"' where UserName like '"+str_UserName+"'";
Ex.exeSql(strSql);
}
else
{
//用户刚登录的情况
strSql = "insert into userlist (ChatRoom,UserName,ChatTime) values ('"+str_ChatRoom+"','"+str_UserName+"','"+l_ChatTime+"')";
Ex.exeSql(strSql);
}
rs.close();
//更新用户登录时间
strSql = "update users set LoginTime = '"+l_ChatTime+"' where UserName like '"+str_UserName+"'";
Ex.exeSql(strSql);
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>欢迎光临本聊天室</title>
</head>
<frameset rows="*" cols="130,*" border="1" framespacing="1" bordercolor="#FF0000">
<frame name="leftFrame" scrolling="no" noresize src="left.jsp">
<frameset rows="*,130" border="1" framespacing="1" cols="*" bordercolor="#FF0000">
<frame name="topFrame" scrolling="yes" src="display.jsp">
<frame name="mainFrame" src="send.jsp">
</frameset>
</frameset>
<noframes>
<body>
<h1 align="center">
<font color="#FF0000">您的浏览器不知道框架,所以不能看到内容。</font>
</h1>
</body>
</noframes>
</html>
网上在线聊天系统main.jsp
最新推荐文章于 2016-07-11 21:19:41 发布