Package Utils

Class DatabaseConnect

java.lang.Object

Utils.DatabaseConnect

public class DatabaseConnect
extends Object

This class establishes a connection to the database and performs queries.
Additionally, it will update the Inventory automatically based on Order.

Since:

2023-03-07

Field Summary

Fields

Modifier and Type	Field	Description
private Connection	conn	Connection to the server
private final String	dbConnectionString	String that connects to the server
private final String	password	String password credentials
private final String	username	String user name credentials

Constructor Summary

Constructors

Constructor	Description
DatabaseConnect(String dbConnectionString, String username, String password)	Construct a connection to the database

Method Summary

Modifier and Type	Method	Description
ResultSet	executeQuery(String command)	Execute a SQL query.
int	executeUpdate(String command)	Handles the UPDATE, INSERT, and DELETE SQL query.
void	setUpDatabase()	Initialize conn and established a connection to the database.

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Details

conn

private Connection conn

Connection to the server

dbConnectionString

private final String dbConnectionString

String that connects to the server

username

private final String username

String user name credentials

password

private final String password

String password credentials

Constructor Details

DatabaseConnect

public DatabaseConnect(String dbConnectionString,
 String username,
 String password)

Construct a connection to the database

Parameters:

dbConnectionString - connection String

username - user name credentials

password - password credentials

Method Details

setUpDatabase

public void setUpDatabase()

Initialize conn and established a connection to the database.

executeQuery

public ResultSet executeQuery(String command)

Execute a SQL query. This method will NOT handle UPDATE queries. Use executeUpdate(String) instead.

Parameters:

command - query to send to database

Returns:

the ResultSet of the query

executeUpdate

public int executeUpdate(String command)

Handles the UPDATE, INSERT, and DELETE SQL query.

Parameters:

command - update to send to the database

Returns:

the result of the query