Page 911 - 3-3
P. 911

InitStmt->execute("CREATE TABLE IF NOT EXISTS CurrentStatus(Name text, Status
               text, Date text)");
                   // Database table  값 초기화
                   InitStmt->execute("INSERT      INTO     CurrentStatus(Name,    Status)    VALUES(' 이두희',
               'Unknown')");
                   InitStmt->execute("INSERT      INTO     CurrentStatus(Name,    Status)    VALUES(' 윤상종',
               'Unknown')");
                   InitStmt->execute("INSERT      INTO     CurrentStatus(Name,     Status)    VALUES(' 김진섭
               ','Unknown')");
                   InitStmt->execute("INSERT      INTO     CurrentStatus(Name,    Status)    VALUES(' 최윤희',
               'Unknown')");
                   // PreparedStatement Setting
                   EventStmt    =  con->prepareStatement("INSERT      INTO   EventLog(Name,    Status,  Date)
               VALUES(?, ?, ?)");
                   CurrentStmt = con->prepareStatement("UPDATE CurrentStatus SET Status = ?, Date = ?
               WHERE Name = ?");
                   LoginStmt = con->prepareStatement("SELECT ID, Password, Name FROM UserInfo
               WHERE ID=?");


                   delete InitStmt;
               }


               // Update Current Time
               void Handler::UpdateTime() {
                   memset(EventTime, 0, sizeof(EventTime));
                   // Year-Month-Day-Hour-Minute
                   sprintf(EventTime,    "%d-%02d-%02d        %02d:%02d",     tm.Get_year(),    tm.Get_mon(),
               tm.Get_day(), tm.Get_hour(), tm.Get_min());
               }


               // packetCommon   구조체 전달 시 상태 값으로 변환
               char* Handler::ConvertStatus(packetCommon &packet) {
                   int len = 0;
                   char *stat;


                   switch (packet.status) {
                   case MESSAGE::STATUS::IN:
                       len = sizeof(" 재실중");
                       stat = new char[len];
                       strncpy(stat, " 재실중", len); break;
                   case MESSAGE::STATUS::LESSON:
                       len = sizeof(" 수업중");
                       stat = new char[len];
                       strncpy(stat, " 수업중", len); break;
                   case MESSAGE::STATUS::OUTING:


                                                          - 911 -
   906   907   908   909   910   911   912   913   914   915   916