بِسْمِ اللَّهِ الرَّحْمَنِ الرَّحِيمِ
First download the mysql-connector-java library you can search on google, after that import it from java. If the library is alredy imported please write the code below :
package Connection;
import java.sql.Connection;
import java.sql.Driver;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.swing.JOptionPane;
/**
*
* @author Awan-Cs
*/
public class mysql_connection {
private String database = "apotek"; //the name of database you want to connection with java
private String server = "jdbc:mysql://localhost/" + database;
private String username = "root";
private String password = "";
private Connection kon = null;
public mysql_k() {
try {
Class.forName("com.mysql.jdbc.Driver");
kon = DriverManager.getConnection(server, username, password);
JOptionPane.showMessageDialog(null, "Connection Succesfull");//messange
} catch (ClassNotFoundException ex) {
Logger.getLogger(mysql_k.class.getName()).log(Level.SEVERE, null, ex);
} catch (SQLException ex) {
JOptionPane.showMessageDialog(null, ex);
}
}
public static void main(String[] args) {
new mysql_k();
}
}
That's all, thank you.
Good Luck
