package net.chat;
import java.sql.*;
import java.text.SimpleDateFormat;
public class ChatRoom {
/**
* 判断用户是否在聊天室被踢出聊天室
* */
public boolean denyUser(String userName,String chatRoom)
throws SQLException,ClassNotFoundException
{
BaseConn conn =null;
try
{
conn = new BaseConn();
String sql = "select * from onlineUser where nickName=? and chatRoom=?";
PreparedStatement ps = conn.preparedStatement(sql);
ps.setString(1,userName);
ps.setString(2,chatRoom);
ResultSet rs = conn.executeQuery();
if(rs.next())
{
return false;
}
else
return true;
}catch(SQLException ex)
{
ex.printStackTrace();
throw ex;
}catch(ClassNotFoundException ex)
{
ex.printStackTrace();
throw ex;
}
finally
{
conn.closeDB();
}
}
/**
* 用户离开聊天室的时候,将用户从在线人员表中删除
* */
public void logout(String userName)
throws SQLException,ClassNotFoundException
{
BaseConn conn=null;
try
{
conn=new BaseConn();
String sql = "delete from onlineUser where nickName=?";
PreparedStatement ps = conn.preparedStatement(sql);
ps.setString(1,userName);
conn.executeUpdate();
}catch(SQLException ex)
{
ex.printStackTrace();
throw ex;
}catch(ClassNotFoundException ex)
{
ex.printStackTrace();
throw ex;
}finally
{
conn.closeDB();
}
}
/**
* 换房间,将用户从原来的聊天室在线用户表中删除
* */
public void changeRoom(String userName,String chatRoom)
throws SQLException,ClassNotFoundException
{
BaseConn conn=null;
try
{
conn=new BaseConn();
String sql = "delete from onlineUser where nickName=? and chatRoom=?";
PreparedStatement ps = conn.preparedStatement(sql);
ps.setString(1,userName);
ps.setString(2,chatRoom);
conn.executeUpdate();
}catch(SQLException ex)
{
ex.printStackTrace();
throw ex;
}catch(ClassNotFoundException ex)
{
ex.printStackTrace();
throw ex;
}finally
{
conn.closeDB();
}
}
/**
* 检查用户是不是管理员,如果是管理员返回true,如果不是返回false;
* */
public boolean checkAdmin(String userName) throws SQLException,ClassNotFoundException
{
BaseConn conn = null;
try
{
conn = new BaseConn();
String sql="select role from userInfo where nickName=?";
PreparedStatement ps = conn.preparedStatement(sql);
ps.setString(1,userName);
ResultSet rs = conn.executeQuery();
if(rs.next())
{
if(rs.getInt("role")==1)
return true;
else
return false;
}
else
return false;
}catch(SQLException ex)
{
ex.printStackTrace();
throw ex;
}catch(ClassNotFoundException ex)
{
ex.printStackTrace();
throw ex;
}finally
{
conn.closeDB();
}
}
/**
* 将用户踢出聊天室
* */
public void kickUser(String userName,String chatRoom)
throws SQLException ,ClassNotFoundException
{
BaseConn conn = null;
try
{
conn = new BaseConn();
String sql="delete from onlineUser where nickName=? and chatRoom = ?";
PreparedStatement ps = conn.preparedStatement(sql);
ps.setString(1,userName);
ps.setString(2,chatRoom);
conn.executeUpdate();
SimpleDateFormat cal = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
String time = cal.format(new java.util.Date());
//在聊天信息表中添加一条踢人的系统公告
sql = "insert into msgInfo(chatRoom,msgFrom,msgTo,chatTime,msgContent) values(?,?,?,?,?)";
ps = conn.preparedStatement(sql);
ps.setString(1,chatRoom);
ps.setString(2,"system notice");
ps.setString(3,"all people");
ps.setString(4,time);
ps.setString(5,"<font color=red>"+userName+"</font>is kicked out of chatroom by admin !!!");
conn.executeUpdate();
}catch(SQLException ex)
{
ex.printStackTrace();
throw ex;
}catch(ClassNotFoundException ex)
{
ex.printStackTrace();
throw ex;
}finally
{
conn.closeDB();
}
}
/**
* 删除用户
* */
public void deleteUser(String userName)
throws SQLException,ClassNotFoundException
{
BaseConn conn = null;
try
{
conn = new BaseConn();
String sql="delete from onlineUser where nickName=?";
PreparedStatement ps = conn.preparedStatement(sql);
ps.setString(1,userName);
conn.executeUpdate();
sql="delete from userInfo where nickName=?";
ps=conn.preparedStatement(sql);
ps.setString(1,userName);
conn.executeUpdate();
}catch(SQLException ex)
{
ex.printStackTrace();
throw ex;
}catch(ClassNotFoundException ex)
{
ex.printStackTrace();
throw ex;
}finally
{
conn.closeDB();
}
}
}
没有合适的资源?快使用搜索试试~ 我知道了~
JSP 聊天室 chartroom
共82个文件
jsp:34个
jar:12个
class:10个
4星 · 超过85%的资源 需积分: 9 7 下载量 36 浏览量
2011-05-15
20:50:40
上传
评论 2
收藏 3.03MB RAR 举报
温馨提示
<html> <%@ page language="java" pageEncoding="utf-8"%> <head> <script language="javascript" type="text/javascript"> //javascript����λҳ��ê�㣬��ҳ���scroll-bar�õ�ҳ��ĩβ������ʾ���µ�������Ϣ�� function GetPosition() { window.location.hash="position"; } </script> </head> <body onload="GetPosition()" background="images\4.jpg"> <!-- dataValue.jsp��������Ϣ����ݼ���ҳ��--> <iframe src="dataValue.jsp" id="dataValue" style="visibility:hidden; height:0" width="1"></iframe> <!--ע��span��id��loadContent����dataValue.jsp�н�������IDȷ����Ϣ��ʾλ��--> <span id="loadContent">data is loading</span> <!-- ����t��ê�㣬ʵ����scroll-bar��ҳ��ĩβ������ʾ���µ�������Ϣ--> <a id="position"></a> </body> </html>
资源推荐
资源详情
资源评论
收起资源包目录
chartroom.rar (82个子文件)
chartroom
login.jsp 2KB
.project 1KB
chatRoom.jsp 854B
WEB-INF
web.xml 381B
sqlserver
msbase.jar 280KB
mssqlserver.jar 66KB
msutil.jar 58KB
lib
jstl-1.2.jar 407KB
msbase.jar 280KB
mssqlserver.jar 66KB
jsf-api.jar 314KB
jsf-impl.jar 1.15MB
msutil.jar 58KB
classes
net
chat
CheckLogin.class 3KB
BaseConn.class 3KB
ChatRoom.class 4KB
ChatRoomList.class 3KB
Message.class 2KB
chatRoomList.jsp 2KB
changeRoom.jsp 1KB
index.jsp 809B
META-INF
MANIFEST.MF 39B
.mymetadata 300B
WebRoot
login.jsp 3KB
chatRoom.jsp 854B
WEB-INF
web.xml 381B
lib
msbase.jar 280KB
mssqlserver.jar 66KB
msutil.jar 58KB
classes
net
chat
CheckLogin.class 3KB
BaseConn.class 3KB
ChatRoom.class 4KB
ChatRoomList.class 3KB
Message.class 2KB
chatRoomList.jsp 2KB
changeRoom.jsp 1KB
index.jsp 809B
META-INF
MANIFEST.MF 39B
chat.css 531B
show.jsp 775B
kick.jsp 695B
input.jsp 6KB
chklogin.jsp 2KB
images
4.jpg 27KB
2.jpg 73KB
0.gif 2KB
1.jpg 71KB
Thumbs.db 9KB
sendMsg.jsp 2KB
chkSession.jsp 582B
userList.jsp 2KB
logout.jsp 844B
delete.jsp 660B
redirectChatRoom.jsp 910B
dataValue.jsp 3KB
advanced.jsp 4KB
chat.css 531B
.myeclipse
show.jsp 952B
src
net
chat
CheckLogin.java 3KB
ChatRoom.java 5KB
ChatRoomList.java 3KB
BaseConn.java 3KB
Message.java 2KB
kick.jsp 695B
input.jsp 6KB
chklogin.jsp 2KB
images
4.jpg 27KB
2.jpg 73KB
0.gif 2KB
1.jpg 71KB
Thumbs.db 9KB
sendMsg.jsp 2KB
chkSession.jsp 582B
.classpath 574B
userList.jsp 2KB
dabase
chatroom_Log.LDF 1024KB
chatroom_Data.MDF 1024KB
logout.jsp 844B
delete.jsp 660B
redirectChatRoom.jsp 910B
dataValue.jsp 3KB
advanced.jsp 4KB
共 82 条
- 1
资源评论
- Xixilili0082013-01-26用的数据库是sqlserver,很好很不错
tracyailk
- 粉丝: 15
- 资源: 20
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
最新资源
- 上市公司-股票性质数据-工具变量(民企、国企、央企)2003-2022年.dta
- 上市公司-股票性质数据-工具变量(民企、国企、央企)2003-2022年.xlsx
- Reeds+Shepp曲线算法讲解和实现.pdf
- 毕业设计基于SpringBoot+MyBatisPlus+MySQL+Vue的外卖配送信息系统源代码+数据库
- 词向量(Word Embeddings)是自然语言处理(NLP)领域的一种重要技术.txt
- Surfer,线性函数
- MyBatis 的动态 SQL 是其核心特性之一.txt
- 时代的sdddsddsddsd
- 基于哈希链表的简单人员信息管理系统
- 其他类别JdonFramework开源框架 v5.1 Build20071025-jdonframework-5.1.rar
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功