Desenvolvendo programas básicos em java

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

public class ConnectionFactory {

	// Nome do driver
	private static final String jdbcDriver = "com.mysql.jdbc.Driver";
	// Informações sobre o banco de dados
	private static final String jdbcUrl = "jdbc:mysql://HOST:PORTA/NOME_DO_BD";
	// Nome do usuário
	private static final String jdbcUser = "root";
	// Senha
	private static final String jdbcPasswd = "";
		
	public ConnectionFactory() {
	}
	
	public static Connection getConnection() {
		try {
			Class.forName(jdbcDriver);

			Connection conn = DriverManager.getConnection(jdbcUrl,jdbcUser,jdbcPasswd);
			
			return conn;
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	    return null;
	}
	
	public static void closeConnection(Connection conn) {
		
		try {

			conn.close();
			
		} catch (SQLException e) {
			e.printStackTrace();
		}
		
	}
	
}

Connection conn = ConnectionFactory.getConnection();
Statement stmt = conn.createStatement();
ResultSet rst = stmt.executeQuery("select * from TABELA");
// ou stmt.executeUpdate("insert into TABELA (CAMPOS) values (VALORES)");