Source Code:
Copied!
import java.awt.Color;
import javax.swing.JOptionPane;
import java.sql.Connection;
import java.sql.DriverManager;
private Connection conn;
private void btnConnectActionPerformed(java.awt.event.ActionEvent evt) {
try {
Class.forName("com.mysql.cj.jdbc.Driver");
String url = "jdbc:mysql://localhost:3306/?useSSL=false&serverTimezone=Asia/Phnom_Penh";
String user = "root"; // your MySQL username
String password = "root"; // your MySQL password
conn = DriverManager.getConnection(url, user, password);
lblStatus.setText("Connected");
lblStatus.setForeground(Color.ORANGE);
} catch (Exception ex) {
JOptionPane.showMessageDialog(this, "Connection Failed: " + ex.getMessage());
}
}
private void btnDisconnectActionPerformed(java.awt.event.ActionEvent evt) {
try {
if (conn != null && !conn.isClosed()) {
conn.close();
lblStatus.setText("Disconnected");
lblStatus.setForeground(Color.RED);
}
} catch (Exception ex) {
JOptionPane.showMessageDialog(this, "Error disconnecting: " + ex.getMessage());
}
}
Result:
