resortdaoimpl.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.List;

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

import com.night.DAO.ResortDAO;

public class ResortDAOImpl implements ResortDAO {

	public void insertResort(String resortname, String city, int ccount,
			int cprice) {
		Connection conn = DB.getConn();
		try {
			CallableStatement cstmt = conn
					.prepareCall("{call HotelSystem.insertResort(?,?,?,?)}");
			cstmt.setString(1, resortname);
			cstmt.setString(2, city);
			cstmt.setInt(3, ccount);
			cstmt.setInt(4, cprice);
			cstmt.execute();
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			DB.close(conn);
		}
	}

	public List showResort() {
        Connection conn=DB.getConn();
        List list=null;
        try {
			CallableStatement cstmt = conn
					.prepareCall("{call HotelSystem.showResort(?)}");
            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 showResortByCity(String city) {
		Connection conn = DB.getConn();
		List list =null;
		try {
			CallableStatement cstmt = conn
					.prepareCall("{call HotelSystem.showResortByCity(?,?)}");
			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){
		ResortDAOImpl rd = new ResortDAOImpl();
		rd.insertResort("����ɼٴ�", "����", 50, 200);
	}
}