i want to fetch data from product table where Cat_Name=Kid's Clothing
but it is not fetching the data of kid's clothing because it contains single quote. i have find the solution for that i.e replace function to escape the single quote but still it is not working
Putting aside that the query tag shouldn't really be used outside of prototyping, you should be using the <sql:param> tag to bind the cat variable, so using it as a PreparedStatement.
At the moment you have something that is prone to SQL injection.
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.