database

JDBC Example

This is a quick basic example of a CRUD in Java using JDBC on a MySQL database

Build on Linux executing ./buildScript.sh

Execute the generated JAR using java -jar JDBCExample.jar

The database can be imported from the games_tournament.sql script. It requires the following process:

1. CREATE DATABASE games_tournament;
2. mysql -p <user with privileges> -p games_tournament < games_tournament.sql
3. CREATE USER 'games_tournament'@'localhost' IDENTIFIED_BY 'games_tournament';
4. GRANT ALL PRIVILEGES ON games_tournament.* TO 'games_tournament'@'localhost';

Javadoc can be generated into a doc folder using javadoc -d doc src/*.java

Made by Juan C. Alvarez