IT Practical Assessment Task 2023 - Medication Management System - Code Dump

MEDITRACK
PHASE 3




Michaelhouse
231094020121

,15 October 2023 231094020121



DBManager Class
package meditrackapp;



import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.util.ArrayList;

import java.util.List;

/**

*

* @author abevi

*/

public class DBManager

{

//Andrew Beviss-Challinor



Page | 1

,15 October 2023 231094020121



private static Connection conn = null;



//Connect to DB

public DBManager()

{

try

{

if (conn == null)

{

Class.forName("com.mysql.cj.jdbc.Driver");

conn = DriverManager.getConnection("jdbc:mysql://localhost/meditrackapp?"

+ "user=root&password=password");

System.out.println("Connected Successfully");

}

}

catch (Exception e)


Page | 2

, 15 October 2023 231094020121



{

System.out.println("ERROR : " + e);

}

}



//Get student from DB

public ArrayList<Student> getStudents()

{

ArrayList<Student> output = new ArrayList<Student>();



String sql = "SELECT * FROM tblstudents";



try

{

PreparedStatement p = conn.prepareStatement(sql);

ResultSet rs = p.executeQuery();


Page | 3