0

Hi! I am having problems with my login form. So I created a database for my login form so that i can create multiple user. That works fine but when I try to log in the user created an error shows:

Error:

java.sql.SQLException: No row count was produced
	at sun.jdbc.odbc.JdbcOdbcPreparedStatement.executeUpdate(JdbcOdbcPreparedStatement.java:146)
	at myjava.login.jButton1ActionPerformed(login.java:144)
	at myjava.login.access$000(login.java:21)
	at myjava.login$1.actionPerformed(login.java:68)
	at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
	at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
	at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
	at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
	at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)
	at java.awt.Component.processMouseEvent(Component.java:6288)
	at javax.swing.JComponent.processMouseEvent(JComponent.java:3267)
	at java.awt.Component.processEvent(Component.java:6053)
	at java.awt.Container.processEvent(Container.java:2041)
	at java.awt.Component.dispatchEventImpl(Component.java:4651)
	at java.awt.Container.dispatchEventImpl(Container.java:2099)
	at java.awt.Component.dispatchEvent(Component.java:4481)
	at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4577)
	at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4238)
	at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4168)
	at java.awt.Container.dispatchEventImpl(Container.java:2085)
	at java.awt.Window.dispatchEventImpl(Window.java:2478)
	at java.awt.Component.dispatchEvent(Component.java:4481)
	at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:643)
	at java.awt.EventQueue.access$000(EventQueue.java:84)
	at java.awt.EventQueue$1.run(EventQueue.java:602)
	at java.awt.EventQueue$1.run(EventQueue.java:600)
	at java.security.AccessController.doPrivileged(Native Method)
	at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
	at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:98)
	at java.awt.EventQueue$2.run(EventQueue.java:616)
	at java.awt.EventQueue$2.run(EventQueue.java:614)
	at java.security.AccessController.doPrivileged(Native Method)
	at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
	at java.awt.EventQueue.dispatchEvent(EventQueue.java:613)
	at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
	at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
	at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174)
	at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)
	at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)
	at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)

and this is my code for my login form:

private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
        
        String database = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)}; DBQ=C:/Users/OJT/Documents/db3.mdb";
           
        try {
            // TODO add your handling code here:
            if (conn == null)
                conn = DriverManager.getConnection(database);
            String username = userField.getText();
            String password = passField.getText();
            
            String s = "select Username, Pass2 from Info where Username = '"+ username +
    "' and Pass2 = '"+password+ "'";
            
            PreparedStatement statement1 = conn.prepareStatement(s);
                                statement1.executeUpdate();
                                //getContentPane().update();
                              
                                if (statement1 != null)
                                {
                                JOptionPane.showMessageDialog(null, "Login Successful!", 
                                        "Information!", JOptionPane.INFORMATION_MESSAGE);}
                                
                                else
                                {
                                JOptionPane.showMessageDialog(null, "Wrong Username Password!", 
                                        "Information!", JOptionPane.INFORMATION_MESSAGE);
                                }
        } catch (Exception ex) {
            Logger.getLogger(login.class.getName()).log(Level.SEVERE, null, ex);
        }
    }

thanks :)

Edited by marsangel: n/a

1
Contributor
1
Reply
2
Views
5 Years
Discussion Span
Last Post by marsangel
0

im sorry, i just overlooked the execution of the query. instead of query i coded it as update. problem solved already :)

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.