Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package maxdown;
- import java.sql.*;
- public class Conexao {
- Connection conexao = null;
- Statement stmt = null;
- public String urlServidor, nomeServidor, usuarioServidor, senhaServidor, databaseServidor;
- public boolean statusConexao;
- public Conexao(String s, String u, String pw, String db) {
- nomeServidor = s;
- usuarioServidor = u;
- senhaServidor = pw;
- databaseServidor = db;
- urlServidor = "jdbc:mysql://" + nomeServidor + "/" + databaseServidor;
- statusConexao = false;
- }
- public void conectar() {
- try {
- String nomeDriver = "com.mysql.jdbc.Driver";
- Class.forName(nomeDriver);
- conexao = DriverManager.getConnection(urlServidor, usuarioServidor, senhaServidor);
- stmt = conexao.createStatement();
- statusConexao = true;
- } catch (ClassNotFoundException e) {
- System.out.println("Classe não encontrada");
- } catch (SQLException e) {
- System.out.println("SQL Exception");
- }
- }
- public void desconectar() {
- try {
- conexao.close();
- statusConexao = false;
- } catch (SQLException e) {
- System.out.println("Erro ao desconectar");
- }
- }
- public boolean isConectado() {
- return statusConexao;
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement