<%@ page import="java.sql.*" %>
<%@ page import="javax.sql.*" %>
<%@ page session="true" %>
<%
// Check if user is logged in
String username = (String) session.getAttribute("user");
String email = (String) session.getAttribute("email");
String state = (String) session.getAttribute("state");
String mob_no = (String) session.getAttribute("mob_no");
/*
if (username == null) {
// Not logged in, redirect to login page
response.sendRedirect("SignUp_Login_Form.html");
return;
}
// Set up DB connection parameters - update these as per your environment
String dbURL = "jdbc:mysql://localhost:3306/charge_ev_platform";
String dbUser = "root";
String dbPassword = "password";
Connection conn = null;
PreparedStatement ps = null;
ResultSet rs = null;
String fullName = "";
String email = "";
String phone = "";
String address = "";
try {
Class.forName("com.mysql.cj.jdbc.Driver");
conn = DriverManager.getConnection(dbURL, dbUser, dbPassword);
String sql = "SELECT fullname, email, phone, address FROM users WHERE username = ?";
ps = conn.prepareStatement(sql);
ps.setString(1, username);
rs = ps.executeQuery();
if (rs.next()) {
fullName = rs.getString("fullname");
email = rs.getString("email");
phone = rs.getString("phone");
address = rs.getString("address");
} else {
// User not found in DB (unlikely since logged in)
fullName = "Unknown User";
}
} catch (Exception e) {
e.printStackTrace();
} finally {
if (rs != null) try { rs.close(); } catch (Exception e) {}
if (ps != null) try { ps.close(); } catch (Exception e) {}
if (conn != null) try { conn.close(); } catch (Exception e) {}
}
*/
%>
Profile - Charge EV Platform
Welcome, <%= username %>!
Your profile details:
<%= email %>
<%= mob_no %>
<%= state %>
Logout