📄 forgotpasswordresult.jsp
字号:
<%@ page import="java.sql.*" errorPage="error.jsp"%>
<%
String comment=(String)request.getAttribute("comment");
%>
<%!
String usn,email,dbusername,dbpassword,dbrole,role,uid,name,ur_id,ur_name,ur_cp_pass,ur_contact_person,ur_cp_phone,ur_cp_email,ur_cp_fax;
%>
<%
usn=request.getParameter("usn");
role=request.getParameter("role");
%>
<html>
<title> ForgotPasssword</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 width="3%"> </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%"><p class="logged">Welcome Guest! </p></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="login.jsp">Home</a> | <a href="help.html">Help</a></td>
</tr>
</table></td>
</tr>
</table>
<br>
<br>
<center><font color="red"><%if(comment==null){}else{%><%=comment%><%}%></font></center>
<table width="30%" border="0" cellpadding="0" cellspacing="0" class="general" align="Center">
<tr><td class="head">Password</td></tr>
<%
HttpServletRequest req;
HttpServletResponse res;
RequestDispatcher rd=null;
//rd=req.getRequestDispatcher("ForgotPassword.jsp");
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 username,password,role from login where username='"+usn+"'");
if(rs.next())
{
dbusername=rs.getString(1);
dbpassword=rs.getString(2);
dbrole=rs.getString(3);
if(role.equals(dbrole))
{
%>
<tr><td><font color="green"><%=dbpassword%></font></td></tr>
<%
}
else
{
%>
<tr><td>Please Enter Correct Role</td></tr>
<%
}
}
else
%>
<tr><td>Please Enter Correct Details</td></tr>
<%
st.close();
}
catch(Exception e)
{
e.printStackTrace();
}
%>
</table>
</body>
</form>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -