?? login_page.jsp
字號:
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<meta http-equiv="Content-Language" content="en-us">
<title>Login Page</title>
</head>
<body bgcolor="#C0C0C0" topmargin="0" background="http:\\localhost:8000\music\Background.bmp" >
<table border="0" width="100%">
<tr>
<td width="100%">
<table border="0" width="97%" height="19">
<tr>
<td width="18%" height="13" valign="middle" align="right">
<font face="Arial" size="5" color="#800000"><b><i>eMusicWorld-----> The World of Music</i></b></font>
</td>
</tr>
</table>
</td>
</tr>
</table>
<form method="GET" action="http://localhost:8000/music/login_page.jsp">
<table border="1" width="100%">
<tr>
<td width="18%">
<p><font face="Arial" size="2" color="#800000"><b><a HREF="http://localhost:8000/music/home_page.htm">Home</a></b></font></p>
<p><b><font face="Arial" size="2" color="#800000"><a HREF="http://localhost:8000/music/chart_toppers.jsp">Chart Toppers</a></font></b></p>
<p><b><font face="Arial" size="2" color="#800000"><a HREF="http://localhost:8000/SearchContext/SearchAlias">Search</a></font></b></p>
<p><b><font face="Arial" size="2" color="#800000"><a HREF="http://localhost:8000/music/vote_page.jsp">Vote</a></font></b></p>
<p><b><font face="Arial" size="2" color="#800000"><a HREF="http://localhost:8000/music/new_release_page.jsp">New Releases</a></font></b>
<p><font face="Arial" size="2" color="#800000"><b><a HREF="http://localhost:8000/music/register_page1.htm">Register</a></b></font>
<p><font face="Arial" size="2" color="#800000"><b><a HREF="http://localhost:8000/music/help_page.htm">Help</a></b></font></p>
<p> </td>
<td width="82%" valign="top">
<p align="center"><font face="Arial" size="2" color="#800000"><b><u>Login Page</u></b></font> </p>
<%! String username;%>
<%! String password;%>
<%! String role;%>
<%@ page import="java.util.*" %>
<%@ page import="java.sql.*" %>
<%@ page import="java.text.*" %>
<%@ page import="java.sql.Date" %>
<%@ page language = "java" %>
<%
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection connect;
connect=DriverManager.getConnection("jdbc:odbc:RegisterDataSource","wasiqr","bhalbabatu");
Statement state;
state = connect.createStatement();
String strQuery1 = "select Password, Role from Login_Info where User_name='"+username+ "'";
username=request.getParameter("username");
password=request.getParameter("password");
ResultSet result1 = state.executeQuery(strQuery1);
String pass;
String user="user";
while(result1.next())
{
pass=result1.getString("Password");
role=result1.getString("Role");
role=role.trim();
if((pass.equals(password))&&(role.equals("user")))
{
role="user";
session.setAttribute("username", username);
}
else if ((pass.equals(password))&&(role.equals("admin"))) role="admin";
else
role="no_user";
}
}
catch(Exception e){
out.println("done exception" +e);
}
Vector vc=new Vector(1,1);
session.setAttribute("Shopping_List",vc);
role=role.trim();
if(role.equals("user")) {%>
<jsp:forward page="user_home_page.jsp" />
<%}
else if (role.equals("admin")){
%>
<jsp:forward page="admin_home_page.htm"/>
<%}
else
out.println("<p><font face=\"Arial\" size=\"2\" color=\"#800000\"><b>You have entered incorrect logon information. Please enter correct logon details.</b></font> </p>");
%>
<p><font face="Arial" size="2" color="#800000">Please enter your logon details.</font> </p>
<p><font face="Arial" size="2" color="#800000">User Name :</font> <input type="text" name="username" size="20">
</p>
<p><font face="Arial" size="2" color="#800000">Password :</font> <input type="password" name="password" size="20"></p>
<p><font face="Arial" size="2" color="#800000">New User? <a HREF="http://localhost:8000/Register/RegisterPage.htm">Register</a></font></p>
<p align="center"><input type="submit" value="Submit" name="B1"><input type="reset" value="Clear" name="B2"></p>
<p> </td>
</tr>
</table>
<p> </p>
<p> </p>
</form>
</body>
</html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -