package data;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;

public class DB {

    private static final String DRIVER = "com.mysql.jdbc.Driver";
    private static String URL = "jdbc:mysql://SKRIV IP HER:3306/cupcakeshop";
//    private static String URL = "jdbc:mysql://localhost:3306/cupcakeshop";
    private static String USER = "XXXXXX";
    private static String PASSWORD = "YYYYYY";
//    private static String USER = "root";
//    private static String PASSWORD = "root";
    private static Connection conn = null;

    public static Connection getConnection() {
        if (conn == null) {
            try {
                Class.forName(DRIVER);
                conn = DriverManager.getConnection(URL, USER, PASSWORD);
            } catch (ClassNotFoundException | SQLException ex) {
                ex.printStackTrace();
            }
        }
        return conn;
    }

    public static void main(String[] args) {
        //Test connection
        try {
            String sql = "select idCupcake, cupcakeName, idTopping, idBottom from cupcake";
            ResultSet rs = getConnection().prepareStatement(sql).executeQuery();
            while (rs.next()) {
                System.out.println(rs.getString("cupcakeName"));
            }
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
    }
}