📄 liao.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="../error/error.jsp" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<meta http-equiv="refresh" content="2" />
<title>聊天室</title>
<link rel="stylesheet" type="text/css" href="../image/com.css" />
<jsp:useBean id="time" class="useBean.Usetime" scope="request" />
<jsp:useBean id="liao" class="useBean.Link_db" scope="page" />
</head>
<body>
<div align="center" class="style8">欢迎来到紫宇轩聊天室</div>
<br>
<div align="center" class="style5">请您正常离开聊天室</div>
<hr>
<%
try{
String sqls="SELECT * FROM liaotian ";
Connection con=useBean.Link_db.getCon();
Statement state=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
ResultSet rs=state.executeQuery(sqls);
rs.absolute(-18);
while(rs.next()){
String nowtime1=rs.getString("发送时间");
String username1=rs.getString("发送人");
String biaoqing1=rs.getString("表情");
String selcolor=rs.getString("字颜色");
String lname1=rs.getString("接受人");
String said1=rs.getString("聊天纪录");
%>
<div align="justify">
<%=nowtime1%> <a class="style11"><%=username1%></a><a class="style21"><%=biaoqing1%></a>对<a class="style24"><%=lname1%></a>说：<font color="<%=selcolor%>"><%=said1%></font>
</div>
<%
}
liao.close();
}catch(Exception e){
out.print(e);
}
%></body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -