Koneksi mysql di java












/****[SOURCE CODE]*****/
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;
 
public class test_koneksi {
    public static Connection con;
    public static Statement stm;
    public static void main (String args[]){
       
        try{
            String url="";//ip database server + ("pake slash / ") nama database ex : jdbc:mysql://localhost/db_test_koneksi
            String user="";//isi sesuai dengan user yang di pakai ex :root
            String pass="";//isi sesuai dengan passoword usernya ex : 12345678 atau , jika kosong passwordnya ; tidak usah di isi
            Class.forName("com.mysql.jdbc.Driver");
            con =DriverManager.getConnection(url,user,pass);
            stm = con.createStatement();
            System.out.println("koneksi berhasil : ");
        }
        catch (Exception e){
           
            System.err.println("koneksi gagal : "+e.getMessage());
       
        }
   
    }
}
 


tested with : mysql : v14.14 Distrib 5.7.20, for Linux (x86_64) java : openjdk version 1.8.0_151 IDE : BlueJ : v4.1.2 sumber: 
https://www.malasngoding.com/cara-menghubungkan-java-dengan-database-mysql/

Comments