📄 setroomjsp.jsp
字号:
<%@ page contentType="text/html; charset=GBK" %>
<%@ page import="java.sql.*" %>
<%@ page import="chatroomweb.*"%>
<jsp:useBean id="dbBean" scope="page" class="chatroomweb.DbJspBean"></jsp:useBean>
<html>
<head>
<title>
SetRoomJsp
</title>
</head>
<body bgcolor="#008080">
<h1>
房间管理
</h1>
<%
int room_count=0;
ResultSet rs;
int i=0;
try
{
dbBean.connect();
String sql="select * from room_info";
rs=dbBean.openRs(sql);
while(rs.next())
{
room_count++;
}
rs.close();
} //检查房间数
catch(Exception e)
{
}
finally
{
}
// 显示
%>
<p align="center"><h3>现有房间<%=room_count%>间</h3></p>
<form method="POST" action="do_UpdateRoomJsp.jsp">
<input type="hidden" name="type" value="1">
<input type="hidden" name="count" value=<%=Integer.toString(room_count)%>>
<div align="center">
<center>
<table border="1" width="50%" cellpadding="2">
<tr>
<td width="50%" align="left"><b><font face=""楷体_GB2312>房间名称</font></b></td>
<td width="50%" align="left"><b><font face=""楷体_GB2312>容纳最大人数</font></b></td>
<td width="10%" align="left"><b><font face=""楷体_GB2312>点选</font></b></td>
</tr>
<%
String roomname;
String roomnum;
String sql="select * from room_info";
rs=dbBean.openRs(sql);
while(rs.next())
{
i++;
roomname=rs.getString("room_name");
roomnum=rs.getString("room_max_member");
%>
<tr>
<td width="40%" align="left"><b><font face=""楷体_GB2312><%=roomname%></font></b></td>
<td width="40%" align="left"><b><font face=""楷体_GB2312><%=roomnum%></font></b></td>
<td width="20%"><p> <input type="checkbox" name=<%="room"+Integer.toString(i)%> value="yes"></p></td>
</tr>
<%
}
%>
</table>
</center>
</div>
<p align="center"><input type="submit" value="删除" name="B1" >
</form >
<form method = "POST"action="do_UpdateRoomJsp.jsp">
<input type="hidden" name = "type"value="2">
<input type="hidden" name="count" value=<%=Integer.toString(room_count)%>>
<table align ="center" border="1" width="50%" cellpadding="2">
<tr>
<td width="100%" colspan="2"><font color="#00FFFF">输入房间参数</font></td>
</tr>
<tr>
<td width="39%" align="left"><b><font face="楷体_GB2312">房名</font></b></td>
<td width="66%"><input type="text" name="upname" size="20" > </td>
</tr>
<tr>
<td width="39%" align="left"><b><font face="楷体_GB2312">最大成员数</font></b></td>
<td width="66%"><input type="text" name="upmembernum" size="20" > </td>
</tr>
</table>
<p align="center"><input align="center" type="submit" value="增添房间" name="B2">
</form>
</body>
</html>
%>
-->
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -