View difference between Paste ID: 3iQxJbiN and NarhwmfU
SHOW: | | - or go back to the newest paste.
1
package ContohLaporan;
2
3
import java.sql.Connection;
4
import java.sql.DriverManager;
5
import java.sql.SQLException;
6
import javax.swing.JOptionPane;
7
8
public class DBConnection {
9
10
    private Connection conn = null;
11
    static String DB_URL, DB_USER, DB_PASS, dbname, host, port;
12
    boolean koneksi = false, db = false;
13
14
    public DBConnection() {
15
        host = "localhost";
16
        port = "3306";
17
        dbname = "db_supermarket_siti3";
18
        DB_USER = "root";
19
        DB_PASS = "";
20
        DB_URL = "jdbc:mysql://" + host + ":" + port + "/" + dbname;
21
        if (conn == null) {
22
            try {
23
                Class.forName("com.mysql.jdbc.Driver");
24
                conn = DriverManager.getConnection(DB_URL, DB_USER, DB_PASS);
25
                koneksi = true;
26
            } catch (SQLException ex) {
27
                JOptionPane.showMessageDialog(null,
28
                        ex.getErrorCode() + ": " + ex.getMessage());
29
                koneksi = false;
30
            } catch (ClassNotFoundException cne) {
31
                JOptionPane.showMessageDialog(null,
32
                        "COM.MYSQL.JDBC.Driver tidak ditemukan\n" + cne.getMessage());
33
                koneksi = false;
34
            }
35
        }
36
    }
37
}