how to use wild cards in search engine to search

Dear every one,

how to search particular data in database using AND operator...

i have used LIKE operator to search and am able to retrieve datas....

but the problem is how to search the datas using AND operator...

eg: if i am searching for employees based on skills..ie java and jsp

how to get only those employees...

the code that i used for LIKE operator is..

pr=con.prepareStatement("select eid from lang where language like ? ");

pr.setString(1, "%" + s2 + "%")

[523 byte] By [senthil_yogaa] at [2007-11-27 5:56:29]