Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <%@ page language="java" contentType="text/html; charset=ISO-8859-1"
- pageEncoding="ISO-8859-1"%>
- <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
- <%@ page import="java.sql.*"%>
- <%
- String connectionURL = "jdbc:mysql://localhost:3306/bank";
- Connection connection = null;
- Statement statement = null;
- %>
- <html>
- <head>
- <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
- <title>Login</title>
- </head>
- <body>
- <%
- Class.forName("com.mysql.jdbc.Driver").newInstance();
- connection = DriverManager.getConnection(connectionURL, "root", "1029384756");
- statement = connection.createStatement();
- ResultSet rs = statement.executeQuery("SELECT * FROM users");
- String usrname = request.getParameter("usrname").trim();
- String pass = request.getParameter("passwrd").trim();
- if (usrname == null || pass == null) {
- %>
- <center>
- <h1> Insert your credentials</h1>
- <br/>
- <form name="form1" method ="post" action="login.jsp">
- Username: <br/>
- <input type=text name= "usrname" />
- <br/>
- Password: <br/>
- <input type=password name= "passwrd" />
- <br/>
- <br/>
- <input type=submit name = "submit" value="Submit"/>
- <input type=reset value="Reset"/>
- </form>
- </center>
- </body>
- </html>
- <% }
- else {
- while (rs.next()) {
- if (usrname.equals(rs.getString("username"))){
- if (pass.equals(rs.getString("password")) && rs.getBoolean("isAdmin")){
- %>
- <jsp:forward page="confirm.jsp" />
- <%
- rs.close();
- }
- else if (pass.equals(rs.getString("password")) && !rs.getBoolean("isAdmin")){
- %>
- <jsp:forward page="transfer.jsp" />
- <%
- rs.close();
- }
- else {
- %>
- <jsp:forward page="login.jsp" />
- <%
- rs.close();
- }
- }
- }
- rs.close();
- }
- %>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement