📄 message.java
字号:
package net.chat;
import java.text.SimpleDateFormat;
import java.sql.*;
public class Message{
private String chatRoom;//聊天房间
private String msgForm;//消息发送者
private String msgTo;//消息接收者
private String chatAction;//聊天表情
private String msgContent;//消息内容
private int secret;//是否悄悄话
public void setChatRoom(String chatRoom)
{
this.chatRoom=chatRoom;
}
public void setMsgForm(String msgForm)
{
this.msgFrom=msgFrom;
}
public void setMsgTo(String msgTo)
{
this.msgTo=msgTo;
}
public void setChatAction(String chatAction)
{
this.chatAction=chatAction;
}
public void setMsgContent(String msgContent)
{
this.msgContent=msgContent;
}
//是否是悄悄话
public void setSecret(int secret)
{
this.secret=secret;
}
//将message对象保存到数据库msgInfo表中的方法
public boolean saveToDataBase()throws SQLException,Class NotFoundException
{
BaseConn conn=null;
try
{
conn=new BaseConn();
SimpleDateFormat cal=new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
String time=cal.format(new java.util.Date());
String sql="insert into msgInfo(chatRoom,msgForm,msgTo,charTime,chatAction,
msgContent,secret)values(?,?,?,?,?,?,?)";
PreparedStatement ps=conn.preparedStatement(sql);
ps.setString(1,chatRoom);
ps.setString(2,msgFrom);
ps.setString(3,msgTo);
ps.setString(4,time);
ps.setString(5,chatAction);
ps.setString(6,msgContent);
ps.setString(7,secret);
conn.executeUpdate();
sql="update onlineUser set lastChatTime=?where nickName=?and chatRoom="?";
ps=conn.preparedStatement(sql);
ps.setString(1,time);
ps.setString(2,msgFrom);
ps.setString(3,chatRoom);
conn.executeUpdate();
reture true;
}catch(SQLException ex)
{
ex.printStackTrace();
throw ex;
}catch(ClassNotFoundException ex)
{
ex.printStackTrace();
throw ex;
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -