Koneksi Java Driver Mysql

Kesulitan ane dengan masalah koneksi database ke java udah bikin ane pusing banget, pengalaman ane cari info tentang ini masalah ke forum2 malah dapet jawaban yang gak diharapkan. akhirnya dengan berjuang memanfaatkan komputer yang setia melapakan ruang buat jadi klinci percobaan ane ngoding beribu2 skrip yang emang dasarnye ane cuma modal otodidak sama dapet ebook dari om google akhirnye dapet wangsit untuk berbagi kepada orang-orang yang berkesulitan pada maslah koneksi yang sebenarnya sangat lah simple bgt. ane ada info sedikit semoga bermanfaat buat ente-ente yang butuh.


Jadi yang pertama harus disiapin adalah Driver koneksi disini

Teken to liat

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.logging.Level;
import java.util.logging.Logger;

/*
* lanavirgo.blogspot.com* 
and open the template in the editor.
*/

/**
*
* @author SainsDoc */
public class MySQLConnection {
private String url = "jdbc:mysql://localhost:3306/database";
private String host = "localhost";
private int port = 3306;
private String username = "root";
private String password = "";
private String database = "data";
private Connection conn = null;

public MySQLConnection(){
try {
try {
Class.forName("com.mysql.jdbc.Driver").newInstance();
} catch (InstantiationException ex) {
Logger.getLogger(MySQLConnection.class.getName()).log(Level.SEVERE, null, ex);
} catch (IllegalAccessException ex) {
Logger.getLogger(MySQLConnection.class.getName()).log(Level.SEVERE, null, ex);
}
} catch (ClassNotFoundException ex) {
Logger.getLogger(MySQLConnection.class.getName()).log(Level.SEVERE, null, ex);
}
}

public Connection getConn() {
if(conn==null){
try {
conn = DriverManager.getConnection(getUrl(), getUsername(), getPassword());
} catch (SQLException ex) {
Logger.getLogger(MySQLConnection.class.getName()).log(Level.SEVERE, null, ex);
}
}
return conn;
}

public void setConn(Connection conn) {
this.conn = conn;
}

public String getDatabase() {
return database;
}

public void setDatabase(String database) {
this.database = database;
}

public String getHost() {
return host;
}

public void setHost(String host) {
this.host = host;
}

public String getPassword() {
return password;
}

public void setPassword(String password) {
this.password = password;
}

public int getPort() {
return port;
}

public void setPort(int port) {
this.port = port;
}

public String getUrl() {
return url;
}

public void setUrl(String url) {
this.url = url;
}

public String getUsername() {
return username;
}

public void setUsername(String username) {
this.username = username;
}

}
kemudian buat kelas tes.java

import com.mysql.jdbc.Connection;

/*
* To change this template, choose Tools | Templates
* and open the template in the editor.
*/
/**
*
* @author Achmad SainsDoc
*/
public class Test {

public static void main(String[] args) {
MySQLConnection msqlc = new MySQLConnection();
Connection conn = null;
msqlc.setUrl("jdbc:mysql://localhost:3306/database");
msqlc.setUsername("root");
msqlc.setPassword("");
try {
msqlc.setConn(conn);
msqlc.getConn();
System.out.println("Koneksi Berhasil");
} catch (Exception e) {
e.printStackTrace();
System.out.println("Koneksi Gagal");
}
}
}