Query from oracle database for specific character

[Albert Hopkins]

Hi...
please assist me:

I want to query a name called "hello_sbm_007" from a field.

I used this code:

  if ("Development".equals(STATENAME) & "_SBM_".equals(BLESS_ORNO) )
{
if ("1".equals(BLESS_SEVERITY)) devsubcount1 = devsubcount1 + 1; 
if ("2".equals(BLESS_SEVERITY)) devsubcount2 = devsubcount2 + 1; 
if ("3".equals(BLESS_SEVERITY)) devsubcount3 = devsubcount3 + 1;
}  

The code should query word that contains "_SBM_" . It didn't worked for me.

Pleas help

[Bauke Scholtz]

Sorry, I don't see how the given information fits in each other and above all I also don't see how this is related to JSP.

Please elaborate your problem the smart way.

[Albert Hopkins]

Ok..this is another example

  try {
        if (configId != null && configId.trim().length() > 0) {

            Config dsConfig = dataService.getConfig(configId);
            if (config != null) {
                dataSourceType = dsConfig.getDataSourceType();
                ArrayList configProperties = dsConfig.getProperties();
                propertyIterator = configProperties.iterator();
                if("RDBMS".equals(dataSourceType)){
                    String jdbcUrl = dsConfig.getPropertyValue(DBConstants.PROTOCOL);
                    if(jdbcUrl != null){
                        rdbmsEngineType = Utils.getRDBMSEngine(jdbcUrl);
                    }
                }
            }
        } else {
            configId = "";
  

you can see this

  if("RDBMS".equals(dataSourceType)){   

line.

It queries "RDBMS" from the database. I want that the script queries any word contains any "R _ _ _ S" . The result will come out.

In SQL, I understand we can use ( select dataSourceType from data where dataSourceType like 'r_ _ _s') .

I hope this helps.

thank you

[Bauke Scholtz]

Albert Hopkins wrote:
you can see this

  if("RDBMS".equals(dataSourceType)){   

line.

It queries "RDBMS" from the database.

This doesn't query "RDBMS" from the database at all. It just compares the string "RDBMS" with the string value as referenced by 'dataSourceType'.

I want that the script queries any word contains any "R _ _ _ S" . The result will come out.

In SQL, I understand we can use ( select dataSourceType from data where dataSourceType like 'r_ _ _s') .

I hope this helps.

thank you

This is database specific. Consult its documentation. In MySQL you could do so, but then without spaces.

This has still nothing to do with JSP at all. If you were writing this code in a JSP file, you should immediately stop this and moving it into a real Java class. Scriptlets are a bad practice.

[Albert Hopkins]

Thank you.

[Albert Hopkins]

ok...

the script compares string

"RDBMS" using .equals

How if i don't want to use equals, because I want the script to compare without using the whole "RDBMS". Just compare "R....S" ??

Can you suggest??

[Balu Sadhasivam]

Check out this String.matches(). Create a regular expression something like "R[a-zA-Z]*S" this and match the result.

Note if you want to limit the charcters to 5, change it accordingly using Regex Pattern

[Bauke Scholtz]

It's sometimes very impressive how a question can be asked the bad way that it will be interpreted completely differently.

In the future please try to use the correct terminology and ask questions the smart way.