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

From:

tobleron <budhik@yahoo.com>

Newsgroups:

comp.lang.java.programmer

Date:

Tue, 30 Sep 2008 06:59:45 -0700 (PDT)

Message-ID:

<cb925a28-798f-42e6-8940-fe78e1159d4d@t54g2000hsg.googlegroups.com>

On Sep 30, 7:54 pm, Roland de Ruiter
<roland.de.rui...@example.invalid> wrote:

On 30-9-2008 9:16, Stefan Rybacki wrote:

Tom Anderson schrieb:

On Mon, 29 Sep 2008, tobleron wrote:

...
As far as i know, case sensitivity is database-specific. There will be
special commands in your database's dialect of SQL to control it.

If I remember correct for MySQL it was the BINARY keyword.

Exactly:

SELECT "abc" = "ABC"
-> 1

SELECT "abc" = BINARY "ABC"
-> 0

Other than that I agree with the "use prepared statements" as well as
"don't store your password in plain text" comments.

Stefan

I agree.
--
Regards,

Roland

Hi, I've tried to follow all of your suggestion, but my program always
result to the else statements of the if selection, whatever values
that inputted through the form. Here is my code :

@Action public void dologin() {
        String url = "jdbc:mysql://localhost:3306/dicom?
jdbcCompliantTruncation=false";
        Connection con;
        PreparedStatement passwordLookup ;

        try {
            Class.forName("com.mysql.jdbc.Driver");
        } catch(java.lang.ClassNotFoundException e) {
            System.err.println(e);
        }

        try {
            con = DriverManager.getConnection(url, "root", "");
            String sql = "SELECT * FROM user WHERE userid = '"+
UserIDTxt.getText() +"' AND passwd = '"+ PasswdTxt.getSelectedText()
+"'";
            passwordLookup = con.prepareStatement(sql);
            ResultSet result = passwordLookup.executeQuery();

            if (result.first()) {
                  String dbUsername = result.getString(1) ;
                  String dbPassword = result.getString(2) ;

                  if ((dbUsername.equals(UserIDTxt.getText())) &&
(dbPassword.equals(PasswdTxt.getSelectedText()))){
                       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();
                           LoginWarningBox = new
LoginWarning(mainFrame);

LoginWarningBox.setLocationRelativeTo(mainFrame);
                       }
                       Main.getApplication().show(LoginWarningBox);
                  }
            }
            else {
                       setVisible(false);
                       if (LoginWarningBox == null) {
                           JFrame mainFrame =
Main.getApplication().getMainFrame();
                           LoginWarningBox = new
LoginWarning(mainFrame);

LoginWarningBox.setLocationRelativeTo(mainFrame);
                       }
                       Main.getApplication().show(LoginWarningBox);
                  }
            result.close();
            con.close();
        } catch(SQLException e) {
            System.err.println(e);
        }
    }

The structure of my table is :

a4identity : 1
userid : test
passwd : myecg
repasswd : myecg
phyname : test
dept : test
create : N
view : N
edit : N

I'm using NetBeans 6.1 and MySQL 5.0.51b. Do I missed something ?
Please help.