hi everybody wazup
I am currently practicing my java skills by doing this program called car rental management system. I am creating a login page where when the user login it should bring up a dashboard. but the problems when the user login and it say "credentials match, the dashboard doesnt come up and in the output controls I got this error msg:
and here is the codes that i used. can someone tell me what is going on and tell me how to rectified it
Sat Jan 13 00:12:21 BOT 2018 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import javax.swing.*;
/**
*
* @author luana
*/
public class Login_Form extends javax.swing.JFrame {
Connection conn;
PreparedStatement stmt = null;
ResultSet rs;
public Login_Form() {
initComponents();
}
@SuppressWarnings("unchecked")
// <editor-fold defaultstate="collapsed" desc="Generated Code">
private void initComponents() {
jPanel1 = new javax.swing.JPanel();
jLab_UserLogin = new javax.swing.JLabel();
jLab_UserID = new javax.swing.JLabel();
jText_UserID = new javax.swing.JTextField();
jLab_pwd = new javax.swing.JLabel();
jPass = new javax.swing.JPasswordField();
jLab_display = new javax.swing.JLabel();
jText_display = new javax.swing.JTextField();
jLab_UserType = new javax.swing.JLabel();
jComboBox1 = new javax.swing.JComboBox<>();
jbtn_Exit = new javax.swing.JButton();
jbtn_Login = new javax.swing.JButton();
jLabel1 = new javax.swing.JLabel();
jbtn_reset = new javax.swing.JButton();
setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
setMinimumSize(new java.awt.Dimension(580, 560));
setPreferredSize(new java.awt.Dimension(580, 560));
getContentPane().setLayout(null);
jPanel1.setMinimumSize(new java.awt.Dimension(580, 660));
jPanel1.setLayout(null);
jLab_UserLogin.setFont(new java.awt.Font("Cambria", 3, 24)); // NOI18N
jLab_UserLogin.setForeground(new java.awt.Color(204, 0, 0));
jLab_UserLogin.setHorizontalAlignment(javax.swing.SwingConstants.CENTER);
jLab_UserLogin.setText("User Login");
jPanel1.add(jLab_UserLogin);
jLab_UserLogin.setBounds(124, 40, 220, 30);
jLab_UserID.setFont(new java.awt.Font("Cambria", 3, 12)); // NOI18N
jLab_UserID.setForeground(new java.awt.Color(204, 0, 0));
jLab_UserID.setText("User ID");
jPanel1.add(jLab_UserID);
jLab_UserID.setBounds(20, 110, 100, 15);
jText_UserID.setFont(new java.awt.Font("Cambria", 3, 12)); // NOI18N
jPanel1.add(jText_UserID);
jText_UserID.setBounds(170, 110, 230, 21);
jLab_pwd.setFont(new java.awt.Font("Cambria", 3, 12)); // NOI18N
jLab_pwd.setForeground(new java.awt.Color(204, 0, 0));
jLab_pwd.setText("Password");
jPanel1.add(jLab_pwd);
jLab_pwd.setBounds(20, 180, 100, 15);
jPass.setFont(new java.awt.Font("Cambria", 3, 12)); // NOI18N
jPanel1.add(jPass);
jPass.setBounds(170, 180, 230, 21);
jLab_display.setFont(new java.awt.Font("Cambria", 3, 12)); // NOI18N
jLab_display.setForeground(new java.awt.Color(153, 0, 0));
jLab_display.setText("Display");
jPanel1.add(jLab_display);
jLab_display.setBounds(20, 240, 100, 15);
jText_display.setFont(new java.awt.Font("Cambria", 3, 11)); // NOI18N
jText_display.setEnabled(false);
jPanel1.add(jText_display);
jText_display.setBounds(170, 240, 230, 20);
jLab_UserType.setFont(new java.awt.Font("Cambria", 3, 12)); // NOI18N
jLab_UserType.setForeground(new java.awt.Color(153, 0, 0));
jLab_UserType.setText("UserType");
jPanel1.add(jLab_UserType);
jLab_UserType.setBounds(20, 310, 100, 20);
jComboBox1.setFont(new java.awt.Font("Cambria", 3, 12)); // NOI18N
jComboBox1.setModel(new javax.swing.DefaultComboBoxModel<>(new String[] { "Admin", "Receptionist 2", "Supervisor 3", "Manager 4" }));
jPanel1.add(jComboBox1);
jComboBox1.setBounds(170, 300, 220, 30);
jbtn_Exit.setFont(new java.awt.Font("Cambria", 3, 14)); // NOI18N
jbtn_Exit.setForeground(new java.awt.Color(204, 0, 51));
jbtn_Exit.setText("Exit");
jbtn_Exit.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jbtn_ExitActionPerformed(evt);
}
});
jPanel1.add(jbtn_Exit);
jbtn_Exit.setBounds(173, 377, 100, 40);
jbtn_Login.setFont(new java.awt.Font("Cambria", 3, 14)); // NOI18N
jbtn_Login.setForeground(new java.awt.Color(204, 0, 0));
jbtn_Login.setText("Login");
jbtn_Login.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jbtn_LoginActionPerformed(evt);
}
});
jPanel1.add(jbtn_Login);
jbtn_Login.setBounds(310, 373, 90, 40);
jLabel1.setIcon(new javax.swing.ImageIcon(getClass().getResource("/Rental_Services/note.png"))); // NOI18N
jLabel1.setText("jLabel1");
jPanel1.add(jLabel1);
jLabel1.setBounds(0, 0, 510, 460);
jbtn_reset.setFont(new java.awt.Font("Cambria", 3, 12)); // NOI18N
jbtn_reset.setForeground(new java.awt.Color(255, 0, 0));
jbtn_reset.setText("Reset");
jbtn_reset.setActionCommand("");
jbtn_reset.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jbtn_resetActionPerformed(evt);
}
});
jPanel1.add(jbtn_reset);
jbtn_reset.setBounds(20, 383, 90, 40);
getContentPane().add(jPanel1);
jPanel1.setBounds(0, 0, 510, 460);
pack();
}// </editor-fold>
private JFrame frame;
private void jbtn_ExitActionPerformed(java.awt.event.ActionEvent evt) {
frame = new JFrame("Exit");
if(JOptionPane.showConfirmDialog(frame, "Confirm if you wish to exit", "Clear TextField System",
JOptionPane.YES_NO_OPTION)==JOptionPane.YES_NO_OPTION){
System.exit(0);
}
}
private void jbtn_LoginActionPerformed(java.awt.event.ActionEvent evt) {
try{
Class.forName("java.sql.Driver");
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/car_rental_management_system", "root","");
String sql = "Select * from login where usersID = ? and password = ?";
PreparedStatement stmt = conn.prepareStatement(sql);
stmt.setString(1, jText_UserID.getText());
stmt.setString(2, jPass.getText());
ResultSet rs = stmt.executeQuery();
if(rs.next()){
JOptionPane.showMessageDialog(null, "login crendtials match");
Dashboard dash = new Dashboard();
dash.setVisible(false);
}
else{
JOptionPane.showMessageDialog(null, "login credential does not match");
}
conn.close();
}catch(Exception e){
JOptionPane.showMessageDialog(null, e);
}