📄 staffeditstudent.jsp

📁 Student Information system
💻 JSP
字号:
<%@ page import="java.sql.*" errorPage="error.jsp" %>
<%
String comment=(String)request.getAttribute("comment");
%>
<%!
String role,name,ur_id,ur_name,ur_contact_person,ur_cp_phone,ur_cp_email,ur_cp_fax,ur_cp_address,uid;%>

<%
uid=request.getParameter("uid");
%>

<%
HttpSession hs=request.getSession(false);
if (hs!= null)
{
	if(!(hs.getAttribute("valid").equals("yes")))
	{
		response.sendRedirect("error.jsp");
	}
	else
	{
		name=(String)hs.getAttribute("name");
		role=(String)hs.getAttribute("role");
	}
}
else
{
	response.sendRedirect("error.jsp");
}
%>

<html>
<head>
<title>Staff EditStudent</title>
<link href="css/styles.css" rel="stylesheet" type="text/css">
<script language="javascript">
function validate()
	{
			if(document.esform.uid.value.length == 0)
			{
				alert("Please Enter the UserID");
				document.esform.uid.focus();
				return false;
			}
			if(document.esform.uname.value.length == 0)
			{
				alert("Please Enter the UserName");
				document.esform.uname.focus();
				return false;
			}
			if(document.esform.upass.value.length == 0)
			{
				alert("Please Enter the Password");
				document.esform.upass.focus();
				return false;
			}
			if(document.esform.upass1.value.length == 0)
			{
				alert("Please Enter the Retype Password");
				document.esform.upass1.focus();
				return false;
			}
			if(document.esform.ucperson.value.length == 0)
			{
				alert("Please Enter the Contact Person");
				document.esform.ucperson.focus();
				return false;
			}
			if(document.esform.uphone.value.length == 0)
			{
				alert("Please Enter the Phone No");
				document.esform.uphone.focus();
				return false;
			}
			if(document.esform.uemail.value.length == 0)
			{
				alert("Please Enter the Email ID");
				document.esform.uemail.focus();
				return false;
			}
			if(document.esform.ufax.value.length == 0)
			{
				alert("Please Enter the Fax");
				document.esform.ufax.focus();
				return false;
			}
			if(document.esform.uaddress.value.length == 0)
			{
				alert("Please Enter the Address");
				document.esform.uaddress.focus();
				return false;
			}
				document.all("alert").innerText = "";
				return true;
	}
</script>
</head>

<form name="esform" method="post" action="StaffEditStudent">
<body  background="back">
<table width="100%"  border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td colspan="3">&nbsp;</td>
  </tr>
  <tr> <td>&nbsp;</td></tr>
  <tr>
    <td width="3%">&nbsp;</td>
  </tr>
  <tr>
	<td width="3%">&nbsp</td>
	<td width="63%"><b><font color="red" size="4">A</font><font color="green">c</font> <font color="orange" size="4">I</font>
    <font color="green" size="4">T</font>&nbsp<font color="red"></b><b>S</b></font>TUDENT <font color="red"><b>I</b></font>NFORMATION<font color="red"> <b>S</b></font>YSTEM</td>
    <td width="30%" class="logout"><p>Welcome<font color="green"><b> <%=name%></b></font> logged in as<font color="red"><b> <%if(role.equals("admin")){%>ADMIN<%}else if(role.equals("staff")){%> STAFF <%}else if(role.equals("student")){%> STUDENT <%}%></font></td>
  </tr>
  <tr>
    <td height="10" colspan="3"></td>
  </tr>
  <tr>
    <td height="30" class="bordertop">&nbsp;</td>
    <td height="30" class="bordertop">&nbsp;</td>
    <td height="30" class="bordertop"><table width="100%" border="0" cellspacing="0" cellpadding="0">
      <tr>
        <td class="logout"><a href="Staff.jsp">Home</a> | <a href="help1.html">Help</a> | <a href="signout.jsp">Logout</a> </td>
        </tr>
    </table></td>
  </tr>
</table>
  
<center><font color="red"><%if(comment==null){}else{%><%=comment%><%}%></font></center>




<table width="35%" border="0" cellpadding="0" cellspacing="0" class="general" align="Center">
<tr><td class="head" colspan="2"><div align=center><b>Edit Student</b></div></td></tr>
<%
try
{
	Class.forName("oracle.jdbc.driver.OracleDriver");
	Connection con=DriverManager.getConnection("jdbc:oracle:thin:@mcalab1:1521:mcalab","project","password");
	Statement st=con.createStatement();
	ResultSet rs=st.executeQuery("select ur_id,ur_name,ur_contact_person,ur_cp_phone,ur_cp_email,ur_cp_fax,ur_cp_address from aituser where ur_id='"+uid+"'");
	while(rs.next())
	
	{
	 	ur_id=rs.getString(1);
	 	ur_name=rs.getString(2);
	 	ur_contact_person=rs.getString(3);
	 	ur_cp_phone=rs.getString(4);
	 	ur_cp_email=rs.getString(5);
	 	ur_cp_fax=rs.getString(6);
	 	ur_cp_address=rs.getString(7);
	%>
		<input type="hidden" name="uid" value="<%=ur_id%>">
		<tr><td width=150>Name*<td><input type="text" name="uname" value="<%=ur_name%>"></tr>
		<tr><td>Password*<td><input type="password" name="upass"></tr>
		<tr><td>Retype Password*<td><input type="password" name="upass1"></tr>
		<tr><td>Contact Person*<td><input type="text" name="ucperson" value="<%=ur_contact_person%>"></tr>
		<tr><td>Phone*<td><input type="text" name="uphone" value="<%=ur_cp_phone%>"></tr>
		<tr><td>Email*<td><input type="text" name="uemail" value="<%=ur_cp_email%>"></tr>
		<tr><td>Fax*<td><input type="text" name="ufax" value="<%=ur_cp_fax%>"></tr>
		<tr><td>Address*<td><textarea name="uaddress" rows=4 cols=15><%=ur_cp_address%></textarea></tr>
	<%
	}
	st.close();
}
catch(Exception e)
{}
%>
</table>
<br>
<!--<center><input type=submit name=submit onClick="return validate()"></center>-->
<center>
<div align="center"><input name="signon" type="image" src="images/submit_button.jpg" width="63" height="29" border="0" onClick="return validate()"></div></td>
</center>
</table>
</body>
</form>
</html>
⌨️ 快捷键说明

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