Classe Conexao - deve ir junto ao projeto javacombanco

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

/**
 *
 * @author Professor
 */
public class Conexao {

    static final String JDBC_DRIVER = "org.mariadb.jdbc.Driver";
    static final String DB_URL = "jdbc:mariadb://localhost:3306/bdteste";

    static final String USER = "root";
    static final String PASS = "";

    public Connection conectar() {

        Connection conn = null;

        try {
            conn = DriverManager.getConnection(DB_URL, USER, PASS);
            //System.out.println("Conectado");

            return conn;

//conn.close();
        } catch (SQLException ex) {
            System.out.println("Erro " + ex);
            conn = null;

        }
        return conn;

    }

    public void desconectar(Connection conn) {
        try {
            if (conn != null && !conn.isClosed()) {
                conn.close();
                //System.out.println("Desconectou do banco de dados.");
            }
        } catch (SQLException ex) {
            System.out.println("Não conseguiu desconectar do BD.");
        }
    }

}