Advertisement
huyhung94

DatabaseConnect

Apr 21st, 2015
280
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 3.52 KB | None | 0 0
  1. package DatabaseConnect;
  2.  
  3. import java.io.FileInputStream;
  4. import java.io.IOException;
  5. import java.sql.Connection;
  6. import java.sql.DriverManager;
  7. import java.sql.PreparedStatement;
  8. import java.sql.ResultSet;
  9. import java.sql.SQLException;
  10. import java.sql.Statement;
  11. import java.util.Properties;
  12. import java.util.logging.Level;
  13. import java.util.logging.Logger;
  14. import javax.swing.JOptionPane;
  15.  
  16. /**
  17.  *
  18.  * @author Huy Hùng
  19.  * @Copyright (c) 2015 Huy Hùng
  20.  */
  21. public class DatabaseConnect {
  22.  
  23.     public static String url;
  24.     public static String driver;
  25.     public static String servername;
  26.     public static String database;
  27.     public static String user;
  28.     public static String pwd;
  29.     public static String port;
  30.     public static Connection connection;
  31.     public static Statement statement;
  32.  
  33.     public static boolean connect() {
  34.         try {
  35.  
  36.             Properties p = new Properties();
  37.             p.load(new FileInputStream("database.properties"));
  38.             driver = p.getProperty("driver");
  39.             servername = p.getProperty("servername");
  40.             database = p.getProperty("database");
  41.             user = p.getProperty("user");
  42.             pwd = p.getProperty("password");
  43.             port = p.getProperty("port");
  44.             url = "jdbc:sqlserver://" + servername + ":" + port + ";databaseName=" + database;
  45.             Class.forName(driver);
  46.             connection = DriverManager.getConnection(url, user, pwd);
  47.             if (connection == null) {
  48.                 throw new NullPointerException("Can not connect to SQL server!");
  49.             }
  50.  
  51.         } catch (IOException ex) {
  52.             System.out.println("Error(IO): " + ex.toString() + "\n");
  53.             JOptionPane.showMessageDialog(null, "Can not connect to server.\nPlease try again!", "ERROR!", 0);
  54.         } catch (ClassNotFoundException ex) {
  55.             System.out.println("Error: Class not found!\n");
  56.             JOptionPane.showMessageDialog(null, "Can not connect to server.\nPlease try again!", "ERROR!", 0);
  57.         } catch (SQLException ex) {
  58.             System.out.println("Error(SQL): " + ex.toString());
  59.             JOptionPane.showMessageDialog(null, "Can not connect to server.\nPlease try again!", "ERROR!", 0);
  60.         }
  61.         return true;
  62.     }
  63.  
  64.     public static ResultSet getData(String sqlCommand) {
  65.         try {
  66.             statement = connection.createStatement();
  67.             ResultSet rs = statement.executeQuery(sqlCommand);
  68.             return rs;
  69.         } catch (SQLException ex) {
  70.             System.out.println("Error!\n" + ex.toString());
  71.             return null;
  72.         }
  73.     }
  74.  
  75.     public static void close() {
  76.         try {
  77.             if (connection != null) {
  78.                 connection.close();
  79.             }
  80.         } catch (SQLException ex) {
  81.             Logger.getLogger(DatabaseConnect.class.getName()).log(Level.SEVERE, null, ex);
  82.         }
  83.     }
  84.  
  85.     public static void close(PreparedStatement ps) {
  86.         try {
  87.             if (ps != null) {
  88.                 ps.close();
  89.             }
  90.         } catch (SQLException ex) {
  91.             Logger.getLogger(DatabaseConnect.class.getName()).log(Level.SEVERE, null, ex);
  92.         }
  93.         close();
  94.     }
  95.  
  96.     public static void close(PreparedStatement ps, ResultSet rs) {
  97.         try {
  98.             if (rs != null) {
  99.                 rs.close();
  100.             }
  101.         } catch (SQLException ex) {
  102.             Logger.getLogger(DatabaseConnect.class.getName()).log(Level.SEVERE, null, ex);
  103.         }
  104.         close(ps);
  105.     }
  106. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement