📄 mess_del.jsp
字号:
<%@ page language="java" pageEncoding="GB2312"%>
<%@ page import="java.sql.*" %>
<jsp:useBean id="DB1" scope="page" class="ConnBean.conn"/>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>My JSP 'admin_del.jsp' starting page</title>
<!--
<link rel="stylesheet" type="text/css" href="styles.css">
-->
</head>
<body BGCOLOR="#FFCCCC">
<%
int PageSize=5;
int CurPage=1;
int TotalPage=0;
int RecCount=0;
if(request.getParameter("page")!=null){
CurPage=Integer.parseInt(request.getParameter("page"));}
ResultSet rss=null;
try{
String strSQL="select count(*) as RecCount from message";
rss=DB1.executeQuery(strSQL);
if(rss.next()){
RecCount=rss.getInt("RecCount");
}
rss=null;
TotalPage=RecCount/PageSize+(RecCount%PageSize==0?0:1);
strSQL="select top "+PageSize+" * from message where ID not in " +
"(select top "+(CurPage-1)*PageSize+" ID from message)";
rss=DB1.executeQuery(strSQL);
//rs.next();
//out.print(rs.getString("ID"));
while(rss.next()){
String messno=rss.getString("ID");
int count=0;
if(request.getParameter("check"+messno)!=null)
{
//out.println(rs2.getString("AdminID"));
String str1="delete from message where ID='"+messno+"'";
//out.print(str1);
count=DB1.executeUpdate(str1);
out.print("<BR>");
//out.println(count);
}
}
//response.sendRedirect("admin.jsp");
}catch(SQLException e){out.print(e);}
out.println("<script language=javascript>");
out.println("alert('恭喜你,删除成功!');");
out.println("window.location.href='message.jsp';");
out.println("</script>");
%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -