Advertisement
mqnoy

[JAVA] how to connect mysql on java

Nov 28th, 2017
126
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 1.19 KB | None | 0 0
  1. /****[SOURCE CODE]*****/
  2. import java.sql.Connection;
  3. import java.sql.DriverManager;
  4. import java.sql.Statement;
  5.  
  6. public class test_koneksi {
  7.     public static Connection con;
  8.     public static Statement stm;
  9.     public static void main (String args[]){
  10.        
  11.         try{
  12.             String url="";//ip database server + ("pake slash / ") nama database ex : jdbc:mysql://localhost/db_test_koneksi
  13.             String user="";//isi sesuai dengan user yang di pakai ex :root
  14.             String pass="";//isi sesuai dengan passoword usernya ex : 12345678 atau , jika kosong passwordnya ; tidak usah di isi
  15.             Class.forName("com.mysql.jdbc.Driver");
  16.             con =DriverManager.getConnection(url,user,pass);
  17.             stm = con.createStatement();
  18.             System.out.println("koneksi berhasil : ");
  19.         }
  20.         catch (Exception e){
  21.            
  22.             System.err.println("koneksi gagal : "+e.getMessage());
  23.        
  24.         }
  25.    
  26.     }
  27. }
  28.  
  29.  
  30. tested with :
  31. mysql :  v14.14 Distrib 5.7.20, for Linux (x86_64)
  32. java : openjdk version 1.8.0_151
  33.  
  34. codding with :
  35. BlueJ : v4.1.2
  36.  
  37.  
  38.  
  39. REF : https://www.malasngoding.com/cara-menghubungkan-java-dengan-database-mysql/
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement