⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 classmana2.jsp

📁 本程序的功能如下: 1)本程序完全采用jsp脚本技术 2)后台管理
💻 JSP
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@ include file="../conn.jsp"%>
<%request.setCharacterEncoding("GB2312");
if(session.getAttribute("admin")==null){
response.sendRedirect("admin.jsp");
}else{
String str=(String)session.getAttribute("rights");
int flag=Integer.parseInt(str.trim());
 if (flag<1){
 out.print("<br><p align=center>您没有权限操作!</p>");
 }else{
 String submitoption="改名";
  if(submitoption.equals(request.getAttribute("rename"))){
  String sql="Update nclass set nclass='"+request.getParameter("reTitle")+"' and classid='"+request.getParameter("Classid")+"' where nclassid='"+request.getParameter("subject")+"'";
  stmt.executeUpdate(sql);
  }
 String submitoption1="删除";
 if(submitoption.equals(request.getParameter("del"))){
 String sql1="delete from nclass where nclassid='"+request.getParameter("subject")+"'";
 stmt.executeUpdate(sql1);
 String sql2="delete from download where Nclassid='"+request.getParameter("subject")+"'";
 stmt.executeUpdate(sql2);
  }
 String submitoption2="新增";
 if(submitoption2.equals(request.getParameter("new"))){
 String sql4="INSERT INTO nclass(nclass,classid) Values('"+request.getParameter("newTitle")+"','"+request.getParameter("psubject")+"')"; 
 stmt.executeUpdate(sql4); 
  }
  %>
  
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="refresh" content="1;url=classmana.jsp">
<title>修改成功</title>
<style type="text/css">
<!--
body {
	background-color: #799AE1;
}
.style1 {
	color: #FF0000;
	font-weight: bold;
}
-->
</style>
<style type=text/css>
<!--
BODY{
	margin:0px;
	FONT-SIZE: 12px;
	FONT-FAMILY:  "宋体", "Verdana", "Arial", "Helvetica", "sans-serif";
	scrollbar-face-color: #DEE3E7;
	scrollbar-highlight-color: #FFFFFF;
	scrollbar-shadow-color: #DEE3E7;
	scrollbar-3dlight-color: #D1D7DC;
	scrollbar-arrow-color:  #006699;
	scrollbar-track-color: #EFEFEF;
	scrollbar-darkshadow-color: #98AAB1;
	background-color: #D4DEF9;
}
table  { border:0px; }
td  { font:normal 12px 宋体; }
img  { vertical-align:bottom; border:0px; }
a  { font:normal 12px 宋体; color:#000000; text-decoration:none; }
a:hover  { color:#428EFF;text-decoration:underline; }
.sec_menu  { border-left:1px solid white; border-right:1px solid white; border-bottom:1px solid white; overflow:hidden; background:#D6DFF7; }
.menu_title  { }
.menu_title span  { position:relative; top:2px; left:8px; color:#215DC6; font-weight:bold; }
.menu_title2  { }
.menu_title2 span  { position:relative; top:2px; left:8px; color:#428EFF; font-weight:bold; }
input,select,Textarea{
font-family:宋体,Verdana, Arial, Helvetica, sans-serif; font-size: 12px;}
}
.style1 {
	color: #3D6DD3;
	font-weight: bold;
}
-->
</style></head>
<body>
<p align="center" class="style1">&nbsp;</p>
<p align="center" class="style1">类别修改成功!</p>
</body>
</html>
<% stmt.close();
 conn.close();
 }

}

%>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -