SQL-Utils

Collection of SQL utilities to make your life a bit easier. Java Database Connectivity (JDBC) Utils. Add this as dependency to your project via Maven/Gradle/Sbt/Leinigen (requires Java 8 or higher).

SQLUtils.initTables(...) will create missing tables and columns, and even update the columns definitions.

import com.osiris.sql.SQLUtils;
import com.osiris.sql.SQLTable;

import java.sql.Connection;

class Example {
    public static SQLTable tableUsers;
    public static SQLTable tableStats;

    public static void main(String[] args) {
        String dbName = "db_name";
        Connection con = DriverManager.getConnection("jdbc:mysql://localhost/" + dbName, "root", "");
        SQLUtils sql = new SQLUtils();
        sql.initTables(con,
                (tableUsers = sql.table("users",
                        sql.col("id", "INT NOT NULL AUTO_INCREMENT PRIMARY KEY"),
                        sql.col("name", "VARCHAR(20) NOT NULL"),
                        sql.col("age", "TINYINT NOT NULL"),
                        sql.col("email", "VARCHAR(255) NOT NULL"))),
                (tableStats = sql.table("stats",
                        sql.col("id", "INT NOT NULL AUTO_INCREMENT PRIMARY KEY"),
                        sql.col("timestamp", "TIMESTAMP NOT NULL"),
                        sql.col("daily_visits", "LONG NOT NULL"),
                        sql.col("daily_users", "INT NOT NULL")))
        );
    }
}