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 | } |