Re: How to make getText() return the result in case sensitive ?

From:

Stefan Rybacki <noemail@noemail.foobar>

Newsgroups:

comp.lang.java.programmer

Date:

Wed, 01 Oct 2008 15:57:49 +0200

Message-ID:

<48e381dd$1@news.uni-rostock.de>

tobleron schrieb:

...
            if (result.next()) {
                  String dbUsername = result.getString("userid") ;
                  String dbPassword = result.getString("passwd") ;

You are still doing this redundant check whether username and password are
correct which the database already did for you.

                  if ((dbUsername.equals(userIDTxt.getText().trim()))
&& (dbPassword.equals(convertedChars.trim()))){
                       setVisible(false);
                       if (ecgMenuBox == null) {
                            JFrame mainFrame =
Main.getApplication().getMainFrame();
                            ecgMenuBox = new ECGMenu(mainFrame);

ecgMenuBox.setLocationRelativeTo(mainFrame);
                       }
                       Main.getApplication().show(ecgMenuBox);
                  }
                  else {
                       setVisible(false);
                       if (loginWarningBox == null) {
                           JFrame mainFrame =
Main.getApplication().getMainFrame();
                           mainFrame.setSize(100,80);
                           loginWarningBox = new
LoginWarning(mainFrame);

loginWarningBox.setLocationRelativeTo(mainFrame);
                       }
                       Main.getApplication().show(loginWarningBox);
                  }
            }
            else {
                       setVisible(false);
                       if (loginWarningBox == null) {
                           JFrame mainFrame =
Main.getApplication().getMainFrame();
                           mainFrame.setSize(100,80);
                           loginWarningBox = new
LoginWarning(mainFrame);

loginWarningBox.setLocationRelativeTo(mainFrame);
                       }
                       Main.getApplication().show(loginWarningBox);

                  }
            result.close();
            passwordLookup.close();
            con.close();
        } catch(SQLException e) {
            System.err.println(e);
        }
    }