// Needs a connection so it can fetch more stuff lazily
  Copy(ResultSet rs) throws SQLException {
    super();

    copyId = rs.getInt("copy#");
    bibId = rs.getInt("bib#");
    note = rs.getString("pac_note");

    location = rs.getString("location");
    locationName = rs.getString("location_name");
    collectionDescr = rs.getString("collection_descr");
    collection = rs.getString("collection");

    callNumber =
        new CallNumber(
            rs.getString("call_number"),
            rs.getString("call_type"),
            rs.getString("copy_number"),
            rs.getString("call_type_hint"));
    callType = rs.getString("call_type");
    callTypeHint = rs.getString("call_type_hint");
    callTypeName = rs.getString("call_type_name");

    mediaType = rs.getString("media_type");
    mediaTypeDescr = rs.getString("media_descr");
    summaryOfHoldings = rs.getBoolean("summary_of_holdings");
    itemType = rs.getString("itype");
    itemTypeDescr = rs.getString("idescr");
  }
示例#2
0
  public static void main(String[] args)
      throws SQLException, ClassNotFoundException, JSONException {
    PostgresDb db = new PostgresDb();
    // db.setUrl("jdbc:postgresql://localhost:5432/powaaim");

    try {
      Class.forName("org.postgresql.Driver");
      c = DriverManager.getConnection(db.getUrl(), db.getUser(), db.getPass());
    } catch (ClassNotFoundException e) {
      // TODO Auto-generated catch block
      e.printStackTrace();
    }

    st = c.createStatement();
    rs = st.executeQuery("SELECT id, name, externalshopid from shop where name='David_3'");
    System.out.println("id" + " " + "name" + " " + "externalshopid");
    c.close();
    obj = new JSONObject();

    while (rs.next()) {
      int id = rs.getInt("id");
      String externaId = rs.getString("externalshopid");
      String name = rs.getString("name");
      // System.out.println(id+ " " + " "+ name + " " +" "+ externaId);
      System.out.println();
      obj.put("id", id);
      obj.put("name", name);
      obj.put("externalshopid", externaId);
      System.out.print(obj);
    }
  }
  /**
   * 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");
    PrintWriter out = response.getWriter();
    try {
      /*
       * TODO output your page here out.println("<html>");
       * out.println("<head>"); out.println("<title>Servlet
       * JDBCServlet</title>"); out.println("</head>");
       * out.println("<body>"); out.println("<h1>Servlet JDBCServlet at " +
       * request.getContextPath () + "</h1>"); out.println("</body>");
       * out.println("</html>");
       */
      prefixHTML(out);
      DAO dao = new DAO();
      dao.connect();
      ResultSet rst = dao.getAll();
      if (rst != null) {
        while (rst.next()) {
          int id = rst.getInt(1);
          String foo = rst.getString(2);
          String bar = rst.getString(3);

          out.println(foo + ", " + bar + "<br/>");
        }
      } else {
        out.println("failed to get data from database <br/>");
      }

      out.println("Getting capital of India <br/>");
      rst = dao.getCapital("India");
      if (rst != null) {
        while (rst.next()) {
          String foo = rst.getString("CAPITAL");

          out.println(foo + "<br/>");
        }
      } else {
        out.println("failed to get capital for India");
      }
      dao.disconnect();
    } catch (Exception e) {
      e.printStackTrace();
    } finally {
      postfixHTML(out);
      out.close();
    }
  }