📄 updatestudentthingresult.jsp

📁 多功能学生宿舍管理系统分布式体系结构

💻 JSP

字号:

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<!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" />
<title>无标题文档</title>
</head>
<%@page import="myweb.DBContent.DBContent,myweb.bean.Studentthing" %>
<body>
<jsp:useBean id="db" class="myweb.DBContent.DBContent"></jsp:useBean>
<jsp:useBean id="s" class="myweb.bean.Studentthing"></jsp:useBean>
<jsp:setProperty name="s" property="*"/>
<%
	String up=request.getParameter("update");
	if(up.equals("modify"))
	{
	//out.println(s.getBuildingid());
	//out.println(s.getHouseid());
	//out.println(s.getStudentid());
		String sql1="update studentthing set computer='"+s.getComputer()+"',mobile='"+s.getMobile()+"',extra='"+s.getExtra()+"' where buildingid='"+s.getBuildingid()+"'and houseid='"+s.getHouseid()+"'and studentid='"+s.getStudentid()+"'";
		db.update(sql1);
		out.println("<script>alert('修改成功！');window.open('../admin/updatestudentthing.jsp','_self')</script>");
	}else if(up.equals("delete"))
	{
		String sql2="delete from studentthing where buildingid='"+s.getBuildingid()+"' and houseid='"+s.getHouseid()+"' and studentid='"+s.getStudentid()+"'";
		db.delete(sql2);
		out.println("<script>alert('删除成功！');window.open('../admin/updatestudentthing.jsp','_self')</script>");
	}
%>
</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -