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
