@@ -0,0 +1,1403 @@
+/*%0A * To change this template, choose Tools %7C Templates%0A * and open the template in the editor.%0A */%0A%0A/**%0A *%0A * @author kd%0A */%0Aimport com.vedisoft.ConnectionPool;%0A    import java.sql.*;%0A    import java.util.ArrayList;%0A    import javax.servlet.http.HttpSession;%0A%0Apublic class TariffDAO %7B%0A     ConnectionPool c = null;%0A        Connection conn = null;%0A%0A    public ArrayList%3CTariff%3E findAll() %7B%0A        ArrayList%3CTariff%3E al = new ArrayList%3CTariff%3E();%0A        try %7B%0A            if (c == null) %7B%0A                c = ConnectionPool.getInstance();%0A                c.initialize();%0A            %7D%0A            conn = c.getConnection();%0A            String sql = %22select * from tariff%22;%0A            PreparedStatement pstmt = conn.prepareStatement(sql);%0A            ResultSet rs = pstmt.executeQuery();%0A            while (rs.next()) %7B%0A                Tariff bean = new Tariff();%0A                bean.setTariffId(rs.getInt(%22id%22));%0A                bean.setCity(rs.getString(%22city%22));%0A                bean.setMedium(rs.getString(%22medium%22));%0A                bean.setStartPoint(rs.getString(%22startPlace%22));%0A                bean.setEndPoint(rs.getString(%22stopPlace%22));%0A                bean.setAmount(rs.getDouble(%22amount%22));%0A                al.add(bean);%0A            %7D%0A            c.putConnection(conn);%0A%0A        %7D catch (Exception e) %7B%0A            System.out.println(%22Exception %22 + e);%0A        %7D%0A        return al;%0A    %7D%0A%0A%7D%0A

Create TariffDAO.java