Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- private void entrar() {
- String sql = "SELECT * FROM logins WHERE usuario = ? and senha = ?";
- try {
- pst = conn.prepareStatement(sql);
- pst.setString(1, nomeUser.getText());
- pst.setString(2, senhaUser.getText());
- rs = pst.executeQuery();
- if(rs.next()){
- JOptionPane.showMessageDialog(null, "Login efetuado com sucesso");
- }else{
- JOptionPane.showMessageDialog(null, "Login inexistente");
- }
- } catch (Exception e) {
- JOptionPane.showMessageDialog(null, e);
- }
- }
- Exception in thread "AWT-EventQueue-0" java.lang.NullPointerException
- at forms.login.entrar(login.java:156)
- at forms.login.btnEntrarKeyPressed(login.java:136)
- at forms.login.access$100(login.java:21)
- at forms.login$2.keyPressed(login.java:83)
- at java.awt.Component.processKeyEvent(Component.java:6493)
- at javax.swing.JComponent.processKeyEvent(JComponent.java:2832)
- at java.awt.Component.processEvent(Component.java:6312)
- at java.awt.Container.processEvent(Container.java:2236)
- at java.awt.Component.dispatchEventImpl(Component.java:4891)
- at java.awt.Container.dispatchEventImpl(Container.java:2294)
- at java.awt.Component.dispatchEvent(Component.java:4713)
- at java.awt.KeyboardFocusManager.redispatchEvent(KeyboardFocusManager.java:1954)
- at java.awt.DefaultKeyboardFocusManager.dispatchKeyEvent(DefaultKeyboardFocusManager.java:806)
- at java.awt.DefaultKeyboardFocusManager.preDispatchKeyEvent(DefaultKeyboardFocusManager.java:1074)
- at java.awt.DefaultKeyboardFocusManager.typeAheadAssertions(DefaultKeyboardFocusManager.java:945)
- at java.awt.DefaultKeyboardFocusManager.dispatchEvent(DefaultKeyboardFocusManager.java:771)
- at java.awt.Component.dispatchEventImpl(Component.java:4762)
- at java.awt.Container.dispatchEventImpl(Container.java:2294)
- at java.awt.Window.dispatchEventImpl(Window.java:2750)
- at java.awt.Component.dispatchEvent(Component.java:4713)
- 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)
- pst = conn.prepareStatement(sql);
- public static final Connection getConnection(){
- try {
- Class.forName("org.sqlite.JDBC");
- return DriverManager.getConnection( (“jdbc:sqlite:nomeDoSeuBanco.db") );
- } catch (final Exception e) {
- e.printStackTrace();
- return null;
- }
- }
- private void entrar() {
- String sql = "SELECT * FROM logins WHERE usuario = ? and senha = ?";
- try {
- Connection con = getConnection();
- if(null == con){
- // está nula, não consegui carregar, então ão poderemos continuar!
- return;
- }
- pst = conn.prepareStatement(sql);
- pst.setString(1, nomeUser.getText());
- pst.setString(2, senhaUser.getText());
- rs = pst.executeQuery();
- if(rs.next()){
- JOptionPane.showMessageDialog(null, "Login efetuado com sucesso");
- }else{
- JOptionPane.showMessageDialog(null, "Login inexistente");
- }
- } catch (Exception e) {
- JOptionPane.showMessageDialog(null, e);
- }
- }
- public static Connection ConnectionDB(){
- try{
- Class.forName("org.sqlite.JDBC");
- Connection conn = DriverManager.getConnection("jdbc:sqlite:/home/aminadabe/Documentos/DBmembresia/membresiaDB.sqlite");
- // JOptionPane.showMessageDialog(null, "Deu certo");
- return conn;
- }
- catch(Exception e){
- JOptionPane.showMessageDialog(null, e);
- }
- return null;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement