String count with substring

[sang]

Hello
i have a doubt in string count with the sub string.
the main string is "java,mysql,jsp,java,html";
the sub string is like this "java,mysql"

The output is like this
java 2
mysql 1

that is count the no of occureience of the sub string .

how can i do this please help to do this .

Thanks
Sang

[Ganon11]

Could you please explain your problem a bit more fully and post any code you've written or ideas you have?

[sang]

Here is my code

import java.io.*; 
 import java.util.StringTokenizer; 
 public class strcount
    {      
          public static void main(String arg[]) {      
     String Resume = "java,html,jsp,c,java,dhtml,unix,html";                    String Keyword = "java,html";           
          StringTokenizer st = new      StringTokenizer(Keyword, ",");           
          int count = st.countTokens();           
          int pos = -1;  
     while ( (pos = Resume.indexOf( Keyword, pos + 1 ) ) > -1 )                count++ ;
    System.out.println( "The Keyword" + Keyword + " occurs " + count +               " times" ) ; 
      }   
}

The output is The Keywordjava,html occurs 3 times.

but i want to print java 2 times
html 1 time
Help me please
Thank you
Sang

[r035198x]

Hello
i have a doubt in string count with the sub string.
the main string is "java,mysql,jsp,java,html";
the sub string is like this "java,mysql"

The output is like this
java 2
mysql 1

that is count the no of occureience of the sub string .

how can i do this please help to do this .

Thanks
Sang

You better have a look at regular expressions too.

[sang]

You better have a look at regular expressions too.

please give me the code to solve my problem

[sicarie]

please give me the code to solve my problem

The experts on this site are more than happy to help you with your problems but they cannot do your assignment/program for you. Attempt the assignment/program yourself first and post questions regarding any difficulties you have or about a particular function of the code that you don't know how to achieve.

Please read the Posting Guidelines and particularly the Coursework Posting Guidlines.

Then when you are ready post a new question in this thread.

MODERATOR

That is in our Posting Guidelines. Not only that, but we can't help you without more information (which a more specific question would have given us). It depends what you are looking for, and what your regex is currently. Try looking at this tutorial, and see where it gets you. When you have another, more specific question, post it here, and we'll be able to help you better.

[sang]

The experts on this site are more than happy to help you with your problems but they cannot do your assignment/program for you. Attempt the assignment/program yourself first and post questions regarding any difficulties you have or about a particular function of the code that you don't know how to achieve.

Please read the Posting Guidelines and particularly the Coursework Posting Guidlines.

Then when you are ready post a new question in this thread.

MODERATOR

That is in our Posting Guidelines. Not only that, but we can't help you without more information (which a more specific question would have given us). It depends what you are looking for, and what your regex is currently. Try looking at this tutorial, and see where it gets you. When you have another, more specific question, post it here, and we'll be able to help you better.

Here is my example code i already posted.so please correct my code to solve my problem.

Re: String count with substring
Here is my codeCode:
import java.io.*;
import java.util.StringTokenizer;
public class strcount
{
public static void main(String arg[]) {
String Resume = "java,html,jsp,c,java,dhtml,unix,html"; String Keyword = "java,html";
StringTokenizer st = new StringTokenizer(Keyword, ",");
int count = st.countTokens();
int pos = -1;
while ( (pos = Resume.indexOf( Keyword, pos + 1 ) ) > -1 ) count++ ;
System.out.println( "The Keyword" + Keyword + " occurs " + count + " times" ) ;
}
}



The output is The Keywordjava,html occurs 3 times.

but i want to print java 2 times
html 1 time
Help me please
Thank you
Sang

[r035198x]

Here is my example code i already posted.so please correct my code to solve my problem.

You are better off using regular expressions for this. If you do have to use that tokenizer of yours, then you should use something like

 
String resume = "java,html,jsp,c,java,dhtml,unix,html";
StringTokenizer st = new StringTokenizer(resume , ",");
int javaCount = 0;
int htmlCount = 0;
while(st.hasMoreTokens()) {
 String s = st.nextToken();
    if(s.equals("java")) {
        javaCount = javaCount  + 1;
    }
    else if(s.equals("html")) {
        htmlCount =  htmlCount + 1;
    }
}
 

[sang]

You are better off using regular expressions for this. If you do have to use that tokenizer of yours, then you should use something like

 
String resume = "java,html,jsp,c,java,dhtml,unix,html";
StringTokenizer st = new StringTokenizer(resume , ",");
int javaCount = 0;
int htmlCount = 0;
while(st.hasMoreTokens()) {
 String s = st.nextToken();
    if(s.equals("java")) {
        javaCount = javaCount  + 1;
    }
    else if(s.equals("html")) {
        htmlCount =  htmlCount + 1;
    }
}
 

Sorry to distrub you.
I am not finished my work till. From the above coding we don't use the sub string.
My actual requriement is count the no of substrings occurs in the main string.

my actual string is "java,html,unix,java"
my substring is "java,html"

output
java occures in 2 times
html occures in 1 time

the output we count the no of occurence of java and html.

the sub string is not only java and html,anything in the actual string will be given.

So help to do this.Its very urgent please do the needful

Thanks in Advance
Sang

[r035198x]

Sorry to distrub you.
I am not finished my work till. From the above coding we don't use the sub string.
My actual requriement is count the no of substrings occurs in the main string.

my actual string is "java,html,unix,java"
my substring is "java,html"

output
java occures in 2 times
html occures in 1 time

the output we count the no of occurence of java and html.

the sub string is not only java and html,anything in the actual string will be given.

So help to do this.Its very urgent please do the needful

Thanks in Advance
Sang

How about this?

 
int count = 0;
  int wordLength = word.length();
  for(int i = 0; i < sentence.length(); i = i + wordLength) {
   if(word.equals(sentence.substring(i, i + wordLength))) {
    count++;
   }
  }
 
 

Let me know where you don't understand.

[Ganon11]

How about this?

 
int count = 0;
  int wordLength = word.length();
  for(int i = 0; i < sentence.length(); i = i + wordLength) {
   if(word.equals(sentence.substring(i, i + wordLength))) {
    count++;
   }
  }
 
 

Let me know where you don't understand.

I don't think this will work correctly. You are checking every wordLength characters to see if that substring is the word, but the words can be of varying lengths, and you may be checking part of one word and part of another. Why not try:

int count = 0;
int wordLength = word.length();
for (int i = 0; i < sentence.length() - wordLength; i++) {
   if (word.equals(sentence.substring(i, i + wordLength)
      count++;
}

This will check every possible location of word inside the string.

[r035198x]

I don't think this will work correctly. You are checking every wordLength characters to see if that substring is the word, but the words can be of varying lengths, and you may be checking part of one word and part of another. Why not try:

int count = 0;
int wordLength = word.length();
for (int i = 0; i < sentence.length() - wordLength; i++) {
if (word.equals(sentence.substring(i, i + wordLength)
count++;
}

This will check every possible location of word inside the string.

Guess I overdid there that time.
Thanks again Ganon.

[Ganon11]

That's why we're a team :)

[r035198x]

That's why we're a team :)

If you only you guys stay around here more often. Our times seem to be off too.
You always seem to appear around 4pm (for me here).

[Ganon11]

Right now according to my time, it's 11:22 AM (EST) - what time is it there?

I'm usually on around 3:00 PM (EST) and at least once during the day from Monday-Friday.

[r035198x]

Right now according to my time, it's 11:22 AM (EST) - what time is it there?

I'm usually on around 3:00 PM (EST) and at least once during the day from Monday-Friday.

My time is 5:25 pm now.

[Ganon11]

And if you see me get on around 4:00 PM your time, that's about 10:00 AM my time - which is when I have a free period sometimes and usually get on TSDN. That would make sense.

[sang]

I don't think this will work correctly. You are checking every wordLength characters to see if that substring is the word, but the words can be of varying lengths, and you may be checking part of one word and part of another. Why not try:

int count = 0;
int wordLength = word.length();
for (int i = 0; i < sentence.length() - wordLength; i++) {
   if (word.equals(sentence.substring(i, i + wordLength)
      count++;
}

This will check every possible location of word inside the string.

Thank you for your reply

I do that as you give in the above

import java.io.*;
 
public class strcount 
 {
      public static void main(String arg[]) {
         try
         {
         String sentence = "java,jsp,c,dhtml,unix";
         String word = "java,html";
         int count=0;
         int wordLength = word.length();
         for(int i = 0; i < sentence.length() - wordLength; i++) {
             if (word.equals(sentence.substring(i, i + wordLength)))
             count++;
         }
         }catch (Exception e) {
             System.out.println("Exception is "+e);
         }
     }
 }
 

But i am confused in how to print the word with their count. I am not able to do that please help me.

Thank you for your kind help
Sang

[r035198x]

Thank you for your reply

I do that as you give in the above

import java.io.*;
 
public class strcount 
{
     public static void main(String arg[]) {
         try
         {
         String sentence = "java,jsp,c,dhtml,unix";
         String word = "java,html";
         int count=0;
         int wordLength = word.length();
         for(int i = 0; i < sentence.length() - wordLength; i++) {
             if (word.equals(sentence.substring(i, i + wordLength)))
         count++;
         }
         }catch (Exception e) {
             System.out.println("Exception is "+e);
         }
     }
}
 

But i am confused in how to print the word with their count. I am not able to do that please help me.

Thank you for your kind help
Sang

If you want to check for occurrences java and html, (independanlty) you will have to split the string "java,html" into the separate strings first.

[sang]

If you want to check for occurrences java and html, (independanlty) you will have to split the string "java,html" into the separate strings first.

i split the string like this

int wordLength = word.split(",");

but i don't know how to count this using the split .please do this on the code

Thank you very much

[r035198x]

i split the string like this

int wordLength = word.split(",");

but i don't know how to count this using the split .please do this on the code

Thank you very much

Not very good there. I hope you noticed this.

The split reaturns an array of strings not an int.
You should consider making the word count a function and calling it from the main method for each word you want to count for.

[sang]

Not very good there. I hope you noticed this.

The split reaturns an array of strings not an int.
You should consider making the word count a function and calling it from the main method for each word you want to count for.

sorry sir please give me the code its very urgent.

please do the needfull

Thankyou

[r035198x]

sorry sir please give me the code its very urgent.

please do the needfull

Thankyou

The code is already there and I've posted most of it. Where exactly is your problem now?

Did you change that line for spilt to something like

 String[] words = word.split(","); 

[sang]

The code is already there and I've posted most of it. Where exactly is your problem now?

Did you change that line for spilt to something like

 String[] words = word.split(","); 

my program is

 import java.io.*;
 
public class strcount 
 {
          String sentence = "java,jsp,c,dhtml,unix";
         String word = "java,html";
         int count=0;
         int i;
         String temp[] = word.split(",");
 
         public void st(){
         int wordLength = word.length();
         for( i = 0; i > temp.length - wordLength; i++) {
             if (temp.equals(sentence.substring(i, i+ wordLength)))
             count++;
             System.out.println("the"+i+"array"+count);
         }
    }
    public static void main(String arg[]) {    
            strcount s = new strcount();
            s.st();
     }
 
 }        
 
 

the out put is like this

the0array0
the1array0
the2array0
the3array0
the4array0
the5array0
the6array0
the7array0
the8array0
the9array0
the10array0
the11array0
the12array0
Exception in thread "main" java.lang.StringIndexOutOfBoundsException: String ind
ex out of range: 22
        at java.lang.String.substring(String.java:1765)
        at strcount.st(strcount.java:14)
        at strcount.main(strcount.java:21)
 

What can i do,i want to calculate the substring count.Please help to do this.
Its very urgent so please give me the code for this program or correct my program.
Thank you very much

[r035198x]

 
public class strcount {
    public static int countTimes(String sentence, String word){
  int count = 0;
    int wordLength = word.length();
    for(int i = 0; i < sentence.length() - wordLength; i++) {
     if(word.equals(sentence.substring(i, i + wordLength))) {
   count++;
     }
    }
    return count;
 }
 public static void main(String arg[]) {
  String sentence = "java,jsp,c,dhtml,unix";
  String word = "java,html";
  String temp[] = word.split(",");
  for(int i = 0; i < temp.length;i++) {
   System.out.print(temp[i]+" appears : ");
   System.out.print(countTimes(sentence, temp[i]) + " times");
   System.out.println();
  }
 } 
 
 }
 

Notice that html is found because of dhtml. Do you want it like that?

[sang]

The code is already there and I've posted most of it. Where exactly is your problem now?

Did you change that line for spilt to something like

 String[] words = word.split(","); 

import java.io.*;
 
public class strcount 
 {
          String sentence = "java,jsp,c,dhtml,unix";
         String word = "java,html";
         int count=0;
         int i;
         String temp[] = word.split(",");
 
         public void st(){
         int wordLength = word.length();
         for( i = 0; i > temp.length - wordLength; i++) {
             if (temp[i].equals(sentence.substring(i, i+ wordLength)))
             count++;
             System.out.println("the"+temp[i]+"count"+i);
         }
    }
    public static void main(String arg[]) {    
            strcount s = new strcount();
            s.st();
     }
 
 }        
 
 

the output is

thejavacount0
thehtmlcount1
Exception in thread "main" java.lang.ArrayIndexOutOfBoundsException: 2
        at strcount.st(strcount.java:14)
        at strcount.main(strcount.java:21)
 

but i want to count the no of occurence of word (ie java and html)
please correct the code

Thankyou very much

[sang]

 
public class strcount {
    public static int countTimes(String sentence, String word){
  int count = 0;
    int wordLength = word.length();
    for(int i = 0; i < sentence.length() - wordLength; i++) {
     if(word.equals(sentence.substring(i, i + wordLength))) {
   count++;
     }
    }
    return count;
 }
 public static void main(String arg[]) {
  String sentence = "java,jsp,c,dhtml,unix";
  String word = "java,html";
  String temp[] = word.split(",");
  for(int i = 0; i < temp.length;i++) {
   System.out.print(temp[i]+" appears : ");
   System.out.print(countTimes(sentence, temp[i]) + " times");
   System.out.println();
  }
 } 
 
 }
 

Notice that html is found because of dhtml. Do you want it like that?

Thank you very much for your kind help

[Ganon11]

The split method returns a String array, correct? And you want to find the occurances of each word in this array? Then you can use a loop to perform this check in every line. As the final statement in this loop, put a println() call to output the word and count.

[sang]

 
public class strcount {
    public static int countTimes(String sentence, String word){
  int count = 0;
    int wordLength = word.length();
    for(int i = 0; i < sentence.length() - wordLength; i++) {
     if(word.equals(sentence.substring(i, i + wordLength))) {
   count++;
     }
    }
    return count;
 }
 public static void main(String arg[]) {
  String sentence = "java,jsp,c,dhtml,unix";
  String word = "java,html";
  String temp[] = word.split(",");
  for(int i = 0; i < temp.length;i++) {
   System.out.print(temp[i]+" appears : ");
   System.out.print(countTimes(sentence, temp[i]) + " times");
   System.out.println();
  }
 } 
 
 }
 

Notice that html is found because of dhtml. Do you want it like that?

Hello Sir
I used the above code in DB to count the no of keyword matches in the resume. The Resume is stored in one table and the Key word is on the another table.i do it but one error will be occur. i will give that code please correct it. Because it is very urgent.So i finished it
The code is

package ic.bo;
 
import java.io.*;
import java.sql.*;
import ic.bo.*;
import ic.db.DBConnection;
//import java.util.StringTokenizer;
 
public class KeywordCount {
    private Connection dbConnection = null;    
    public String errDesc;    
 
    public KeywordCount() throws SQLException {
        DBConnection db = new DBConnection();
        dbConnection = db.getDBConnection();
        if (dbConnection == null) {
            throw new SQLException("Connection Error");
        }
    }        
 
    public void closeConnection() {
        try{
            dbConnection.close();
        }catch(Exception e) {
        }
     }
     public void countKeyword() {
         try{
             String sql1 = "select JobRefNo,ifnull(Keywords,' ') from JOB_ORDER where Status<>'Expired' and ValidUpto >= sysdate()";
             Statement stm1 = dbConnection.createStatement();
             ResultSet rs1 = null;
             rs1 = stm1.executeQuery(sql1);            
 
            while(rs1.next()) {
                String sql2 = "select UserId from JOB_APPLICATION where  NoOfMatch=-1 and JobRefNo=" +rs1.getInt(1);
                Statement stm2 = dbConnection.createStatement();
                ResultSet rs2 = null;
                rs2 = stm2.executeQuery(sql2);
                while(rs2.next()) {
                  try
                    {
                    String sql3 = "select TxtResume from CAN_RESUME where UserId="+rs2.getInt(1);
                    Statement stm3 = dbConnection.createStatement();
                    ResultSet rs3 = null;
                    rs3 = stm3.executeQuery(sql3);
                    rs3.next();
                    String TxtResume=rs3.getString(1);
                    String Keywords=rs1.getString(2);
                    String temp[] = Keywords.split(",");
                    for(int i = 0; i < temp.length;i++) {
                    System.out.print(temp[i]+" appears : ");
                    System.out.print(countTimes(TxtResume, temp[i]) + " times");
                    System.out.println();
                    }
                    } catch (Exception e) {
                    System.out.println("DB error while execute the SQL " + e);
                    }
            }
            rs2.close();
                stm2.close();
            }
            }catch (Exception e) {
                    System.out.println("DB error while execute the SQL " + e);
                    }
 
        public void countTimes(String TxtResume ,String Keywords){
                    try
                    {
                    int KeywordsLength = Keywords.length();
                    for(int i = 0; i < TxtResume.length() - KeywordsLength; i++) {
                    if(Keywords.equals(TxtResume.substring(i, i + KeywordsLength))) {
                    count++;
                        }
                    }
                    return count;
                    rs1.close();
                    stm1.close();
            } catch (Exception e) {
                System.out.println("DB error while execute the SQL " + e);
                return;
            }
        }
    }
    public static void main(String arg[]) {
        try
        {
        KeywordCount key = new KeywordCount();
        key.countKeyword();
        key.countTimes();
        } catch(Exception e) {
        }
    }
}
 
 

The Error is D:\epc\delv\WEB-INF\classes\ic\bo\KeywordCount.java:66: illegal start of expression
public void countTimes(String TxtResume ,String Keywords){
So please help to solve the problem

Thanks and Regards
Sang

[r035198x]

Hello Sir
I used the above code in DB to count the no of keyword matches in the resume. The Resume is stored in one table and the Key word is on the another table.i do it but one error will be occur. i will give that code please correct it. Because it is very urgent.So i finished it
The code is

package ic.bo;
 
import java.io.*;
import java.sql.*;
import ic.bo.*;
import ic.db.DBConnection;
//import java.util.StringTokenizer;
 
public class KeywordCount {
    private Connection dbConnection = null;    
    public String errDesc;    
 
    public KeywordCount() throws SQLException {
        DBConnection db = new DBConnection();
        dbConnection = db.getDBConnection();
        if (dbConnection == null) {
            throw new SQLException("Connection Error");
        }
    }        
 
    public void closeConnection() {
        try{
            dbConnection.close();
        }catch(Exception e) {
        }
     }
     public void countKeyword() {
         try{
             String sql1 = "select JobRefNo,ifnull(Keywords,' ') from JOB_ORDER where Status<>'Expired' and ValidUpto >= sysdate()";
             Statement stm1 = dbConnection.createStatement();
             ResultSet rs1 = null;
             rs1 = stm1.executeQuery(sql1);            
 
            while(rs1.next()) {
                String sql2 = "select UserId from JOB_APPLICATION where NoOfMatch=-1 and JobRefNo=" +rs1.getInt(1);
                Statement stm2 = dbConnection.createStatement();
                ResultSet rs2 = null;
                rs2 = stm2.executeQuery(sql2);
                while(rs2.next()) {
             try
                    {
                    String sql3 = "select TxtResume from CAN_RESUME where UserId="+rs2.getInt(1);
                    Statement stm3 = dbConnection.createStatement();
                    ResultSet rs3 = null;
                    rs3 = stm3.executeQuery(sql3);
                    rs3.next();
                    String TxtResume=rs3.getString(1);
                    String Keywords=rs1.getString(2);
                    String temp[] = Keywords.split(",");
                    for(int i = 0; i < temp.length;i++) {
                    System.out.print(temp[i]+" appears : ");
                    System.out.print(countTimes(TxtResume, temp[i]) + " times");
                    System.out.println();
                    }
                    } catch (Exception e) {
                    System.out.println("DB error while execute the SQL " + e);
                    }
            }
            rs2.close();
                stm2.close();
            }
            }catch (Exception e) {
                    System.out.println("DB error while execute the SQL " + e);
                    }
 
        public void countTimes(String TxtResume ,String Keywords){
                    try
                    {
                    int KeywordsLength = Keywords.length();
                    for(int i = 0; i < TxtResume.length() - KeywordsLength; i++) {
                    if(Keywords.equals(TxtResume.substring(i, i + KeywordsLength))) {
                    count++;
                        }
                    }
                    return count;
                    rs1.close();
                    stm1.close();
            } catch (Exception e) {
                System.out.println("DB error while execute the SQL " + e);
                return;
            }
        }
    }
    public static void main(String arg[]) {
        try
        {
        KeywordCount key = new KeywordCount();
        key.countKeyword();
        key.countTimes();
        } catch(Exception e) {
        }
    }
}
 
 

The Error is D:\epc\delv\WEB-INF\classes\ic\bo\KeywordCount.java:66: illegal start of expression
public void countTimes(String TxtResume ,String Keywords){
So please help to solve the problem

Thanks and Regards
Sang

1.)You don't have to post all your code like this
2.)You have put the countTimes method inside another method. This is not allowed and is the reason for the error. Pluck it out so that no method is inside another method.
3.) When handling exceptions do not use

 catch(Exception e) { 
}
 

This hides the exception when it occurs so you don't see it. Ideally you should want to be able to know if your code is throwing an exception.

[sang]

1.)You don't have to post all your code like this
2.)You have put the countTimes method inside another method. This is not allowed and is the reason for the error. Pluck it out so that no method is inside another method.
3.) When handling exceptions do not use

 catch(Exception e) { 
}
 

This hides the exception when it occurs so you don't see it. Ideally you should want to be able to know if your code is throwing an exception.

Yes I done your advice

The program is Complie and run Successfully but it does not return any output
please help to do this

public class KeywordCount {
 public void countKeyword() {
         try{
             String sql1 = "select JobRefNo,ifnull(Keywords,' ') from JOB_ORDER where Status<>'Expired' and ValidUpto >= sysdate()";
             Statement stm1 = dbConnection.createStatement();
             ResultSet rs1 = null;
             rs1 = stm1.executeQuery(sql1);            
 
            while(rs1.next()) {
                String sql2 = "select UserId from JOB_APPLICATION where  NoOfMatch=-1 and JobRefNo=" +rs1.getInt(1);
                Statement stm2 = dbConnection.createStatement();
                ResultSet rs2 = null;
                rs2 = stm2.executeQuery(sql2);
                while(rs2.next()) {
                  try {
                    String sql3 = "select TxtResume from CAN_RESUME where UserId="+rs2.getInt(1);
                    Statement stm3 = dbConnection.createStatement();
                    ResultSet rs3 = null;
                    rs3 = stm3.executeQuery(sql3);
                    rs3.next();
                    String TxtResume=rs3.getString(1);
                    String Keywords=rs1.getString(2);
                    String temp[] = Keywords.split(",");
                    for(int i = 0; i < temp.length;i++) {
                    System.out.print(temp[i]+" appears : ");
                    //System.out.print(countTimes(TxtResume, temp[i]) + " times");
 
                    }
                    } catch (Exception e) {
                    System.out.println("DB error while execute the SQL " + e);
                    }
            }
            rs2.close();
                stm2.close();
            }
            }catch (Exception e) {
                    System.out.println("DB error while execute the SQL " + e);
                    }
     }            
        public int countTimes(InputStream in ,String Keywords1){
            DataInputStream din = new DataInputStream(in);
            String line = null;
            int count=0;
                    try    {
                        while((line=din.readLine()) != null){
                        String line2 = line.toLowerCase();
                        int KeywordsLength = Keywords1.length();
                        for(int i = 0; i < line2.length() - KeywordsLength; i++) {
                        if(Keywords1.equals(line2.substring(i, i + KeywordsLength))) {
                        count++;
                        System.out.println("the count is "+count);
                        }
                    }
                        }
                    return count;
                    //
                    //rs1.close();
                    //stm1.close();
            } catch (Exception e1) {
                System.out.println("DB error while execute the SQL " + e1);
                return -1;
            }
        }
    public static void main(String arg[]) {
        try
        {
        KeywordCount key = new KeywordCount();
        key.countKeyword();
        //key.countTimes();
        } catch(Exception e) {
            System.out.println("Exception is"+e);
        }
    }
}
 

please help to do this

Thankyou
Sang

[r035198x]

Yes I done your advice

The program is Complie and run Successfully but it does not return any output
please help to do this

public class KeywordCount {
public void countKeyword() {
         try{
             String sql1 = "select JobRefNo,ifnull(Keywords,' ') from JOB_ORDER where Status<>'Expired' and ValidUpto >= sysdate()";
             Statement stm1 = dbConnection.createStatement();
             ResultSet rs1 = null;
             rs1 = stm1.executeQuery(sql1);            
 
            while(rs1.next()) {
                String sql2 = "select UserId from JOB_APPLICATION where NoOfMatch=-1 and JobRefNo=" +rs1.getInt(1);
                Statement stm2 = dbConnection.createStatement();
                ResultSet rs2 = null;
                rs2 = stm2.executeQuery(sql2);
                while(rs2.next()) {
             try {
                    String sql3 = "select TxtResume from CAN_RESUME where UserId="+rs2.getInt(1);
                    Statement stm3 = dbConnection.createStatement();
                    ResultSet rs3 = null;
                    rs3 = stm3.executeQuery(sql3);
                    rs3.next();
                    String TxtResume=rs3.getString(1);
                    String Keywords=rs1.getString(2);
                    String temp[] = Keywords.split(",");
                    for(int i = 0; i < temp.length;i++) {
                    System.out.print(temp[i]+" appears : ");
                    //System.out.print(countTimes(TxtResume, temp[i]) + " times");
 
                    }
                    } catch (Exception e) {
                    System.out.println("DB error while execute the SQL " + e);
                    }
            }
            rs2.close();
                stm2.close();
            }
            }catch (Exception e) {
                    System.out.println("DB error while execute the SQL " + e);
                    }
     }            
        public int countTimes(InputStream in ,String Keywords1){
            DataInputStream din = new DataInputStream(in);
            String line = null;
            int count=0;
                    try    {
                        while((line=din.readLine()) != null){
                        String line2 = line.toLowerCase();
                        int KeywordsLength = Keywords1.length();
                        for(int i = 0; i < line2.length() - KeywordsLength; i++) {
                        if(Keywords1.equals(line2.substring(i, i + KeywordsLength))) {
                        count++;
                        System.out.println("the count is "+count);
                        }
                    }
                        }
                    return count;
                    //
                    //rs1.close();
                    //stm1.close();
            } catch (Exception e1) {
                System.out.println("DB error while execute the SQL " + e1);
                return -1;
            }
        }
    public static void main(String arg[]) {
        try
        {
        KeywordCount key = new KeywordCount();
        key.countKeyword();
        //key.countTimes();
        } catch(Exception e) {
            System.out.println("Exception is"+e);
        }
    }
}
 

please help to do this

Thankyou
Sang

What output do you want it to give?

[sang]

What output do you want it to give?

The resume and keywords are taken from different table.
The program is check whether the keywords are in the resume, if the keywords are present Count the each keywords.

In the out put it will be return

Keyword How many times present

for example the keyword is java and it present 3 times

The output is

java ===>3 times

Thankyou
Sang

[r035198x]

The resume and keywords are taken from different table.
The program is check whether the keywords are in the resume, if the keywords are present Count the each keywords.

In the out put it will be return

Keyword How many times present

for example the keyword is java and it present 3 times

The output is

java ===>3 times

Thankyou
Sang

Debug it with println statements to verify that each statement is doing what you think it is doing.

[sang]

Debug it with println statements to verify that each statement is doing what you think it is doing.

My problem is

public void countKeyword() {
         try{
             String sql1 = "select JobRefNo,ifnull(Keywords,' ') from JOB_ORDER where Status<>'Expired' and ValidUpto >= sysdate()";
             Statement stm1 = dbConnection.createStatement();
             ResultSet rs1 = null;
             rs1 = stm1.executeQuery(sql1);            
 
            while(rs1.next()) {
                String sql2 = "select UserId from JOB_APPLICATION where  NoOfMatch=-1 and JobRefNo=" +rs1.getInt(1);
                Statement stm2 = dbConnection.createStatement();
                ResultSet rs2 = null;
                rs2 = stm2.executeQuery(sql2);
                while(rs2.next()) {
                  try {
 
                    String sql3 = "select TxtResume from CAN_RESUME where TxtStatus=1 and UserId="+rs2.getInt(1);                    Statement stm3 = dbConnection.createStatement();
                    ResultSet rs3 = null;
                    rs3 = stm3.executeQuery(sql3);
                    rs3.next();
                    String TxtResume=rs3.getString(1);
                    String Keywords=rs1.getString(2);
                    String temp[] = Keywords.split(",");
        //            countKeyword ct = new countKeyword();
                    for(int i = 0; i < temp.length;i++) {
                    System.out.print(temp[i]+" appears : ");
                    System.out.print(countTimes(TxtResume, temp[i]) + " times");
                    }
                    } catch (Exception e) {
                    System.out.println("DB error while execute the SQL " + e);
                    }
            }
            rs2.close();
                stm2.close();
            }
            }catch (Exception e) {
                    System.out.println("DB error while execute the SQL " + e);
                    }            
     }
        public int countTimes(InputStream in ,String Keywords1){
            DataInputStream din = new DataInputStream(in);
            String line = null;
            int count=0;
                    try    {
                        while((line=din.readLine()) != null){
                        String line2 = line.toLowerCase();
                        int KeywordsLength = Keywords1.length();
                        for(int i = 0; i < line2.length() - KeywordsLength; i++) {
                        if(Keywords1.equals(line2.substring(i, i + KeywordsLength))) {
                        count++;
                        //System.out.println("the count is "+count);
                        }
                    }
                        }
                    return count;
                    //
                    //rs1.close();
                    //stm1.close();
            } catch (Exception e1) {
                System.out.println("DB error while execute the SQL " + e1);
                return -1;
            }
        }
 

In this how can i call the countTimes() in the countKeyword()

I call this using
System.out.print(countTimes(TxtResume, temp[i]) + " times");

but erorr is occured in the above line

D:\epc\delv\WEB-INF\classes\ic\bo\KeywordCount.java:51: countTimes(java.io.Input
Stream,java.lang.String) in ic.bo.KeywordCount cannot be applied to (java.lang.S
tring,java.lang.String)
System.out.print(countTimes(TxtResume, t
emp[i]) + " times");

please help to do this
Thanks and regards
Sang

[r035198x]

My problem is

public void countKeyword() {
         try{
             String sql1 = "select JobRefNo,ifnull(Keywords,' ') from JOB_ORDER where Status<>'Expired' and ValidUpto >= sysdate()";
             Statement stm1 = dbConnection.createStatement();
             ResultSet rs1 = null;
             rs1 = stm1.executeQuery(sql1);            
 
            while(rs1.next()) {
                String sql2 = "select UserId from JOB_APPLICATION where NoOfMatch=-1 and JobRefNo=" +rs1.getInt(1);
                Statement stm2 = dbConnection.createStatement();
                ResultSet rs2 = null;
                rs2 = stm2.executeQuery(sql2);
                while(rs2.next()) {
             try {
 
                    String sql3 = "select TxtResume from CAN_RESUME where TxtStatus=1 and UserId="+rs2.getInt(1);                    Statement stm3 = dbConnection.createStatement();
                    ResultSet rs3 = null;
                    rs3 = stm3.executeQuery(sql3);
                    rs3.next();
                    String TxtResume=rs3.getString(1);
                    String Keywords=rs1.getString(2);
                    String temp[] = Keywords.split(",");
        //            countKeyword ct = new countKeyword();
                    for(int i = 0; i < temp.length;i++) {
                    System.out.print(temp[i]+" appears : ");
                    System.out.print(countTimes(TxtResume, temp[i]) + " times");
                    }
                    } catch (Exception e) {
                    System.out.println("DB error while execute the SQL " + e);
                    }
            }
            rs2.close();
                stm2.close();
            }
            }catch (Exception e) {
                    System.out.println("DB error while execute the SQL " + e);
                    }            
     }
        public int countTimes(InputStream in ,String Keywords1){
            DataInputStream din = new DataInputStream(in);
            String line = null;
            int count=0;
                    try    {
                        while((line=din.readLine()) != null){
                        String line2 = line.toLowerCase();
                        int KeywordsLength = Keywords1.length();
                        for(int i = 0; i < line2.length() - KeywordsLength; i++) {
                        if(Keywords1.equals(line2.substring(i, i + KeywordsLength))) {
                        count++;
                        //System.out.println("the count is "+count);
                        }
                    }
                        }
                    return count;
                    //
                    //rs1.close();
                    //stm1.close();
            } catch (Exception e1) {
                System.out.println("DB error while execute the SQL " + e1);
                return -1;
            }
        }
 

In this how can i call the countTimes() in the countKeyword()

I call this using
System.out.print(countTimes(TxtResume, temp[i]) + " times");

but erorr is occured in the above line

D:\epc\delv\WEB-INF\classes\ic\bo\KeywordCount.java:51: countTimes(java.io.Input
Stream,java.lang.String) in ic.bo.KeywordCount cannot be applied to (java.lang.S
tring,java.lang.String)
System.out.print(countTimes(TxtResume, t
emp[i]) + " times");

please help to do this
Thanks and regards
Sang

Your arguments are not matching the countTimes signature. Look at the countTimes method again and understand what each parameter is doing in the method.

[sang]

Your arguments are not matching the countTimes signature. Look at the countTimes method again and understand what each parameter is doing in the method.

Thankyou very much I solved that problem. but i have another error.
That is DB error please see the code and give the suggesstion to solve it

public void countKeyword() {
         try{
             String sql1 = "select JobRefNo,ifnull(Keywords,' ') from JOB_ORDER where Status<>'Expired' and ValidUpto >= sysdate()";
             Statement stm1 = dbConnection.createStatement();
             ResultSet rs1 = null;
             rs1 = stm1.executeQuery(sql1);            
 
            while(rs1.next()) {
                String sql2 = "select UserId from JOB_APPLICATION where  NoOfMatch=-1 and JobRefNo=" +rs1.getInt(1);
                Statement stm2 = dbConnection.createStatement();
                ResultSet rs2 = null;
                rs2 = stm2.executeQuery(sql2);
                while(rs2.next()) {
                  try {
 
                    String sql3 = "select TxtResume from CAN_RESUME where TxtStatus=1 and UserId="+rs2.getInt(1);                    Statement stm3 = dbConnection.createStatement();
                    ResultSet rs3 = null;
                    rs3 = stm3.executeQuery(sql3);
                    rs3.next();
                    String TxtResume=rs3.getString(1);
                    String Keywords=rs1.getString(2);
                    String temp[] = Keywords.split(",");
        //            countKeyword ct = new countKeyword();
                    for(int i = 0; i < temp.length;i++) {
                    System.out.print(temp[i]+" appears : ");
                    System.out.print(countTimes(TxtResume, temp[i]) + " times");
                    System.out.println();
                    }
                    } catch (Exception e) {
                    System.out.println("DB error while execute the SQL " + e);
                    }
            }
            rs2.close();
                stm2.close();
            }
            }catch (Exception e) {
                    System.out.println("DB error while execute the SQL " + e);
                    }            
     }
        public int countTimes(String TxtResume ,String Keywords){
            //DataInputStream din = new DataInputStream(in);
            //String line = null;
            int count=0;
                    try    {
                        //while((line=din.readLine()) != null){
                        //String line2 = line.toLowerCase();
                        int KeywordsLength = Keywords.length();
                        for(int i = 0; i < TxtResume.length() - KeywordsLength; i++) {
                        if(Keywords.equals(TxtResume.substring(i, i + KeywordsLength))) {
                        count++;
                        }
                    }
 
                    return count;
                    //
                    //rs1.close();
                    //stm1.close();
            } catch (Exception e1) {
                System.out.println("DB error while execute the SQL " + e1);
                return -1;
            }
        }
 

the error is

Cummins appears : DB error while execute the SQL java.lang.NullPointerException
-1 times
Service appears : DB error while execute the SQL java.lang.NullPointerException
-1 times
 

please help to slove this error
Thankyou
Sang

[r035198x]

Thankyou very much I solved that problem. but i have another error.
That is DB error please see the code and give the suggesstion to solve it

public void countKeyword() {
         try{
             String sql1 = "select JobRefNo,ifnull(Keywords,' ') from JOB_ORDER where Status<>'Expired' and ValidUpto >= sysdate()";
             Statement stm1 = dbConnection.createStatement();
             ResultSet rs1 = null;
             rs1 = stm1.executeQuery(sql1);            
 
            while(rs1.next()) {
                String sql2 = "select UserId from JOB_APPLICATION where NoOfMatch=-1 and JobRefNo=" +rs1.getInt(1);
                Statement stm2 = dbConnection.createStatement();
                ResultSet rs2 = null;
                rs2 = stm2.executeQuery(sql2);
                while(rs2.next()) {
             try {
 
                    String sql3 = "select TxtResume from CAN_RESUME where TxtStatus=1 and UserId="+rs2.getInt(1);                    Statement stm3 = dbConnection.createStatement();
                    ResultSet rs3 = null;
                    rs3 = stm3.executeQuery(sql3);
                    rs3.next();
                    String TxtResume=rs3.getString(1);
                    String Keywords=rs1.getString(2);
                    String temp[] = Keywords.split(",");
        //            countKeyword ct = new countKeyword();
                    for(int i = 0; i < temp.length;i++) {
                    System.out.print(temp[i]+" appears : ");
                    System.out.print(countTimes(TxtResume, temp[i]) + " times");
                    System.out.println();
                    }
                    } catch (Exception e) {
                    System.out.println("DB error while execute the SQL " + e);
                    }
            }
            rs2.close();
                stm2.close();
            }
            }catch (Exception e) {
                    System.out.println("DB error while execute the SQL " + e);
                    }            
     }
        public int countTimes(String TxtResume ,String Keywords){
            //DataInputStream din = new DataInputStream(in);
            //String line = null;
            int count=0;
                    try    {
                        //while((line=din.readLine()) != null){
                        //String line2 = line.toLowerCase();
                        int KeywordsLength = Keywords.length();
                        for(int i = 0; i < TxtResume.length() - KeywordsLength; i++) {
                        if(Keywords.equals(TxtResume.substring(i, i + KeywordsLength))) {
                        count++;
                        }
                    }
 
                    return count;
                    //
                    //rs1.close();
                    //stm1.close();
            } catch (Exception e1) {
                System.out.println("DB error while execute the SQL " + e1);
                return -1;
            }
        }
 

the error is

Cummins appears : DB error while execute the SQL java.lang.NullPointerException
-1 times
Service appears : DB error while execute the SQL java.lang.NullPointerException
-1 times
 

please help to slove this error
Thankyou
Sang

Check the line number for the exception and locate it in your code

[sang]

Check the line number for the exception and locate it in your code

Thanyou for your kind help

I solved the problem and my program is excuted well. But the count will reduce the count by one. my keyword appears actually 3 times but in the output will be printed as 2 times appears.
I am trying to finish that problem if you have any suggestion please give me to solve the problem

I once again Say Thankyou for your timely help.

Thankyou VeryMuch
Sang

[r035198x]

Thanyou for your kind help

I solved the problem and my program is excuted well. But the count will reduce the count by one. my keyword appears actually 3 times but in the output will be printed as 2 times appears.
I am trying to finish that problem if you have any suggestion please give me to solve the problem

I once again Say Thankyou for your timely help.

Thankyou VeryMuch
Sang

Try changing your for header to

 
for(int i = 0; i < (TxtResume.length() - KeywordsLength) + 1; i++) 
 

[sang]

Try changing your for header to

 
for(int i = 0; i < (TxtResume.length() - KeywordsLength) + 1; i++) 
 

I tried this one but there is no changes in my output.

Thankyou for your kind help,
Sang

[r035198x]

I tried this one but there is no changes in my output.

Thankyou for your kind help,
Sang

You can always solve the problem by using return count + 1; but I'd rather you check first that the output you are getting is really not what it should be.

[sang]

You can always solve the problem by using return count + 1; but I'd rather you check first that the output you are getting is really not what it should be.

Thankyou very much for your help

[sang]

 
public class strcount {
    public static int countTimes(String sentence, String word){
  int count = 0;
    int wordLength = word.length();
    for(int i = 0; i < sentence.length() - wordLength; i++) {
     if(word.equals(sentence.substring(i, i + wordLength))) {
   count++;
     }
    }
    return count;
 }
 public static void main(String arg[]) {
  String sentence = "java,jsp,c,dhtml,unix";
  String word = "java,html";
  String temp[] = word.split(",");
  for(int i = 0; i < temp.length;i++) {
   System.out.print(temp[i]+" appears : ");
   System.out.print(countTimes(sentence, temp[i]) + " times");
   System.out.println();
  }
 } 
 
 }
 

Notice that html is found because of dhtml. Do you want it like that?

Hello Sir

Another help to do the above program in single method.
In the above program the count is seperate function and it is call on the main.
but i want to all this on main there is no other function call.

I will try this one but my output is 0 please help to do this

public class strcount
 {
    public static void main(String arg[]) {
    String resume = "java,html,jsp,c,java,dhtml,unix,html";
     String word = "java,jsp,html";
    String temp[] = word.split(",");
        for(int i = 0; i < temp.length;i++) {
         System.out.println(temp[i]+" appears : ");
        }
        int count = 0;
    int wordLength = word.length();
    for(int j = 0; j < resume.length() - wordLength; j++) {
     if(word.equals(resume.substring(j, j + wordLength))) {
   count++;
   //System.out.print((temp[i]),count);
     }
    }
    System.out.println(count);
    //return count;
    }
 }
 

output is like this

java appears :
jsp appears :
html appears :
 
 

please help to solve my problem
Thanks and Regards
Sang

[r035198x]

Hello Sir

Another help to do the above program in single method.
In the above program the count is seperate function and it is call on the main.
but i want to all this on main there is no other function call.

I will try this one but my output is 0 please help to do this

public class strcount
 {
    public static void main(String arg[]) {
    String resume = "java,html,jsp,c,java,dhtml,unix,html";
     String word = "java,jsp,html";
    String temp[] = word.split(",");
        for(int i = 0; i < temp.length;i++) {
         System.out.println(temp[i]+" appears : ");
        }
        int count = 0;
    int wordLength = word.length();
    for(int j = 0; j < resume.length() - wordLength; j++) {
     if(word.equals(resume.substring(j, j + wordLength))) {
   count++;
   //System.out.print((temp[i]),count);
     }
    }
    System.out.println(count);
    //return count;
    }
 }
 

output is like this

java appears :
jsp appears :
html appears :
 
 

please help to solve my problem
Thanks and Regards
Sang

Do not change the structure of your main method, just change the part that called the function and replace that part with the function itself with slight modifications. Why don't you want to call the function?

[sang]

Do not change the structure of your main method, just change the part that called the function and replace that part with the function itself with slight modifications. Why don't you want to call the function?

I do this program in jsp. I don't know how to call the function in jsp because the inputs are taken from the database. i think the main method is easly implemented in jsp. I am also do this in jsp but it print the keywords only the count values is 0. so that i ask how can i do this without function call.

Please help to do this

Thanks and Regards
Sang

[r035198x]

I do this program in jsp. I don't know how to call the function in jsp because the inputs are taken from the database. i think the main method is easly implemented in jsp. I am also do this in jsp but it print the keywords only the count values is 0. so that i ask how can i do this without function call.

Please help to do this

Thanks and Regards
Sang

public class strcount {
    public static void main(String arg[]) {
        String sentence = "java,jsp,c,dhtml,unix";
        String word = "java,html";
        String temp[] = word.split(",");
        int count = 0;
        for(int i = 0; i < temp.length;i++) {
            System.out.print(temp[i]+" appears : ");
            count = 0;
            int wordLength = temp[i].length();
            for(int j = 0; j < sentence.length() - wordLength; j++) {
               if(temp[i].equals(sentence.substring(j, j + wordLength))) {
                   count++;
               }
            }
              System.out.print(count + " times");
            System.out.println();
        }
 
    }
 
 
 }

[sang]

public class strcount {
    public static void main(String arg[]) {
        String sentence = "java,jsp,c,dhtml,unix";
        String word = "java,html";
        String temp[] = word.split(",");
        int count = 0;
        for(int i = 0; i < temp.length;i++) {
            System.out.print(temp[i]+" appears : ");
            count = 0;
            int wordLength = temp[i].length();
            for(int j = 0; j < sentence.length() - wordLength; j++) {
               if(temp[i].equals(sentence.substring(j, j + wordLength))) {
                   count++;
               }
            }
              System.out.print(count + " times");
            System.out.println();
        }
 
    }
 
 
 }

Hello Sir,
I want to use above code in jsp page to print the keywords and count. But the count values is not correct .

please help to do and also how can i place this code in jsp.
my code.

<table  border="0" cellspacing="4">
  <tr>
 
    <td width="241" align="right" valign="middle" bgcolor="#0F6484"><div align="center" class="joblisting">Keyword</div></td>
    <td width="122" valign="middle" bgcolor="#0F6484"><div align="center" class="joblisting">NoOfCount&nbsp;&nbsp;</div></td>
  </tr>
  <%
    String UserId=request.getParameter("UserId");
    String JobRefNo=request.getParameter("JobRefNo");
    String Resume=request.getParameter("Resume");
 
    String sql1 = "select Keywords from JOB_ORDER a, JOB_APPLICATION b, CAN_RESUME c where a.JobRefNo=b.JobRefNo and a.JobRefNo="+ JobRefNo+" and c.UserId="+UserId;
 
 
    Statement stm1 = dbConnection.createStatement();
        ResultSet rs1 = null;
        rs1 = stm1.executeQuery(sql1);
        rs1.next();
        String Keywords=rs1.getString(1);
        String temp[] = Keywords.split(",");
        for(int i = 0; i < temp.length;i++) {
 
 
%>
  <tr>
 
    <td align="left" valign="middle" class="altrow2"><%= temp[i] %></td>
    <% 
 
    String sql2 ="select Resume from CAN_RESUME a,JOB_APPLICATION b,JOB_ORDER c where b.JobRefNo=c.JobRefNo and a.UserId=b.UserId and a.UserId="+UserId;
    Statement stm2 = dbConnection.createStatement();
        ResultSet rs2 = null;
        rs2 = stm2.executeQuery(sql2);
        rs2.next();
        String Resume1=rs2.getString(1);
        %>
 
    <%!int count = 0;
    int j;
     %>
 
    <% int KeywordsLength = temp[i].length();
            for( j = 0; j < Resume1.length() - KeywordsLength; j++) {
 
       if(temp[i].equals(Resume1.substring(j, j + KeywordsLength))) {
                   count++; 
    %>           
 
    <%  } %>
    <%    } %>
 
    <td align="center" valign="middle" class="altrow2"><% out.print(count); %></td>
  </tr>
  <% } %>
  <tr>
    <td colspan="3" align="center"><img src="/epc/img/close.gif"  width="53" height="19"   onClick="javascript: window.close()"/> </td>
 

Please help to correct the count values
Thnaks and Regards
Sang

[r035198x]

Hello Sir,
I want to use above code in jsp page to print the keywords and count. But the count values is not correct .

please help to do and also how can i place this code in jsp.
my code.

<table border="0" cellspacing="4">
<tr>
 
<td width="241" align="right" valign="middle" bgcolor="#0F6484"><div align="center" class="joblisting">Keyword</div></td>
<td width="122" valign="middle" bgcolor="#0F6484"><div align="center" class="joblisting">NoOfCount&nbsp;&nbsp;</div></td>
</tr>
<%
    String UserId=request.getParameter("UserId");
    String JobRefNo=request.getParameter("JobRefNo");
    String Resume=request.getParameter("Resume");
 
    String sql1 = "select Keywords from JOB_ORDER a, JOB_APPLICATION b, CAN_RESUME c where a.JobRefNo=b.JobRefNo and a.JobRefNo="+ JobRefNo+" and c.UserId="+UserId;
 
 
    Statement stm1 = dbConnection.createStatement();
        ResultSet rs1 = null;
        rs1 = stm1.executeQuery(sql1);
        rs1.next();
        String Keywords=rs1.getString(1);
        String temp[] = Keywords.split(",");
        for(int i = 0; i < temp.length;i++) {
 
 
%>
<tr>
 
<td align="left" valign="middle" class="altrow2"><%= temp[i] %></td>
    <% 
 
    String sql2 ="select Resume from CAN_RESUME a,JOB_APPLICATION b,JOB_ORDER c where b.JobRefNo=c.JobRefNo and a.UserId=b.UserId and a.UserId="+UserId;
    Statement stm2 = dbConnection.createStatement();
        ResultSet rs2 = null;
        rs2 = stm2.executeQuery(sql2);
        rs2.next();
        String Resume1=rs2.getString(1);
        %>
 
    <%!int count = 0;
    int j;
     %>
 
    <% int KeywordsLength = temp[i].length();
            for( j = 0; j < Resume1.length() - KeywordsLength; j++) {
 
     if(temp[i].equals(Resume1.substring(j, j + KeywordsLength))) {
                 count++; 
    %>         
 
    <% } %>
    <%    } %>
 
<td align="center" valign="middle" class="altrow2"><% out.print(count); %></td>
</tr>
<% } %>
<tr>
<td colspan="3" align="center"><img src="/epc/img/close.gif" width="53" height="19" onClick="javascript: window.close()"/> </td>
 

Please help to correct the count values
Thnaks and Regards
Sang

What answers are you getting and what are you expecting?

[sang]

What answers are you getting and what are you expecting?

The count value is incorrect. That is the sql1 gets the keyword form the dataabase and split it.
The sql2 gets the resume from database and check the resume with the keyword.
I want to count the noof keywords appears in the resume.
in normal java program it works well but in the jsp i got incorrect count values.
The count values are changed after refeshing (every time) of the page.

This is most urget so please help me as soon as possible

Please hel pto correct it
Thanyou,
Sang