Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.ResultSet;
- import java.sql.SQLException;
- import java.sql.Statement;
- public class BancoDeDados {
- private static Connection conexao;
- private static ResultSet resultado;
- public static boolean conectar() {
- try {
- Class.forName("com.mysql.jdbc.Driver");
- BancoDeDados.conexao = DriverManager
- .getConnection("jdbc:mysql://localhost/BancoDeSangue?user=root&password=1234");
- } catch (ClassNotFoundException e) {
- e.printStackTrace();
- return false;
- } catch (SQLException e) {
- e.printStackTrace();
- return false;
- }
- return true;
- }
- public static boolean executar(String sql) {
- Statement query;
- try {
- query = BancoDeDados.conexao.createStatement();
- query.execute(sql);
- BancoDeDados.resultado = query.getResultSet();
- } catch (SQLException e) {
- e.printStackTrace();
- return false;
- }
- return true;
- }
- public static ResultSet recuperarResultados() {
- return BancoDeDados.resultado;
- }
- public static boolean desconectar() {
- try {
- BancoDeDados.conexao.close();
- } catch (SQLException e) {
- e.printStackTrace();
- return false;
- }
- return true;
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement