skoinfo.rfc.bus.dao
Class BusDAO

java.lang.Object
  skoinfo.rfc.bus.dao.BusDAO

public class BusDAO
extends java.lang.Object

Constructor Summary

BusDAO()

Method Summary

void	deleteBus(BusVO busVO)
void	deleteStation(StationVO stationVO)
java.util.List<BusVO>	getBusList(java.lang.String searchType, java.lang.String keyword, int beginRow, int rowCount) 버스 노선 검색
int	getBusSearchCount(java.lang.String searchType, java.lang.String keyword) 검색된 버스노선 갯수
int	getBusTotalCount() 버스노선 전체 갯수
BusVO	getBusVO(long busSid)
java.util.List<java.lang.String>	getStationConsonant()
java.util.List<StationVO>	getStationList(java.lang.String searchType, java.lang.String keyword, int beginRow, int rowCount) 정류장 검색
int	getStationSearchCount(java.lang.String searchType, java.lang.String keyword) 검색된 버스노선 갯수
int	getStationTotalCount() 버스노선 전체 갯수
StationVO	getStationVO(long stationSid)
void	updateBus(BusVO busVO) 버스노선 정보 수정
void	updateStation(StationVO stationVO) 버스노선 정보 수정
void	writeBus(BusVO busVO) 버스 노선 추가
void	writeStation(StationVO stationVO) 정류장 추가

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

BusDAO

public BusDAO()

Method Detail

writeBus

public void writeBus(BusVO busVO)
              throws java.lang.Exception

버스 노선 추가

Parameters:

busVO -

Throws:

java.lang.Exception

updateBus

public void updateBus(BusVO busVO)
               throws java.lang.Exception

버스노선 정보 수정

Parameters:

busVO -

Throws:

java.lang.Exception

getBusVO

public BusVO getBusVO(long busSid)
               throws java.lang.Exception

Throws:

java.lang.Exception

getBusTotalCount

public int getBusTotalCount()
                     throws java.lang.Exception

버스노선 전체 갯수

Returns:

Throws:

java.lang.Exception

getBusSearchCount

public int getBusSearchCount(java.lang.String searchType,
                             java.lang.String keyword)
                      throws java.lang.Exception

검색된 버스노선 갯수

Parameters:

searchType -

keyword -

Returns:

Throws:

java.lang.Exception

getBusList

public java.util.List<BusVO> getBusList(java.lang.String searchType,
                                        java.lang.String keyword,
                                        int beginRow,
                                        int rowCount)
                                 throws java.lang.Exception

버스 노선 검색

Parameters:

searchType -

keyword -

beginRow -

rowCount -

Returns:

Throws:

java.lang.Exception

deleteBus

public void deleteBus(BusVO busVO)
               throws java.lang.Exception

Throws:

java.lang.Exception

writeStation

public void writeStation(StationVO stationVO)
                  throws java.lang.Exception

정류장 추가

Parameters:

stationVO -

Throws:

java.lang.Exception

updateStation

public void updateStation(StationVO stationVO)
                   throws java.lang.Exception

버스노선 정보 수정

Parameters:

stationVO -

Throws:

java.lang.Exception

getStationVO

public StationVO getStationVO(long stationSid)
                       throws java.lang.Exception

Throws:

java.lang.Exception

getStationTotalCount

public int getStationTotalCount()
                         throws java.lang.Exception

버스노선 전체 갯수

Returns:

Throws:

java.lang.Exception

getStationSearchCount

public int getStationSearchCount(java.lang.String searchType,
                                 java.lang.String keyword)
                          throws java.lang.Exception

검색된 버스노선 갯수

Parameters:

searchType -

keyword -

Returns:

Throws:

java.lang.Exception

getStationConsonant

public java.util.List<java.lang.String> getStationConsonant()
                                                     throws java.lang.Exception

Throws:

java.lang.Exception

getStationList

public java.util.List<StationVO> getStationList(java.lang.String searchType,
                                                java.lang.String keyword,
                                                int beginRow,
                                                int rowCount)
                                         throws java.lang.Exception

정류장 검색

Parameters:

searchType -

keyword -

beginRow -

rowCount -

Returns:

Throws:

java.lang.Exception

deleteStation

public void deleteStation(StationVO stationVO)
                   throws java.lang.Exception

Throws:

java.lang.Exception