📄 updatestudentresult.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.Student" %>
<body>
<p>
  <jsp:useBean id="db" class="myweb.DBContent.DBContent">
  </jsp:useBean>
  <jsp:useBean id="st" class="myweb.bean.Student">
  </jsp:useBean>
  <jsp:setProperty name="st" property="*"/>
  <%
	String sql1="update student set name='"+st.getName()+"',sex='"+st.getSex()+"',homeaddress='"+st.getHomeaddress()+"',years='"+st.getYears()+"',nianzhi='"+st.getNianzhi()+"',academe='"+st.getAcademe()+"',department='"+st.getDepartment()+"',profession='"+st.getProfession()+"',classes='"+st.getClasses()+"' where studentid='"+st.getStudentid()+"'";
    String sql2="update studenthouse set buildingid='"+st.getBuildingid()+"',houseid='"+st.getHouseid()+"',intime='"+st.getIntime()+"' where studentid='"+st.getStudentid()+"'";
	db.update(sql1);
	db.update(sql2);
	out.println("<script>alert('修改成功！');window.open('../admin/updatestudent.jsp','_self')</script>");
	//response.sendRedirect("../admin/updatestudent.jsp");
    //response.sendRedirect("../admin/updatestudent.jsp");
%>
</p>
</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -