procedurce.txt

旅馆预订系统.采用jstl+oracle,jsp/servlet,,供初学者学习用.

create or replace package HotelSystem is

  type resultSet is ref cursor;
  
  procedure insertHotel(hotelname in varchar2,
                        city in varchar2,
                        rcount in number,
                        rprice in number,
                        dcount in number,
                        dprice in number);
  procedure showHotel(rs out resultSet);  --显示旅馆列表
  
  procedure showHotelByCity(rs out resultSet
                           ,in_city in varchar2);
                        
  procedure insertResort(resortname in varchar2,--添加新渡假村
                         city in varchar2,
                         ccount in number,
                         cprice in number);
  procedure showResort(rs out resultSet); --显示渡假村列表
  procedure showResortByCity(rs out resultSet,
                             in_city in varchar2);
                         
  procedure insertOrUpdateorder(
                        housestyle in varchar2,
                        in_id in number,
                        roomstyle in varchar2,
                        num in number,
                        in_custom in varchar2,
                        in_tel in varchar2,
                        email in varchar2);
                          
  procedure deleteOrderByCustomName(customname in varchar2);
  procedure deleteOrderByOrderId(in_orderid in number);
  procedure showOrders(rs out resultSet);
  procedure showHousesByCity(rs out resultSet,
                              in_city in varchar2);
  
end HotelSystem;