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