Package kr.ac.konkuk.ccslab.cm.manager

Class CMDBManager

java.lang.Object
kr.ac.konkuk.ccslab.cm.manager.CMDBManager
public class CMDBManager extends Object

  • Constructor Details

    • CMDBManager

      public CMDBManager()

  • Method Details

    • init

      public static void init(CMInfo cmInfo)

    • connectDB

      public static boolean connectDB(CMInfo cmInfo)

    • closeDB

      public static void closeDB(CMInfo cmInfo)

    • closeRS

      public static void closeRS(ResultSet rs)

    • sendSelectQuery

      public static ResultSet sendSelectQuery(String strQuery, CMInfo cmInfo)

    • sendUpdateQuery

      public static int sendUpdateQuery(String strQuery, CMInfo cmInfo)

    • sendUpdateQuery

      public static int sendUpdateQuery(String strQuery, CMInfo cmInfo, boolean bCloseDB)

    • queryInsertUser

      public static int queryInsertUser(String name, String password, CMInfo cmInfo)

    • authenticateUser

      public static boolean authenticateUser(String strUserName, String strPassword, CMInfo cmInfo)

    • queryGetUsers

      public static ResultSet queryGetUsers(int index, int num, CMInfo cmInfo)

    • queryUpdateUser

      public static int queryUpdateUser(String name, String fieldName, String value, CMInfo cmInfo)

    • queryDeleteUser

      public static int queryDeleteUser(String name, CMInfo cmInfo)

    • queryTruncateUserTable

      public static void queryTruncateUserTable(CMInfo cmInfo)

    • queryInsertSNSContent

      public static int queryInsertSNSContent(String userName, String text, int nNumAttachedFiles, int nReplyOf, int nLevelOfDisclosure, CMInfo cmInfo)

    • queryGetSNSContent

      public static ResultSet queryGetSNSContent(int index, int num, CMInfo cmInfo)

    • queryGetSNSContent

      public static CMSNSContentList queryGetSNSContent(String strRequester, String strWriter, int index, int num, CMInfo cmInfo)

    • queryUpdateSNSContent

      public static int queryUpdateSNSContent(int seqNum, String fieldName, String value, CMInfo cmInfo)

    • queryDeleteSNSContent

      public static int queryDeleteSNSContent(int seqNum, CMInfo cmInfo)

    • showResultSNSContent

      public static void showResultSNSContent(ResultSet rs)

    • queryTruncateSNSContentTable

      public static void queryTruncateSNSContentTable(CMInfo cmInfo)

    • queryInsertSNSAttachedFile

      public static int queryInsertSNSAttachedFile(int nContentID, String strFilePath, String strFileName, CMInfo cmInfo)

    • queryGetSNSAttachedFile

      public static ArrayList<String> queryGetSNSAttachedFile(int nContentID, CMInfo cmInfo)

    • queryUpdateSNSAttachedFile

      public static int queryUpdateSNSAttachedFile(int seqNum, String fieldName, String value, CMInfo cmInfo)

    • queryDeleteSNSAttachedFile

      public static int queryDeleteSNSAttachedFile(int seqNum, CMInfo cmInfo)

    • showResultSNSAttachedFile

      public static void showResultSNSAttachedFile(ResultSet rs)

    • queryTruncateSNSAttachedFileTable

      public static void queryTruncateSNSAttachedFileTable(CMInfo cmInfo)

    • sendRowNumQuery

      public static long sendRowNumQuery(String table, CMInfo cmInfo)

    • queryInsertFriend

      public static int queryInsertFriend(String strUserName, String strFriendName, CMInfo cmInfo)

    • queryDeleteFriend

      public static int queryDeleteFriend(String strUserName, String strFriendName, CMInfo cmInfo)

    • queryGetFriendsList

      public static ArrayList<String> queryGetFriendsList(String strUserName, CMInfo cmInfo)

    • queryGetRequestersList

      public static ArrayList<String> queryGetRequestersList(String strUserName, CMInfo cmInfo)

    • queryInsertAccessHistory

      public static int queryInsertAccessHistory(String strUserName, Calendar date, String strWriterName, int nAccessCount, CMInfo cmInfo)

    • queryDeleteAccessHistory

      public static int queryDeleteAccessHistory(String strUserName, Calendar date, String strWriterName, CMInfo cmInfo)

    • queryUpdateAccessCount

      public static int queryUpdateAccessCount(String strUserName, Calendar date, String strWriterName, int nAccessCount, CMInfo cmInfo)

    • queryGetAccessHistory

      public static CMSNSAttachAccessHistoryList queryGetAccessHistory(String strUserName, Calendar startDate, Calendar endDate, String strWriterName, CMInfo cmInfo)

    • queryTruncateAccessHistoryTable

      public static void queryTruncateAccessHistoryTable(CMInfo cmInfo)