📄 updatehousethingresult.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.Housething" %>
<body>
<jsp:useBean id="db" class="myweb.DBContent.DBContent"></jsp:useBean>
<jsp:useBean id="h" class="myweb.bean.Housething"></jsp:useBean>
<jsp:setProperty name="h" property="*"/>
<%
	String up=request.getParameter("update");
	if(up.equals("modify"))
	{
		String sql1="update housethings set doorcount='"+h.getDoorcount()+"',doorstatus='"+h.getDoorstatus()+"',bedcount='"+h.getBedcount()+"',bedstatus='"+h.getBedstatus()+"',cupboardcount='"+h.getCupboardcount()+"',cupboardstatus='"+h.getCupboardstatus()+"',deskcount='"+h.getDeskcount()+"',deskstatus='"+h.getDeskstatus()+"',chaircount='"+h.getChaircount()+"',chairstatus='"+h.getChairstatus()+"',lampcount='"+h.getLampcount()+"',lampstatus='"+h.getLampstatus()+"',fancount='"+h.getFancount()+"',fanstatus='"+h.getFanstatus()+"',extra='"+h.getExtra()+"' where buildingid='"+h.getBuildingid()+"' and houseid='"+h.getHouseid()+"'";
		db.update(sql1);
		out.println("<script>alert('修改成功！');window.open('../admin/updatehousething.jsp','_self')</script>");
	}else if(up.equals("delete"))
	{
		String sql2="delete from housethings where buildingid='"+h.getBuildingid()+"' and houseid='"+h.getHouseid()+"'";
		db.delete(sql2);
		out.println("<script>alert('删除成功！');window.open('../admin/updatehousething.jsp','_self')</script>");
	}
%>
</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -