📄 login_page.jsp
字号:
<html>
<head>
<title>Money Banks, Inc. -- Login Page</title>
</head>
<body bgproperties="fixed" bgcolor="#CCCCFF">
<form name="form" method="POST">
<%@ page import="java.util.*" %>
<%@ page import="java.sql.*" %>
<%@ page import="java.text.*" %>
<%@ page import="java.sql.Date" %>
<%@ page language = "java" %>
<%! int flag=0; %>
<%! int ctr=0; %>
<%
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection connect;
connect=DriverManager.getConnection("jdbc:odbc:BankDataSource","","");
Statement state;
String actNumber,actNo, password,pwd;
state = connect.createStatement();
actNumber=(String)request.getParameter("txtActNumber");
password=(String)request.getParameter("txtUsrPwd");
password=password.trim();
actNumber=actNumber.trim();
out.println("You have provided incorrect information.Click cancel to go to home page.");
String strQuery1 = "select * from Login_Info where Account_No='" + actNumber +"'";
ResultSet result1 = state.executeQuery(strQuery1);
while(result1.next())
{
actNo=(String)result1.getString("Account_No");
pwd=(String)result1.getString("Password");
actNo=actNo.trim();
pwd=pwd.trim();
if((actNo.equals(actNumber))&&(pwd.equals(password))&&(actNo.length()!=0)&&(pwd.length()!=0))
{
flag=1;
%>
<jsp:forward page="actDetails.jsp"/>
<%
}
}
}
catch(Exception e)
{
}
%>
<p align="center"></p>
<table border="0" width="100%" height="42">
<tr>
<td width="50%" height="36"><b><font size="5" ><i>Money Banks, Inc.</i></font></b></td>
<td width="50%" height="36"></td>
</tr>
</table>
<p align="center"><b><font size="4" >Login Information</font></b></p>
<p ><font >Account Number: </font><input type="text" name="txtActNumber" size="20"></p>
<p ><font >Password:
</font><input type="password" name="txtUsrPwd" size="20"> </p>
<p align="center"><input type="submit" value="View Account Details" name="login" > <input type="button" value="Cancel" name="cancel" onClick="Home()"></p>
</form>
<p > </p>
<script language="JavaScript">
function Home()
{
open("Home_page.htm");
}
</script>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -