// Frederik public Order getOrder(Connection conn, int oID) { Order o = null; String SQLString = "select * " + "from orders " + "where oid = ?"; PreparedStatement statement = null; try { statement = conn.prepareStatement(SQLString); statement.setInt(1, oID); ResultSet rs = statement.executeQuery(); if (rs.next()) { o = new Order(rs.getInt(1), rs.getInt(2), rs.getDate(3), rs.getDate(4)); SQLString = "select * " + "from orderdetails " + "where oid = ?"; statement = conn.prepareStatement(SQLString); statement.setInt(1, oID); rs = statement.executeQuery(); while (rs.next()) { o.addDetail(new OrderDetail(rs.getInt(1), rs.getInt(2), rs.getInt(3))); } } } catch (SQLException ex) { System.out.println("Fail in OrderMapper - getOrder"); System.out.println(ex.getMessage()); } return o; }
// Kirstine, Charlotte og Frederik public ArrayList<Order> getOrders(Connection conn, String datoFra, String datoTil) { Order currentO = null; ArrayList<Order> ol = new ArrayList(); String SQLString = "select * " + "from orders " + "where datofra between to_date(?,'dd-mon-yyyy') " + "and to_date(?,'dd-mon-yyyy')"; PreparedStatement statement = null; try { statement = conn.prepareStatement(SQLString); statement.setString(1, datoFra); statement.setString(2, datoTil); ResultSet rs = statement.executeQuery(); SQLString = "select * " + "from orderdetails " + "where oID = ?"; statement = conn.prepareStatement(SQLString); ResultSet rs2; String SQLString2 = "select * " + "from installers " + "where oID = ?"; PreparedStatement statement2 = conn.prepareStatement(SQLString2); ResultSet rs3; while (rs.next()) { currentO = new Order(rs.getInt(1), rs.getInt(2), rs.getDate(3), rs.getDate(4)); statement.setInt(1, currentO.getOID()); rs2 = statement.executeQuery(); while (rs2.next()) { currentO.addDetail(new OrderDetail(rs2.getInt(1), rs2.getInt(2), rs2.getInt(3))); } statement2.setInt(1, currentO.getOID()); rs3 = statement2.executeQuery(); Calendar c = new GregorianCalendar(); while (rs3.next()) { c.setTimeInMillis(rs3.getDate(3).getTime()); String from = c.get(c.DAY_OF_MONTH) + "-" + c.get(c.MONTH) + "-" + c.get(c.YEAR) + " " + c.get(c.HOUR_OF_DAY) + ":" + c.get(c.MINUTE); c.setTimeInMillis(rs3.getDate(4).getTime()); String to = c.get(c.DAY_OF_MONTH) + "-" + c.get(c.MONTH) + "-" + c.get(c.YEAR) + " " + c.get(c.HOUR_OF_DAY) + ":" + c.get(c.MINUTE); currentO.addInstaller(new Installer(rs3.getInt(1), rs3.getInt(2), from, to)); } ol.add(currentO); } } catch (SQLException ex) { System.out.println("Fail in OrderMapper - getOrders"); System.out.println(ex.getMessage()); } return ol; }