package javacode;
import javax.servlet.*;
import javax.servlet.http.*;
import java.io.IOException;
import java.sql.*;
public class AutocompleterTest extends HttpServlet {
public void doGet(HttpServletRequest request, HttpServletResponse response ) throws ServletException, IOException {
String search = request.getParameter("search");
response.setContentType("text/html");
response.setHeader("Cache-Control", "no-cache");
if(!((search.trim()).equals(""))){
String searchString = getSearchResult(search);
System.out.println(searchString);
response.getWriter().write(searchString);
}
else{
System.out.println("Length of string"+("".length()));
response.getWriter().write("");
}
}
public String getSearchResult(String search) {
Connection con = null;
String driverName = "com.mysql.jdbc.Driver";
String url = "jdbc:
mysql://192.168.10.211:3306/";;
String dbName = "amar";
String userName = "amar";
String password = "amar123";
String finalSearch="";
try{
Class.forName(driverName).newInstance();
con = DriverManager.getConnection(url+dbName, userName, password);
try{
Statement st = con.createStatement();
ResultSet res = st.executeQuery("SELECT distinct(citylist) FROM SearchDetail WHERE citylist like('"+search+"%') ORDER BY citylist");
System.out.println("res>>>" + res);
while (res.next()) {
String un = res.getString("citylist");
finalSearch+= un+"\n";
}
con.close();
}
catch (SQLException e){
System.out.println("SQL code does not execute." + e);
}
}
catch (Exception e){
e.printStackTrace();
}
return finalSearch;
}
}