Advertisement
Guest User

Untitled

a guest
May 26th, 2017
68
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.23 KB | None | 0 0
  1. import java.sql.Connection;
  2. import java.sql.DriverManager;
  3. import java.sql.ResultSet;
  4. import java.sql.SQLException;
  5. import java.sql.Statement;
  6.  
  7. public class BancoDeDados {
  8.  
  9. private static Connection conexao;
  10. private static ResultSet resultado;
  11.  
  12. public static boolean conectar() {
  13.  
  14. try {
  15. Class.forName("com.mysql.jdbc.Driver");
  16. BancoDeDados.conexao = DriverManager
  17. .getConnection("jdbc:mysql://localhost/BancoDeSangue?user=root&password=1234");
  18.  
  19. } catch (ClassNotFoundException e) {
  20.  
  21. e.printStackTrace();
  22. return false;
  23.  
  24. } catch (SQLException e) {
  25. e.printStackTrace();
  26. return false;
  27. }
  28.  
  29. return true;
  30.  
  31. }
  32.  
  33. public static boolean executar(String sql) {
  34. Statement query;
  35.  
  36. try {
  37. query = BancoDeDados.conexao.createStatement();
  38. query.execute(sql);
  39.  
  40. BancoDeDados.resultado = query.getResultSet();
  41.  
  42. } catch (SQLException e) {
  43. e.printStackTrace();
  44. return false;
  45. }
  46.  
  47. return true;
  48.  
  49. }
  50.  
  51. public static ResultSet recuperarResultados() {
  52.  
  53. return BancoDeDados.resultado;
  54. }
  55.  
  56. public static boolean desconectar() {
  57.  
  58. try {
  59. BancoDeDados.conexao.close();
  60.  
  61. } catch (SQLException e) {
  62. e.printStackTrace();
  63. return false;
  64. }
  65. return true;
  66. }
  67. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement