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 -