Index (io.github.coho04:MYSQL-Api 5.7.6 API)

A B C D E F G H I J M N O P Q R S T U V W Y
All Classes and Interfaces|All Packages|Serialized Form

A

addColumn(String) - Method in class io.github.coho04.mysql.entities.Table: Adds a column to the table with the given name.
ALL - Enum constant in enum class io.github.coho04.mysql.entities.enums.Permissions: Represents the permission for all operations.

B

BIGINT - Enum constant in enum class io.github.coho04.mysql.entities.enums.MysqlTypes: Represents a variable of type BIGINT.
BINARY - Enum constant in enum class io.github.coho04.mysql.entities.enums.MysqlTypes: Represents a binary value.
BIT - Enum constant in enum class io.github.coho04.mysql.entities.enums.MysqlTypes: Enumeration representing the variable "BIT".
BLOB - Enum constant in enum class io.github.coho04.mysql.entities.enums.MysqlTypes: Represents a BLOB (Binary Large OBject).
BOOLEAN - Enum constant in enum class io.github.coho04.mysql.entities.enums.MysqlTypes: The BOOLEAN enum represents the boolean MySQL data type.
build() - Method in class io.github.coho04.mysql.entities.RowBuilder: Builds and returns a HashMap containing the key-value pairs that were inserted using the with() method.

C

callException(Exception) - Method in class io.github.coho04.mysql.errors.ExceptionHandler: Throws an exception and takes action based on the configuration flags.
callException(Exception) - Method in class io.github.coho04.mysql.MYSQL: This method is used to handle exceptions.
CHAR - Enum constant in enum class io.github.coho04.mysql.entities.enums.MysqlTypes: The CHAR variable represents a character type in Java.
close() - Method in class io.github.coho04.mysql.MYSQL: Closes the connection to the MySQL server.
closeConnection() - Method in class io.github.coho04.mysql.MYSQL: Closes the connection to the MySQL server.
closeRsAndSt(ResultSet, Statement) - Method in class io.github.coho04.mysql.MYSQL: Closes the given ResultSet and Statement objects.
Column - Class in io.github.coho04.mysql.entities: Represents a column in a database table.
Column(String, Table, MYSQL) - Constructor for class io.github.coho04.mysql.entities.Column: Initializes a new instance of the Column class with the given name, table, and MYSQL object.
countColumn() - Method in class io.github.coho04.mysql.entities.Table: Retrieves the number of columns in the table.
countRows() - Method in class io.github.coho04.mysql.entities.Table: Retrieves the number of rows in the database table.
createDatabase(String) - Method in class io.github.coho04.mysql.MYSQL: This method is used to create a new database.
createTable(String) - Method in class io.github.coho04.mysql.entities.Database: Creates a new table with the given name.
createTable(String, String[]) - Method in class io.github.coho04.mysql.entities.Database: Creates a new table with the given name and columns (if specified).
createTable(String, List<String>) - Method in class io.github.coho04.mysql.entities.Database: Creates a new table with the given name and columns.
createUser(String, String) - Method in class io.github.coho04.mysql.MYSQL: Creates a user in the MySQL server.
createUser(String, String, Boolean) - Method in class io.github.coho04.mysql.MYSQL: Creates a user in the MySQL server.
customExecute(String) - Method in class io.github.coho04.mysql.MYSQL: Executes the given SQL statement.

D

Database - Class in io.github.coho04.mysql.entities: The Database class represents a database in a MySQL server.
Database(String, MYSQL) - Constructor for class io.github.coho04.mysql.entities.Database: Creates a new instance of the Database class.
DATE - Enum constant in enum class io.github.coho04.mysql.entities.enums.MysqlTypes: This is a constant variable representing a date.
DATETIME - Enum constant in enum class io.github.coho04.mysql.entities.enums.MysqlTypes: Represents a variable indicating the datetime.
DECIMAL - Enum constant in enum class io.github.coho04.mysql.entities.enums.MysqlTypes: The DECIMAL enum represents the decimal MySQL data type.
DELETE - Enum constant in enum class io.github.coho04.mysql.entities.enums.Permissions
describe() - Method in class io.github.coho04.mysql.entities.Table: Returns the description of the table.
DOUBLE - Enum constant in enum class io.github.coho04.mysql.entities.enums.MysqlTypes: Represents a variable of type double.
drop() - Method in class io.github.coho04.mysql.entities.Column: Drops the column from the table in the database.
drop() - Method in class io.github.coho04.mysql.entities.Database: Drops the database.
drop() - Method in class io.github.coho04.mysql.entities.Row: Deletes the row from the database table associated with this object.
drop() - Method in class io.github.coho04.mysql.entities.Table: Drops the table from the database.
drop(boolean) - Method in class io.github.coho04.mysql.entities.User: Drops the user from the database.
dropRow(int) - Method in class io.github.coho04.mysql.entities.Table: Drops a row from the database table based on the provided ID.

E

ExceptionHandler - Class in io.github.coho04.mysql.errors: The ExceptionHandler class handles exceptions and takes action based on the configuration flags.
ExceptionHandler() - Constructor for class io.github.coho04.mysql.errors.ExceptionHandler: The ExceptionHandler class handles exceptions and takes action based on the configuration flags.
EXECUTE - Enum constant in enum class io.github.coho04.mysql.entities.enums.Permissions: Represents the permission for executing a procedure or function in a database.
executeQuery(String, QueryHelper.ResultSetHandler<T>, MYSQL) - Method in interface io.github.coho04.mysql.interfaces.QueryHelper: Executes a query on the database and returns the result.
executeQuery(String, QueryHelper.ResultSetHandler<T>, MYSQL, String) - Method in interface io.github.coho04.mysql.interfaces.QueryHelper: Executes a query on the database and returns the result.
executeUpdate(String, MYSQL) - Method in interface io.github.coho04.mysql.interfaces.QueryHelper: Executes an update query on the database.
executeUpdate(String, MYSQL, String) - Method in interface io.github.coho04.mysql.interfaces.QueryHelper: Executes an update query on the database.
existsColumn(String) - Method in class io.github.coho04.mysql.entities.Table: Checks if a column exists in the table.
existsDatabase(String) - Method in class io.github.coho04.mysql.MYSQL: Checks if a database with the given name exists.
existsRow(Column, String) - Method in class io.github.coho04.mysql.entities.Table: Checks if a row exists in the database table based on the provided column and item.
existsTable(String) - Method in class io.github.coho04.mysql.entities.Database: Checks if a table exists in the database.
existsUser(String) - Method in class io.github.coho04.mysql.MYSQL: Checks if a user with the given name exists in the MySQL server.

F

FLOAT - Enum constant in enum class io.github.coho04.mysql.entities.enums.MysqlTypes: Represents a variable of data type float.

G

getAll() - Method in class io.github.coho04.mysql.entities.Column: Retrieves all search results from the database.
getAsBoolean() - Method in class io.github.coho04.mysql.entities.SearchResult: Retrieves the item as a boolean value.
getAsBoolean() - Method in class io.github.coho04.mysql.entities.SearchResults: Returns a list of boolean values representing the search results.
getAsBoolean(int) - Method in class io.github.coho04.mysql.entities.Column: Retrieves the boolean value of the specified column for a given ID.
getAsByte() - Method in class io.github.coho04.mysql.entities.SearchResult: Retrieves the item as a byte value.
getAsByte() - Method in class io.github.coho04.mysql.entities.SearchResults: Retrieves the search results as a list of byte values.
getAsDouble() - Method in class io.github.coho04.mysql.entities.SearchResult: Retrieves the item as a double value.
getAsDouble() - Method in class io.github.coho04.mysql.entities.SearchResults: Returns a list of double values representing the search results.
getAsFloat() - Method in class io.github.coho04.mysql.entities.SearchResult: Retrieves the item as a float value.
getAsFloat() - Method in class io.github.coho04.mysql.entities.SearchResults: Retrieves the search results as a list of float values.
getAsInt() - Method in class io.github.coho04.mysql.entities.SearchResult: Retrieves the item as an integer.
getAsInt() - Method in class io.github.coho04.mysql.entities.SearchResults: Retrieves the search results as a list of integers.
getAsLong() - Method in class io.github.coho04.mysql.entities.SearchResult: Retrieves the item as a long value.
getAsLong() - Method in class io.github.coho04.mysql.entities.SearchResults: Retrieves the search results as a list of long values.
getAsObject() - Method in class io.github.coho04.mysql.entities.SearchResult: Retrieves the item as an Object.
getAsObject() - Method in class io.github.coho04.mysql.entities.SearchResults: Returns a list of objects representing the search results.
getAsSearchResults() - Method in class io.github.coho04.mysql.entities.SearchResults: Retrieves the search results as a list of SearchResult objects.
getAsShort() - Method in class io.github.coho04.mysql.entities.SearchResult: Retrieves the item as a short value.
getAsShort() - Method in class io.github.coho04.mysql.entities.SearchResults: Retrieves the search results as a list of short values.
getAsString() - Method in class io.github.coho04.mysql.entities.SearchResult: Retrieves the item as a string.
getAsString() - Method in class io.github.coho04.mysql.entities.SearchResults: Returns a list of strings representing the search results.
getAsString(int) - Method in class io.github.coho04.mysql.entities.Column: Retrieves the string value of the specified column for a given ID.
getColumn(String) - Method in class io.github.coho04.mysql.entities.Table: Retrieves a Column object with the given name from the table.
getColumns() - Method in class io.github.coho04.mysql.entities.Row: Retrieves the list of columns in the table.
getColumns() - Method in class io.github.coho04.mysql.entities.Table: Retrieves the list of columns for the table.
getConnect() - Method in class io.github.coho04.mysql.MYSQL: This method is used to get the connection to the MySQL server.
getData() - Method in class io.github.coho04.mysql.entities.Row: Retrieves data from the MySQL database.
getDatabase() - Method in class io.github.coho04.mysql.entities.Column: Retrieves the Database object associated with this Column.
getDatabase() - Method in class io.github.coho04.mysql.entities.Row: Retrieves the database associated with this Row.
getDatabase() - Method in class io.github.coho04.mysql.entities.Table: Retrieves the database associated with the table.
getDatabase(String) - Method in class io.github.coho04.mysql.MYSQL: Retrieves a Database object with the given name.
getDatabases() - Method in class io.github.coho04.mysql.MYSQL: Retrieves a list of databases from the MySQL server.
getExceptionHandlerClass() - Method in class io.github.coho04.mysql.MYSQL: This method is used to get the ExceptionHandler class associated with the MYSQL class.
getHostname() - Method in class io.github.coho04.mysql.MYSQL: This method returns the hostname of the MySQL server.
getId() - Method in class io.github.coho04.mysql.entities.Row: Retrieves the id associated with this Row.
getLastestRow() - Method in class io.github.coho04.mysql.entities.Table: Retrieves the latest row from the table.
getMap(Column, String) - Method in class io.github.coho04.mysql.entities.Table: Retrieves a map of search results based on the specified column and item.
getMysqlTypeName() - Method in enum class io.github.coho04.mysql.entities.enums.MysqlTypes: Retrieves the MySQL type name associated with this MysqlTypes object.
getName() - Method in class io.github.coho04.mysql.entities.Column: Retrieves the name of the column.
getName() - Method in class io.github.coho04.mysql.entities.Database: Retrieves the name of the database.
getName() - Method in class io.github.coho04.mysql.entities.Table: Retrieves the name of the table.
getName() - Method in class io.github.coho04.mysql.entities.User: Retrieves the name of the user.
getOldestRow() - Method in class io.github.coho04.mysql.entities.Table: Retrieves the oldest row from the table.
getOrCreateDatabase(String) - Method in class io.github.coho04.mysql.MYSQL: Retrieves an existing Database object with the given name or creates a new one if it doesn't exist.
getOrCreateUser(String, String) - Method in class io.github.coho04.mysql.MYSQL: Retrieves an existing User object with the given username or creates a new one if it doesn't exist.
getPort() - Method in class io.github.coho04.mysql.MYSQL: This method is used to retrieve the port of the MySQL server.
getRandom() - Method in class io.github.coho04.mysql.entities.Column: Retrieves a random value from the specified column in the database table.
getRandomRow() - Method in class io.github.coho04.mysql.entities.Table: Retrieves a random row from the table.
getRow(Column, Object) - Method in class io.github.coho04.mysql.entities.Table: Retrieves a row from the table based on a specific column and item.
getRowById(int) - Method in class io.github.coho04.mysql.entities.Table: Retrieves a row from the table based on the provided ID.
getRows() - Method in class io.github.coho04.mysql.entities.Table: Retrieves the list of rows from the table.
getTable() - Method in class io.github.coho04.mysql.entities.Column: Retrieves the Table object associated with this Column.
getTable() - Method in class io.github.coho04.mysql.entities.Row: Retrieves the table associated with this Row.
getTable(String) - Method in class io.github.coho04.mysql.entities.Database: Retrieves a table from the database with the given name.
getTables() - Method in class io.github.coho04.mysql.entities.Database: Retrieves a list of tables from the database.
getUser(String) - Method in class io.github.coho04.mysql.MYSQL: This method is used to get a User object with the given name.
getUsername() - Method in class io.github.coho04.mysql.MYSQL: Retrieves the username associated with the MySQL server.
getUsers() - Method in class io.github.coho04.mysql.MYSQL: Retrieves a list of User objects representing the users in the MySQL server.
getValue() - Method in enum class io.github.coho04.mysql.entities.enums.Permissions: Retrieves the value of a permission.
getVersion() - Method in class io.github.coho04.mysql.MYSQL: This method is used to get the version of the MySQL server.

H

handle(ResultSet) - Method in interface io.github.coho04.mysql.interfaces.QueryHelper.ResultSetHandler: Handles the result set returned from a database query.
hasColumn(String) - Method in class io.github.coho04.mysql.entities.Table: Checks if a column exists in the table.
hasColumns() - Method in class io.github.coho04.mysql.entities.Table: Checks if the table has any columns.

I

insert(HashMap<String, String>) - Method in class io.github.coho04.mysql.entities.Table: Inserts a row into the table with the provided data.
INSERT - Enum constant in enum class io.github.coho04.mysql.entities.enums.Permissions: Represents the permission for inserting data into a database.
INT - Enum constant in enum class io.github.coho04.mysql.entities.enums.MysqlTypes: The INT enum represents the int MySQL data type.
io.github.coho04.mysql - package io.github.coho04.mysql
io.github.coho04.mysql.entities - package io.github.coho04.mysql.entities
io.github.coho04.mysql.entities.enums - package io.github.coho04.mysql.entities.enums
io.github.coho04.mysql.errors - package io.github.coho04.mysql.errors
io.github.coho04.mysql.exceptions - package io.github.coho04.mysql.exceptions
io.github.coho04.mysql.interfaces - package io.github.coho04.mysql.interfaces
isEmpty() - Method in class io.github.coho04.mysql.entities.Table: Checks if the table is empty.
isPrint() - Method in class io.github.coho04.mysql.errors.ExceptionHandler: Returns the value of the 'print' flag.

J

JSON - Enum constant in enum class io.github.coho04.mysql.entities.enums.MysqlTypes: The JSON enum represents the JSON MySQL data type.

M

MYSQL - Class in io.github.coho04.mysql: The MYSQL class provides methods for connecting to a MySQL server and performing operations on the server.
MYSQL(String, String, String) - Constructor for class io.github.coho04.mysql.MYSQL: Constructor for creating a MYSQL object with the specified hostname, username, and password.
MYSQL(String, String, String, int) - Constructor for class io.github.coho04.mysql.MYSQL: Constructor for creating a MYSQL object with the specified hostname, username, password, and port.
MYSQL(String, String, String, int, T) - Constructor for class io.github.coho04.mysql.MYSQL: Constructs a MYSQL object with the specified hostname, username, password, and port.
MysqlTypes - Enum Class in io.github.coho04.mysql.entities.enums: The MysqlTypes enum represents the different MySQL data types.

N

NCHAR - Enum constant in enum class io.github.coho04.mysql.entities.enums.MysqlTypes: Represents a constant for the "nchar" variable.
NoConnectionException - Exception Class in io.github.coho04.mysql.exceptions: The NoConnectionException is an exception thrown when there is no connection to the MySQL server.
NoConnectionException(String) - Constructor for exception class io.github.coho04.mysql.exceptions.NoConnectionException: NoConnectionException is an exception thrown when there is no connection to the MySQL server.
NoConnectionException(String, Throwable) - Constructor for exception class io.github.coho04.mysql.exceptions.NoConnectionException: Creates a new instance of NoConnectionException with the specified detail message and cause.
NUMERIC - Enum constant in enum class io.github.coho04.mysql.entities.enums.MysqlTypes: Represents a numeric value.
NVARCHAR - Enum constant in enum class io.github.coho04.mysql.entities.enums.MysqlTypes: Represents a variable of NVARCHAR data type.

O

onFlushPrivileges() - Method in class io.github.coho04.mysql.MYSQL: This method is used to flush the MySQL server privileges.

P

Permissions - Enum Class in io.github.coho04.mysql.entities.enums: Represents different permissions that can be assigned to a user or database.

Q

QueryHelper - Interface in io.github.coho04.mysql.interfaces
QueryHelper.ResultSetHandler<T> - Interface in io.github.coho04.mysql.interfaces

R

REAL - Enum constant in enum class io.github.coho04.mysql.entities.enums.MysqlTypes: Enum variable representing the type "real".
REFERENCES - Enum constant in enum class io.github.coho04.mysql.entities.enums.Permissions
removePermission(Permissions) - Method in class io.github.coho04.mysql.entities.User: Removes the specified permissions from the user.
removePermissionToDatabase(Permissions, Database) - Method in class io.github.coho04.mysql.entities.User: Removes the specified permissions from the user for the given database.
rename(String) - Method in class io.github.coho04.mysql.entities.Database: Renames the database.
Row - Class in io.github.coho04.mysql.entities: Represents a row in a MySQL database table.
Row(Table, Column, MYSQL, String) - Constructor for class io.github.coho04.mysql.entities.Row: Represents a row in a database table.
RowBuilder - Class in io.github.coho04.mysql.entities: The RowBuilder class is used to build a row for database insertion.
RowBuilder() - Constructor for class io.github.coho04.mysql.entities.RowBuilder

S

SearchResult - Class in io.github.coho04.mysql.entities: The SearchResult class represents a single search result item.
SearchResult(String) - Constructor for class io.github.coho04.mysql.entities.SearchResult: The SearchResult class represents a single search result item.
SearchResults - Class in io.github.coho04.mysql.entities: The SearchResults class represents a collection of SearchResult objects.
SearchResults(List<SearchResult>) - Constructor for class io.github.coho04.mysql.entities.SearchResults: The SearchResults class represents a collection of SearchResult objects.
SELECT - Enum constant in enum class io.github.coho04.mysql.entities.enums.Permissions: The SELECT variable represents the permission for querying or retrieving data from a database.
set(Column, Object) - Method in class io.github.coho04.mysql.entities.Row: Sets the value of a specific item in the column.
setBreakProgramm(boolean) - Method in class io.github.coho04.mysql.errors.ExceptionHandler: Sets the value of the 'breakProgramm' flag.
setExceptionHandlerClass(T) - Method in class io.github.coho04.mysql.MYSQL: Sets the ExceptionHandler class for handling exceptions.
setExportMap(HashMap<String, SearchResult>) - Method in class io.github.coho04.mysql.entities.Row: Sets the export map for the Row.
setHostname(String) - Method in class io.github.coho04.mysql.MYSQL: Sets the hostname for the MYSQL class.
setItemNull(int) - Method in class io.github.coho04.mysql.entities.Column: Sets the value of a specific item in the column to null.
setName(String) - Method in class io.github.coho04.mysql.entities.Column: Sets the name of the column.
setName(String) - Method in class io.github.coho04.mysql.entities.Database: Sets the name of the database.
setNull() - Method in class io.github.coho04.mysql.entities.Column: Sets the value of the column to null for all rows where the column is not already null.
setPassword(String) - Method in class io.github.coho04.mysql.entities.User: Sets the password for the user.
setPassword(String) - Method in class io.github.coho04.mysql.MYSQL: Sets the password for the MYSQL class.
setPermission(Permissions) - Method in class io.github.coho04.mysql.entities.User: Sets the permissions for the user.
setPermissionToDatabase(Permissions, Database) - Method in class io.github.coho04.mysql.entities.User: Sets the specified permissions to the given database for the current user.
setPort(int) - Method in class io.github.coho04.mysql.MYSQL: Sets the port for the MYSQL class.
setPrint(boolean) - Method in class io.github.coho04.mysql.errors.ExceptionHandler: Sets the value of the 'print' flag.
setUniqueColumn(String) - Method in class io.github.coho04.mysql.entities.Table: Sets a unique constraint on the specified column in the table.
setupMysql() - Method in interface io.github.coho04.mysql.interfaces.TestHelper
setUsername(String) - Method in class io.github.coho04.mysql.MYSQL: Sets the username for the MYSQL class.
showColumns() - Method in class io.github.coho04.mysql.entities.Row: Retrieves the list of columns in the table.
SMALLINT - Enum constant in enum class io.github.coho04.mysql.entities.enums.MysqlTypes: The SMALLINT enum represents the smallint MySQL data type.
switchDatabase(Database) - Method in class io.github.coho04.mysql.MYSQL: Switches the current database to the specified database.

T

Table - Class in io.github.coho04.mysql.entities: The Table class represents a table in a database.
Table(String, Database, MYSQL) - Constructor for class io.github.coho04.mysql.entities.Table: Creates a new Table object with the given name, database, and MYSQL objects.
TestHelper - Interface in io.github.coho04.mysql.interfaces
TEXT - Enum constant in enum class io.github.coho04.mysql.entities.enums.MysqlTypes: Represents a variable for storing text.
TIME - Enum constant in enum class io.github.coho04.mysql.entities.enums.MysqlTypes: Represents a variable called TIME.
TIMESTAMP - Enum constant in enum class io.github.coho04.mysql.entities.enums.MysqlTypes: Represents the timestamp of an event or record.
TINYINT - Enum constant in enum class io.github.coho04.mysql.entities.enums.MysqlTypes: The TINYINT enum represents the tinyint MySQL data type.
TRIGGER - Enum constant in enum class io.github.coho04.mysql.entities.enums.Permissions: Represents the permission for creating and managing triggers in a database.

U

UPDATE - Enum constant in enum class io.github.coho04.mysql.entities.enums.Permissions: Represents the permission for updating data in a database.
User - Class in io.github.coho04.mysql.entities: Represents a User in the application.
User(String, MYSQL) - Constructor for class io.github.coho04.mysql.entities.User: Represents a User in the application.

V

valueOf(String) - Static method in enum class io.github.coho04.mysql.entities.enums.MysqlTypes: Returns the enum constant of this class with the specified name.
valueOf(String) - Static method in enum class io.github.coho04.mysql.entities.enums.Permissions: Returns the enum constant of this class with the specified name.
values() - Static method in enum class io.github.coho04.mysql.entities.enums.MysqlTypes: Returns an array containing the constants of this enum class, in the order they are declared.
values() - Static method in enum class io.github.coho04.mysql.entities.enums.Permissions: Returns an array containing the constants of this enum class, in the order they are declared.
VARBINARY - Enum constant in enum class io.github.coho04.mysql.entities.enums.MysqlTypes: Represents a VARBINARY type in a database.
VARCHAR - Enum constant in enum class io.github.coho04.mysql.entities.enums.MysqlTypes: Represents the VARCHAR data type in a database.

W

with(Column, Object) - Method in class io.github.coho04.mysql.entities.RowBuilder: Inserts a key-value pair into the insertMap HashMap.

Y

YEAR - Enum constant in enum class io.github.coho04.mysql.entities.enums.MysqlTypes: This enumeration represents the available values for the "year" variable.

A B C D E F G H I J M N O P Q R S T U V W Y
All Classes and Interfaces|All Packages|Serialized Form