Last active
January 12, 2023 14:21
-
-
Save antonio-abrantes/86686b91b9537492d874587052767bcb to your computer and use it in GitHub Desktop.
Classe de conexão com o banco de dados MySql em Java
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
import java.sql.Connection; | |
import java.sql.DriverManager; | |
import java.sql.ResultSet; | |
import java.sql.SQLException; | |
import java.sql.Statement; | |
public class CasaMarmitasConnection { | |
private static String status = "Não conectado..."; | |
public static Connection criarConexao() | |
throws InstantiationException, IllegalAccessException, ClassNotFoundException, SQLException { | |
Connection connection = null; | |
String serverName = "localhost"; // caminho do servidor do BD | |
String mydatabase = "nome-do-banco"; // nome do seu banco de dados | |
String url = "jdbc:mysql://" + serverName + "/" + mydatabase; | |
String username = "usuario"; // nome de um usuário de seu BD | |
String password = "senha"; // sua senha de acesso | |
connection = DriverManager.getConnection(url, username, password); | |
Class.forName("com.mysql.jdbc.Driver").newInstance(); | |
//Testa a conexão com o banco | |
if (connection != null) { | |
status = ("STATUS: Conectado com sucesso!"); | |
} else { | |
status = ("STATUS: Não foi possivel realizar conexão"); | |
} | |
return connection; | |
} | |
public static ResultSet executarSelect(Connection conn, String sql) throws SQLException{ | |
Statement query = conn.createStatement(); | |
return query.executeQuery(sql); | |
} | |
public static java.sql.PreparedStatement prepararSql(Connection conn, String sql) throws SQLException{ | |
return conn.prepareStatement(sql); | |
} | |
public static String statusConection() { | |
return status; | |
} | |
} |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment