Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- /*
- * To change this license header, choose License Headers in Project Properties.
- * To change this template file, choose Tools | Templates
- * and open the template in the editor.
- */
- import java.io.IOException;
- import java.io.PrintWriter;
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.ResultSet;
- import java.sql.SQLException;
- import java.sql.Statement;
- import javax.servlet.ServletException;
- import javax.servlet.http.HttpServlet;
- import javax.servlet.http.HttpServletRequest;
- import javax.servlet.http.HttpServletResponse;
- /**
- *
- * @author Abhishek
- */
- public class searchContractor extends HttpServlet {
- /**
- * Processes requests for both HTTP <code>GET</code> and <code>POST</code>
- * methods.
- *
- * @param request servlet request
- * @param response servlet response
- * @throws ServletException if a servlet-specific error occurs
- * @throws IOException if an I/O error occurs
- */
- protected void processRequest(HttpServletRequest request, HttpServletResponse response)
- throws ServletException, IOException {
- response.setContentType("text/html;charset=UTF-8");
- try (PrintWriter out = response.getWriter()) {
- /* TODO output your page here. You may use following sample code. */
- out.println("<!DOCTYPE html>");
- out.println("<html>");
- out.println("<head>");
- out.println("<title>Servlet searchContractor</title>");
- out.println("</head>");
- out.println("<body>");
- out.println("<h1>Servlet searchContractor at " + request.getContextPath() + "</h1>");
- out.println("</body>");
- out.println("</html>");
- }
- }
- // <editor-fold defaultstate="collapsed" desc="HttpServlet methods. Click on the + sign on the left to edit the code.">
- /**
- * Handles the HTTP <code>GET</code> method.
- *
- * @param request servlet request
- * @param response servlet response
- * @throws ServletException if a servlet-specific error occurs
- * @throws IOException if an I/O error occurs
- */
- private static String dbURL = "jdbc:derby://localhost:1527/assignment;create=true;user=abhishek;password=abhishek";
- private static String tableName = "contractor_details";
- // jdbc Connection
- private static Connection conn = null;
- private static Statement stmt = null;
- private static void createConnection()
- {
- try
- {
- Class.forName("org.apache.derby.jdbc.ClientDriver").newInstance();
- //Get a connection
- conn = DriverManager.getConnection(dbURL);
- }
- catch (Exception except)
- {
- except.printStackTrace();
- }
- }
- @Override
- protected void doGet(HttpServletRequest request, HttpServletResponse response)
- throws ServletException, IOException {
- PrintWriter out = response.getWriter();
- String contractor_name = (request.getParameter("contractor_name"));
- createConnection();
- try
- {
- stmt = conn.createStatement();
- ResultSet rs = stmt.executeQuery("select * from " + tableName + " where contractor_name LIKE '"+contractor_name+"%'");
- while(rs.next()){
- //Retrieve by column name
- int id = rs.getInt("contractor_id");
- String name = rs.getString("contractor_name");
- int bid_cost = rs.getInt("bid_cost");
- String materials_used = rs.getString("materials_used");
- //String estimated_completion_date = rs.getString("estimated_completion_date");
- //Display values
- out.print("ID: " + id);
- out.print(", CONTRACTOR_NAME: " + name);
- out.print(", BID_COST: " + bid_cost);
- out.print(", MATERIALS_USED: " + materials_used);
- //System.out.print(", ESTIMATED_COMPLETION_DATE: " + estimated_completion_date);
- out.println("");
- }
- rs.close();
- stmt.close();
- }
- catch (SQLException sqlExcept)
- {
- sqlExcept.printStackTrace();
- }
- try
- {
- if (stmt != null)
- {
- stmt.close();
- }
- if (conn != null)
- {
- DriverManager.getConnection(dbURL + ";shutdown=true");
- conn.close();
- }
- }
- catch (SQLException sqlExcept)
- {
- }
- }
- /**
- * Handles the HTTP <code>POST</code> method.
- *
- * @param request servlet request
- * @param response servlet response
- * @throws ServletException if a servlet-specific error occurs
- * @throws IOException if an I/O error occurs
- */
- @Override
- protected void doPost(HttpServletRequest request, HttpServletResponse response)
- throws ServletException, IOException {
- processRequest(request, response);
- }
- /**
- * Returns a short description of the servlet.
- *
- * @return a String containing servlet description
- */
- @Override
- public String getServletInfo() {
- return "Short description";
- }// </editor-fold>
- }
Add Comment
Please, Sign In to add comment