Can some help me making a search Engine by a Servlet ? Our site has got 2 d/b. One is 'bout course details (it contains course name, code, duration ,fees , module details), and other is about placement details (it has fields like year, company, name, batch) How can I handle this situation ? How I can search for Java+HTML-SQL.? How can I search two tables ? ( the question comes if user wants to search for a particular course and another user wants to search how many students are placed in the year 1989 ? )
I think we need to know a little more about your problem. Are your two tables stored in a database? If so it is fairly straighforward to build a SQL query for any search you require, and execute that from your servlet using JDBC. For example, to select all the details for a particular course, you might use SQL like: select * from courses where name = 'Introduction to database programming'
Actually you should have explained more clearly. Any how here is one of the possible answers. from html page(the value of textfield for example) you get the value to the servlet by using getQueryString,getParameter etc..and pass this string to sql query if you are using jdbc so that it retrieves from tables.if the queryString contains something like two or more words (java+jdbc etc...) through String manipulation you seperate them or do as per yr.need and write a sql query.