Database Connection Utility Class
package com.database;
import java.sql.*;
public class DBConnector {
private static final String DB_URL = "jdbc:mysql://127.0.0.1:3306/health_db";
private static final String DB_USER = "admin";
private static final String DB_PASS = "secure123";
public static Connection createConnection() {
Connection conn = null;
try {
Class.forName("com.mysql.cj.jdbc.Driver");
conn = DriverManager.getConnection(DB_URL, DB_USER, DB_PASS);
} catch (ClassNotFoundException | SQLException ex) {
System.err.println("Connection error: " + ex.getMessage());
}
return conn;
}
public static void releaseResources(ResultSet result) {
if (result != null) {
try {
result.close();
} catch (SQLException e) {
System.err.println("ResultSet close error: " + e.getMessage());
}
}
}
public static void releaseResources(Statement stmt) {
if (stmt != null) {
try {
stmt.close();
} catch (SQLException e) {
System.err.println("Statement close error: " + e.getMessage());
}
}
}
public static void releaseResources(Connection connection) {
if (connection != null) {
try {
connection.close();
} catch (SQLException e) {
System.err.println("Connection close error: " + e.getMessage());
}
}
}
}
Mental Health Asesssment JSP Implementation
<%@ page import="com.models.Assessment" %>
<%@ page import="com.services.AssessmentService" %>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
<title>Assessment Results</title>
<style>
.assessment-card {
background: white;
border-radius: 10px;
padding: 25px;
width: 500px;
margin: 50px auto;
box-shadow: 0 2px 10px rgba(0,0,0,0.1);
}
.result-header {
font-size: 24px;
margin-bottom: 20px;
}
.result-value {
font-size: 20px;
margin: 15px 0;
}
.action-btn {
background: #4285f4;
color: white;
padding: 10px 20px;
border: none;
border-radius: 5px;
cursor: pointer;
margin-top: 20px;
}
</style>
</head>
<body>
<div class="assessment-card">
<%
int cognition = Integer.parseInt(request.getParameter("cognition"));
int aggression = Integer.parseInt(request.getParameter("aggression"));
int depression = Integer.parseInt(request.getParameter("depression"));
int total = cognition + aggression + depression;
String diagnosis;
if (total == 0) {
diagnosis = "Normal cognitive function";
} else if (total == 1) {
diagnosis = "Mild impairment";
} else if (total <= 3) {
diagnosis = "Moderate impairment";
} else {
diagnosis = "Severe impairment";
}
Assessment assessment = new Assessment();
String currentUser = (String) session.getAttribute("currentUser");
assessment.setUserId(currentUser);
assessment.setCognitionScore(cognition);
assessment.setAggressionScore(aggression);
assessment.setDepressionScore(depression);
assessment.setTotalScore(total);
assessment.setDiagnosis(diagnosis);
AssessmentService service = new AssessmentService();
service.saveAssessment(assessment);
%>
<h2 class="result-header">Assessment Complete</h2>
<div class="result-value">Diagnosis: <%= diagnosis %></div>
<div class="result-value">Total Score: <%= total %></div>
<button class="action-btn" onclick="location.href='/dashboard.jsp'">Return to Dashboard</button>
</div>
</body>
</html>