Bank connection error. Java + Workbench

Question

Bank connection error. Java + Workbench

Navigation

#1 by (1 votes)

1

Bank connection error. Can anyone help me?

package conexaoprojeto;

import java.sql.*;
import javax.swing.JOptionPane;

public class ConexaoProjeto {

    private final String Driver = "com.mysql.jdbc.Driver";
    private final String Url = "jdbc:mysql://localhost:3306/ConexaoProjeto";
    private final String User = "root";
    private final String Pass = "123456";
    public Connection conn;
    public Statement stmt;
    public ResultSet rs;


    public Statement Conectar() {
        try {
            System.setProperty("jdbc.drivers", Driver);
            conn = DriverManager.getConnection(Url, User, Pass);
            stmt = conn.createStatement();
            JOptionPane.showMessageDialog(null, "Conectado com Sucesso!");
        } catch (SQLException ex) {
            JOptionPane.showMessageDialog(null, "Ocorreu uma falha! Não pode ser conectado" + "\n" + ex.getMessage());
        }
        return stmt;
    }

    public void Desconectar() {
        try {
            conn.close();
            JOptionPane.showMessageDialog(null, "Conexão fechada com sucesso!");
        } catch (SQLException ex) {
            JOptionPane.showMessageDialog(null, "Conexão falhou ao ser encerrada!" + "\n" + ex.getMessage());
        }
    }
}

mysql java mysql-workbench

asked by anonymous 24.05.2015 / 05:54

1 answer

Hover effect does not work How to use event dynamically created buttons to redirect to another ASP.NET page?

score 1 · Answer 1

Try this:

package conexaoprojeto;

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

public class Conecta {

    private String DRIVER = "com.mysql.jdbc.Driver";
    private String BD = "ConexaoProjeto";
    private String URL = "jdbc:mysql://localhost:3306/" +BD;
    private String USERNAME = "root";
    private String PASSWORD = "123456";
    private Connection conexao;
    private Statement stm;
    private String msg;

    public Conecta() {
        this.msg = this.iniciaConexao();                
    }

    public Conecta(String bd, String user, String senha) {
        this.BD = bd;
        this.USERNAME = user;
        this.PASSWORD = senha;
        this.msg = this.iniciaConexao();
    }

    public String iniciaConexao() {
        try {
            Class.forName(this.DRIVER);
            this.conexao = DriverManager.getConnection(URL, USERNAME, PASSWORD);
            // Definimos o objeto responsÃ¡vel por executar os comandos
            this.stm = this.getConexao().createStatement();
            return "sucesso";

        } catch (ClassNotFoundException e) {
            this.conexao = null;
            return "Não foi possivel encontrar o driver de banco: " + e.getMessage();
        } catch (SQLException e) {
            this.conexao = null;
            return "SQLException Erro!" + e.getMessage();
        }
    }

    public String fechaConexao() {
        try {
            if (this.getConexao() != null) {
                this.getConexao().close();
                this.conexao = null;
            }
            if (this.getStm() != null) {
                this.stm = null;
            }
            return "Conexão Encerrada";
        } catch (SQLException ex) {
            return "Houve erro no fechamento da conexão! "+ex.getMessage();
        }
    }

    public Connection getConexao() {
        return conexao;
    }

    public Statement getStm() {
        return stm;
    }

    public String getMsg() {
        return msg;
    }

}

Make sure the database exists, that the username and password are correct, and that you have added the .jar of the driver JDBC do MySQL in your project. The JDBC driver is responsible for integrating Java with the database.

If you are using NetBeans, right-click% with%, then go to Bibliotecas , as shown in the following image:

Searchfor Adicionar Biblioteca... and add to your project: