Guest User

Database

a guest
Apr 30th, 2015
428
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 1.55 KB | None | 0 0
  1. package com.brinedev.libs.db;
  2.  
  3. import java.io.File;
  4. import java.sql.Connection;
  5. import java.sql.DriverManager;
  6. import java.sql.ResultSet;
  7. import java.sql.Statement;
  8.  
  9. public class Database {
  10.  
  11.     private Connection conn;
  12.     private File file;
  13.     private Statement stmt;
  14.  
  15.     private Database(File f) {
  16.         file = f;
  17.         try {
  18.             Class.forName("org.sqlite.JDBC");
  19.             conn = DriverManager.getConnection("jdbc:sqlite:" + file);
  20.             stmt = conn.createStatement();
  21.         } catch (Exception e) {
  22.             e.printStackTrace();
  23.         }
  24.     }
  25.  
  26.     private Database(String urlconn) {
  27.         try {
  28.             conn = DriverManager.getConnection(urlconn);
  29.             stmt = conn.createStatement();
  30.         } catch (Exception e) {
  31.         }
  32.     }
  33.  
  34.     public static Database load(File f) {
  35.         return new Database(f);
  36.     }
  37.  
  38.     public static Database load(String f) {
  39.         return new Database(new File(f));
  40.     }
  41.  
  42.     public static Database load(String host, String database, String user,
  43.             String pass) {
  44.         return new Database("jdbc:mysql://" + host + "/" + database + "?"
  45.                 + "user=" + user + "&password=" + pass);
  46.     }
  47.  
  48.     public void update(String q) {
  49.         try {
  50.             stmt.executeUpdate(q);
  51.         } catch (Exception e) {
  52.         }
  53.     }
  54.    
  55.     public ResultSet query(String q) {
  56.         try {
  57.             return stmt.executeQuery(q);
  58.         } catch (Exception e) {
  59.         }
  60.         return null;
  61.     }
  62.    
  63.     public void close() {
  64.         try {
  65.             stmt.close();
  66.             conn.close();
  67.         } catch (Exception e) {}
  68.     }
  69.    
  70.     public boolean isConnected() {
  71.         try {
  72.         return stmt!=null && conn!=null && !stmt.isClosed() && !conn.isClosed();
  73.         } catch (Exception e) {}
  74.         return false;
  75.     }
  76.  
  77. }
Advertisement
Add Comment
Please, Sign In to add comment