import javax.servlet.*; import javax.servlet.http.*; import java.io.*; import java.util.*; import java.sql.*; import com.brainysoftware.java.StringUtil; public class SearchServlet extends HttpServlet { private String keyword = ""; public void init() { try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); System.out.println("JDBC driver loaded"); } catch (ClassNotFoundException e) { System.out.println(e.toString()); } } /**Process the HTTP Get request*/ public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { sendPageHeader(response); sendSearchForm(response); sendPageFooter(response); } /**Process the HTTP Post request*/ public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { keyword = request.getParameter("keyword"); sendPageHeader(response); sendSearchForm(response); sendSearchResult(response); sendPageFooter(response); } void sendSearchResult(HttpServletResponse response) throws IOException { PrintWriter out = response.getWriter(); try { Connection con = DriverManager.getConnection("jdbc:odbc:JavaWeb"); System.out.println("got connection"); Statement s = con.createStatement(); out.println("
First Name | "); out.println("Last Name | "); out.println("User Name | "); out.println("Password | "); out.println("
---|---|---|---|
" + StringUtil.encodeHtmlTag(rs.getString(1)) + " | "); out.println("" + StringUtil.encodeHtmlTag(rs.getString(2)) + " | "); out.println("" + StringUtil.encodeHtmlTag(rs.getString(3)) + " | "); out.println("" + StringUtil.encodeHtmlTag(rs.getString(4)) + " | "); out.println("