hoteldaoimpl.java

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

package com.night.DAO.Impl;

import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Iterator;
import java.util.List;

import oracle.jdbc.OracleTypes;
import Util.DB;
import Util.ListSwap;

import com.night.DAO.HotelDAO;

public class HotelDAOImpl implements HotelDAO {

	public void insertHotel(String hotelname, String city, int dcount,
			int dprice, int rcount, int rprice) {
		Connection conn = DB.getConn();
		try {
			CallableStatement cstmt = conn
					.prepareCall("{call HotelSystem.insertHotel(?,?,?,?,?,?)}");
			cstmt.setString(1, hotelname);
			cstmt.setString(2, city);
			cstmt.setInt(3, dcount);
			cstmt.setInt(4, dprice);
			cstmt.setInt(5, rcount);
			cstmt.setInt(6, rprice);
			cstmt.execute();
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			DB.close(conn);
		}
	}

	public List showHotel() {
		Connection conn = DB.getConn();
		List list =null;
		try {
			CallableStatement cstmt = conn
					.prepareCall("{call HotelSystem.showHotel(?)}");
			cstmt.registerOutParameter(1, OracleTypes.CURSOR);
			cstmt.execute();
			ResultSet rs = (ResultSet) cstmt.getObject(1);
			list = ListSwap.toArrayList(rs);
		} catch (SQLException e) {
			e.printStackTrace();
		} finally{
			DB.close(conn);
		}
		return list;

	}
	
	public List showHotelByCity(String city) {
		Connection conn = DB.getConn();
		List list =null;
		try {
			CallableStatement cstmt = conn
					.prepareCall("{call HotelSystem.showHotelByCity(?,?)}");
			cstmt.registerOutParameter(1, OracleTypes.CURSOR);
			cstmt.setString(2, city);
			cstmt.execute();
			ResultSet rs = (ResultSet) cstmt.getObject(1);
			list = ListSwap.toArrayList(rs);
		} catch (SQLException e) {
			e.printStackTrace();
		} finally{
			DB.close(conn);
		}
		return list;

	}
	
	public List showAllByCity(String city){
		Connection conn = DB.getConn();
		List list=null;
		try {
			CallableStatement cstmt = conn
					.prepareCall("{call HotelSystem.showHousesByCity(?,?)}");
			cstmt.registerOutParameter(1, OracleTypes.CURSOR);
			cstmt.setString(2, city);
			cstmt.execute();
			ResultSet rs = (ResultSet) cstmt.getObject(1);
			list = ListSwap.toArrayList(rs);
		} catch (SQLException e) {
			e.printStackTrace();
		} finally{
			DB.close(conn);
		}
		return list;
	}
	
	public static void main(String[] args){
		HotelDAOImpl hd =new HotelDAOImpl();
		List list = hd.showAllByCity("all");
		Iterator iter =list.iterator();
		while(iter.hasNext()){
			System.out.println(iter.next());
		}
	}
}