Regex Fetched from MYSQL is not validating

Question

  for(String paramName:paramNames){
    String regexString = regexPair.get(paramName);
    try{             
        System.out.println(regexString);
        Pattern p = Pattern.compile(regexString);
        Matcher m = p.matcher(paramMap.get(paramName)[0]);
        status = m.matches();
    }catch(Exception e)
    {
        e.printStackTrace();
    }
    if(!status)
           break;
}

where regexSring have value

 "^(?!.*[^A-Za-z0-9@])((?=.*\\d)(?=.*[a-z]).{6,20})$"

The value of regexString is fecthed from mysql db an populated in map and paramMap.get(paramName)[0] have value "dssf55454" but it is retuning false while it should return true.

If I write the following sample program

 Pattern p = Pattern.compile("^(?!.*[^A-Za-z0-9@])((?=.*\\d)(?=.*[a-z]).{6,20})$");
 Matcher m = p.matcher("mal4554SD");
 status = m.matches();
 System.out.println(status);

it returns true. Why?

Bhesh Gurung · Accepted Answer · 2012-07-27 04:05:23Z

3

The problem might be in the snippet \\d in the regexString.

What is the result printed in console?

System.out.println(regexString);

Also, it will be helpful if you can share more details about regexPair and its get().

edited Jul 27, 2012 at 4:05

Bhesh Gurung

51.1k23 gold badges96 silver badges147 bronze badges

answered Jul 27, 2012 at 3:51

kshen

8197 silver badges6 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

user1047873 Over a year ago

the value of System.out.println(regexString); is ^(?!.*[^A-Za-z0-9@])((?=.*\\d)(?=.*[a-z]).{6,20})$ regexPair contain regex for different field

kshen Over a year ago

\\d is the root cause. In your case, regexPair.get() should return \d. I mean you expect some digit number.

Collectives™ on Stack Overflow

Regex Fetched from MYSQL is not validating

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related