📄 do_updateroomjsp.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>
do_UpdateRoomJsp
</title>
</head>
<body bgcolor="#008080">
<h1>
房间管理
</h1>
<%
String type=request.getParameter("type");
String getCount=request.getParameter("count");
dbBean.connect();
String sql="select * from room_info";
ResultSet rs=dbBean.openRs(sql);
rs.setFetchDirection(rs.FETCH_REVERSE);
if(type.compareTo("1")==0)
{
for(int i=1;i<=Integer.parseInt(getCount);i++)
{
String check;
check=request.getParameter("room"+Integer.toString(i));
if(check!=null)
{
if(check.compareTo("yes")==0)
{
rs.absolute(i);
rs.deleteRow();
out.print("删除房间"+Integer.toString(i)+"成功！");
}
}
}
}
else if(type.compareTo("2")==0)
{
String roomname=new String();
String roomnum=new String();
roomname=request.getParameter("upname");
roomnum=request.getParameter("upmembernum");
sql="insert into room_info (room_name,room_max_member) values('"+roomname+"','"+roomnum+"')";
if(dbBean.executeSql(sql))
out.print("增加");
}
%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -