gnu.caf.db.impl
Class DBManager2MSSQL

java.lang.Object
  extended by gnu.caf.db.impl.SqlUtilOracle
      extended by gnu.caf.db.impl.DBManager2Oracle
          extended by gnu.caf.db.impl.DBManager2MSSQL
All Implemented Interfaces:
DBManager2, SqlUtil

public class DBManager2MSSQL
extends DBManager2Oracle
implements DBManager2

DBManager2 의 MS-SQL 구현 클래스임.

Since:
1.0
Author:
이호성

Field Summary
 
Fields inherited from class gnu.caf.db.impl.DBManager2Oracle
blobClessName, clobClessName, pagingTypeRsNext, resourceSqlPath, sqlIdTracable, sqlIdTraceList
 
Fields inherited from class gnu.caf.db.impl.SqlUtilOracle
bDEBUG, connection, dataSource, isAutoCommit, jndiDataSourceName, rowCallbackHandler, transaction
 
Constructor Summary
DBManager2MSSQL()
           
 
Method Summary
protected  java.util.List executeProcedureCallByQueryItem(gnu.caf.db.querymanager.QueryItem query, Attribute params)
           
protected  PagingList executeQueryForPagingListByQueryItem(gnu.caf.db.querymanager.QueryItem query, Attribute params, int pageNo, int pageSize)
          sql에 해당하는 PagingList 객체를 반환함.
protected  PagingList executeQueryForPagingListByQueryItem(gnu.caf.db.querymanager.QueryItem query, Attribute params, int pageNo, int pageSize, int totalCount)
           
protected  java.util.List executeQueryForRandomListByQueryItem(gnu.caf.db.querymanager.QueryItem query, Attribute params, int randomResults, int totalCount)
           
protected  int executeQueryForTotalCountByQueryItem(gnu.caf.db.querymanager.QueryItem query, Attribute params, boolean logPrint)
           
protected  void executeQueryForXlobByQueryItem(gnu.caf.db.querymanager.QueryItem query, Attribute data)
           
 Attribute getGlobalParams()
          DBManager 수행시 내부적으로 sql type="uid" 인 경우에는 DBManager 내부 글로벌 변수에 저장하게 되는 데, 이 글로벌 Parameter를 가져옴.
 boolean isMSSQL2005()
           
static void main(java.lang.String[] args)
           
 void setMSSQL2005(boolean mssql2005)
           
 
Methods inherited from class gnu.caf.db.impl.DBManager2Oracle
close, close, executeBatchUpdateByQueryGroup, executeQueryForIntByQueryGroup, executeQueryForListByQueryGroup, executeQueryForListByQueryGroup, executeQueryForListByQueryGroup, executeQueryForListByQueryGroup, executeQueryForMapByQueryGroup, executeQueryForPagingListByQueryGroup, executeQueryForPagingListByQueryGroup, executeQueryForPagingListByQueryGroup, executeQueryForPagingListByQueryGroup, executeQueryForRandomListByQueryGroup, executeQueryForRandomListByQueryGroup, executeQueryForRandomListByQueryGroup, executeQueryForRandomListByQueryItem, executeQueryForTotalCountByQueryGroup, executeQueryForTotalCountByQueryGroup, executeUpdateByQueryGroup, executeUpdateByQueryGroup, executeUpdateByQueryGroupDelete, executeUpdateByQueryGroupInsert, executeUpdateByQueryGroupUpdate, getResourceSqlPath, isPagingTypeRsNext, isSqlIdTracable, saveByQueryGroup, setPagingTypeRsNext, setResourceSqlPath, setSqlIdTracable, sqlIdAppend
 
Methods inherited from class gnu.caf.db.impl.SqlUtilOracle
clearParams, commit, executeQueryForFixedSequenceString, executeQueryForFixedSequenceString, executeQueryForInt, executeQueryForInt, executeQueryForList, executeQueryForList, executeQueryForList, executeQueryForMap, executeQueryForMap, executeQueryForPagingList, executeQueryForPagingList, executeUpdate, executeUpdate, executeUpdateClob, executeUpdateClob, executeUpdateNCHAR, finalize, getAutoCommit, getConnection, getConnection, getConnection, getDataSource, getJndiDataSourceName, getRowCallbackHandler, isDebug, loadParams, prepareCall, rollback, setAutoCommit, setConnection, setDataSource, setDebug, setJndiDataSourceName, setRowCallbackHandler
 
Methods inherited from class java.lang.Object
clone, equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 
Methods inherited from interface gnu.caf.db.DBManager2
close, executeBatchUpdateByQueryGroup, executeQueryForIntByQueryGroup, executeQueryForListByQueryGroup, executeQueryForListByQueryGroup, executeQueryForListByQueryGroup, executeQueryForMapByQueryGroup, executeQueryForPagingListByQueryGroup, executeQueryForPagingListByQueryGroup, executeQueryForPagingListByQueryGroup, executeQueryForPagingListByQueryGroup, executeQueryForRandomListByQueryGroup, executeQueryForRandomListByQueryGroup, executeQueryForRandomListByQueryGroup, executeQueryForTotalCountByQueryGroup, executeQueryForTotalCountByQueryGroup, executeUpdateByQueryGroup, executeUpdateByQueryGroup, executeUpdateByQueryGroupDelete, executeUpdateByQueryGroupInsert, executeUpdateByQueryGroupUpdate, getResourceSqlPath, saveByQueryGroup, setDebug, setPagingTypeRsNext, setResourceSqlPath, setSqlIdTracable
 
Methods inherited from interface gnu.caf.db.SqlUtil
clearParams, close, commit, executeQueryForFixedSequenceString, executeQueryForFixedSequenceString, executeQueryForInt, executeQueryForInt, executeQueryForList, executeQueryForList, executeQueryForList, executeQueryForMap, executeQueryForMap, executeQueryForPagingList, executeQueryForPagingList, executeUpdate, executeUpdate, executeUpdateClob, executeUpdateClob, executeUpdateNCHAR, getAutoCommit, getConnection, getConnection, getConnection, getDataSource, getJndiDataSourceName, getRowCallbackHandler, prepareCall, rollback, setAutoCommit, setConnection, setDataSource, setJndiDataSourceName, setRowCallbackHandler
 

Constructor Detail

DBManager2MSSQL

public DBManager2MSSQL()
Method Detail

getGlobalParams

public Attribute getGlobalParams()
Description copied from interface: DBManager2
DBManager 수행시 내부적으로 sql type="uid" 인 경우에는 DBManager 내부 글로벌 변수에 저장하게 되는 데, 이 글로벌 Parameter를 가져옴.

Specified by:
getGlobalParams in interface DBManager2
Overrides:
getGlobalParams in class DBManager2Oracle
Returns:
Attribute

main

public static void main(java.lang.String[] args)

executeQueryForTotalCountByQueryItem

protected int executeQueryForTotalCountByQueryItem(gnu.caf.db.querymanager.QueryItem query,
                                                   Attribute params,
                                                   boolean logPrint)
                                            throws java.sql.SQLException
Overrides:
executeQueryForTotalCountByQueryItem in class DBManager2Oracle
Throws:
java.sql.SQLException

executeQueryForPagingListByQueryItem

protected PagingList executeQueryForPagingListByQueryItem(gnu.caf.db.querymanager.QueryItem query,
                                                          Attribute params,
                                                          int pageNo,
                                                          int pageSize)
                                                   throws java.sql.SQLException
sql에 해당하는 PagingList 객체를 반환함. 페이징처리시 해당페이지의 리스트를 가져옴. 처리시 전체 카운트와 해당페이지의 리스트객체를 반환함. PagingList paginglist = executeQueryForPagingList(queryitem, params, 1, 10); int totalCount = paginglist.getTotalCount(); List list = paginglist.getList();

Overrides:
executeQueryForPagingListByQueryItem in class DBManager2Oracle
Parameters:
query -
params -
pageNo -
pageSize -
Returns:
PagingList
Throws:
java.sql.SQLException

executeQueryForPagingListByQueryItem

protected PagingList executeQueryForPagingListByQueryItem(gnu.caf.db.querymanager.QueryItem query,
                                                          Attribute params,
                                                          int pageNo,
                                                          int pageSize,
                                                          int totalCount)
                                                   throws java.sql.SQLException
Overrides:
executeQueryForPagingListByQueryItem in class DBManager2Oracle
Throws:
java.sql.SQLException

executeQueryForXlobByQueryItem

protected void executeQueryForXlobByQueryItem(gnu.caf.db.querymanager.QueryItem query,
                                              Attribute data)
                                       throws java.sql.SQLException
Overrides:
executeQueryForXlobByQueryItem in class DBManager2Oracle
Throws:
java.sql.SQLException

executeProcedureCallByQueryItem

protected java.util.List executeProcedureCallByQueryItem(gnu.caf.db.querymanager.QueryItem query,
                                                         Attribute params)
                                                  throws java.sql.SQLException
Overrides:
executeProcedureCallByQueryItem in class DBManager2Oracle
Throws:
java.sql.SQLException

executeQueryForRandomListByQueryItem

protected java.util.List executeQueryForRandomListByQueryItem(gnu.caf.db.querymanager.QueryItem query,
                                                              Attribute params,
                                                              int randomResults,
                                                              int totalCount)
                                                       throws java.sql.SQLException
Overrides:
executeQueryForRandomListByQueryItem in class DBManager2Oracle
Throws:
java.sql.SQLException

isMSSQL2005

public boolean isMSSQL2005()

setMSSQL2005

public void setMSSQL2005(boolean mssql2005)


Copyright © 2003 All Rights Reserved.