import java.awt.Frame;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.swing.JFrame;
import javax.swing.JOptionPane;
/*
* To change this license header, choose License Headers in Project Properties.
* To change this template file, choose Tools | Templates
* and open the template in the editor.
*/
/**
*
* @author User
*/
public class LoginForm extends javax.swing.JFrame {
/**
* Creates new form LoginForm
*/
public LoginForm() {
initComponents();
}
/**
* This method is called from within the constructor to initialize the form.
* WARNING: Do NOT modify this code. The content of this method is always
* regenerated by the Form Editor.
*/
@SuppressWarnings("unchecked")
// <editor-fold defaultstate="collapsed" desc="Generated Code">
private void initComponents() {
jPanel1 = new javax.swing.JPanel();
jPanelLOG_IN = new javax.swing.JPanel();
jLabel1 = new javax.swing.JLabel();
jTextField_username = new javax.swing.JTextField();
jLabel2 = new javax.swing.JLabel();
jPasswordField_password = new javax.swing.JPasswordField();
jLabel3 = new javax.swing.JLabel();
jComboBox_USERTYPE = new javax.swing.JComboBox<>();
jLabel5 = new javax.swing.JLabel();
jLabel4 = new javax.swing.JLabel();
jLabel6 = new javax.swing.JLabel();
jLabel_EXIT = new javax.swing.JLabel();
jLabel_MINIMIZED = new javax.swing.JLabel();
jButtonLOG_IN = new javax.swing.JButton();
setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
setLocation(new java.awt.Point(525, 250));
setUndecorated(true);
jPanel1.setBackground(new java.awt.Color(204, 204, 204));
jPanelLOG_IN.setBackground(new java.awt.Color(1, 152, 117));
jLabel1.setBackground(new java.awt.Color(255, 255, 255));
jLabel1.setFont(new java.awt.Font("Rockwell", 0, 15)); // NOI18N
jLabel1.setForeground(new java.awt.Color(255, 255, 255));
jLabel1.setText("Username");
jTextField_username.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jTextField_usernameActionPerformed(evt);
}
});
jLabel2.setFont(new java.awt.Font("Rockwell", 0, 15)); // NOI18N
jLabel2.setForeground(new java.awt.Color(255, 255, 255));
jLabel2.setText("Password");
jLabel3.setFont(new java.awt.Font("Rockwell", 0, 15)); // NOI18N
jLabel3.setForeground(new java.awt.Color(255, 255, 255));
jLabel3.setText("Usertype:");
jComboBox_USERTYPE.setFont(new java.awt.Font("Rockwell", 0, 13)); // NOI18N
jComboBox_USERTYPE.setModel(new javax.swing.DefaultComboBoxModel<>(new String[] { "Please Choose Usertype", "Admin", "Teacher", "Student" }));
jLabel5.setIcon(new javax.swing.ImageIcon("C:\\Users\\User\\Downloads\\KLD.jpg")); // NOI18N
jLabel4.setIcon(new javax.swing.ImageIcon("C:\\Users\\User\\Downloads\\Dasma_City_Logo.png")); // NOI18N
jLabel6.setFont(new java.awt.Font("Rockwell", 0, 18)); // NOI18N
jLabel6.setForeground(new java.awt.Color(255, 255, 255));
jLabel6.setText("Welcome Kolehiyans!");
jLabel_EXIT.setFont(new java.awt.Font("Rockwell", 1, 24)); // NOI18N
jLabel_EXIT.setForeground(new java.awt.Color(255, 255, 255));
jLabel_EXIT.setText("X");
jLabel_EXIT.addMouseListener(new java.awt.event.MouseAdapter() {
public void mouseClicked(java.awt.event.MouseEvent evt) {
jLabel_EXITMouseClicked(evt);
}
});
jLabel_MINIMIZED.setFont(new java.awt.Font("Rockwell", 1, 24)); // NOI18N
jLabel_MINIMIZED.setForeground(new java.awt.Color(255, 255, 255));
jLabel_MINIMIZED.setText("-");
jLabel_MINIMIZED.addMouseListener(new java.awt.event.MouseAdapter() {
public void mouseClicked(java.awt.event.MouseEvent evt) {
jLabel_MINIMIZEDMouseClicked(evt);
}
});
enter code here
jButtonLOG_IN.setFont(new java.awt.Font("Rockwell", 0, 15)); // NOI18N
jButtonLOG_IN.setText("Login");
jButtonLOG_IN.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButtonLOG_INActionPerformed(evt);
}
});
javax.swing.GroupLayout jPanelLOG_INLayout = new javax.swing.GroupLayout(jPanelLOG_IN);
jPanelLOG_IN.setLayout(jPanelLOG_INLayout);
jPanelLOG_INLayout.setHorizontalGroup(
jPanelLOG_INLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanelLOG_INLayout.createSequentialGroup()
.addGap(70, 70, 70)
.addComponent(jLabel5)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 97, Short.MAX_VALUE)
.addGroup(jPanelLOG_INLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanelLOG_INLayout.createSequentialGroup()
.addComponent(jLabel4)
.addGap(134, 134, 134))
.addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanelLOG_INLayout.createSequentialGroup()
.addComponent(jLabel6)
.addGap(86, 86, 86))
.addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanelLOG_INLayout.createSequentialGroup()
.addComponent(jLabel2)
.addGap(139, 139, 139))
.addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanelLOG_INLayout.createSequentialGroup()
.addGroup(jPanelLOG_INLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
.addComponent(jTextField_username)
.addComponent(jPasswordField_password)
.addGroup(jPanelLOG_INLayout.createSequentialGroup()
.addComponent(jLabel3)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(jComboBox_USERTYPE, javax.swing.GroupLayout.PREFERRED_SIZE, 181, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGroup(jPanelLOG_INLayout.createSequentialGroup()
.addGap(91, 91, 91)
.addComponent(jLabel1))
.addComponent(jButtonLOG_IN, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.PREFERRED_SIZE, 107, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGap(45, 45, 45))))
.addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanelLOG_INLayout.createSequentialGroup()
.addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(jLabel_MINIMIZED)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addComponent(jLabel_EXIT)
.addContainerGap())
);
jPanelLOG_INLayout.setVerticalGroup(
jPanelLOG_INLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanelLOG_INLayout.createSequentialGroup()
.addContainerGap()
.addGroup(jPanelLOG_INLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel_EXIT, javax.swing.GroupLayout.PREFERRED_SIZE, 27, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel_MINIMIZED, javax.swing.GroupLayout.PREFERRED_SIZE, 27, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGap(22, 22, 22)
.addGroup(jPanelLOG_INLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanelLOG_INLayout.createSequentialGroup()
.addComponent(jLabel4)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(jLabel6, javax.swing.GroupLayout.DEFAULT_SIZE, 34, Short.MAX_VALUE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(jLabel1)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(jTextField_username, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(jLabel2)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addComponent(jPasswordField_password, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(18, 18, 18)
.addGroup(jPanelLOG_INLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel3)
.addComponent(jComboBox_USERTYPE, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addComponent(jButtonLOG_IN)
.addGap(139, 139, 139))
.addGroup(jPanelLOG_INLayout.createSequentialGroup()
.addComponent(jLabel5)
.addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))))
);
javax.swing.GroupLayout jPanel1Layout = new javax.swing.GroupLayout(jPanel1);
jPanel1.setLayout(jPanel1Layout);
jPanel1Layout.setHorizontalGroup(
jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel1Layout.createSequentialGroup()
.addContainerGap()
.addComponent(jPanelLOG_IN, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addContainerGap())
);
jPanel1Layout.setVerticalGroup(
jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel1Layout.createSequentialGroup()
.addContainerGap()
.addComponent(jPanelLOG_IN, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addContainerGap())
);
javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
getContentPane().setLayout(layout);
layout.setHorizontalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jPanel1, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
);
layout.setVerticalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jPanel1, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
);
pack();
}// </editor-fold>
private void jLabel_EXITMouseClicked(java.awt.event.MouseEvent evt) {
System.exit(0);
}
private void jLabel_MINIMIZEDMouseClicked(java.awt.event.MouseEvent evt) {
this.setState(JFrame.ICONIFIED);
}
private void jTextField_usernameActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
}
private void jButtonLOG_INActionPerformed(java.awt.event.ActionEvent evt) {
Connection con = MyConnection.getConnection();
PreparedStatement ps;
ResultSet rs;
String username = jTextField_username.getText();
String password = String.valueOf(jPasswordField_password.getPassword());
String query = "SELECT * FROM `accounts` WHERE `username` =? AND `password `=?";
try {
ps = MyConnection.getConnection().prepareStatement(query);
rs = ps.executeQuery();
ps.setString(1, username);
ps.setString(2, password);
if(rs.next())
{
Faculty fac = new Faculty();
fac.setVisible(true);
fac.pack();
fac.setLocationRelativeTo(null);
fac.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
this.dispose();
}
{
JOptionPane.showMessageDialog(null, "NO");
}
} catch (SQLException ex) {
Logger.getLogger(LoginForm.class.getName()).log(Level.SEVERE, null, ex);
}
}
/**
* @param args the command line arguments
*/
public static void main(String args[]) {
/* Set the Nimbus look and feel */
//<editor-fold defaultstate="collapsed" desc=" Look and feel setting code (optional) ">
/* If Nimbus (introduced in Java SE 6) is not available, stay with the default look and feel.
* For details see http://download.oracle.com/javase/tutorial/uiswing/lookandfeel/plaf.html
*/
try {
for (javax.swing.UIManager.LookAndFeelInfo info : javax.swing.UIManager.getInstalledLookAndFeels()) {
if ("Nimbus".equals(info.getName())) {
javax.swing.UIManager.setLookAndFeel(info.getClassName());
break;
}
}
} catch (ClassNotFoundException ex) {
java.util.logging.Logger.getLogger(LoginForm.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
} catch (InstantiationException ex) {
java.util.logging.Logger.getLogger(LoginForm.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
} catch (IllegalAccessException ex) {
java.util.logging.Logger.getLogger(LoginForm.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
} catch (javax.swing.UnsupportedLookAndFeelException ex) {
java.util.logging.Logger.getLogger(LoginForm.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
}
//</editor-fold>
/* Create and display the form */
java.awt.EventQueue.invokeLater(new Runnable() {
public void run() {
new LoginForm().setVisible(true);
}
});
}
// Variables declaration - do not modify
private javax.swing.JButton jButtonLOG_IN;
private javax.swing.JComboBox<String> jComboBox_USERTYPE;
private javax.swing.JLabel jLabel1;
private javax.swing.JLabel jLabel2;
private javax.swing.JLabel jLabel3;
private javax.swing.JLabel jLabel4;
private javax.swing.JLabel jLabel5;
private javax.swing.JLabel jLabel6;
private javax.swing.JLabel jLabel_EXIT;
private javax.swing.JLabel jLabel_MINIMIZED;
private javax.swing.JPanel jPanel1;
private javax.swing.JPanel jPanelLOG_IN;
private javax.swing.JPasswordField jPasswordField_password;
private javax.swing.JTextField jTextField_username;
// End of variables declaration
}
This is my error:
run:
com.mysql.cj.jdbc.Driver
Exception in thread "AWT-EventQueue-0" java.lang.NullPointerException
com.mysql.cj.jdbc.Driver
at LoginForm.jButtonLOG_INActionPerformed(LoginForm.java:244)
at LoginForm.access$300(LoginForm.java:23)
at LoginForm$4.actionPerformed(LoginForm.java:116)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2022)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2348)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:402)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:252)
at java.awt.Component.processMouseEvent(Component.java:6533)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3324)
at java.awt.Component.processEvent(Component.java:6298)
at java.awt.Container.processEvent(Container.java:2236)
at java.awt.Component.dispatchEventImpl(Component.java:4889)
at java.awt.Container.dispatchEventImpl(Container.java:2294)
at java.awt.Component.dispatchEvent(Component.java:4711)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4888)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4525)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4466)
at java.awt.Container.dispatchEventImpl(Container.java:2280)
at java.awt.Window.dispatchEventImpl(Window.java:2746)
at java.awt.Component.dispatchEvent(Component.java:4711)
at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:758)
at java.awt.EventQueue.access$500(EventQueue.java:97)
at java.awt.EventQueue$3.run(EventQueue.java:709)
at java.awt.EventQueue$3.run(EventQueue.java:703)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:76)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:86)
at java.awt.EventQueue$4.run(EventQueue.java:731)
at java.awt.EventQueue$4.run(EventQueue.java:729)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:76)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:728)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:201)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:105)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:82)
