Conexão com MySQL

com.mysql.jdbc.Driver

/*
 * BDConexao.java
 * Created on 1 de Maio de 2003, 12:05
 * @author  Rodrigo Reis
 */

package negocio;

import java.sql.*;

public class BDConexao {
    private static Connection con;
    private static Statement stmt;
    private static ResultSet resultado;
    private static boolean status = false;
    
    /** Creates a new instance of BDConexao */
    public BDConexao() throws ClassNotFoundException, SQLException {
        inicializarConexaoBD();
    }
    
    public static void inicializarConexaoBD() throws ClassNotFoundException, SQLException {
        status = true;
        Class.forName("org.gjt.mm.mysql.Driver");        
        con = DriverManager.getConnection("jdbc:mysql://localhost/escola", "root", "");
        stmt = con.createStatement();
    }
    
    public static void finalizarConexaoBD() {
        try {
            stmt.close();
            con.close();
        }
        catch (Exception e) {
            e.printStackTrace();
        }
    }        
     
    public static Statement getStatement() {
        return stmt;
    }
    
    public static boolean getStatus() {
        return status;
    }
    
    public static int obterUltimoCodigoGeradoTabela(String nomeTabela) {
        try {
            String csCodigoGerado = "SELECT LAST_INSERT_ID() from " + nomeTabela;
            resultado = stmt.executeQuery(csCodigoGerado);
            resultado.first();
            return (resultado.getInt(1));
        }
        catch (SQLException se) {
            return 0;
        }
    }
}

...
} catch (SQLException e) {
      System.out.println("Problemas com a fonte de dados");
}