private void jButton1ActionPerformed( java.awt.event.ActionEvent evt) { // GEN-FIRST:event_jButton1ActionPerformed // TODO add your handling code here: DataBaseConnect db = new DataBaseConnect(); Connection con; Statement stmt; ResultSet rs; try { con = db.dbConnect(); stmt = con.createStatement(); // String id=getConnectionId(); rs = stmt.executeQuery("select *from userlogin"); Boolean found = false; while (rs.next()) { if (rs.getString(1).equalsIgnoreCase(jtxtuser.getText()) && rs.getString(2).equalsIgnoreCase(jtxtpass.getText())) { found = true; break; } } rs.close(); // int i= stmt.executeUpdate("insert into // bills(billid,customerid,datefrom,dateto,units,maxunit,minunit,maxcharge,mincharge,status) // values ( // '"+jtxtbillid.getText()+"','"+jcmbcustomerid.getSelectedItem().toString()+"','"+jtxtbillfrom.getText()+"','"+jtxtbillto.getText()+"','"+jtxtunits.getText()+"','"+jtxtmaxunit.getText()+"','"+jtxtminunit.getText()+"','"+Double.parseDouble(jtxtmaxunit.getText())*maxunitrate+"','"+Double.parseDouble(jtxtmaxunit.getText())*unitrate+"','1')"); if (found) { this.dispose(); CEB ce = new CEB(); ce.setVisible(true); } else JOptionPane.showMessageDialog(null, "Wrong Password"); stmt.close(); con.close(); } catch (SQLException sql) { JOptionPane.showMessageDialog(null, sql); } } // GEN-LAST:event_jButton1ActionPerformed