Advertisement
dirham_yord

01 database

May 2nd, 2024 (edited)
479
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 1.27 KB | Software | 0 0
  1. package pert3_NPM;
  2. //ganti NPM sesuai NPM anda
  3.  
  4. import java.sql.Connection;
  5. import java.sql.DriverManager;
  6. import java.sql.PreparedStatement;
  7. import java.sql.ResultSet;
  8. import java.sql.Statement;
  9.  
  10. //ganti NPM sesuai NPM anda
  11. public class Pert3_NPM {
  12.     private Statement data=null;
  13.     private Connection koneksi=null;
  14.     Statement st = null;
  15.     ResultSet rs = null;
  16.     PreparedStatement pst = null;
  17. //ganti url koneksi database sesuai dengan database anda
  18.     private String url="jdbc:mysql://localhost:3306/gudang?zeroDateTimeBehavior=convertToNull";
  19.     private String user="root";
  20.     private String pass="";
  21.  
  22. //ganti NPM sesuai NPM anda
  23.     Pert3_NPM(){
  24.         try{
  25.             koneksi = DriverManager.getConnection(url, user, pass);
  26.             data = this.koneksi.createStatement();
  27.             System.out.println("[" + System.currentTimeMillis() + "] Koneksi database berhasil!");
  28.         }catch(Throwable e){
  29.             System.out.println("[" + System.currentTimeMillis() + "] Koneksi database gagal: " + e);
  30.             System.exit(1);
  31.         }
  32.     }
  33.     public Connection getConnection(){
  34.         return koneksi;
  35.     }
  36.     public Statement getStatement(){
  37.         return data;
  38.     }
  39.     public static void main(String[]args){
  40.        
  41.     }
  42. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement