updatestu.jsp

来自「高校毕业生答辩安排管理系统」· JSP 代码 · 共 28 行

JSP
28
字号
<%@ page contentType="text/html;charset=gb2312" %>
<%@ include file="../incoming/common.jsp"%>
<html>
<head>
<title>答辩安排</title>
<link href="../incoming/style.css" rel="stylesheet" type="text/css">
</head>
<body>
<div align="center"><br>
<%
		String isbn = new String(request.getParameter("isbn").trim().getBytes("ISO-8859-1"));
		String number = new String(request.getParameter("number").trim().getBytes("ISO-8859-1"));
		String pwd = new String(request.getParameter("pwd").trim().getBytes("ISO-8859-1"));
		String name = new String(request.getParameter("name").trim().getBytes("ISO-8859-1"));
		String sex = new String(request.getParameter("sex").trim().getBytes("ISO-8859-1"));
		String xueyuan = new String(request.getParameter("xueyuan").trim().getBytes("ISO-8859-1"));
		String zhuanye = new String(request.getParameter("zhuanye").trim().getBytes("ISO-8859-1"));
		DBSQLManager dbsm = new DBSQLManager();
		String sql="UPDATE student SET number='"+number+"',pwd='"+pwd+"',name='"+name+"',sex='"+sex+"',xueyuan='"+xueyuan+"',zhuanye='"+zhuanye+"' WHERE id='"+isbn+"'";
		dbsm.setSqlStr(sql);
		dbsm.executeUpdate();
		dbsm.close();
		out.print("<script>alert('修改学生成功!');location.href='mainstu.jsp';</script>");  
%>

</body>
</html>

⌨️ 快捷键说明

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