Advertisement
Guest User

Untitled

a guest
May 6th, 2017
116
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 1.69 KB | None | 0 0
  1. package me.drbooker.bookplayersonline.mysql;
  2.  
  3. import java.sql.Connection;
  4. import java.sql.DriverManager;
  5. import java.sql.ResultSet;
  6. import java.sql.SQLException;
  7. import java.sql.Statement;
  8.  
  9. public class MySQL {
  10.    
  11.     private String HOST = "localhost";
  12.     private String DATABASE = "baza";
  13.     private String USER = "nazwa";
  14.     private String PASSWORD = "password";
  15.    
  16.     private Connection con;
  17.    
  18.     public MySQL(String host, String database, String user, String password) {
  19.         this.HOST = host;
  20.         this.DATABASE = database;
  21.         this.USER = user;
  22.         this.PASSWORD = password;
  23.        
  24.         connect();
  25.     }
  26.  
  27.     public void connect() {
  28.         try {
  29.             con = DriverManager.getConnection("jdbc:mysql://" + HOST + ":3306/" + DATABASE + "?autoReconnect=true", USER, PASSWORD);
  30.             System.out.println("[MySQL] Polaczono z baza MySQL.");
  31.         } catch (SQLException e) {
  32.             System.out.println("[MySQL] Polaczenie z baza MySQL nie powiodlo sie! Blad: " + e.getMessage());
  33.         }
  34.     }
  35.    
  36.     public void close() {
  37.         try {
  38.             if(con != null) {
  39.                 con.close();
  40.                 System.out.println("[MySQL] Rozlaczenie z baza MySQL zakonczylo sie pomyslnie!");
  41.             }
  42.         } catch (SQLException e) {
  43.             System.out.println("[MySQL] Rozlaczanie z baza MySQL nie powiodlo sie! Blad: " + e.getMessage());
  44.         }
  45.     }
  46.    
  47.     public void update(String qry) {
  48.         try {
  49.             Statement st = con.createStatement();
  50.             st.executeUpdate(qry);
  51.             st.close();
  52.         } catch (SQLException e) {
  53.             connect();
  54.             System.err.println(e);
  55.         }
  56.     }
  57.    
  58.     public ResultSet query(String qry) {
  59.         ResultSet rs = null;
  60.        
  61.         try {
  62.             Statement st = con.createStatement();
  63.             rs = st.executeQuery(qry);
  64.         } catch (SQLException e) {
  65.             connect();
  66.             System.err.println(e);
  67.         }
  68.         return rs;
  69.     }
  70. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement