📄 stusearchstudentresult.jsp
字号:
<%@ page import="java.sql.*" errorPage="error.jsp"%>
<%
String comment=(String)request.getAttribute("comment");
%>
<%
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");
}
%>
<%!
String role,sid,name,ur_id,ur_name,ur_contact_person,ur_cp_phone,ur_cp_email,ur_cp_fax,uid;
%>
<%
sid=request.getParameter("sid");
%>
<html>
<title>Student SearchStudentResult</title>
<link href="css/styles.css" rel="stylesheet" type="text/css">
<form name="lform" method=post action="">
<body background="back">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td colspan="3"> </td>
</tr>
<tr> <td> </td></tr>
<tr>
<td width="3%"> </td>
</tr>
<tr>
<td> </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> <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"> </td>
<td height="30" class="bordertop"> </td>
<td height="30" class="bordertop"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="logout"><a href="Student.jsp">Home</a> | <a href="help2.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="80%" border="0" cellpadding="0" cellspacing="0" class="general" align="Center">
<tr><td class="head">UserID<td class="head">Name<td class="head">Contact Person<td class="head">Phone<td class="head">Email<td class="head">Fax</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 from aituser where ur_id='"+sid+"'");
if(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);
%>
<tr><td><div align=center><%=ur_id%></div><td><div align=center><%=ur_name%></div><td><div align=center><%=ur_contact_person%></div><td><div align=center><%=ur_cp_phone%></div><td><div align=center><%=ur_cp_email%></div><td><div align=center><%=ur_cp_fax%></div></tr>
<%
}
else
{
%><tr>
<table width="80%" border="0" cellpadding="0" cellspacing="0" class="general" align="Center">
<tr><td><div align=center><font color="green">No Records Found</font><font color="red"> !!!</div></td></tr></table></tr>
<%
}
st.close();
}
catch(Exception e)
{
e.printStackTrace();
}
%>
</table>
<br>
</body>
</form>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -