loginAction.js

 <%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>


<%@ page import="java.sql.*" %>


<!DOCTYPE html>


<html>


<head>


<meta charset="UTF-8">


<title>Login Result</title>


</head>


<body>


<%


String customerId = request.getParameter("customerId");


String password = request.getParameter("password");




// Placeholder for database connection


Connection conn = null;


PreparedStatement pstmt = null;


ResultSet rs = null;




// You need to set up your database connection here


try {


Class.forName("com.mysql.cj.jdbc.Driver"); // Load MySQL driver


conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/yourdatabase", "username", "password");




String sql = "SELECT * FROM customers WHERE customer_id = ?";


pstmt = conn.prepareStatement(sql);


pstmt.setString(1, customerId);


rs = pstmt.executeQuery();




if (rs.next()) {


String storedPassword = rs.getString("password");




if (storedPassword.equals(password)) {


response.sendRedirect("home.jsp");


} else {


out.println("<p>Password not valid</p>");


}


} else {


out.println("<p>ID not valid</p>");


}


} catch (Exception e) {


e.printStackTrace();


out.println("<p>An error occurred. Please try again later.</p>");


} finally {


if (rs != null) try { rs.close(); } catch (SQLException e) { e.printStackTrace(); }


if (pstmt != null) try { pstmt.close(); } catch (SQLException e) { e.printStackTrace(); }


if (conn != null) try { conn.close(); } catch (SQLException e) { e.printStackTrace(); }


}


%>


<p><a href="login.jsp">Go back to login</a></p>


</body>


</html>

Comments

Post a Comment

Popular posts from this blog

fruit.jsp

 <%@ page language="java" contentType="text/html; charset=ISO-8859-1"     pageEncoding="ISO-8859-1"%>     <%@ page import="cart.CartItem" %>      <!DOCTYPE html> <html lang="en"> <head>   <meta charset="ISO-8859-1">     <meta name="viewport" content="width=device-width, initial-scale=1.0">     <title>Online Grocery Store - Home</title>     <link rel="stylesheet" href="home.css">     <script src="js/script.js" defer></script> </head> <body>     <header>         <div class="header-container">             <h1>Online Grocery Store</h1>             <nav>                 <a href="home.jsp">Home</a>                 <...
Read more
const btnCart = document.querySelector('#cart-icon'); const cart = document.querySelector('.cart'); const btnClose = document.querySelector('#cart-close'); btnCart.addEventListener('click', () => { cart.classList.add('cart-active'); }); btnClose.addEventListener('click', () => { cart.classList.remove('cart-active'); }); document.addEventListener('DOMContentLoaded', () => { loadContent(); loadFood(); }); function loadFood() { // Any initialization related to food items can be placed here } function loadContent() { // Retrieve item list from localStorage itemList = JSON.parse(localStorage.getItem('cartItems')) || []; // Remove Food Items From Cart let btnRemove = document.querySelectorAll('.cart-remove'); btnRemove.forEach((btn) => { btn.addEventListener('click', removeItem); }); // Product Item Change Event let qtyElements = document.querySelectorAll('.ca...
Read more
/* General Styles */ body {     font-family: Arial, sans-serif;     background-color: #f4fdf4; /* Light green background */     color: #333;     margin: 0;     padding: 0; } /* Header and Navigation */ header {     background-color: #2d572c; /* Dark green */     color: white;     padding: 10px 20px;     position: sticky;     top: 0;     z-index: 1000; } .header-container {     display: flex;     justify-content: space-between;     align-items: center; } nav {     display: flex;     justify-content: space-between;     width: 100%;     align-items: center; } .nav-left, .nav-center, .nav-right {     display: flex;     align-items: center; } .nav-center {     justify-content: center;     flex-grow: 1; } .nav-link {     color: white;     text-decoration: n...
Read more